Re: SQLException when using a datasource
Hi Samuel, I am getting same problem... if you solve this problem send me the solution. Thanks in advance vijay --- Samuel Cheung [EMAIL PROTECTED] wrote: 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 namefactory/name valueorg.apache.commons.dbcp.BasicDataSourceFactory/value /parameter !-- DBCP database connection settings -- parameter nameurl/name valuejdbc:mysql://localhost:3306/mysql/value /parameter parameter namedriverClassName/namevalueorg.gjt.mm.mysql.Driver/value /parameter parameter nameusername/name valueremote/value /parameter parameter namepassword/name valueremote/value /parameter !-- DBCP connection pooling options -- parameter namemaxWait/name value5000/value /parameter parameter namemaxIdle/name value2/value /parameter parameter namemaxActive/name value4/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(BasicDataSource.jav a:529) at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:3 12) at net.sf.hibernate.connection.DatasourceConnectionProvider.getConnection(Datas ourceConnectionProvider.java:60) at net.sf.hibernate.impl.SessionFactoryImpl.init(SessionFactoryImpl.java:160) at net.sf.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:59 4) at net.sf.hibernate.examples.quickstart.TestHibernateServlet.initHibernate(Test HibernateServlet.java:109) at net.sf.hibernate.examples.quickstart.TestHibernateServlet.doGet(TestHibernat eServlet.java:26) at javax.servlet.http.HttpServlet.service(HttpServlet.java:740) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
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 namefactory/name valueorg.apache.commons.dbcp.BasicDataSourceFactory/value /parameter !-- DBCP database connection settings -- parameter nameurl/name valuejdbc:mysql://localhost:3306/mysql/value /parameter parameter namedriverClassName/namevalueorg.gjt.mm.mysql.Driver/value /parameter parameter nameusername/name valueremote/value /parameter parameter namepassword/name valueremote/value /parameter !-- DBCP connection pooling options -- parameter namemaxWait/name value5000/value /parameter parameter namemaxIdle/name value2/value /parameter parameter namemaxActive/name value4/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(BasicDataSource.jav a:529) at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:3 12) at net.sf.hibernate.connection.DatasourceConnectionProvider.getConnection(Datas ourceConnectionProvider.java:60) at net.sf.hibernate.impl.SessionFactoryImpl.init(SessionFactoryImpl.java:160) at net.sf.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:59 4) at net.sf.hibernate.examples.quickstart.TestHibernateServlet.initHibernate(Test HibernateServlet.java:109) at net.sf.hibernate.examples.quickstart.TestHibernateServlet.doGet(TestHibernat eServlet.java:26) at javax.servlet.http.HttpServlet.service(HttpServlet.java:740) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
RE: SQLException when using a datasource
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 namefactory/name valueorg.apache.commons.dbcp.BasicDataSourceFactory/value /parameter !-- DBCP database connection settings -- parameter nameurl/name valuejdbc:mysql://localhost:3306/mysql/value /parameter parameter namedriverClassName/namevalueorg.gjt.mm.mysql.Driver/value /parameter parameter nameusername/name valueremote/value /parameter parameter namepassword/name valueremote/value /parameter !-- DBCP connection pooling options -- parameter namemaxWait/name value5000/value /parameter parameter namemaxIdle/name value2/value /parameter parameter namemaxActive/name value4/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]