Error when creation data source in websphere with neo4j jdbc driver

[sachin_kamath]

Im trying to create data source for neo4j in websphere application server but its failing to connect. Any pointers on this would be helpful.

JDBC Driver Created with the following parameters:

• Name : neo4j Driver
• Class path : path of the neo4j jdbc jar/neo4j-jdbc-driver-3.3.1.jar
• Implementation class name : org.neo4j.jdbc.Driver

Data source created with the following :

• jndi Name: jdbc/neo4j

Custom Properties:

• 1. auth : container
• 2. type: javax.sql.DataSource
• 3. username: neo4j
• 4. password: password
• 5. url:jdbc:neo4j:bolt://localhost:port
• 6. removeAbandonedOnBorrow : true
• 7. closeMethod : close

The properties are added based on the pointers provided in https://github.com/neo4j-contrib/neo4j-jdbc

Here is the error from logs:

java.lang.Exception: DSRA8101E: DataSource class cannot be used as one-phase: ClassCastException: org.neo4j.jdbc.bolt.BoltDriver incompatible with javax.sql.ConnectionPoolDataSource [5/27/19 13:12:41:533 UTC] 00000111 SystemErr R at com.ibm.ws.rsadapter.AdapterUtil.createDataStoreAdapterException(AdapterUtil.java:441) [5/27/19 13:12:41:533 UTC] 00000111 SystemErr R at com.ibm.ws.rsadapter.DSConfigHelper.getPooledConnection(DSConfigHelper.java:1340)

[stefan_armbrust]

A similar error message is discussed in https://stackoverflow.com/a/36931996/158701. One user there suggests to enable "isolate this resource provider" in websphere config.

(Disclaimer: Not being a websphere user myself.)

[sachin_kamath]

@stefan.armbruster.I checked the steps provided in the link. This did not help 😞

[stefan_armbrust]

Another idea: the ClassCastException gives me the impression that WebSphere expects a DataSource instance and not a JDBC driver class.

Try to use org.neo4j.jdbc.bolt.BoltNeo4jDataSource instead of org.neo4j.jdbc.Driver for implementation class name.

If that doesn't work revert to org.neo4j.jdbc.Driver and try to change the type properties to something else than javax.sql.DataSource. Don't know what an alternative value could be, maybe WebSphere docs tell you.