Thanks Peter, Without looking at your file, I can confirm that I noticed the potential issue as the trigger thread is not killed when the DB is closed. As you say this does not apply to server modes because the process will exit and kill the threads at database shutdown.
We will fix this hopefully for the next alpha release. Fred ----- Original Message ----- From: "Pete Church" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: 29 January 2003 10:51 Subject: [Hsqldb-developers] In-Process mode doesn't exit 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] ------------------------------------------------------- This SF.NET email is sponsored by: SourceForge Enterprise Edition + IBM + LinuxWorld = Something 2 See! http://www.vasoftware.com _______________________________________________ hsqldb-developers mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/hsqldb-developers
