The solidDB® JDBC Driver includes features that improve WebSphere compatibility.
Java Transaction API (JTA) support
solidDB® server can participate in distributed transactions using the Java Transaction API (JTA) interface. The following interfaces are supported, as described in the Java Transaction API Specification 1.1:
When using JTA with SQL passthrough in solidDB® Universal Cache, only read statements (SELECT) are supported.
When using JTA in HotStandby configurations, load balancing is not supported.
solidDB® Data Store Helper Class in WebSphere
WebSphere needs an adapter class for those JDBC data sources that are to be used within WebSphere. The base class for these adapters is thecom.ibm.websphere.rsadapter.GenericDataStoreHelper class; solidDB® implements its own version of this adapter inside a class called:com.ibm.websphere.rsadapter.SolidDataStoreHelper.
This class is provided within the solidDB® product as a separate archive file called SolidDataStoreHelper.jar You can find this file in the jdbc directory in the solidDB® installation directory.
When you are configuring a new solidDB® data source in WebSphere, you need to
▪give the classcom.ibm.websphere.rsadapter.SolidDataStoreHelper in the data store helper field of the configuration, and
▪specify the full path to the SolidDataStoreHelper.jar file in the data source configuration of WebSphere.
See the WebSphere documentation for further details how to define new data sources in WebSphere.
For an example of how to install a solidDB®'s WebSphere sample application in the Websphere Studio Application Developer's workspace, see the samples/websphere directory in your solidDB® installation directory.
solidDB® Data Source Properties and WebSphere
You need to define the following properties when configuring a new data source in the WebSphere:
URL
▪type: java.lang.String
▪value should use syntax similar to the following syntax: 'jdbc:solid:// <hostname>:<port>'