Hi,

I am working on WAS 8.5 clustered environment, the cluster has two members

Only on node1(member 1) I am getting the error - java.sql.SQLException: Could not commit with auto-commit set on
 while node2(member 2) is working fine

JDBC driver is configured at cluster scope and datasource is configured at cluster scope

Using Oracle JDBC driver ojdbc6.jar

------------------------------
Vignesh G
------------------------------

Hi, this error can depend on a number of things, but it usually does not have to do with being in a cluster unless caching is involved.  Can you attach the full stacktrace?

Also, please include the following:

version with fixpak (8.5.x.x)
If you are using JPA included with tWAS or your own bundled version
If this is using Spring/Springboot for DB access
Are both members/servers on the same system
Are they sharing a cache
Exact version of the DB

The database driver is very old, can we get the exact version number of the driver and make sure they are the same on each system.  

Brian

------------------------------
Brian S Paskin
Sr. Technology Engineer
IBM Cloud Engineering
------------------------------

Oracle made a change to their driver, this may be the reason why this is happening and that the appropriate JVM Setting is not on all servers:

Brian

------------------------------
Brian S Paskin
Sr. Technology Engineer
IBM Cloud Engineering
------------------------------