java.sql.SQLException

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • 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)
    via by Charles Miller,
  • 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)
    via by Charles Miller,
  • Error related to escape processing
    via by 666705,
  • RE: Oracle OJB error
    via by Ferrer, Eric,
  • Openbravo won't run.
    via openbravo by kchopein
    ,
  • amount field with decimals in hibernate
    via Stack Overflow by JNPW
    ,
    • 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)

    Users with the same issue

    Unknown visitor
    Unknown visitor1 times, last one,
    Unknown visitor
    Unknown visitor1 times, last one,
    Unknown visitor
    Unknown visitor1 times, last one,
    Unknown visitor
    Unknown visitor1 times, last one,
    Unknown visitor
    Unknown visitor1 times, last one,
    76 more bugmates