Hi,

I'm using latest Hibernate in my webapp framework and I've configured it to use HsqlDB. When I start my webapplication using Tomcat, I see the last contents of my database as well as this CONNECT USER sa PASSWORD appended to the end of the file:

INSERT INTO DOWNLOAD_INFO VALUES('42de6054fffef7de01001e1383730108','Test','Test@test.com','Test',NULL,0,false,1100016223090,'Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.0.3705)')
INSERT INTO DOWNLOAD_INFO VALUES('42de6054fffef7de01001e6b7fbc0109','Test','Test@test.com','Test',NULL,0,false,1100021989307,'Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.0.3705)')
/*C1*/CONNECT USER sa PASSWORD ""
SET AUTOCOMMIT FALSE

Now, data can be added to the database, but it can't retrieve it e.g.

INSERT INTO DOWNLOAD_INFO VALUES('42de6054fffef7de01001e1383730108','Test','Test@test.com','Test',NULL,0,false,1100016223090,'Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.0.3705)')
INSERT INTO DOWNLOAD_INFO VALUES('42de6054fffef7de01001e6b7fbc0109','Test','Test@test.com','Test',NULL,0,false,1100021989307,'Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.0.3705)')
/*C1*/CONNECT USER sa PASSWORD ""
SET AUTOCOMMIT FALSE
INSERT INTO DOWNLOAD_INFO VALUES('42de6054fffef7de01001e6b7fbc0109','Test2','Test2@test.com','Test2',NULL,0,false,1100021989307,'Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.0.3705)')

will not let me query for the last DOWNLOAD_INFO Test2.

Furthermore when I shit down the webapp and restart, the Test2 and anything after the /*C1*/CONNECT statement is totally lost!!!

What can I do? I've tried manually editing the file after shutting down but that doesn't help.

Thanks, Jason