Hi all,

I want to use hsqldb to do some rapid prototyping (not so rapid since I
don't have it done yet, but anyway -- it's a concept).  Basically, I
have unit tests that I want to run against model classes that in turn
use OJB.

So here's how my flow works once I trigger a "run JUnit tests" Ant
target.

1. Generate hsqldb DDL scripts via XDoclet and Torque.  Then, execute
this script.  The execution is done via torque -- and it seems to work.
I'm using the following protocol string: jdbc:hsqldb:file:ucm

The DDL looks like the usual "create table ...  alter table ... add
constraint" stuff.  And that works.  If I use the database manager tool,
it shows the tables that I want.

Also, I've generated an ojb repository.xml file, the contents of which
are not particularly important.

The next thing in the sequence is to execute the Unit tests.  Here's
where I run into a problem.  Using the same protocol,
jdbc:hsqldb:file:ucm and within the same Ant target sequence (so
user.dir should be the same) I get the following:

org.apache.ojb.broker.PersistenceBrokerSQLException:
java.sql.SQLException: Table not found: PROJECTS in statement [SELECT
A0.name,A0.id FROM ...

According to the DatabaseManager, the table is there.

Any ideas?


Thanks,

Dave



---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to