From: | Achilleas Mantzios <achill(at)matrix(dot)gatewaynet(dot)com> |
---|---|
To: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | Re: Tomcat7 connection pool with postgresql |
Date: | 2011-11-21 09:21:18 |
Message-ID: | 201111211121.19202.achill@matrix.gatewaynet.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
Στις Friday 18 November 2011 13:38:52 γράψατε:
> Στις Friday 18 November 2011 13:13:18 ο/η Samuel Gendler έγραψε:
> > On Fri, Nov 18, 2011 at 1:09 AM, Achilleas Mantzios <
> > achill(at)matrix(dot)gatewaynet(dot)com> wrote:
> > >
> > >
> > > root cause
> > > java.sql.SQLException: No suitable driver
> > > java.sql.DriverManager.getDriver(DriverManager.java:279)
> > >
> > > org.apache.tomcat.dbcp.dbcp.BasicDataSource.createConnectionFactory(BasicDataSource.java:1437)
> > >
> > > org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1371)
> > >
> > > org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
> > > org.apache.jsp.index_jsp._jspService(index_jsp.java:102)
> > >
> > >
> > I think if you have tomcat instantiate the data source and db driver, the
> > jar file with the driver must be available to tomcat's class loader. Odds
> > are good that you have the driver packaged up with your webapp, which means
> > it is only available to the webapp's class loader. Move it to wherever
>
> Thanx, but i actually had gone this step and had placed in dist $CATALINA_HOME/lib already.
> Nothing explicit in the webapp about the driver.
> I am starting to suspect that this has to do with declaring the resource as global under GlobalNamingResources
> and forgetting to do the proper linkage xml in context. But i think it should be placed inside
> context, in the first place and scrapping the GlobalNamingResources altogether.
>
Now its ok, i had to declare the datasource inside META-INF/context.xml of the webapp.
Thanx! And indeed it was 100% tomcat-related ;)
> > tomcat loads external jar files from (or add it to a classpath environment
> > variable that gets read by the tomcat startup script). A quickie place to
> > drop it to see if I'm correct is $CATALINA_HOME/lib but I don't think it is
> > recommend that you put it there permanently, since it will be mixed with
> > the jars that ship as part of tomcat in there.
> >
>
>
>
--
Achilleas Mantzios
From | Date | Subject | |
---|---|---|---|
Next Message | fed | 2011-11-22 10:29:06 | Re: Publish 9.1-901 JDBC drivers on maven central |
Previous Message | Stevo Slavić | 2011-11-18 22:56:18 | Re: Publish 9.1-901 JDBC drivers on maven central |