Grouper Users - Open Discussion List

["RL 'Bob' Morgan" <>]

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"