Sybase CMP SybSQLException
Hello,
I've run my tests on both JBoss3.0.6 and 3.2.1 but keep getting the same error. I turned on debug in the jaws config and the CMP generated SQL looks fine however Sybase complains about a column (@p0) that doesn't appear in the SQL that JBoss proclaims to execute. Has anyone seen this before?
Below is a snippet of the log (sorry large snippet).
Any help / suggestions would be greatly appreciated,
Mark
2003-05-07 17:11:39,201 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.CatalogEntry.findAll] Executing SQL: SELECT t0_c.catalogId FROM QbRawCatalog t0_c
2003-05-07 17:11:39,456 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.CatalogEntry] Executing SQL: SELECT catalogId,acquisitionTime, manualCloudCover, manualImageQuality, browseRawImageFileName FROM QbRawCatalog WHERE (catalogId=?) OR (catalogId=?) OR (catalogId=?) OR (catalogId=?)
2003-05-07 17:11:39,924 ERROR [org.jboss.ejb.plugins.LogInterceptor] TransactionRolledbackLocalException, causedBy:
com.sybase.jdbc2.jdbc.SybSQLException: Validation failure: Column @p0 cannot be found in any of the referenced tables
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 org.jboss.resource.adapter.jdbc.local.LocalPreparedStatement.executeQuery(LocalPreparedStatement.java:289)
at org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.execute(JDBCLoadEntityCommand.java:122)
at org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.execute(JDBCLoadEntityCommand.java:62)
at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.loadEntity(JDBCStoreManager.java:572)
at org.jboss.ejb.plugins.CMPPersistenceManager.loadEntity(CMPPersistenceManager.java:410)
...........................................................