Problem with datasource connecting to postgresql

2008-04-17 Thread Ken Bowen
Hi all, I've successfully built a number of Tomcat projects using MySQL, but now I have to also use PostgreSQL for a small demo app. I'm having some trouble with the context and datasource. Setup: Tomcat 5.5.26 (unzipped from the Apache site) on Mac OSX 10.5.2, developing using Eclipse

Re: Problem with datasource connecting to postgresql

2008-04-17 Thread Jim Cox
Do you use the same version of Java and run as the same user Tomcat runs under when you run it statically outside of Tomcat? On Thu, Apr 17, 2008 at 9:53 AM, Ken Bowen [EMAIL PROTECTED] wrote: Hi all, I've successfully built a number of Tomcat projects using MySQL, but now I have to also use

Re: Problem with datasource connecting to postgresql

2008-04-17 Thread Ken Bowen
I used the same Java 1.5 (the only Java on the system); the snippet occurs in the the build tree for the Tomcat project. The snippet was run inside Eclipse which is running under my own user login, so presumably that's how the snippet ran. I'm not sure what the user is when Tomcat runs --

Re: Problem with datasource connecting to postgresql

2008-04-17 Thread Mark H. Wood
You must be careful to distinguish the two different users involved. The OS user would determine whether there is a permissions problem with the JAR containing the PostgreSQL JDBC driver, but be insignificant in actually connecting to the DBMS. Ensuring that the JAR is world-readable should