Re: can�t Configurate Database Connection Pool (DBCP) with Tomcat 5.0.28

[Caroline Jen <ji...@yahoo.com>]

I had exactly the same problem when I tried to
configure the Tomcat 5.0.27.  At that time, a number
of people reported "the" difficulty.  Finally, we put
the configuration code in between the <realm .../>
element and the <Host> element of the
$TOMCAT/conf/server.xml.

Please e-mail me if you still have the problem.  I
will give you the step-by-step procedure.
--- Anto Paul <an...@gmail.com> wrote:

> On 4/15/05, Sevillano sevi llano
> <se...@hotmail.com> wrote:
> > I don�t know if it helps, but this is my
> environment:
> > 
> > j2sdk1.4.2_07
> > tomcat 5.0.28
> > oracle 9
> > 
> > j2sdk1.4.2_07
> > tomcat 5.0.28
> > mysql (I don�t remember the version, this is my
> home environment)
> > 
> > thanks
> > 
> > >From: "Sevillano sevi llano"
> <se...@hotmail.com>
> > >Reply-To: "Tomcat Users List"
> <to...@jakarta.apache.org>
> > >To: tomcat-user@jakarta.apache.org
> > >Subject: Re: can�t Configurate Database
> Connection Pool (DBCP) with Tomcat
> > >5.0.28
> > >Date: Fri, 15 Apr 2005 09:48:29 +0000
> > >
> > >I think JDBC Drivers are correctly installed,
> because direct connection
> > >works correctly:
> > >DriverManager.registerDriver(new
> oracle.jdbc.driver.OracleDriver());
> > >conn =
> >
>
>DriverManager.getConnection("jdbc:oracle:thin:@*.*.*.*:1521:bddesa","**","**");
> > >
> > >
> > >I have the .jar files in
> > >Tomcat 5.0\common\lib
> > >
> > >
> > >>From: "Benjamin Cuthbert"
> <be...@db.com>
> > >>Reply-To: "Tomcat Users List"
> <to...@jakarta.apache.org>
> > >>To: "Tomcat Users List"
> <to...@jakarta.apache.org>
> > >>CC: tomcat-user@jakarta.apache.org
> > >>Subject: Re:  can�t Configurate Database
> Connection Pool (DBCP) with
> > >>Tomcat 5.0.28
> > >>Date: Fri, 15 Apr 2005 10:45:01 +0100
> > >>
> > >>And you have the JDBC Driver installed, and
> tomcat comes up with no
> > >>errors.
> > >>
> > >>Are you just trying to setup user authentication
> against a database
> > >>instead of tomcat-users.xml
> > >>
> > >>
> > >>
> > >>Ben Cuthbert
> > >>Deutsche Bank - Global Markets
> > >>TISO Customer Trading Technology
> > >>PGP: http://pgp.mit.edu
> > >>
> > >>+44 (0) 20 754 76389 (Tel)
> > >>+44 (0) 20 754 74996 (Fax)
> > >>
> > >>
> > >>
> > >>
> > >>"Sevillano sevi llano" <se...@hotmail.com>
> > >>04/15/2005 10:41 AM
> > >>Please respond to "Tomcat Users List"
> > >>
> > >>         To:     tomcat-user@jakarta.apache.org
> > >>         cc:
> > >>         Subject:        Re: can�t Configurate
> Database Connection Pool
> > >>(DBCP) with Tomcat 5.0.28
> > >>
> > >>
> > >>Hi Benajmin,
> > >>
> > >>I�m testing with two different databases:
> > >>oracle 9 and mysql
> > >>
> > >>with both I�ve got the same error
> > >>org.apache.commons.dbcp.SQLNestedException:
> Cannot create JDBC driver of
> > >>class '' for connect URL 'null'
> > >>
> > >>and with both I can connect directly
> > >>for example, it works correctly:
> > >>...
> > >>DriverManager.registerDriver(new
> oracle.jdbc.driver.OracleDriver());
> > >>conn =
> >
>
>>DriverManager.getConnection("jdbc:oracle:thin:@*.*.*.*:1521:bddesa","**","**");
> > >>...
> > >>
> > >>
> > >>Thanks very much
> > >>
> > >>
> > >> >From: "Benjamin Cuthbert"
> <be...@db.com>
> > >> >Reply-To: "Tomcat Users List"
> <to...@jakarta.apache.org>
> > >> >To: "Tomcat Users List"
> <to...@jakarta.apache.org>
> > >> >CC: tomcat-user@jakarta.apache.org
> > >> >Subject: Re:  can�t Configurate Database
> Connection Pool (DBCP) with
> > >>Tomcat
> > >> >5.0.28
> > >> >Date: Fri, 15 Apr 2005 10:36:30 +0100
> > >> >
> > >> >Sevillano
> > >> >
> > >> >Can you show me your JDBC configuration.
> > >> >
> > >> >
> > >> >
> > >> >Ben Cuthbert
> > >> >Deutsche Bank - Global Markets
> > >> >TISO Customer Trading Technology
> > >> >PGP: http://pgp.mit.edu
> > >> >
> > >> >+44 (0) 20 754 76389 (Tel)
> > >> >+44 (0) 20 754 74996 (Fax)
> > >> >
> > >> >
> > >> >
> > >> >
> > >> >"Sevillano sevi llano"
> <se...@hotmail.com>
> > >> >04/15/2005 10:34 AM
> > >> >Please respond to "Tomcat Users List"
> > >> >
> > >> >         To:    
> tomcat-user@jakarta.apache.org
> > >> >         cc:
> > >> >         Subject:        can�t Configurate
> Database Connection Pool
> > >>(DBCP)
> > >> >with Tomcat 5.0.28
> > >> >
> > >> >
> > >> >Hi, I�m a newbie trying to configurate DBCP
> with Tomcat 5.0.28
> > >> >
> > >> >I�m following this documentation:
> > >>
>
>http://jakarta.apache.org/tomcat/tomcat-5.0-doc/jndi-datasource-examples-howto.html
> > >> >
> > >> >
> > >> >"...Add this in between the </Context> tag of
> the examples context and
> > >>the
> > >> >
> > >> ></Host> tag closing the localhost
> definition..."
> > >> >but there is no </Context> in my server.xml
> > >> >
> > >> >also I�ver read tons of forums about this
> question, and I�ve tested a
> > >>lot
> > >> >of
> > >> >different configuration.
> > >> >
> > >> >this is the error I�ve got (the usual I
> think):
> > >> >org.apache.commons.dbcp.SQLNestedException:
> Cannot create JDBC driver of
> > >> >class '' for connect URL 'null'
> > >> >
> > >> >
> > >> >
> > >> >any help please? I�ve been the whole week
> trying to fix it
> > >> >
> > >> >thanks
> > >> >
> > >> >
> > >> >
> > >> >
> > >> >these are my files:
> > >> >
> > >> >SERVER.XML
> > >> >
> > >> ><Server port="8005" shutdown="SHUTDOWN">
> > >> >
> > >> >
> > >> >   <GlobalNamingResources>
> > >> >     <!-- Used by Manager webapp -->
> > >> >     <Resource name="UserDatabase"
> auth="Container"
> 
=== message truncated ===


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org