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
------------------------------
Original Message:
Sent: Mon December 26, 2022 11:01 AM
From: Vignesh G
Subject: java.sql.SQLException: Could not commit with auto-commit set on
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
------------------------------