org.springframework.transaction.CannotCreateTransactionException: Could not open JDBC Connection for transaction; nested exception is java.sql.SQLException: Invalid Oracle URL specified

activiti.org | 3 months ago
  1. 0

    not able to start activiti-explorer after changing the database configuration | Activiti Forums

    activiti.org | 3 months ago
    org.springframework.transaction.CannotCreateTransactionException: Could not open JDBC Connection for transaction; nested exception is java.sql.SQLException: Invalid Oracle URL specified
  2. 0

    Getting Caused by: {quote} 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.jdbc.datasource.DataSourceTransactionManager.doBegin(DataSourceTransactionManager.java:242) 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.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:95) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207) at com.sun.proxy.$Proxy95.getLastJobExecution(Unknown Source) at org.springframework.batch.core.launch.support.SimpleJobLauncher.run(SimpleJobLauncher.java:98) {quote} when launching a simple batch job with GemXD configured as the database {quote} job create --name myjob --definition "filejdbc --resources=file:///home/mpollack/csv/*.csv --driverClassName=com.pivotal.gemfirexd.jdbc.ClientDriver --names=id,name,test --tableName=APP.mytable" job deploy --name myjob job launch --name myjob {quote} {quote} spring: datasource: url: jdbc:gemfirexd://localhost:1527/ username: admin password: admin driverClassName: com.pivotal.gemfirexd.jdbc.ClientDriver {quote}

    Spring JIRA | 2 years ago | Mark Pollack
    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.
  3. 0

    Getting Caused by: {quote} 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.jdbc.datasource.DataSourceTransactionManager.doBegin(DataSourceTransactionManager.java:242) 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.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:95) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207) at com.sun.proxy.$Proxy95.getLastJobExecution(Unknown Source) at org.springframework.batch.core.launch.support.SimpleJobLauncher.run(SimpleJobLauncher.java:98) {quote} when launching a simple batch job with GemXD configured as the database {quote} job create --name myjob --definition "filejdbc --resources=file:///home/mpollack/csv/*.csv --driverClassName=com.pivotal.gemfirexd.jdbc.ClientDriver --names=id,name,test --tableName=APP.mytable" job deploy --name myjob job launch --name myjob {quote} {quote} spring: datasource: url: jdbc:gemfirexd://localhost:1527/ username: admin password: admin driverClassName: com.pivotal.gemfirexd.jdbc.ClientDriver {quote}

    Spring JIRA | 2 years ago | Mark Pollack
    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.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Unsupported operation READ_COMMITTED/SERIALIZABLE

    Stack Overflow | 1 year ago | user5412028
    org.springframework.transaction.CannotCreateTransactionException: Could not open JDBC Connection for transaction; nested exception is java.sql.SQLException: JDBC-590722:Unsupported operation. Supports READ_COMMITTED/SERIALIZABLE.
  6. 0

    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.

    GitHub | 2 years ago | georgeangeletos
    org.springframework.transaction.CannotCreateTransactionException: 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.

  1. kkandda 3 times, last 6 months ago
2 unregistered visitors
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. org.springframework.transaction.CannotCreateTransactionException

    Could not open JDBC Connection for transaction; nested exception is java.sql.SQLException: Invalid Oracle URL specified

    at org.springframework.jdbc.datasource.DataSourceTransactionManager.doBegin()
  2. Spring Framework
    DataSourceTransactionManager.doBegin
    1. org.springframework.jdbc.datasource.DataSourceTransactionManager.doBegin(DataSourceTransactionManager.java:242)
    1 frame
  3. Spring Tx
    AbstractPlatformTransactionManager.getTransaction
    1. org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:373)
    1 frame
  4. Activiti - Spring
    SpringTransactionContext.rollback
    1. org.activiti.spring.SpringTransactionContext.rollback(SpringTransactionContext.java:60)
    1 frame
  5. Activiti - Engine
    CommandContextInterceptor.execute
    1. org.activiti.engine.impl.interceptor.CommandContext.close(CommandContext.java:173)
    2. org.activiti.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:66)
    2 frames
  6. Activiti - Spring
    SpringTransactionInterceptor$1.doInTransaction
    1. org.activiti.spring.SpringTransactionInterceptor$1.doInTransaction(SpringTransactionInterceptor.java:47)
    1 frame
  7. Spring Tx
    TransactionTemplate.execute
    1. org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:133)
    1 frame
  8. Activiti - Spring
    SpringTransactionInterceptor.execute
    1. org.activiti.spring.SpringTransactionInterceptor.execute(SpringTransactionInterceptor.java:45)
    1 frame
  9. Activiti - Engine
    CommandExecutorImpl.execute
    1. org.activiti.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:31)
    2. org.activiti.engine.impl.cfg.CommandExecutorImpl.execute(CommandExecutorImpl.java:40)
    2 frames