I agree, but it looks good and I've tried without one being specified. In addition, I've never see a connection raised at the database server end. This makes me think the DataSource is just not working and I'm not seeing the proper error. But I can find nothing more in the logs :(
>-----Original Message----- >From: D'Alessandro, Arthur [mailto:[EMAIL PROTECTED] >Sent: 17 March 2004 18:00 >To: Tomcat Users List; [EMAIL PROTECTED]; Parsons Technical Services >Subject: RE: Problem using JNDI/DBCP to get DataSouce > > >Check your validation query in your resource definition. > >-----Original Message----- >From: Paul Mahoney [mailto:[EMAIL PROTECTED] >Sent: Wednesday, March 17, 2004 12:57 PM >To: 'Parsons Technical Services'; 'Tomcat Users List' >Subject: RE: Problem using JNDI/DBCP to get DataSouce > >Tried > dataSource = (DataSource) >initContext.lookup("java:comp/jdbc/OscarsDB"); >But it return null, so tried > dataSource = (DataSource) >initContext.lookup("java:comp/env/jdbc/OscarsDB"); >And a datasource instance was return so before, looking good... >However, still got the same exception when trying to get a connection >instance > "Cannot get a connection, pool exhausted" >with a nested exception > "Could not create a validated object" > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
