SqlSyntaxErrorException when starting JCR service configured with DB2 10 ------------------------------------------------------------------------ Key: GTNPORTAL-2935 URL: https://issues.jboss.org/browse/GTNPORTAL-2935 Project: GateIn Portal Issue Type: Bug Security Level: Public(Everyone can see) Affects Versions: 3.6.0.Beta01, 3.6.0.Beta02 Environment: DB2 10 Reporter: Tomas Kyjovsky Assignee: Vlastislav Ramik Labels: JPP61-Test-dev Attachments: SqlSyntaxErrorException.txt There are exceptions when starting repository service when portal is configured with DB2 10. JCR tables in DB are created. Caused by: com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=LIMIT;;FETCH FIRST <n> ROWS ONLY, DRIVER=4.13.127 at com.ibm.db2.jcc.am.id.a(id.java:677) at com.ibm.db2.jcc.am.id.a(id.java:60) at com.ibm.db2.jcc.am.id.a(id.java:127) at com.ibm.db2.jcc.am.no.c(no.java:2653) at com.ibm.db2.jcc.am.no.d(no.java:2641) at com.ibm.db2.jcc.am.no.a(no.java:2090) at com.ibm.db2.jcc.am.oo.a(oo.java:7671) at com.ibm.db2.jcc.t4.cb.h(cb.java:141) at com.ibm.db2.jcc.t4.cb.b(cb.java:41) at com.ibm.db2.jcc.t4.q.a(q.java:32) at com.ibm.db2.jcc.t4.sb.i(sb.java:135) at com.ibm.db2.jcc.am.no.ib(no.java:2059) at com.ibm.db2.jcc.am.oo.sc(oo.java:3559) at com.ibm.db2.jcc.am.oo.b(oo.java:4348) at com.ibm.db2.jcc.am.oo.fc(oo.java:743) at com.ibm.db2.jcc.am.oo.executeQuery(oo.java:713) at org.jboss.jca.adapters.jdbc.CachedPreparedStatement.executeQuery(CachedPreparedStatement.java:107) at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:462) at org.exoplatform.services.jcr.impl.storage.jdbc.optimisation.db.DB2MYSMultiDbJDBCConnection.findNodesAndProperties(DB2MYSMultiDbJDBCConnection.java:85) [exo.jcr.component.core-1.15.1-CP01-redhat-1.jar:1.15.1-CP01-redhat-1] at org.exoplatform.services.jcr.impl.storage.jdbc.JDBCStorageConnection.getNodesAndProperties(JDBCStorageConnection.java:1210) [exo.jcr.component.core-1.15.1-CP01-redhat-1.jar:1.15.1-CP01-redhat-1] ... 7 more