If you use hsqldb in client-server mode you can set it up to log all the sql queries (see Advanced Topics in the HSQLDB docs). Or configure p6spy to do the same thing on the OJB side... This might give you some ideas about what it is trying to do...
I assume that your db connection in the repository is set to use the HSQLDB driver, etc?
Good luck,
Rob :)
Rob,
Thanks a bunch for responding. Here's some more info. I'm in the process of trying the P6SPY stuff right now.
here's my repository_database:
<jdbc-connection-descriptor
jcd-alias="tcms"
default-connection="true"
platform="Hsqldb"
driver="org.hsqldb.jdbcDriver"
jdbc-level="2.0"
jndi-datasource-name="java:tcmsDS"
username="sa"
password=""
eager-release="true"
batch-mode="false"
useAutoCommit="0"
ignoreAutoCommitExceptions="false">
<sequence-manager className="org.apache.ojb.broker.util.sequence.SequenceManagerHighLowImpl"/>
</jdbc-connection-descriptor>
Thanks, Brian
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
