Howdy, http://jakarta.apache.org/tomcat/faq/database.html
Yoav Shapira Millennium ChemInformatics >-----Original Message----- >From: Samuel Cheung [mailto:[EMAIL PROTECTED] >Sent: Thursday, October 23, 2003 11:55 AM >To: 'Tomcat Users List' >Subject: SQLException when using a datasource > > >I am trying to setup a hibernate example with Tomcat 4.1.27. So I add a >datasource to my server.xml. But when I access a connection, I got this >exception: >20:56:49,072 WARN SessionFactoryImpl:171 - Could not obtain connection >metadata >java.sql.SQLException: Cannot load JDBC driver class 'null' > >could some one please tell me how to fix that. I check the parameter of the >DBCP connection, they are correct. > >Thanks in advance. > >Sam > > >I have added the following in my server.xml of Tomcat: ><Context path="quickstart" docBase="/quickstart"> ><Resource name="jdbc/quickstart" scope="Shareable" >type="javax.sql.DataSource"/> ><ResourceParams name="jdbc/quickstart"> ><parameter> ><name>factory</name> ><value>org.apache.commons.dbcp.BasicDataSourceFactory</value> ></parameter> > ><!-- DBCP database connection settings --> ><parameter> ><name>url</name> ><value>jdbc:mysql://localhost:3306/mysql</value> ></parameter> ><parameter> ><name>driverClassName</name><value>org.gjt.mm.mysql.Driver</value> ></parameter> ><parameter> ><name>username</name> ><value>remote</value> ></parameter> ><parameter> ><name>password</name> ><value>remote</value> ></parameter> > ><!-- DBCP connection pooling options --> ><parameter> ><name>maxWait</name> ><value>5000</value> ></parameter> ><parameter> ><name>maxIdle</name> ><value>2</value> ></parameter> ><parameter> ><name>maxActive</name> ><value>4</value> ></parameter> > ></ResourceParams> ></Context> > ><< from the Tomcat console >> >20:56:49,010 INFO DatasourceConnectionProvider:51 - Using datasource: >java:comp/env/jdbc/quickstart >20:56:49,010 INFO SessionFactoryImpl:155 - Use outer join fetching: true >20:56:49,057 WARN JDBCExceptionReporter:36 - SQL Error: 0, SQLState: null >20:56:49,057 ERROR JDBCExceptionReporter:44 - Cannot load JDBC driver class >'null' >20:56:49,072 WARN SessionFactoryImpl:171 - Could not obtain connection >metadata >java.sql.SQLException: Cannot load JDBC driver class 'null' >at >org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSourc e.ja >v >a:529) >at >org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.j ava: >3 >12) >at >net.sf.hibernate.connection.DatasourceConnectionProvider.getConnection( Data >s >ourceConnectionProvider.java:60) >at >net.sf.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java :160 >) >at >net.sf.hibernate.cfg.Configuration.buildSessionFactory(Configuration.ja va:5 >9 >4) >at >net.sf.hibernate.examples.quickstart.TestHibernateServlet.initHibernate (Tes >t >HibernateServlet.java:109) >at >net.sf.hibernate.examples.quickstart.TestHibernateServlet.doGet(TestHib erna >t >eServlet.java:26) >at javax.servlet.http.HttpServlet.service(HttpServlet.java:740) >at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) This e-mail, including any attachments, is a confidential business communication, and may contain information that is confidential, proprietary and/or privileged. This e-mail is intended only for the individual(s) to whom it is addressed, and may not be saved, copied, printed, disclosed or used by anyone else. If you are not the(an) intended recipient, please immediately delete this e-mail from your computer system and notify the sender. Thank you. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
