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.
the problem with "table not found" happened for me too but I am using hypersonic sql (defaultDS).
I try to setup JAAS and I am already fail with the database itself :-(