1 Reply Latest reply on Jan 7, 2005 6:58 PM by Didi

    Using hypersonic for PKGen when it should be using Postgres

    Richard Bair Newbie

      Hey all,

      I'm having a problem, I assume with configuration, where I have set up JBoss to work with PostgreSQL for my app, and in every way it (apparently) works perfectly except when calling ejbCreate. When ejbCreate is called, I get the following stack trace:

      11:06:28,553 INFO [STDOUT] Error in PKGen.getNextKeyValue (): Table not found: ADDRESSEJB in statement [SELECT MAX(ID) FROM AddressEJB]
      11:06:28,554 INFO [STDOUT] java.sql.SQLException: Table not found: ADDRESSEJB in statement [SELECT MAX(ID) FROM AddressEJB]
      11:06:28,556 INFO [STDOUT] at org.hsqldb.jdbc.jdbcUtil.throwError(Unknown Source)
      11:06:28,557 INFO [STDOUT] at org.hsqldb.jdbc.jdbcPreparedStatement.(Unknown Source)
      11:06:28,557 INFO [STDOUT] at org.hsqldb.jdbc.jdbcConnection.prepareStatement(Unknown Source)
      11:06:28,557 INFO [STDOUT] at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.prepareStatement(BaseWrapperManagedConnection.java:374)
      11:06:28,557 INFO [STDOUT] at org.jboss.resource.adapter.jdbc.WrappedConnection.prepareStatement(WrappedConnection.java:217)
      11:06:28,557 INFO [STDOUT] at com.sun.j2ee.blueprints.pkgen.PKGen.getNextKeyValue(PKGen.java:67)11:06:28,558 INFO [STDOUT] at com.sun.j2ee.blueprints.address.ejb.AddressEJB.ejbCreate(AddressEJB.java:111)
      ...

      Earlier the container did create this table (I can query it and everything from psql), but when it comes to the key generation, it dies.

      Any ideas?

      Thanks
      Richard