com.sybase.jdbc2.jdbc.SybSQLException: TEXT, IMAGE and off-row Java datatypes may not be selected as DISTINCT.

Atlassian JIRA | Charles Miller | 1 decade ago
  1. 0

    2004-03-23 16:17:59,582 WARN [springframework.jdbc.support.SQLStateSQLExceptionTranslator] Translating SQLException with SQLState 'ZZZZZ' and errorCode '421' and message [TEXT, IMAGE and off-row Java datatypes may not be selected as DISTINCT. ]; SQL was [null] for task [HibernateAccessor] 2004-03-23 16:17:59,587 ERROR [opensymphony.webwork.dispatcher.ServletDispatcher] Could not execute action org.springframework.jdbc.UncategorizedSQLException: (HibernateAccessor): encountered SQLException [TEXT, IMAGE and off-row Java datatypes may not be selected as DISTINCT. ]; nested exception is com.sybase.jdbc2.jdbc.SybSQLException: TEXT, IMAGE and off-row Java datatypes may not be selected as DISTINCT. com.sybase.jdbc2.jdbc.SybSQLException: TEXT, IMAGE and off-row Java datatypes may not be selected as DISTINCT. at com.sybase.jdbc2.tds.Tds.processEed(Tds.java:2636) at com.sybase.jdbc2.tds.Tds.nextResult(Tds.java:1996) at com.sybase.jdbc2.jdbc.ResultGetter.nextResult(ResultGetter.java:69) at com.sybase.jdbc2.jdbc.SybStatement.nextResult(SybStatement.java:204) at com.sybase.jdbc2.jdbc.SybStatement.nextResult(SybStatement.java:187) at com.sybase.jdbc2.jdbc.SybStatement.queryLoop(SybStatement.java:1510) at com.sybase.jdbc2.jdbc.SybStatement.executeQuery(SybStatement.java:1495) at com.sybase.jdbc2.jdbc.SybPreparedStatement.executeQuery(SybPreparedStatement.java:70) at com.p6spy.engine.logging.P6LogPreparedStatement.executeQuery(P6LogPreparedStatement.java:172) at com.mchange.v2.sql.filter.FilterPreparedStatement.executeQuery(FilterPreparedStatement.java:68) at com.mchange.v2.c3p0.impl.C3P0PooledConnection$2.executeQuery(C3P0PooledConnection.java:561) at net.sf.hibernate.impl.BatcherImpl.getResultSet(BatcherImpl.java:87) at net.sf.hibernate.loader.Loader.getResultSet(Loader.java:795) at net.sf.hibernate.loader.Loader.doQuery(Loader.java:189) at net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:133) at net.sf.hibernate.loader.Loader.doList(Loader.java:950) at net.sf.hibernate.loader.Loader.list(Loader.java:935) at net.sf.hibernate.hql.QueryTranslator.list(QueryTranslator.java:834) at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1512) at net.sf.hibernate.impl.QueryImpl.list(QueryImpl.java:39) at com.atlassian.confluence.core.persistence.hibernate.HibernateObjectDao$4.doInHibernate(HibernateObjectDao.java:310) at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:149) at org.springframework.orm.hibernate.HibernateTemplate.executeFind(HibernateTemplate.java:473) at com.atlassian.confluence.core.persistence.hibernate.HibernateObjectDao.findNamedQueryStringParams(HibernateObjectDao.java:291) at com.atlassian.confluence.core.persistence.hibernate.HibernateObjectDao.findNamedQueryStringParams(HibernateObjectDao.java:276) at com.atlassian.confluence.core.persistence.hibernate.HibernateObjectDao.findNamedQueryStringParams(HibernateObjectDao.java:256) at com.atlassian.confluence.core.persistence.hibernate.HibernateObjectDao.findNamedQueryStringParam(HibernateObjectDao.java:241) at com.atlassian.confluence.pages.persistence.dao.hibernate.HibernatePageDao.findPagesWithHistoricalTitle(HibernatePageDao.java:279) at com.atlassian.confluence.pages.DefaultPageManager.getPossibleRedirects(DefaultPageManager.java:156) 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:59) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:201) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176) at com.atlassian.confluence.util.profiling.SpringProfilingInterceptor.invoke(SpringProfilingInterceptor.java:17) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:196) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:154) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:196) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:135) at $Proxy3.getPossibleRedirects(Unknown Source) at com.atlassian.confluence.pages.actions.ViewPageAction.getPossibleAlternativesElsewhere(ViewPageAction.java:259) at com.atlassian.confluence.pages.actions.ViewPageAction.execute(ViewPageAction.java:104) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:171) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:37) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:168) at com.opensymphony.xwork.interceptor.DefaultWorkflowInterceptor.intercept(DefaultWorkflowInterceptor.java:58) at com.atlassian.confluence.core.ConfluenceWorkflowInterceptor.intercept(ConfluenceWorkflowInterceptor.java:32) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:168) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:37) at com.atlassian.confluence.core.ConfluenceValidationInterceptor.intercept(ConfluenceValidationInterceptor.java:18) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:168) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:37) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:168) at com.atlassian.confluence.security.actions.PermissionCheckInterceptor.intercept(PermissionCheckInterceptor.java:40) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:168) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:37) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:168) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:37) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:168) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:37) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:168) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:37) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:168) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:37) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:168) at com.opensymphony.xwork.DefaultActionProxy.execute(DefaultActionProxy.java:116) at com.opensymphony.webwork.dispatcher.ServletDispatcher.serviceAction(ServletDispatcher.java:182) at com.opensymphony.webwork.dispatcher.ServletDispatcher.service(ServletDispatcher.java:162) at javax.servlet.http.HttpServlet.service(HttpServlet.java:103) at com.caucho.server.http.FilterChainServlet.doFilter(FilterChainServlet.java:96) at com.caucho.server.http.Invocation.service(Invocation.java:315) at com.caucho.server.http.CacheInvocation.service(CacheInvocation.java:115) at com.caucho.server.http.QRequestDispatcher.forward(QRequestDispatcher.java:222) at com.caucho.server.http.QRequestDispatcher.forward(QRequestDispatcher.java:103) at com.caucho.server.http.QRequestDispatcher.forward(QRequestDispatcher.java:80) at com.atlassian.confluence.servlet.SimpleDisplayServlet.doGet(SimpleDisplayServlet.java:56) at javax.servlet.http.HttpServlet.service(HttpServlet.java:126) at javax.servlet.http.HttpServlet.service(HttpServlet.java:103) at com.caucho.server.http.FilterChainServlet.doFilter(FilterChainServlet.java:96) at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:129) at com.atlassian.confluence.util.profiling.ProfilingPageFilter.parsePage(ProfilingPageFilter.java:36) at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:61) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at com.atlassian.seraph.filter.SecurityFilter.doFilter(SecurityFilter.java:161) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at com.atlassian.seraph.filter.LoginFilter.doFilter(LoginFilter.java:181) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at com.atlassian.johnson.filters.JohnsonFilter.doFilter(JohnsonFilter.java:96) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at org.springframework.orm.hibernate.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:100) at com.atlassian.confluence.setup.SpringSessionInViewFilter.doFilterInternal(SpringSessionInViewFilter.java:32) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:57) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at com.atlassian.util.profiling.filters.ProfilingFilter.doFilter(ProfilingFilter.java:132) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at com.atlassian.core.filters.AbstractEncodingFilter.doFilter(AbstractEncodingFilter.java:38) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at com.caucho.server.http.Invocation.service(Invocation.java:315) at com.caucho.server.http.CacheInvocation.service(CacheInvocation.java:135) at com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:246) at com.caucho.server.http.HttpRequest.handleConnection(HttpRequest.java:164) at com.caucho.server.TcpConnection.run(TcpConnection.java:139) at java.lang.Thread.run(Thread.java:534)

    Atlassian JIRA | 1 decade ago | Charles Miller
    com.sybase.jdbc2.jdbc.SybSQLException: TEXT, IMAGE and off-row Java datatypes may not be selected as DISTINCT.
  2. 0

    2004-03-23 16:17:59,582 WARN [springframework.jdbc.support.SQLStateSQLExceptionTranslator] Translating SQLException with SQLState 'ZZZZZ' and errorCode '421' and message [TEXT, IMAGE and off-row Java datatypes may not be selected as DISTINCT. ]; SQL was [null] for task [HibernateAccessor] 2004-03-23 16:17:59,587 ERROR [opensymphony.webwork.dispatcher.ServletDispatcher] Could not execute action org.springframework.jdbc.UncategorizedSQLException: (HibernateAccessor): encountered SQLException [TEXT, IMAGE and off-row Java datatypes may not be selected as DISTINCT. ]; nested exception is com.sybase.jdbc2.jdbc.SybSQLException: TEXT, IMAGE and off-row Java datatypes may not be selected as DISTINCT. com.sybase.jdbc2.jdbc.SybSQLException: TEXT, IMAGE and off-row Java datatypes may not be selected as DISTINCT. at com.sybase.jdbc2.tds.Tds.processEed(Tds.java:2636) at com.sybase.jdbc2.tds.Tds.nextResult(Tds.java:1996) at com.sybase.jdbc2.jdbc.ResultGetter.nextResult(ResultGetter.java:69) at com.sybase.jdbc2.jdbc.SybStatement.nextResult(SybStatement.java:204) at com.sybase.jdbc2.jdbc.SybStatement.nextResult(SybStatement.java:187) at com.sybase.jdbc2.jdbc.SybStatement.queryLoop(SybStatement.java:1510) at com.sybase.jdbc2.jdbc.SybStatement.executeQuery(SybStatement.java:1495) at com.sybase.jdbc2.jdbc.SybPreparedStatement.executeQuery(SybPreparedStatement.java:70) at com.p6spy.engine.logging.P6LogPreparedStatement.executeQuery(P6LogPreparedStatement.java:172) at com.mchange.v2.sql.filter.FilterPreparedStatement.executeQuery(FilterPreparedStatement.java:68) at com.mchange.v2.c3p0.impl.C3P0PooledConnection$2.executeQuery(C3P0PooledConnection.java:561) at net.sf.hibernate.impl.BatcherImpl.getResultSet(BatcherImpl.java:87) at net.sf.hibernate.loader.Loader.getResultSet(Loader.java:795) at net.sf.hibernate.loader.Loader.doQuery(Loader.java:189) at net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:133) at net.sf.hibernate.loader.Loader.doList(Loader.java:950) at net.sf.hibernate.loader.Loader.list(Loader.java:935) at net.sf.hibernate.hql.QueryTranslator.list(QueryTranslator.java:834) at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1512) at net.sf.hibernate.impl.QueryImpl.list(QueryImpl.java:39) at com.atlassian.confluence.core.persistence.hibernate.HibernateObjectDao$4.doInHibernate(HibernateObjectDao.java:310) at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:149) at org.springframework.orm.hibernate.HibernateTemplate.executeFind(HibernateTemplate.java:473) at com.atlassian.confluence.core.persistence.hibernate.HibernateObjectDao.findNamedQueryStringParams(HibernateObjectDao.java:291) at com.atlassian.confluence.core.persistence.hibernate.HibernateObjectDao.findNamedQueryStringParams(HibernateObjectDao.java:276) at com.atlassian.confluence.core.persistence.hibernate.HibernateObjectDao.findNamedQueryStringParams(HibernateObjectDao.java:256) at com.atlassian.confluence.core.persistence.hibernate.HibernateObjectDao.findNamedQueryStringParam(HibernateObjectDao.java:241) at com.atlassian.confluence.pages.persistence.dao.hibernate.HibernatePageDao.findPagesWithHistoricalTitle(HibernatePageDao.java:279) at com.atlassian.confluence.pages.DefaultPageManager.getPossibleRedirects(DefaultPageManager.java:156) 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:59) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:201) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176) at com.atlassian.confluence.util.profiling.SpringProfilingInterceptor.invoke(SpringProfilingInterceptor.java:17) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:196) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:154) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:196) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:135) at $Proxy3.getPossibleRedirects(Unknown Source) at com.atlassian.confluence.pages.actions.ViewPageAction.getPossibleAlternativesElsewhere(ViewPageAction.java:259) at com.atlassian.confluence.pages.actions.ViewPageAction.execute(ViewPageAction.java:104) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:171) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:37) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:168) at com.opensymphony.xwork.interceptor.DefaultWorkflowInterceptor.intercept(DefaultWorkflowInterceptor.java:58) at com.atlassian.confluence.core.ConfluenceWorkflowInterceptor.intercept(ConfluenceWorkflowInterceptor.java:32) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:168) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:37) at com.atlassian.confluence.core.ConfluenceValidationInterceptor.intercept(ConfluenceValidationInterceptor.java:18) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:168) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:37) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:168) at com.atlassian.confluence.security.actions.PermissionCheckInterceptor.intercept(PermissionCheckInterceptor.java:40) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:168) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:37) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:168) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:37) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:168) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:37) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:168) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:37) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:168) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:37) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:168) at com.opensymphony.xwork.DefaultActionProxy.execute(DefaultActionProxy.java:116) at com.opensymphony.webwork.dispatcher.ServletDispatcher.serviceAction(ServletDispatcher.java:182) at com.opensymphony.webwork.dispatcher.ServletDispatcher.service(ServletDispatcher.java:162) at javax.servlet.http.HttpServlet.service(HttpServlet.java:103) at com.caucho.server.http.FilterChainServlet.doFilter(FilterChainServlet.java:96) at com.caucho.server.http.Invocation.service(Invocation.java:315) at com.caucho.server.http.CacheInvocation.service(CacheInvocation.java:115) at com.caucho.server.http.QRequestDispatcher.forward(QRequestDispatcher.java:222) at com.caucho.server.http.QRequestDispatcher.forward(QRequestDispatcher.java:103) at com.caucho.server.http.QRequestDispatcher.forward(QRequestDispatcher.java:80) at com.atlassian.confluence.servlet.SimpleDisplayServlet.doGet(SimpleDisplayServlet.java:56) at javax.servlet.http.HttpServlet.service(HttpServlet.java:126) at javax.servlet.http.HttpServlet.service(HttpServlet.java:103) at com.caucho.server.http.FilterChainServlet.doFilter(FilterChainServlet.java:96) at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:129) at com.atlassian.confluence.util.profiling.ProfilingPageFilter.parsePage(ProfilingPageFilter.java:36) at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:61) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at com.atlassian.seraph.filter.SecurityFilter.doFilter(SecurityFilter.java:161) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at com.atlassian.seraph.filter.LoginFilter.doFilter(LoginFilter.java:181) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at com.atlassian.johnson.filters.JohnsonFilter.doFilter(JohnsonFilter.java:96) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at org.springframework.orm.hibernate.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:100) at com.atlassian.confluence.setup.SpringSessionInViewFilter.doFilterInternal(SpringSessionInViewFilter.java:32) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:57) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at com.atlassian.util.profiling.filters.ProfilingFilter.doFilter(ProfilingFilter.java:132) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at com.atlassian.core.filters.AbstractEncodingFilter.doFilter(AbstractEncodingFilter.java:38) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at com.caucho.server.http.Invocation.service(Invocation.java:315) at com.caucho.server.http.CacheInvocation.service(CacheInvocation.java:135) at com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:246) at com.caucho.server.http.HttpRequest.handleConnection(HttpRequest.java:164) at com.caucho.server.TcpConnection.run(TcpConnection.java:139) at java.lang.Thread.run(Thread.java:534)

    Atlassian JIRA | 1 decade ago | Charles Miller
    com.sybase.jdbc2.jdbc.SybSQLException: TEXT, IMAGE and off-row Java datatypes may not be selected as DISTINCT.
  3. 0

    Getting Datatype mismatch in Hibernate Criteria

    Stack Overflow | 3 years ago | amin
    com.sybase.jdbc2.jdbc.SybSQLException: Implicit conversion from datatype 'VARCHAR' to 'BIT' is not allowed. Use the CONVERT function to run this query.</p> </blockquote> <pre><code>at com.sybase.jdbc2.tds.Tds.processEed(Tds.java:2796)
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    under-the-covers stored procedures conflict with caching prepared statements...

    Google Groups | 1 decade ago | Joe Weinstein
    com.sybase.jdbc2.jdbc.SybSQLException: Stored procedure '*0000890000 0000_0033c9' may be run only in unchained transaction mode. The 'SET CHAINED OFF' command will cause the current session to use unchained transaction mode.
  6. 0

    setAutoCommit() can invalidate a PreparedStatement!

    Google Groups | 1 decade ago | Joe Weinstein
    com.sybase.jdbc2.jdbc.SybSQLException: Stored procedure '*0000950000 0000_0033c9' may be run only in unchained transaction mode. The 'SET CHAINED OFF' command will cause the current session to use unchained transaction mode.

    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. com.sybase.jdbc2.jdbc.SybSQLException

      TEXT, IMAGE and off-row Java datatypes may not be selected as DISTINCT.

      at com.sybase.jdbc2.tds.Tds.processEed()
    2. com.sybase.jdbc2
      SybPreparedStatement.executeQuery
      1. com.sybase.jdbc2.tds.Tds.processEed(Tds.java:2636)
      2. com.sybase.jdbc2.tds.Tds.nextResult(Tds.java:1996)
      3. com.sybase.jdbc2.jdbc.ResultGetter.nextResult(ResultGetter.java:69)
      4. com.sybase.jdbc2.jdbc.SybStatement.nextResult(SybStatement.java:204)
      5. com.sybase.jdbc2.jdbc.SybStatement.nextResult(SybStatement.java:187)
      6. com.sybase.jdbc2.jdbc.SybStatement.queryLoop(SybStatement.java:1510)
      7. com.sybase.jdbc2.jdbc.SybStatement.executeQuery(SybStatement.java:1495)
      8. com.sybase.jdbc2.jdbc.SybPreparedStatement.executeQuery(SybPreparedStatement.java:70)
      8 frames
    3. P6Spy
      P6LogPreparedStatement.executeQuery
      1. com.p6spy.engine.logging.P6LogPreparedStatement.executeQuery(P6LogPreparedStatement.java:172)
      1 frame
    4. c3p0:JDBC DataSources/Resource Pools
      C3P0PooledConnection$2.executeQuery
      1. com.mchange.v2.sql.filter.FilterPreparedStatement.executeQuery(FilterPreparedStatement.java:68)
      2. com.mchange.v2.c3p0.impl.C3P0PooledConnection$2.executeQuery(C3P0PooledConnection.java:561)
      2 frames
    5. net.sf.hibernate
      QueryImpl.list
      1. net.sf.hibernate.impl.BatcherImpl.getResultSet(BatcherImpl.java:87)
      2. net.sf.hibernate.loader.Loader.getResultSet(Loader.java:795)
      3. net.sf.hibernate.loader.Loader.doQuery(Loader.java:189)
      4. net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:133)
      5. net.sf.hibernate.loader.Loader.doList(Loader.java:950)
      6. net.sf.hibernate.loader.Loader.list(Loader.java:935)
      7. net.sf.hibernate.hql.QueryTranslator.list(QueryTranslator.java:834)
      8. net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1512)
      9. net.sf.hibernate.impl.QueryImpl.list(QueryImpl.java:39)
      9 frames
    6. com.atlassian.confluence
      HibernateObjectDao$4.doInHibernate
      1. com.atlassian.confluence.core.persistence.hibernate.HibernateObjectDao$4.doInHibernate(HibernateObjectDao.java:310)
      1 frame
    7. Hibernate
      HibernateTemplate.executeFind
      1. org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:149)
      2. org.springframework.orm.hibernate.HibernateTemplate.executeFind(HibernateTemplate.java:473)
      2 frames
    8. com.atlassian.confluence
      DefaultPageManager.getPossibleRedirects
      1. com.atlassian.confluence.core.persistence.hibernate.HibernateObjectDao.findNamedQueryStringParams(HibernateObjectDao.java:291)
      2. com.atlassian.confluence.core.persistence.hibernate.HibernateObjectDao.findNamedQueryStringParams(HibernateObjectDao.java:276)
      3. com.atlassian.confluence.core.persistence.hibernate.HibernateObjectDao.findNamedQueryStringParams(HibernateObjectDao.java:256)
      4. com.atlassian.confluence.core.persistence.hibernate.HibernateObjectDao.findNamedQueryStringParam(HibernateObjectDao.java:241)
      5. com.atlassian.confluence.pages.persistence.dao.hibernate.HibernatePageDao.findPagesWithHistoricalTitle(HibernatePageDao.java:279)
      6. com.atlassian.confluence.pages.DefaultPageManager.getPossibleRedirects(DefaultPageManager.java:156)
      6 frames
    9. 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
    10. Spring AOP
      ReflectiveMethodInvocation.proceed
      1. org.springframework.aop.framework.AopProxyUtils.invokeJoinpointUsingReflection(AopProxyUtils.java:59)
      2. org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:201)
      3. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176)
      3 frames
    11. com.atlassian.confluence
      SpringProfilingInterceptor.invoke
      1. com.atlassian.confluence.util.profiling.SpringProfilingInterceptor.invoke(SpringProfilingInterceptor.java:17)
      1 frame
    12. Spring AOP
      ReflectiveMethodInvocation.proceed
      1. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:196)
      1 frame
    13. Spring Tx
      TransactionInterceptor.invoke
      1. org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:154)
      1 frame
    14. Spring AOP
      JdkDynamicAopProxy.invoke
      1. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:196)
      2. org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:135)
      2 frames
    15. Unknown
      $Proxy3.getPossibleRedirects
      1. $Proxy3.getPossibleRedirects(Unknown Source)
      1 frame
    16. com.atlassian.confluence
      ViewPageAction.execute
      1. com.atlassian.confluence.pages.actions.ViewPageAction.getPossibleAlternativesElsewhere(ViewPageAction.java:259)
      2. com.atlassian.confluence.pages.actions.ViewPageAction.execute(ViewPageAction.java:104)
      2 frames
    17. XWork Tiger Extensions
      DefaultActionInvocation.invoke
      1. com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:171)
      1 frame
    18. com.opensymphony.xwork
      AroundInterceptor.intercept
      1. com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:37)
      1 frame
    19. XWork Tiger Extensions
      DefaultActionInvocation.invoke
      1. com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:168)
      1 frame
    20. com.opensymphony.xwork
      DefaultWorkflowInterceptor.intercept
      1. com.opensymphony.xwork.interceptor.DefaultWorkflowInterceptor.intercept(DefaultWorkflowInterceptor.java:58)
      1 frame
    21. com.atlassian.confluence
      ConfluenceWorkflowInterceptor.intercept
      1. com.atlassian.confluence.core.ConfluenceWorkflowInterceptor.intercept(ConfluenceWorkflowInterceptor.java:32)
      1 frame
    22. XWork Tiger Extensions
      DefaultActionInvocation.invoke
      1. com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:168)
      1 frame
    23. com.opensymphony.xwork
      AroundInterceptor.intercept
      1. com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:37)
      1 frame
    24. com.atlassian.confluence
      ConfluenceValidationInterceptor.intercept
      1. com.atlassian.confluence.core.ConfluenceValidationInterceptor.intercept(ConfluenceValidationInterceptor.java:18)
      1 frame
    25. XWork Tiger Extensions
      DefaultActionInvocation.invoke
      1. com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:168)
      1 frame
    26. com.opensymphony.xwork
      AroundInterceptor.intercept
      1. com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:37)
      1 frame
    27. XWork Tiger Extensions
      DefaultActionInvocation.invoke
      1. com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:168)
      1 frame
    28. com.atlassian.confluence
      PermissionCheckInterceptor.intercept
      1. com.atlassian.confluence.security.actions.PermissionCheckInterceptor.intercept(PermissionCheckInterceptor.java:40)
      1 frame
    29. XWork Tiger Extensions
      DefaultActionInvocation.invoke
      1. com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:168)
      1 frame
    30. com.opensymphony.xwork
      AroundInterceptor.intercept
      1. com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:37)
      1 frame
    31. XWork Tiger Extensions
      DefaultActionInvocation.invoke
      1. com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:168)
      1 frame
    32. com.opensymphony.xwork
      AroundInterceptor.intercept
      1. com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:37)
      1 frame
    33. XWork Tiger Extensions
      DefaultActionInvocation.invoke
      1. com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:168)
      1 frame
    34. com.opensymphony.xwork
      AroundInterceptor.intercept
      1. com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:37)
      1 frame
    35. XWork Tiger Extensions
      DefaultActionInvocation.invoke
      1. com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:168)
      1 frame
    36. com.opensymphony.xwork
      AroundInterceptor.intercept
      1. com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:37)
      1 frame
    37. XWork Tiger Extensions
      DefaultActionInvocation.invoke
      1. com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:168)
      1 frame
    38. com.opensymphony.xwork
      AroundInterceptor.intercept
      1. com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:37)
      1 frame
    39. XWork Tiger Extensions
      DefaultActionProxy.execute
      1. com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:168)
      2. com.opensymphony.xwork.DefaultActionProxy.execute(DefaultActionProxy.java:116)
      2 frames
    40. WebWork
      ServletDispatcher.service
      1. com.opensymphony.webwork.dispatcher.ServletDispatcher.serviceAction(ServletDispatcher.java:182)
      2. com.opensymphony.webwork.dispatcher.ServletDispatcher.service(ServletDispatcher.java:162)
      2 frames
    41. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:103)
      1 frame
    42. com.caucho.server
      QRequestDispatcher.forward
      1. com.caucho.server.http.FilterChainServlet.doFilter(FilterChainServlet.java:96)
      2. com.caucho.server.http.Invocation.service(Invocation.java:315)
      3. com.caucho.server.http.CacheInvocation.service(CacheInvocation.java:115)
      4. com.caucho.server.http.QRequestDispatcher.forward(QRequestDispatcher.java:222)
      5. com.caucho.server.http.QRequestDispatcher.forward(QRequestDispatcher.java:103)
      6. com.caucho.server.http.QRequestDispatcher.forward(QRequestDispatcher.java:80)
      6 frames
    43. com.atlassian.confluence
      SimpleDisplayServlet.doGet
      1. com.atlassian.confluence.servlet.SimpleDisplayServlet.doGet(SimpleDisplayServlet.java:56)
      1 frame
    44. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:126)
      2. javax.servlet.http.HttpServlet.service(HttpServlet.java:103)
      2 frames
    45. com.caucho.server
      FilterChainServlet.doFilter
      1. com.caucho.server.http.FilterChainServlet.doFilter(FilterChainServlet.java:96)
      1 frame
    46. Sitemesh
      PageFilter.parsePage
      1. com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:129)
      1 frame
    47. com.atlassian.confluence
      ProfilingPageFilter.parsePage
      1. com.atlassian.confluence.util.profiling.ProfilingPageFilter.parsePage(ProfilingPageFilter.java:36)
      1 frame
    48. Sitemesh
      PageFilter.doFilter
      1. com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:61)
      1 frame
    49. com.caucho.server
      FilterChainFilter.doFilter
      1. com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88)
      1 frame
    50. com.atlassian.seraph
      SecurityFilter.doFilter
      1. com.atlassian.seraph.filter.SecurityFilter.doFilter(SecurityFilter.java:161)
      1 frame
    51. com.caucho.server
      FilterChainFilter.doFilter
      1. com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88)
      1 frame
    52. com.atlassian.seraph
      LoginFilter.doFilter
      1. com.atlassian.seraph.filter.LoginFilter.doFilter(LoginFilter.java:181)
      1 frame
    53. com.caucho.server
      FilterChainFilter.doFilter
      1. com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88)
      1 frame
    54. com.atlassian.johnson
      JohnsonFilter.doFilter
      1. com.atlassian.johnson.filters.JohnsonFilter.doFilter(JohnsonFilter.java:96)
      1 frame
    55. com.caucho.server
      FilterChainFilter.doFilter
      1. com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88)
      1 frame
    56. Hibernate
      OpenSessionInViewFilter.doFilterInternal
      1. org.springframework.orm.hibernate.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:100)
      1 frame
    57. com.atlassian.confluence
      SpringSessionInViewFilter.doFilterInternal
      1. com.atlassian.confluence.setup.SpringSessionInViewFilter.doFilterInternal(SpringSessionInViewFilter.java:32)
      1 frame
    58. Spring
      OncePerRequestFilter.doFilter
      1. org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:57)
      1 frame
    59. com.caucho.server
      FilterChainFilter.doFilter
      1. com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88)
      1 frame
    60. com.atlassian.util
      ProfilingFilter.doFilter
      1. com.atlassian.util.profiling.filters.ProfilingFilter.doFilter(ProfilingFilter.java:132)
      1 frame
    61. com.caucho.server
      FilterChainFilter.doFilter
      1. com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88)
      1 frame
    62. com.atlassian.core
      AbstractEncodingFilter.doFilter
      1. com.atlassian.core.filters.AbstractEncodingFilter.doFilter(AbstractEncodingFilter.java:38)
      1 frame
    63. com.caucho.server
      TcpConnection.run
      1. com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88)
      2. com.caucho.server.http.Invocation.service(Invocation.java:315)
      3. com.caucho.server.http.CacheInvocation.service(CacheInvocation.java:135)
      4. com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:246)
      5. com.caucho.server.http.HttpRequest.handleConnection(HttpRequest.java:164)
      6. com.caucho.server.TcpConnection.run(TcpConnection.java:139)
      6 frames
    64. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:534)
      1 frame