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

Atlassian JIRA | Charles Miller | 1 decade ago
  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
  6. 0

    query.setMaxRows(10) Error .......

    Oracle Community | 1 decade ago | garberx
    java.sql.SQLException: Attempt to set Escape Processing after SQL is already processed Error Code: 17133

    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

      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