org.springframework.transaction.CannotCreateTransactionException: Could not open JDBC Connection for transaction; nested exception is java.sql.SQLException: S QLSTATE=XJ045,SEVERITY=-1: (Server=localhost[1529],Thread[DRDAConnThread_24,5,gemfirexd.daemons]) Invalid or (currently) unsupported isolation level, '8', passed to Conn ection.setTransactionIsolation(). The currently supported values are java.sql.Connection.TRANSACTION_NONE, java.sql.Connection.TRANSACTION_READ_UNCOMMITTED, java.sql.Con nection.TRANSACTION_READ_COMMITTED and java.sql.Connection.TRANSACTION_REPEATABLE_READ.

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Solutions on the web

via Spring JIRA by Mark Pollack, 1 year ago
Could not open JDBC Connection for transaction; nested exception is java.sql.SQLException: S QLSTATE=XJ045,SEVERITY=-1: (Server=localhost[1529],Thread[DRDAConnThread_24,5,gemfirexd.daemons]) Invalid or (currently) unsupported isolation level, '8
via Spring JIRA by Mark Pollack, 1 year ago
Could not open JDBC Connection for transaction; nested exception is java.sql.SQLException: S QLSTATE=XJ045,SEVERITY=-1: (Server=localhost[1529],Thread[DRDAConnThread_24,5,gemfirexd.daemons]) Invalid or (currently) unsupported isolation level, '8
via GitHub by georgeangeletos
, 1 year ago
Could not open JDBC Connection for transaction; nested exception is org.postgresql.util.PSQLException: Cannot change transaction isolation level in the middle of a transaction.
via pivotal.io by Unknown author, 1 year ago
Could not open JDBC Connection for transaction; nested exception is java.sql.SQLException: Failed to validate a newly established connection.
via zendesk.com by Unknown author, 1 year ago
Could not open JDBC Connection for transaction; nested exception is java.sql.SQLException: Failed to validate a newly established connection.
via Stack Overflow by user2051823
, 11 months ago
Could not open JDBC Connection for transaction; nested exception is java.sql.SQLException: Connections could not be acquired from the underlying database!
org.springframework.transaction.CannotCreateTransactionException: Could not open JDBC Connection for transaction; nested exception is java.sql.SQLException: S QLSTATE=XJ045,SEVERITY=-1: (Server=localhost[1529],Thread[DRDAConnThread_24,5,gemfirexd.daemons]) Invalid or (currently) unsupported isolation level, '8', passed to Conn ection.setTransactionIsolation(). The currently supported values are java.sql.Connection.TRANSACTION_NONE, java.sql.Connection.TRANSACTION_READ_UNCOMMITTED, java.sql.Con nection.TRANSACTION_READ_COMMITTED and java.sql.Connection.TRANSACTION_REPEATABLE_READ.
at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:373)
at org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:420)
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:257)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at com.sun.proxy.$Proxy95.getLastJobExecution(Unknown Source)

Users with the same issue

3 times, 3 months ago
3 times, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 4 days ago
Samebug visitor profile picture
Unknown user
Once, 2 years ago

Write tip

Know the solutions? Share your knowledge to help other developers to debug faster.