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