Skip to Content.
Sympa Menu

grouper-users - Re: [grouper-users] Re: [grouper-dev] more trouble with quickstart

Subject: Grouper Users - Open Discussion List

List archive

Re: [grouper-users] Re: [grouper-dev] more trouble with quickstart


Chronological Thread 
  • From: "RL 'Bob' Morgan" <>
  • To: Grouper Users <>
  • Subject: Re: [grouper-users] Re: [grouper-dev] more trouble with quickstart
  • Date: Fri, 7 Oct 2005 23:20:57 -0700 (PDT)


On Fri, 7 Oct 2005, RL 'Bob' Morgan wrote:

... a bunch of lines of initialization messages ...
2005-10-07 19:45:01,472 DEBUG JDBCSourceAdapter: SQLException occurred: Database does not exists in statement []
java.sql.SQLException: Database does not exists in statement []
at org.hsqldb.jdbc.jdbcUtil.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcConnection.<init>(Unknown Source)
at org.hsqldb.jdbcDriver.getConnection(Unknown Source)
at org.hsqldb.jdbcDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(DriverManager.java:525)
at java.sql.DriverManager.getConnection(DriverManager.java:193)
...

So it looks like it makes a connection to my hsqldb but the database it's looking for does not exist.

Actually not making a connection I guess. I start up the db server with

java -cp hsqldb.jar org.hsqldb.Server -database.0
/pkg/grouper/grouper-qs/grouper/dist/run/grouper -dbname.0 grouper
-user sa

getting the lines:

[Server@ca0b6]:
[Thread[main,5,main]]: checkRunning(false) entered
[Server@ca0b6]:
[Thread[main,5,main]]: checkRunning(false) exited
[Server@ca0b6]:
Startup sequence initiated from main() method
[Server@ca0b6]: Loaded properties from [/usr/local/pkg/tomcat/jakarta-tomcat-5.5.9/webapps/grouper/WEB-INF/lib/server.properties]
[Server@ca0b6]:
Initiating startup sequence...
[Server@ca0b6]:
Server socket opened successfully in 18 ms.
[Server@ca0b6]: Database [index=0, id=0, db=file:/pkg/grouper/grouper-qs/grouper/dist/run/grouper, alias=grouper] opened sucessfully in 2109 ms.
[Server@ca0b6]:
Startup sequence completed in 2181 ms.
[Server@ca0b6]:
2005-10-07 22:59:43.632 HSQLDB server 1.7.2 is online
[Server@ca0b6]:
To close normally, connect and execute SHUTDOWN SQL
[Server@ca0b6]:
From command line, use [Ctrl]+[C] to abort abruptly

and I can see that the process is running and netstat shows a process listening on port 9001. Then I run the hsqldb manager with

java -cp hsqldb.jar org.hsqldb.util.DatabaseManagerSwing -driver
org.hsqldb.jdbcDriver

and get the nice manager UI. I choose File->Connect, and in the connect dialog box choose the HSQL Database Server Engine type, which gives me the jdbc:hsqldb:hsql://localhost/ URL, and when I click OK, I get the now-familiar error message

java.sql.SQLException: Database does not exists in statement []
at org.hsqldb.jdbc.jdbcUtil.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcConnection.<init>(Unknown Source)
at org.hsqldb.jdbcDriver.getConnection(Unknown Source)
at org.hsqldb.jdbcDriver.connect(Unknown Source)
...

If I make it localhost:9001 it's the same. netstat does show me that a process is connecting to 9001 however. So I dunno.

- RL "Bob"



Archive powered by MHonArc 2.6.16.

Top of Page