com.sap.dbtech.jdbc.exceptions.DatabaseException: [-3008] (at 371): Invalid keyword or missing delimiter

Atlassian JIRA | Dave Loeng [Atlassian] | 1 decade ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    Stack trace: Database Trace: com.sap.dbtech.jdbc.ConnectionSapDB@579515.prepareStatement (select distinct space.SPACEID as SPACEID0_, space.SPACENAME as SPACENAME0_, space.SPACEKEY as SPACEKEY0_, space.SPACEDESCID as SPACEDES4_0_, space.HOMEPAGE as HOMEPAGE0_, space.CREATOR as CREATOR0_, space.CREATIONDATE as CREATION7_0_, space.LASTMODIFIER as LASTMODI8_0_, space.LASTMODDATE as LASTMODD9_0_, space.SPACETYPE as SPACETYPE0_ from SPACEPERMISSIONS sp, SPACES space where sp.SPACEID = space.SPACEID and sp.PERMUSERNAME is null and sp.PERMGROUPNAME is null and sp.PERMTYPE = ? and space.SPACETYPE = ?) <-! Timestamp: 2006-06-29 12:13:15.56 com.sap.dbtech.jdbc.exceptions.DatabaseException: [-3008] (at 371): Invalid keyword or missing delimiter at com.sap.dbtech.jdbc.packet.ReplyPacket.createException(ReplyPacket.java:72) at com.sap.dbtech.jdbc.ConnectionSapDB.throwSQLError(ConnectionSapDB.java:927) at com.sap.dbtech.jdbc.ConnectionSapDB.execute(ConnectionSapDB.java:571) at com.sap.dbtech.jdbc.CallableStatementSapDB.sendCommand(CallableStatementSapDB.java:1773) at com.sap.dbtech.jdbc.StatementSapDB.sendSQL(StatementSapDB.java:835) at com.sap.dbtech.jdbc.CallableStatementSapDB.doParse(CallableStatementSapDB.java:233) at com.sap.dbtech.jdbc.CallableStatementSapDB.constructor(CallableStatementSapDB.java:186) at com.sap.dbtech.jdbc.CallableStatementSapDB.<init>(CallableStatementSapDB.java:88) at com.sap.dbtech.jdbc.ConnectionSapDB.prepareStatement(ConnectionSapDB.java:819) at com.sap.dbtech.jdbc.trace.Connection.prepareStatement(Connection.java:587) at com.sap.sql.jdbc.direct.DirectConnection.prepareStatement(DirectConnection.java:278) at com.sap.sql.jdbc.direct.DirectConnection.prepareStatement(DirectConnection.java:218) at com.sap.engine.services.dbpool.cci.ConnectionHandle.prepareStatement(ConnectionHandle.java:81) at net.sf.hibernate.impl.BatcherImpl.getPreparedStatement(BatcherImpl.java:263) at net.sf.hibernate.impl.BatcherImpl.getPreparedStatement(BatcherImpl.java:236) at net.sf.hibernate.impl.BatcherImpl.prepareQueryStatement(BatcherImpl.java:67) at net.sf.hibernate.loader.Loader.prepareQueryStatement(Loader.java:784) at net.sf.hibernate.loader.Loader.doQuery(Loader.java:269) at net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:138) at net.sf.hibernate.loader.Loader.doList(Loader.java:1063) at net.sf.hibernate.loader.Loader.list(Loader.java:1054) at net.sf.hibernate.loader.SQLLoader.list(SQLLoader.java:92) at net.sf.hibernate.impl.SessionImpl.findBySQL(SessionImpl.java:3867) at net.sf.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:52) at com.atlassian.confluence.spaces.persistence.dao.hibernate.HibernateSpaceDao$7.doInHibernate(HibernateSpaceDao.java:416) at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:200) at com.atlassian.confluence.spaces.persistence.dao.hibernate.HibernateSpaceDao.getPermittedSpacesForUserByType(HibernateSpaceDao.java:387) at com.atlassian.confluence.spaces.DefaultSpaceManager.getPermittedSpaces(DefaultSpaceManager.java:197) 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:18) 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)

    Atlassian JIRA | 1 decade ago | Dave Loeng [Atlassian]
    com.sap.dbtech.jdbc.exceptions.DatabaseException: [-3008] (at 371): Invalid keyword or missing delimiter
  2. 0

    Stack trace: Database Trace: com.sap.dbtech.jdbc.ConnectionSapDB@579515.prepareStatement (select distinct space.SPACEID as SPACEID0_, space.SPACENAME as SPACENAME0_, space.SPACEKEY as SPACEKEY0_, space.SPACEDESCID as SPACEDES4_0_, space.HOMEPAGE as HOMEPAGE0_, space.CREATOR as CREATOR0_, space.CREATIONDATE as CREATION7_0_, space.LASTMODIFIER as LASTMODI8_0_, space.LASTMODDATE as LASTMODD9_0_, space.SPACETYPE as SPACETYPE0_ from SPACEPERMISSIONS sp, SPACES space where sp.SPACEID = space.SPACEID and sp.PERMUSERNAME is null and sp.PERMGROUPNAME is null and sp.PERMTYPE = ? and space.SPACETYPE = ?) <-! Timestamp: 2006-06-29 12:13:15.56 com.sap.dbtech.jdbc.exceptions.DatabaseException: [-3008] (at 371): Invalid keyword or missing delimiter at com.sap.dbtech.jdbc.packet.ReplyPacket.createException(ReplyPacket.java:72) at com.sap.dbtech.jdbc.ConnectionSapDB.throwSQLError(ConnectionSapDB.java:927) at com.sap.dbtech.jdbc.ConnectionSapDB.execute(ConnectionSapDB.java:571) at com.sap.dbtech.jdbc.CallableStatementSapDB.sendCommand(CallableStatementSapDB.java:1773) at com.sap.dbtech.jdbc.StatementSapDB.sendSQL(StatementSapDB.java:835) at com.sap.dbtech.jdbc.CallableStatementSapDB.doParse(CallableStatementSapDB.java:233) at com.sap.dbtech.jdbc.CallableStatementSapDB.constructor(CallableStatementSapDB.java:186) at com.sap.dbtech.jdbc.CallableStatementSapDB.<init>(CallableStatementSapDB.java:88) at com.sap.dbtech.jdbc.ConnectionSapDB.prepareStatement(ConnectionSapDB.java:819) at com.sap.dbtech.jdbc.trace.Connection.prepareStatement(Connection.java:587) at com.sap.sql.jdbc.direct.DirectConnection.prepareStatement(DirectConnection.java:278) at com.sap.sql.jdbc.direct.DirectConnection.prepareStatement(DirectConnection.java:218) at com.sap.engine.services.dbpool.cci.ConnectionHandle.prepareStatement(ConnectionHandle.java:81) at net.sf.hibernate.impl.BatcherImpl.getPreparedStatement(BatcherImpl.java:263) at net.sf.hibernate.impl.BatcherImpl.getPreparedStatement(BatcherImpl.java:236) at net.sf.hibernate.impl.BatcherImpl.prepareQueryStatement(BatcherImpl.java:67) at net.sf.hibernate.loader.Loader.prepareQueryStatement(Loader.java:784) at net.sf.hibernate.loader.Loader.doQuery(Loader.java:269) at net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:138) at net.sf.hibernate.loader.Loader.doList(Loader.java:1063) at net.sf.hibernate.loader.Loader.list(Loader.java:1054) at net.sf.hibernate.loader.SQLLoader.list(SQLLoader.java:92) at net.sf.hibernate.impl.SessionImpl.findBySQL(SessionImpl.java:3867) at net.sf.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:52) at com.atlassian.confluence.spaces.persistence.dao.hibernate.HibernateSpaceDao$7.doInHibernate(HibernateSpaceDao.java:416) at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:200) at com.atlassian.confluence.spaces.persistence.dao.hibernate.HibernateSpaceDao.getPermittedSpacesForUserByType(HibernateSpaceDao.java:387) at com.atlassian.confluence.spaces.DefaultSpaceManager.getPermittedSpaces(DefaultSpaceManager.java:197) 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:18) 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)

    Atlassian JIRA | 1 decade ago | Dave Loeng [Atlassian]
    com.sap.dbtech.jdbc.exceptions.DatabaseException: [-3008] (at 371): Invalid keyword or missing delimiter

    Root Cause Analysis

    1. com.sap.dbtech.jdbc.exceptions.DatabaseException

      [-3008] (at 371): Invalid keyword or missing delimiter

      at com.sap.dbtech.jdbc.packet.ReplyPacket.createException()
    2. com.sap.dbtech
      Connection.prepareStatement
      1. com.sap.dbtech.jdbc.packet.ReplyPacket.createException(ReplyPacket.java:72)
      2. com.sap.dbtech.jdbc.ConnectionSapDB.throwSQLError(ConnectionSapDB.java:927)
      3. com.sap.dbtech.jdbc.ConnectionSapDB.execute(ConnectionSapDB.java:571)
      4. com.sap.dbtech.jdbc.CallableStatementSapDB.sendCommand(CallableStatementSapDB.java:1773)
      5. com.sap.dbtech.jdbc.StatementSapDB.sendSQL(StatementSapDB.java:835)
      6. com.sap.dbtech.jdbc.CallableStatementSapDB.doParse(CallableStatementSapDB.java:233)
      7. com.sap.dbtech.jdbc.CallableStatementSapDB.constructor(CallableStatementSapDB.java:186)
      8. com.sap.dbtech.jdbc.CallableStatementSapDB.<init>(CallableStatementSapDB.java:88)
      9. com.sap.dbtech.jdbc.ConnectionSapDB.prepareStatement(ConnectionSapDB.java:819)
      10. com.sap.dbtech.jdbc.trace.Connection.prepareStatement(Connection.java:587)
      10 frames
    3. com.sap.sql
      DirectConnection.prepareStatement
      1. com.sap.sql.jdbc.direct.DirectConnection.prepareStatement(DirectConnection.java:278)
      2. com.sap.sql.jdbc.direct.DirectConnection.prepareStatement(DirectConnection.java:218)
      2 frames
    4. com.sap.engine
      ConnectionHandle.prepareStatement
      1. com.sap.engine.services.dbpool.cci.ConnectionHandle.prepareStatement(ConnectionHandle.java:81)
      1 frame
    5. net.sf.hibernate
      SQLQueryImpl.list
      1. net.sf.hibernate.impl.BatcherImpl.getPreparedStatement(BatcherImpl.java:263)
      2. net.sf.hibernate.impl.BatcherImpl.getPreparedStatement(BatcherImpl.java:236)
      3. net.sf.hibernate.impl.BatcherImpl.prepareQueryStatement(BatcherImpl.java:67)
      4. net.sf.hibernate.loader.Loader.prepareQueryStatement(Loader.java:784)
      5. net.sf.hibernate.loader.Loader.doQuery(Loader.java:269)
      6. net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:138)
      7. net.sf.hibernate.loader.Loader.doList(Loader.java:1063)
      8. net.sf.hibernate.loader.Loader.list(Loader.java:1054)
      9. net.sf.hibernate.loader.SQLLoader.list(SQLLoader.java:92)
      10. net.sf.hibernate.impl.SessionImpl.findBySQL(SessionImpl.java:3867)
      11. net.sf.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:52)
      11 frames
    6. com.atlassian.confluence
      HibernateSpaceDao$7.doInHibernate
      1. com.atlassian.confluence.spaces.persistence.dao.hibernate.HibernateSpaceDao$7.doInHibernate(HibernateSpaceDao.java:416)
      1 frame
    7. Hibernate
      HibernateTemplate.execute
      1. org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:200)
      1 frame
    8. com.atlassian.confluence
      DefaultSpaceManager.getPermittedSpaces
      1. com.atlassian.confluence.spaces.persistence.dao.hibernate.HibernateSpaceDao.getPermittedSpacesForUserByType(HibernateSpaceDao.java:387)
      2. com.atlassian.confluence.spaces.DefaultSpaceManager.getPermittedSpaces(DefaultSpaceManager.java:197)
      2 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:61)
      2. org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:149)
      3. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:116)
      3 frames
    11. com.atlassian.confluence
      SpringProfilingInterceptor.invoke
      1. com.atlassian.confluence.util.profiling.SpringProfilingInterceptor.invoke(SpringProfilingInterceptor.java:18)
      1 frame
    12. Spring AOP
      ReflectiveMethodInvocation.proceed
      1. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:138)
      1 frame
    13. Spring Tx
      TransactionInterceptor.invoke
      1. org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:56)
      1 frame
    14. Spring AOP
      ReflectiveMethodInvocation.proceed
      1. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:138)
      1 frame