Re: Problem with Datasource

2008-04-23 Thread Mark Thomas
Fabien D. wrote: Hi everybody, I'm using tomcat6 and trying to use datasource for mysql connexion (and hibernate). I have looked to the tomcat 6 official documentation, and in the $CATALINA_HOME/conf/context.xml, i have declared : You do want this to be available to *every* webapp don't you?

Re: Problem with Datasource

2008-04-23 Thread David Smith
What is in tomat's lib directory? And what's in the ... section of your web.xml? Commenting on your resource definition below, remove autoReconnect=true as it's not recommended by the mysql folks. Add validationQuery="select 1" to have the pool test connections on borrow. This works a *lo

Problem with Datasource

2008-04-23 Thread Fabien D.
n help me thank you in advance :). -- View this message in context: http://www.nabble.com/Problem-with-Datasource-tp16834612p16834612.html Sent from the Tomcat - User mailing list archive at Nabble.com. - To start a new topic, e-ma

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 elimi

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 -- I

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 a

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 6.