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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
