Hi, Search the archives. This is a common configuration problem. Yoav Shapira Millennium Research Informatics
>-----Original Message----- >From: Freddy Villalba Arias [mailto:[EMAIL PROTECTED] >Sent: Tuesday, April 13, 2004 3:57 AM >To: Tomcat Users List >Subject: RE: Tomcat 5 : Connection Pool to Access database > >BTW, the topic is "JNDI and DataSource" and I'm trying to connect to an >Oracle DB. :) > >Freddy. > >-----Mensaje original----- >De: Francesco Pellegrini [mailto:[EMAIL PROTECTED] >Enviado el: martes, 13 de abril de 2004 9:28 >Para: Tomcat-User-ML >Asunto: Tomcat 5 : Connection Pool to Access database >Importancia: Alta > >Hi All, > >I'm working on Tomcat 5.0.18 web server with Access 2000 database on >Windows >2000 server environment. > >At the moment I use simple connection to database by "direct calling" in >the >Java code like: > >Connection Con=DriverManager.getConnection("jdbc:odbc:MyDatabase"); > >where "MyDatabase" is the ODBC source. > >I'would like to configure a connection pool instead of direct >connection, >but after I did this changes in server.xml : > > >*********************************************************************** * >**** >** > > <GlobalNamingResources> > > > <Resource name="jdbc/myoracle" auth="CONTAINER" >type="javax.sql.DataSource"/> > <ResourceParams name="jdbc/myoracle"> > <parameter> > <name>factory</name> > <value>org.apache.commons.dbcp.BasicDataSourceFactory > </value> > </parameter> > <parameter> > <name>driverClassName</name> > <value>sun.jdbc.odbc.JdbcOdbcDriver</value> > </parameter> > <parameter> > <name>url</name> > <value>jdbc:odbc:MyDatabase</value> > </parameter> > </ResourceParams> > > </GlobalNamingResources> > > > > >*********************************************************************** * >**** >** > > >and this changes in web.xml of my web application : > >*********************************************************************** * >**** >** ><resource-ref> > <description>Oracle Datasource example</description> > <res-ref-name>jdbc/myoracle</res-ref-name> > <res-type>javax.sql.DataSource</res-type> > <res-auth>Container</res-auth> > </resource-ref> >*********************************************************************** * >**** >** > >I got on this error : > >org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC driver of >class '' for connect URL 'null', cause: >java.sql.SQLException: No suitable driver > at java.sql.DriverManager.getDriver(Unknown Source) > at >org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSourc e >.jav >a:743) > at >org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.j a >va:5 >18) > > >Could someone help me? > >Thanks > >Franz. > > >--------------------------------------------------------------------- >To unsubscribe, e-mail: [EMAIL PROTECTED] >For additional commands, e-mail: [EMAIL PROTECTED] > > >--------------------------------------------------------------------- >To unsubscribe, e-mail: [EMAIL PROTECTED] >For additional commands, e-mail: [EMAIL PROTECTED] 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]
