Need help with WO-to-DB server setup on Solaris

Will Scheidegger <[email protected]> Tue, 13 Jul 2004 10:56:21 +0200
Newsgroups gmane.comp.web.webobjects.admin
Message-ID <[email protected]>
I'm playing around with a deployment setup on 3 sun servers: Web, App, 
DB. There seems to be something wrong in my configuration though. My WO 
app won't find the db. It displays the standard error message:

  java.lang.IllegalStateException: _obtainOpenChannel -- 
com.webobjects.eoaccess.EODatabaseContext 
com.webobjects.eoaccess.EODatabaseContext@ef2c60: failed to open 
database channel. Check your connection dictionary, and ensure your 
database is correctly configured.

I did check the connection dictionary several times tough and now even 
tested the access to the db on the command line. We're using FrontBase. 
So I launched the FrontBase sql92 CLI tool on the app server and 
connected to the DB with the same info as in the connection dictionary:

[will@karpo]/home/will: ./sql92
sql92#1> connect to bugtracker host 192.168.1.10 user bugs;
 > Auto committing is on: SET COMMIT TRUE;
[email protected]#2>

The connection dictionary contains the following info:
URL = "jdbc:FrontBase://192.168.1.10/bugtracker/user=bugs";

Now the only think I could think of that could cause the problems are 
missing frameworks or JDBC drivers. I put the FrontBasePlugIn.framework 
into /opt/Apple/Local/Library/Frameworks and the frontbasejdbc.jar into 
/opt/Apple/Library/Java which I think is right. Can somebody tell me 
what I'm missing? Thanks a bunch!

-Will