[gatein-issues] [JBoss JIRA] (GTNPORTAL-2935) SqlSyntaxErrorException when starting JCR service configured with DB2 10

[Tomas Kyjovsky (JIRA)]

     [ https://issues.jboss.org/browse/GTNPORTAL-2935?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Tomas Kyjovsky updated GTNPORTAL-2935:
--------------------------------------

    Description: 
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

  was:There are exceptions when starting repository service when portal is configured with DB2 10. JCR tables in DB are created.


    
> 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
>              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

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira