Grouper Users - Open Discussion List

[Tom Barton <>]

The jdbc url, both in the sources.xml file and in the 
DatabaseManagerSwing GUI, must agree with how the server properties are 
declared. Given that I advised you to use '-dbname.0 grouper', your jdbc 
url must reflect that:

  jdbc:hsqldb:hsql://localhost/grouper

The trailing '/grouper' in that url identifies which one of potentially 
several databases being served on port 9001 you want to connect to. You 
can also start the server up without specifying a -dbname parameter, in 
which case the jdbc url

  jdbc:hsqldb:hsql://localhost

will connect to the singular database being served. I advised you 
otherwise expecting that you'll soon want to be running at least 2 
databases on one server.

BTW, I've done plenty of twiddling of config files in 
webapps/grouper/WEB-INF/classes without rebuilding and redeploying. I 
just restart the /grouper (or /signet) context, and occasionally restart 
tomcat if I'm not certain that all's kosher. Clearly, there are 
circumstances that vary in ways that impact grouper (& maybe signet) 
deployment that we should try to understand and describe in the docs. I 
hope we get to the bottom of yours...

Tom

RL 'Bob' Morgan wrote:
> 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"