Hi all, I was just starting to investigate the use of hsqldb for use with our java-based application and stumbled on something that might make it difficult for us to use.
I wanted to be able to connect to the database using the in-process mode (server mode doesn't seem to have this issue), and the attached java files show the very simple scenario. The scenario is that if a simply define a schema that has a trigger, any program that creates a connection to the database in-process can no longer exit. This includes my sample program which simply creates the schema. It appears that one of the underlying threads cause the program to "hang". I can show that if I create the schema without the trigger, it exists fine, if I simply define the trigger and perform no other task, it doesn't exit. I could not find any other documentation that might explain some other options that the database expects that might alleviate this problem. So, is this a known problem, or am I still doing something wrong? Any help would be appreciated, Pete Contact Info Work: 650-246-5062 Email: [EMAIL PROTECTED]
test.java
Description: test.java
test_gen_id.java
Description: test_gen_id.java
