I am trying to setup my app so I can use hsqldb. First time using that db with OJB. I've pointed the repository's connection info so it will find the DB files at /application-data dir, and it finds them fine since my select works, however if I try to do an insert, I'm getting this error (part of it), which I've never gotten before with any other DBs. I've got the proper OJB specific tables in the DB of course. Is there a special trick with hsqldb?
The other issue is that I can't seem to find a way to get OJB to find the hsqldb script and data files directly within the exploded war directory. What's the trick there? I want to be able to deliver a war file to users, have it explode, then the app is just up and running with no configuration necessary... what's the trick?
[ERROR] SequenceManagerHighLowImpl - -Can't lookup new HighLowSequence for field browserID using sequence name SEQ_CDPCNO_BROWSERS <org.apache.ojb.broker.PersistenceBrokerException: Can't lookup a connection: Can't get connection from DBCP-DataSource: java.util.NoSuchElementException>java.sql.SQLException: java.util.NoSuchElementException
at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:112)
at org.apache.ojb.broker.accesslayer.ConnectionFactoryDBCPImpl.getConnectionFromPool(ConnectionFactoryDBCPImpl.java:56)
at org.apache.ojb.broker.accesslayer.ConnectionFactoryAbstractImpl.lookupConnection(ConnectionFactoryAbstractImpl.java:101)
at org.apache.ojb.broker.accesslayer.ConnectionManagerImpl.getConnection(ConnectionManagerImpl.java:144)
at org.apache.ojb.broker.accesslayer.ConnectionManagerImpl.localBegin(ConnectionManagerImpl.java:186)
The sql for the tables is, maybe I got the wrong ones? (Got them from the OJB samples)
CREATE TABLE OJB_HL_SEQ(TABLENAME VARCHAR(175) NOT NULL,FIELDNAME VARCHAR(70) NOT NULL,MAX_KEY INTEGER,GRAB_SIZE INTEGER,VERSION INTEGER,CONSTRAINT SYS_PK_OJB_HL_SEQ PRIMARY KEY(TABLENAME,FIELDNAME))
CREATE TABLE OJB_LOCKENTRY(OID_ VARCHAR(250) NOT NULL,TX_ID VARCHAR(50) NOT NULL,TIMESTAMP_ TIMESTAMP,ISOLATIONLEVEL INTEGER,LOCKTYPE INTEGER,CONSTRAINT SYS_PK_OJB_LOCKENTRY PRIMARY KEY(OID_,TX_ID))
CREATE TABLE OJB_NRM(NAME VARCHAR(250) NOT NULL PRIMARY KEY,OID_ LONGVARBINARY)
CREATE TABLE OJB_DLIST(ID INTEGER NOT NULL PRIMARY KEY,SIZE_ INTEGER)
CREATE TABLE OJB_DLIST_ENTRIES(ID INTEGER NOT NULL PRIMARY KEY,DLIST_ID INTEGER,POSITION_ INTEGER,OID_ LONGVARBINARY)
CREATE TABLE OJB_DSET(ID INTEGER NOT NULL PRIMARY KEY,SIZE_ INTEGER)
CREATE TABLE OJB_DSET_ENTRIES(ID INTEGER NOT NULL PRIMARY KEY,DLIST_ID INTEGER,POSITION_ INTEGER,OID_ LONGVARBINARY)
CREATE TABLE OJB_DMAP(ID INTEGER NOT NULL PRIMARY KEY,SIZE_ INTEGER)
CREATE TABLE OJB_DMAP_ENTRIES(ID INTEGER NOT NULL PRIMARY KEY,DMAP_ID INTEGER,KEY_OID LONGVARBINARY,VALUE_OID LONGVARBINARY)
TIA R
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
