[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
If you are using the built-in hsqldb database to get started, you need to 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 |