RE: Tomcat 5 : Connection Pool to Access database

[Freddy Villalba Arias]

Hi Franz,

I'm experiencing EXACTLY the same problem, but in Tomcat 4.1 (running
from a Jbuilder X). HAVEN't solved it yet. However, I've received some
valid feedback that may prove to be effective for you.

Let me know of any adavances you make in this regard.

Jee... it's good to know I'm not the only one with this bizarre problem!

Regards,
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(BasicDataSource
.jav
a:743)
        at
org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.ja
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]