0 Replies Latest reply on May 7, 2003 5:27 PM by mkochco

    Sybase CMP SybSQLException

    mkochco Newbie

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