[GRP-218] hsql in file mode doesnt work well with unit tests Created: 03/Feb/09  Updated: 03/Feb/09  Resolved: 03/Feb/09

Status: Resolved
Project: Grouper
Component/s: None
Affects Version/s: 1.4.0
Fix Version/s: 1.4.1

Type: Bug Priority: Major
Reporter: Chris Hyzer (upenn.edu) Assignee: Chris Hyzer (upenn.edu)
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified


 Description   

with hsql in file mode, some queries go too quickly, or maybe pooling messes it up. So now we should use server mode.



 Comments   
Comment by mchyzer [ 03/Feb/09 ]

Changed the README.txt to give instructions on how to start hsql in server mode, change default grouper.hibernate.properties

    1. 4.a Starting The Database

If you are using the built-in hsqldb database to get started, you need to
start the hsqldb server (since hsqldb in file mode does not work well).

Run from the GROUPER_HOME directory:

% java -cp lib/jdbcSamples/hsqldb.jar org.hsqldb.Server -database.0 file:grouper -dbname.0 grouper

Note, you either need to run that command in the background, or use a terminal window that will wait for the server to exit.

Here's the new config:

hibernate.connection.url = jdbc:hsqldb:hsql://localhost/grouper

Also, FYI, if you want to start the HSQL admin tool to browse the DB:

F:\temp\grouper1.4\grouper-api-1.4.1\bin>java -cp ..\lib\jdbcSamples\hsqldb.jar org.hsqldb.util.DatabaseManager -url jdbc:hsqldb:hsql://localhost/grouper

Generated at Wed May 08 11:47:48 UTC 2024 using Jira 9.4.18#940018-sha1:32a59db0b032756f9bbd6a22c656d21edb3fb41f.