java.sql.SQLException: Attempt to set Escape Processing after SQL is already processed

Atlassian JIRA | Charles Miller | 1 decade ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 0

    Reported by Noah Campbell in CONF-2675, this keeps showing up in the logs, but doesn't have any visible effect on the system: SQLException: SQLState(null) vendor code(17133) java.sql.SQLException: Attempt to set Escape Processing after SQL is already processed         at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)         at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:162)         at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:227)         at oracle.jdbc.driver.OracleSql.setEscapeProcessing(OracleSql.java:343)         at oracle.jdbc.driver.OraclePreparedStatement.setEscapeProcessing(OraclePreparedStatement.java:3190)         at weblogic.jdbc.common.internal.ConnectionEnv.cleanUpStatementForReUse(ConnectionEnv.java:1080)         at weblogic.jdbc.common.internal.ConnectionEnv.returnCachedStatement(ConnectionEnv.java:883)         at weblogic.jdbc.wrapper.Statement.internalClose(Statement.java:271)         at weblogic.jdbc.wrapper.Statement.close(Statement.java:293)         at net.sf.hibernate.impl.BatcherImpl.closePreparedStatement(BatcherImpl.java:270)         at net.sf.hibernate.impl.BatcherImpl.closeStatement(BatcherImpl.java:140)         at net.sf.hibernate.impl.BatcherImpl.closeQueryStatement(BatcherImpl.java:156)         at net.sf.hibernate.impl.BatcherImpl.closeQueryStatement(BatcherImpl.java:103)         at net.sf.hibernate.loader.Loader.doQuery(Loader.java:302)         at net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:133)         at net.sf.hibernate.loader.Loader.doList(Loader.java:1033)         at net.sf.hibernate.loader.Loader.list(Loader.java:1024)         at net.sf.hibernate.hql.QueryTranslator.list(QueryTranslator.java:854)         at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1544)         at net.sf.hibernate.impl.QueryImpl.list(QueryImpl.java:39)         at bucket.user.persistence.dao.hibernate.BucketPropertySetDAO.getKeys(BucketPropertySetDAO.java:80)         at sun.reflect.GeneratedMethodAccessor1141.invoke(Unknown Source)         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)         at java.lang.reflect.Method.invoke(Method.java:324)         at org.springframework.aop.framework.AopProxyUtils.invokeJoinpointUsingReflection(AopProxyUtils.java:61)         at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:149)         at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:116)         at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:56)         at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:138)         at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:152)         at $Proxy50.getKeys(Unknown Source)         at com.opensymphony.module.propertyset.hibernate.HibernatePropertySet.getKeys(HibernatePropertySet.java:53)         at com.atlassian.confluence.user.providers.jira.ConditionalPropertySet.getKeys(ConditionalPropertySet.java:37)         at com.opensymphony.module.propertyset.AbstractPropertySet.getKeys(AbstractPropertySet.java:292)         at bucket.propertyset.CachingPropertySet.getKeys(CachingPropertySet.java:261)         at com.opensymphony.module.propertyset.PropertySetCloner.cloneProperties(PropertySetCloner.java:114)         at com.opensymphony.module.propertyset.PropertySetManager.clone(PropertySetManager.java:61)         at bucket.propertyset.CachingPropertySet.init(CachingPropertySet.java:65)         at com.opensymphony.module.propertyset.PropertySetManager.getInstance(PropertySetManager.java:45)         at com.opensymphony.module.propertyset.PropertySetManager.getInstance(PropertySetManager.java:22)         at com.atlassian.core.user.preferences.UserPreferences.<init>(UserPreferences.java:56)         at com.atlassian.core.user.preferences.UserPreferences.<init>(UserPreferences.java:38)         at com.atlassian.confluence.user.DefaultUserAccessor.getDeactivatedUsers(DefaultUserAccessor.java:60)         at com.atlassian.confluence.user.DefaultUserAccessor.initCaches(DefaultUserAccessor.java:74)         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)         at java.lang.reflect.Method.invoke(Method.java:324)         at org.springframework.aop.framework.AopProxyUtils.invokeJoinpointUsingReflection(AopProxyUtils.java:61)         at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:149)         at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:116)         at com.atlassian.confluence.util.profiling.SpringProfilingInterceptor.invoke(SpringProfilingInterceptor.java:16)         at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:138)         at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:56)         at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:138)         at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:152)         at $Proxy55.initCaches(Unknown Source)         at com.atlassian.confluence.user.UserCacheFillerJob.doExecute(UserCacheFillerJob.java:23)         at bucket.event.jobs.AbstractJob.executeInternal(AbstractJob.java:85)         at org.springframework.scheduling.quartz.QuartzJobBean.execute(QuartzJobBean.java:66)         at org.quartz.core.JobRunShell.run(JobRunShell.java:191)         at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:516)

    Atlassian JIRA | 1 decade ago | Charles Miller
    java.sql.SQLException: Attempt to set Escape Processing after SQL is already processed
  2. 0

    Reported by Noah Campbell in CONF-2675, this keeps showing up in the logs, but doesn't have any visible effect on the system: SQLException: SQLState(null) vendor code(17133) java.sql.SQLException: Attempt to set Escape Processing after SQL is already processed         at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)         at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:162)         at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:227)         at oracle.jdbc.driver.OracleSql.setEscapeProcessing(OracleSql.java:343)         at oracle.jdbc.driver.OraclePreparedStatement.setEscapeProcessing(OraclePreparedStatement.java:3190)         at weblogic.jdbc.common.internal.ConnectionEnv.cleanUpStatementForReUse(ConnectionEnv.java:1080)         at weblogic.jdbc.common.internal.ConnectionEnv.returnCachedStatement(ConnectionEnv.java:883)         at weblogic.jdbc.wrapper.Statement.internalClose(Statement.java:271)         at weblogic.jdbc.wrapper.Statement.close(Statement.java:293)         at net.sf.hibernate.impl.BatcherImpl.closePreparedStatement(BatcherImpl.java:270)         at net.sf.hibernate.impl.BatcherImpl.closeStatement(BatcherImpl.java:140)         at net.sf.hibernate.impl.BatcherImpl.closeQueryStatement(BatcherImpl.java:156)         at net.sf.hibernate.impl.BatcherImpl.closeQueryStatement(BatcherImpl.java:103)         at net.sf.hibernate.loader.Loader.doQuery(Loader.java:302)         at net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:133)         at net.sf.hibernate.loader.Loader.doList(Loader.java:1033)         at net.sf.hibernate.loader.Loader.list(Loader.java:1024)         at net.sf.hibernate.hql.QueryTranslator.list(QueryTranslator.java:854)         at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1544)         at net.sf.hibernate.impl.QueryImpl.list(QueryImpl.java:39)         at bucket.user.persistence.dao.hibernate.BucketPropertySetDAO.getKeys(BucketPropertySetDAO.java:80)         at sun.reflect.GeneratedMethodAccessor1141.invoke(Unknown Source)         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)         at java.lang.reflect.Method.invoke(Method.java:324)         at org.springframework.aop.framework.AopProxyUtils.invokeJoinpointUsingReflection(AopProxyUtils.java:61)         at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:149)         at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:116)         at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:56)         at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:138)         at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:152)         at $Proxy50.getKeys(Unknown Source)         at com.opensymphony.module.propertyset.hibernate.HibernatePropertySet.getKeys(HibernatePropertySet.java:53)         at com.atlassian.confluence.user.providers.jira.ConditionalPropertySet.getKeys(ConditionalPropertySet.java:37)         at com.opensymphony.module.propertyset.AbstractPropertySet.getKeys(AbstractPropertySet.java:292)         at bucket.propertyset.CachingPropertySet.getKeys(CachingPropertySet.java:261)         at com.opensymphony.module.propertyset.PropertySetCloner.cloneProperties(PropertySetCloner.java:114)         at com.opensymphony.module.propertyset.PropertySetManager.clone(PropertySetManager.java:61)         at bucket.propertyset.CachingPropertySet.init(CachingPropertySet.java:65)         at com.opensymphony.module.propertyset.PropertySetManager.getInstance(PropertySetManager.java:45)         at com.opensymphony.module.propertyset.PropertySetManager.getInstance(PropertySetManager.java:22)         at com.atlassian.core.user.preferences.UserPreferences.<init>(UserPreferences.java:56)         at com.atlassian.core.user.preferences.UserPreferences.<init>(UserPreferences.java:38)         at com.atlassian.confluence.user.DefaultUserAccessor.getDeactivatedUsers(DefaultUserAccessor.java:60)         at com.atlassian.confluence.user.DefaultUserAccessor.initCaches(DefaultUserAccessor.java:74)         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)         at java.lang.reflect.Method.invoke(Method.java:324)         at org.springframework.aop.framework.AopProxyUtils.invokeJoinpointUsingReflection(AopProxyUtils.java:61)         at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:149)         at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:116)         at com.atlassian.confluence.util.profiling.SpringProfilingInterceptor.invoke(SpringProfilingInterceptor.java:16)         at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:138)         at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:56)         at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:138)         at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:152)         at $Proxy55.initCaches(Unknown Source)         at com.atlassian.confluence.user.UserCacheFillerJob.doExecute(UserCacheFillerJob.java:23)         at bucket.event.jobs.AbstractJob.executeInternal(AbstractJob.java:85)         at org.springframework.scheduling.quartz.QuartzJobBean.execute(QuartzJobBean.java:66)         at org.quartz.core.JobRunShell.run(JobRunShell.java:191)         at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:516)

    Atlassian JIRA | 1 decade ago | Charles Miller
    java.sql.SQLException: Attempt to set Escape Processing after SQL is already processed
  3. 0

    Error related to escape processing

    Oracle Community | 1 decade ago | 666705
    java.sql.SQLException: Attempt to set Escape Processing after SQL is already processed
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    RE: Oracle OJB error

    db-ojb-user | 1 decade ago | Ferrer, Eric
    org.apache.ojb.broker.platforms.PlatformException: Could not set escape processing

    Root Cause Analysis

    1. java.sql.SQLException

      Attempt to set Escape Processing after SQL is already processed

      at oracle.jdbc.driver.DatabaseError.throwSqlException()
    2. Oracle jdbc
      OraclePreparedStatement.setEscapeProcessing
      1. oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
      2. oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:162)
      3. oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:227)
      4. oracle.jdbc.driver.OracleSql.setEscapeProcessing(OracleSql.java:343)
      5. oracle.jdbc.driver.OraclePreparedStatement.setEscapeProcessing(OraclePreparedStatement.java:3190)
      5 frames
    3. weblogic.jdbc.common
      ConnectionEnv.returnCachedStatement
      1. weblogic.jdbc.common.internal.ConnectionEnv.cleanUpStatementForReUse(ConnectionEnv.java:1080)
      2. weblogic.jdbc.common.internal.ConnectionEnv.returnCachedStatement(ConnectionEnv.java:883)
      2 frames
    4. weblogic.jdbc.wrapper
      Statement.close
      1. weblogic.jdbc.wrapper.Statement.internalClose(Statement.java:271)
      2. weblogic.jdbc.wrapper.Statement.close(Statement.java:293)
      2 frames
    5. net.sf.hibernate
      QueryImpl.list
      1. net.sf.hibernate.impl.BatcherImpl.closePreparedStatement(BatcherImpl.java:270)
      2. net.sf.hibernate.impl.BatcherImpl.closeStatement(BatcherImpl.java:140)
      3. net.sf.hibernate.impl.BatcherImpl.closeQueryStatement(BatcherImpl.java:156)
      4. net.sf.hibernate.impl.BatcherImpl.closeQueryStatement(BatcherImpl.java:103)
      5. net.sf.hibernate.loader.Loader.doQuery(Loader.java:302)
      6. net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:133)
      7. net.sf.hibernate.loader.Loader.doList(Loader.java:1033)
      8. net.sf.hibernate.loader.Loader.list(Loader.java:1024)
      9. net.sf.hibernate.hql.QueryTranslator.list(QueryTranslator.java:854)
      10. net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1544)
      11. net.sf.hibernate.impl.QueryImpl.list(QueryImpl.java:39)
      11 frames
    6. bucket.user.persistence
      BucketPropertySetDAO.getKeys
      1. bucket.user.persistence.dao.hibernate.BucketPropertySetDAO.getKeys(BucketPropertySetDAO.java:80)
      1 frame
    7. Java RT
      Method.invoke
      1. sun.reflect.GeneratedMethodAccessor1141.invoke(Unknown Source)
      2. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      3. java.lang.reflect.Method.invoke(Method.java:324)
      3 frames
    8. Spring AOP
      ReflectiveMethodInvocation.proceed
      1. org.springframework.aop.framework.AopProxyUtils.invokeJoinpointUsingReflection(AopProxyUtils.java:61)
      2. org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:149)
      3. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:116)
      3 frames
    9. Spring Tx
      TransactionInterceptor.invoke
      1. org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:56)
      1 frame
    10. Spring AOP
      JdkDynamicAopProxy.invoke
      1. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:138)
      2. org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:152)
      2 frames
    11. Unknown
      $Proxy50.getKeys
      1. $Proxy50.getKeys(Unknown Source)
      1 frame
    12. com.opensymphony.module
      HibernatePropertySet.getKeys
      1. com.opensymphony.module.propertyset.hibernate.HibernatePropertySet.getKeys(HibernatePropertySet.java:53)
      1 frame
    13. com.atlassian.confluence
      ConditionalPropertySet.getKeys
      1. com.atlassian.confluence.user.providers.jira.ConditionalPropertySet.getKeys(ConditionalPropertySet.java:37)
      1 frame
    14. com.opensymphony.module
      AbstractPropertySet.getKeys
      1. com.opensymphony.module.propertyset.AbstractPropertySet.getKeys(AbstractPropertySet.java:292)
      1 frame
    15. bucket.propertyset
      CachingPropertySet.getKeys
      1. bucket.propertyset.CachingPropertySet.getKeys(CachingPropertySet.java:261)
      1 frame
    16. com.opensymphony.module
      PropertySetManager.clone
      1. com.opensymphony.module.propertyset.PropertySetCloner.cloneProperties(PropertySetCloner.java:114)
      2. com.opensymphony.module.propertyset.PropertySetManager.clone(PropertySetManager.java:61)
      2 frames
    17. bucket.propertyset
      CachingPropertySet.init
      1. bucket.propertyset.CachingPropertySet.init(CachingPropertySet.java:65)
      1 frame
    18. com.opensymphony.module
      PropertySetManager.getInstance
      1. com.opensymphony.module.propertyset.PropertySetManager.getInstance(PropertySetManager.java:45)
      2. com.opensymphony.module.propertyset.PropertySetManager.getInstance(PropertySetManager.java:22)
      2 frames
    19. com.atlassian.core
      UserPreferences.<init>
      1. com.atlassian.core.user.preferences.UserPreferences.<init>(UserPreferences.java:56)
      2. com.atlassian.core.user.preferences.UserPreferences.<init>(UserPreferences.java:38)
      2 frames
    20. com.atlassian.confluence
      DefaultUserAccessor.initCaches
      1. com.atlassian.confluence.user.DefaultUserAccessor.getDeactivatedUsers(DefaultUserAccessor.java:60)
      2. com.atlassian.confluence.user.DefaultUserAccessor.initCaches(DefaultUserAccessor.java:74)
      2 frames
    21. 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:324)
      4 frames
    22. Spring AOP
      ReflectiveMethodInvocation.proceed
      1. org.springframework.aop.framework.AopProxyUtils.invokeJoinpointUsingReflection(AopProxyUtils.java:61)
      2. org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:149)
      3. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:116)
      3 frames
    23. com.atlassian.confluence
      SpringProfilingInterceptor.invoke
      1. com.atlassian.confluence.util.profiling.SpringProfilingInterceptor.invoke(SpringProfilingInterceptor.java:16)
      1 frame
    24. Spring AOP
      ReflectiveMethodInvocation.proceed
      1. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:138)
      1 frame
    25. Spring Tx
      TransactionInterceptor.invoke
      1. org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:56)
      1 frame
    26. Spring AOP
      JdkDynamicAopProxy.invoke
      1. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:138)
      2. org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:152)
      2 frames
    27. Unknown
      $Proxy55.initCaches
      1. $Proxy55.initCaches(Unknown Source)
      1 frame
    28. com.atlassian.confluence
      UserCacheFillerJob.doExecute
      1. com.atlassian.confluence.user.UserCacheFillerJob.doExecute(UserCacheFillerJob.java:23)
      1 frame
    29. bucket.event.jobs
      AbstractJob.executeInternal
      1. bucket.event.jobs.AbstractJob.executeInternal(AbstractJob.java:85)
      1 frame
    30. Spring Context Support
      QuartzJobBean.execute
      1. org.springframework.scheduling.quartz.QuartzJobBean.execute(QuartzJobBean.java:66)
      1 frame
    31. quartz
      SimpleThreadPool$WorkerThread.run
      1. org.quartz.core.JobRunShell.run(JobRunShell.java:191)
      2. org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:516)
      2 frames