You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@tomcat.apache.org by "Fabien D." <du...@hotmail.com> on 2008/04/23 15:45:10 UTC
Problem with Datasource
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 :
<Context
path="/appWicket"
reloadable="true">
<Resource
name="jdbc/hibernate"
auth="Container"
type="javax.sql.DataSource"
description="DB Connection"
driverClass="com.mysql.jdbc.Driver"
jdbcUrl="jdbc:mysql://localhost:3306/opensource?autoReconnect=true"
user="root"
password="xxxx"/>
</Context>
In my hibernate.cfg.xml, I have done this (add the first line, to replace
the commented lines):
<session-factory name="appWicketSession">
<property
name="connection.datasource">java:comp/env/jdbc/hibernate</property>
<!--property
name="hibernate.connection.driver_class">org.gjt.mm.mysql.Driver</property-->
<!--property name="hibernate.connection.password">admin</property-->
<!--property
name="hibernate.connection.url">jdbc:mysql://localhost:3306/opensource</property-->
<!--property name="hibernate.connection.username">xxxx</property-->
<property name="bytecode.use_reflection_optimizer">false</property>
<property name="c3p0.max_size">5</property>
<property name="c3p0.min_size">3</property>
<property name="c3p0.timeout">1800</property>
<property name="current_session_context_class">thread</property>
<property
name="dialect">org.hibernate.dialect.MySQLDialect</property>
<property name="format_sql">true</property>
<property name="show_sql">true</property>
When I try to launch the application, an error appears :
INFO [http-8080-1] (NamingHelper.java:26) - JNDI InitialContext
properties:{}
INFO [http-8080-1] (DatasourceConnectionProvider.java:61) - Using
datasource: java:comp/env/jdbc/hibernate
WARN [http-8080-1] (SettingsFactory.java:117) - Could not obtain connection
metadata
org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver of
class '' for connect URL 'null'
at
org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1150)
at
org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
at
org.hibernate.connection.DatasourceConnectionProvider.getConnection(DatasourceConnectionProvider.java:69)
at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:84)
at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2009)
at
org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1292)
at com.mycompany.hibernate.HibernateUtil.<clinit>(Unknown Source)
at com.mycompany.hibernate.GestionBDD.selectQuery(Unknown Source)
at com.mycompany.middleware.CDataFromBDD.getListDomaine(Unknown Source)
at com.mycompany.commun.PanelTreeView.<init>(Unknown Source)
at com.mycompany.HomePage.initPanels(Unknown Source)
at com.mycompany.HomePage.<init>(Unknown Source)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at
org.apache.wicket.session.DefaultPageFactory.newPage(DefaultPageFactory.java:149)
at
org.apache.wicket.session.DefaultPageFactory.newPage(DefaultPageFactory.java:58)
at
org.apache.wicket.request.target.component.BookmarkablePageRequestTarget.newPage(BookmarkablePageRequestTarget.java:262)
at
org.apache.wicket.request.target.component.BookmarkablePageRequestTarget.getPage(BookmarkablePageRequestTarget.java:283)
at
org.apache.wicket.request.target.component.BookmarkablePageRequestTarget.processEvents(BookmarkablePageRequestTarget.java:210)
at
org.apache.wicket.request.AbstractRequestCycleProcessor.processEvents(AbstractRequestCycleProcessor.java:91)
at
org.apache.wicket.RequestCycle.processEventsAndRespond(RequestCycle.java:1166)
at org.apache.wicket.RequestCycle.step(RequestCycle.java:1243)
at org.apache.wicket.RequestCycle.steps(RequestCycle.java:1331)
at org.apache.wicket.RequestCycle.request(RequestCycle.java:493)
at
org.apache.wicket.protocol.http.WicketFilter.doGet(WicketFilter.java:363)
at
org.apache.wicket.protocol.http.WicketFilter.doFilter(WicketFilter.java:194)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
at java.lang.Thread.run(Thread.java:619)
Caused by: java.lang.NullPointerException
at sun.jdbc.odbc.JdbcOdbcDriver.getProtocol(JdbcOdbcDriver.java:507)
at sun.jdbc.odbc.JdbcOdbcDriver.knownURL(JdbcOdbcDriver.java:476)
at sun.jdbc.odbc.JdbcOdbcDriver.acceptsURL(JdbcOdbcDriver.java:307)
at java.sql.DriverManager.getDriver(DriverManager.java:253)
at
org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1143)
The log shows that it tries to load the datasource, and at the end of the
exception, we have this :
at sun.jdbc.odbc.JdbcOdbcDriver.getProtocol(JdbcOdbcDriver.java:507)
and not com.mysql.jdbc.Driver.
I have put the jdbc driver in $CATALINA_HOME/lib/..
My researches on the net, don't help my to solve the problem, so if you can
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-mail: users@tomcat.apache.org
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org
Re: Problem with Datasource
Posted by David Smith <dn...@cornell.edu>.
What is in tomat's lib directory? And what's in the <resource-ref> ...
</resource-ref> 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 *lot*
better than the autoReconnect parameter.
In general your error "Cannot create JDBC driver of class '' for connect
URL 'null'" generally means there's some misconfiguration in either your
context xml file (maybe the one you have below isn't being used?) or
WEB-INF/web.xml file.
--David
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 :
><Context
> path="/appWicket"
> reloadable="true">
> <Resource
> name="jdbc/hibernate"
> auth="Container"
> type="javax.sql.DataSource"
> description="DB Connection"
> driverClass="com.mysql.jdbc.Driver"
> jdbcUrl="jdbc:mysql://localhost:3306/opensource?autoReconnect=true"
> user="root"
> password="xxxx"/>
></Context>
>
>
>
>In my hibernate.cfg.xml, I have done this (add the first line, to replace
>the commented lines):
> <session-factory name="appWicketSession">
>
> <property
>name="connection.datasource">java:comp/env/jdbc/hibernate</property>
>
> <!--property
>name="hibernate.connection.driver_class">org.gjt.mm.mysql.Driver</property-->
> <!--property name="hibernate.connection.password">admin</property-->
> <!--property
>name="hibernate.connection.url">jdbc:mysql://localhost:3306/opensource</property-->
> <!--property name="hibernate.connection.username">xxxx</property-->
>
> <property name="bytecode.use_reflection_optimizer">false</property>
> <property name="c3p0.max_size">5</property>
> <property name="c3p0.min_size">3</property>
> <property name="c3p0.timeout">1800</property>
> <property name="current_session_context_class">thread</property>
> <property
>name="dialect">org.hibernate.dialect.MySQLDialect</property>
> <property name="format_sql">true</property>
> <property name="show_sql">true</property>
>
>
>
>When I try to launch the application, an error appears :
>
> INFO [http-8080-1] (NamingHelper.java:26) - JNDI InitialContext
>properties:{}
> INFO [http-8080-1] (DatasourceConnectionProvider.java:61) - Using
>datasource: java:comp/env/jdbc/hibernate
> WARN [http-8080-1] (SettingsFactory.java:117) - Could not obtain connection
>metadata
>org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver of
>class '' for connect URL 'null'
> at
>org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1150)
> at
>org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
> at
>org.hibernate.connection.DatasourceConnectionProvider.getConnection(DatasourceConnectionProvider.java:69)
> at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:84)
> at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2009)
> at
>org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1292)
> at com.mycompany.hibernate.HibernateUtil.<clinit>(Unknown Source)
> at com.mycompany.hibernate.GestionBDD.selectQuery(Unknown Source)
> at com.mycompany.middleware.CDataFromBDD.getListDomaine(Unknown Source)
> at com.mycompany.commun.PanelTreeView.<init>(Unknown Source)
> at com.mycompany.HomePage.initPanels(Unknown Source)
> at com.mycompany.HomePage.<init>(Unknown Source)
> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
> at
>sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
> at
>sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
> at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
> at
>org.apache.wicket.session.DefaultPageFactory.newPage(DefaultPageFactory.java:149)
> at
>org.apache.wicket.session.DefaultPageFactory.newPage(DefaultPageFactory.java:58)
> at
>org.apache.wicket.request.target.component.BookmarkablePageRequestTarget.newPage(BookmarkablePageRequestTarget.java:262)
> at
>org.apache.wicket.request.target.component.BookmarkablePageRequestTarget.getPage(BookmarkablePageRequestTarget.java:283)
> at
>org.apache.wicket.request.target.component.BookmarkablePageRequestTarget.processEvents(BookmarkablePageRequestTarget.java:210)
> at
>org.apache.wicket.request.AbstractRequestCycleProcessor.processEvents(AbstractRequestCycleProcessor.java:91)
> at
>org.apache.wicket.RequestCycle.processEventsAndRespond(RequestCycle.java:1166)
> at org.apache.wicket.RequestCycle.step(RequestCycle.java:1243)
> at org.apache.wicket.RequestCycle.steps(RequestCycle.java:1331)
> at org.apache.wicket.RequestCycle.request(RequestCycle.java:493)
> at
>org.apache.wicket.protocol.http.WicketFilter.doGet(WicketFilter.java:363)
> at
>org.apache.wicket.protocol.http.WicketFilter.doFilter(WicketFilter.java:194)
> at
>org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
> at
>org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> at
>org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
> at
>org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
> at
>org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
> at
>org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
> at
>org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
> at
>org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
> at
>org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
> at
>org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
> at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
> at java.lang.Thread.run(Thread.java:619)
>Caused by: java.lang.NullPointerException
> at sun.jdbc.odbc.JdbcOdbcDriver.getProtocol(JdbcOdbcDriver.java:507)
> at sun.jdbc.odbc.JdbcOdbcDriver.knownURL(JdbcOdbcDriver.java:476)
> at sun.jdbc.odbc.JdbcOdbcDriver.acceptsURL(JdbcOdbcDriver.java:307)
> at java.sql.DriverManager.getDriver(DriverManager.java:253)
> at
>org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1143)
>
>The log shows that it tries to load the datasource, and at the end of the
>exception, we have this :
>at sun.jdbc.odbc.JdbcOdbcDriver.getProtocol(JdbcOdbcDriver.java:507)
>and not com.mysql.jdbc.Driver.
>
>I have put the jdbc driver in $CATALINA_HOME/lib/..
>
>My researches on the net, don't help my to solve the problem, so if you can
>help me thank you in advance :).
>
>
---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org
Re: Problem with Datasource
Posted by Mark Thomas <ma...@apache.org>.
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? Webapp
specific stuff goes in META-INF/context.xml
Mark
---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org