java.sql.SQLException: Connection is read-only. Queries leading to data modification are not allowed

Oracle Community | 807573 | 7 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    SRM 5.0.3 - Business Structure Rules

    Oracle Community | 7 years ago | 807573
    java.sql.SQLException: Connection is read-only. Queries leading to data modification are not allowed
  2. 0

    Jboss XA Datasource with Oracle Can't Open Connection

    Stack Overflow | 2 years ago | Faisal Basra
    java.sql.SQLException: javax.resource.ResourceException: IJ000457: Unchecked throwable in managedConnectionReconnected() cl=org.jboss.jca.core.connectionmanager.listener.TxConnectionListener@506f65ce[state=DESTROYED managed connection=org.jboss.jca.adapters.jdbc.xa.XAManagedConnection@46c87b4b connection handles=0 lastUse=1410399087408 trackByTx=false pool=org.jboss.jca.core.connectionmanager.pool.strategy.OnePool@6b8913c mcp=SemaphoreArrayListManagedConnectionPool@984da7b[pool=XAOracleDS] xaResource=XAResourceWrapperImpl@10cab9b8[xaResource=org.jboss.jca.adapters.jdbc.xa.XAManagedConnection@46c87b4b pad=true overrideRmValue=null productName=Oracle productVersion=Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options jndiName=java:/XAOracleDS] txSync=null]
  3. Speed up your debug routine!

    Automated exception search integrated into your IDE

  4. 0

    mybatis-user - sqlKind = UNINITIALIZED

    nabble.com | 1 year ago
    java.sql.SQLException: Invalid SQL type: sqlKind = UNINITIALIZED
  5. 0

    Lock wait timeout exceeded; try restarting transaction

    Stack Overflow | 4 years ago | fuyou001
    java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction
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. java.sql.SQLException

    Connection is read-only. Queries leading to data modification are not allowed

    at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate()
  2. Spring Framework
    AbstractFallbackSQLExceptionTranslator.translate
    1. org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:106)
    2. org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
    3. org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
    4. org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
    4 frames
  3. Spring ORM
    SqlMapClientTemplate.update
    1. org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:212)
    2. org.springframework.orm.ibatis.SqlMapClientTemplate.update(SqlMapClientTemplate.java:411)
    2 frames
  4. com.vaau.rbacx
    UserBusinessUnitIfAction.finishAction
    1. com.vaau.rbacx.idw.maintenance.userbusinessunit.dao.ibatis.SqlMapUserBusinessUnitRuleScanDao.updateScanResult(SqlMapUserBusinessUnitRuleScanDao.java:144)
    2. com.vaau.rbacx.idw.maintenance.userbusinessunit.actions.UserBusinessUnitIfAction.finishAction(UserBusinessUnitIfAction.java:109)
    2 frames
  5. com.vaau.rules
    RuleManagerImpl.executeRules
    1. com.vaau.rules.manager.RuleManagerImpl.executeRules(RuleManagerImpl.java:519)
    1 frame
  6. com.vaau.rbacx
    RbacxIDWServiceImpl.executeRules
    1. com.vaau.rbacx.idw.service.RbacxIDWServiceImpl.executeRules(RbacxIDWServiceImpl.java:2157)
    1 frame
  7. Java RT
    Method.invoke
    1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    4. java.lang.reflect.Method.invoke(Method.java:597)
    4 frames
  8. Spring AOP
    ReflectiveMethodInvocation.proceed
    1. org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)
    2. org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
    3. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
    4. org.springframework.aop.interceptor.AbstractTraceInterceptor.invoke(AbstractTraceInterceptor.java:113)
    5. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
    6. org.springframework.aop.interceptor.AbstractTraceInterceptor.invoke(AbstractTraceInterceptor.java:113)
    7. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
    7 frames
  9. org.springframework.security
    MethodSecurityInterceptor.invoke
    1. org.springframework.security.intercept.method.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:66)
    1 frame
  10. Spring AOP
    ReflectiveMethodInvocation.proceed
    1. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
    1 frame
  11. Spring Tx
    TransactionInterceptor.invoke
    1. org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
    1 frame
  12. Spring AOP
    JdkDynamicAopProxy.invoke
    1. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
    2. org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
    3. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
    4. org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
    4 frames
  13. Unknown
    $Proxy69.executeRules
    1. $Proxy69.executeRules(Unknown Source)
    1 frame
  14. com.vaau.rbacx
    AbstractJob.execute
    1. com.vaau.rbacx.scheduling.executor.idw.UserBusinessUnitScanJobExecutor.execute(UserBusinessUnitScanJobExecutor.java:242)
    2. com.vaau.rbacx.scheduling.manager.providers.quartz.jobs.AbstractJob.execute(AbstractJob.java:72)
    2 frames
  15. quartz
    SimpleThreadPool$WorkerThread.run
    1. org.quartz.core.JobRunShell.run(JobRunShell.java:202)
    2. org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:525)
    2 frames