2. You should write a helo world servlet that just looks up the datasource and displays a row, outside of Eclipse and w/o Struts.
pgSQL rocks!
good luck.
.V
Kyle Korndoerfer wrote:
I am not running PostgreSQL on my Windows box. The connection string in the Data Source config section is pointing to the SuSE box. I am using pgAdmin III on my Windows box to manage the database without error, so I can connect to my SuSE box and PostgreSQL without issue.
I launch Tomcat from within Eclipse strictly for debugging purposes. Even though I am using the Sysdeo plugin (to get the debugging capability), my Ant build script copies the WAR file into the TOMCAT/webapps folder first, then I start Tomcat (I do not use any of the deploy tools with the Sysdeo Plugin).
The PostgreSQL jar file is configured as a User Library within Eclipse and has been added to my Project. I've also tried loading Tomcat individually (not from within Eclipse), but I still get the same error.
I think the issue is less about being able to actually talk to the server & service, since it can't even load the Driver (which you have to do before even attempting to make a connection).
The crazy part about this is that I've used the Struts DataSources with PostgreSQL in the past without issue.
I'm going to download the latest PostgreSQL JDBC drivers tonight and see if that makes any difference. Hopefully it will, since I'm still utterly stumped...
Thanks for the help so far.
-={ Kyle }=-
--- Paul Woods <[EMAIL PROTECTED]> wrote:
On Mon, 2004-09-27 at 20:57, Kyle Korndoerfer wrote:
OK, so my idea (recently upgraded Tomcat to 5.0.28 thinking the
problem
could be thier and forgot to update my $CATALINA_HOME to take that
into
account), but that didn't help...
Still stumped. Anyone? Bueler?
Thanks for any help/suggestions. I've been starring at it so long,
I
know it must be something simple.
-={ Kyle }=-
David brings up an interesting point. I'd expand a bit and ask if you can connect to the Suse box's postgres via psql (is that available for windows?) on your windows box? psql is a command line client - and would verify that you have permissions on the suse box to connect from a remote client (and that the network setup is correct).
Something else that crossed my mind. If you have the JAR in the /lib directory of your webapp, in eclipse, right click on the webapp project, and select 'properties'. Verify that the .jar file is in the Libraries tab underneath Java Build Path. Sometimes just putting in /lib isn't enough.
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
_______________________________ Do you Yahoo!? Declare Yourself - Register online to vote today! http://vote.yahoo.com
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]