Robert S. Sfeir wrote:
All,
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?
I'm not aware of any tricks. At least in our junit tests inserting into hsqldb works great.
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?
This is not an OJB issue, it's caused by HSQLDB.
I've been looking for this feature for ages! This would make usage of hsqldb extremely simple in web apps!
The bad news is that I don't think that it is possible with current versions of HSQLDB.
You have to use the complete filesystem path in the OJB connection descriptor.
:-( Maybe we should approach the hsqldb guys to add this feature?
cheers, Thomas
[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]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
