Hi,
Tomcat 5.5.x, 6.0.13 !
<Resource name="jdbc/Name" auth="Container" type="javax.sql.DataSource"
factory="org.apache.tomcat.dbcp.dbcp.BasicDataSourceFactory" username="XXX"
password="XXX" driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://domain.com:3306/BASE?autoReconnect=true" maxActive="10"
maxIdle="10" maxWait="5000" removeAbandoned="true" removeAbandonedTimeout="30"
logAbandoned="true" />
Tomcat 4.x, 5.x
<Resource name="jdbc/Name" auth="Container"
type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/Name">
<parameter>
<name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>10</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>10</value>
</parameter>
<parameter>
<name>maxWait</name>
<value>5000</value>
</parameter>
<parameter>
<name>removeAbandoned</name>
<value>true</value>
</parameter>
<parameter>
<name>removeAbandonedTimeout</name>
<value>30</value>
</parameter>
<parameter>
<name>username</name>
<value>XXXXXX</value>
</parameter>
<parameter>
<name>password</name>
<value>XXXXXXX</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>com.mysql.jdbc.Driver</value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc:mysql://domain1:3306/BASE?autoReconnect=true</value>
</parameter>
</ResourceParams>
</Context>
See you!
-----Original Message-----
From: daniel steel [mailto:[EMAIL PROTECTED]
Sent: sexta-feira, 29 de junho de 2007 14:55
To: Tomcat Users List
Subject: Re: Update Tomcat 5 -> 6 .. JDBC driver problem
if we configure the url / db access as JNDI resource in the context files,
then the implementation has changed betwen tomcat 5 and tomcat6. not sure
about tomcat 5.5..
in tomcat6, it is
<Context ...>
...
<Resource name="jdbc/EmployeeDB" auth="Container"
type="javax.sql.DataSource" username="dbusername"
password="dbpassword"
driverClassName="org.hsql.jdbcDriver"
url="jdbc:HypersonicSQL:database"
maxActive="8" maxIdle="4"/>
...
</Context>
in tomcat 5,
<Context ...>
...
<Resource name="jdbc/EmployeeDB" auth="Container"
type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/EmployeeDB">
<parameter>
<name>username</name>
<value>dbusername</value>
</parameter>
<parameter>
<name>password</name>
<value>dbpassword</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>org.hsql.jdbcDriver</value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc:HypersonicSQL:database</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>8</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>4</value>
</parameter>
</ResourceParams>
...
</Context>
thanks
dan
David Smith <[EMAIL PROTECTED]> wrote: That's good info, but only barely
related to the question at hand and they said they had it working in tomcat
5.5.23 -- just failing in tomcat 6. Given it works in one version of tomcat
and not another, I highly doubt the mysql jdbc url is at fault. The OP needs
to post portions of their configuration (context.xml, web.xml, server.xml)
before any further diagnosis can be done.
--David
Martin Gainty wrote:
> MySQL Connector/J doc says
>
> "The JDBC URL format for MySQL Connector/J is as follows, with items
> in square brackets ([, ]) being optional:
> jdbc:mysql://[host][,failoverhost...][:port]/[database] »
> [?propertyName1][=propertyValue1][&propertyName2][=propertyValue2]...
>
> If the hostname is not specified, it defaults to 127.0.0.1.
> If the port is not specified, it defaults to 3306, the default port
> number for MySQL servers.
> jdbc:mysql://[host:port],[host:port].../[database] »
> [?propertyName1][=propertyValue1][&propertyName2][=propertyValue2]...
>
> If the database is not specified, the connection will be made with
> no default database.
>
> M--
> This email message and any files transmitted with it contain
> confidential information intended only for the person(s) to whom this
> email message is addressed. If you have received this email message
> in error, please notify the sender immediately by telephone or email
> and destroy the original message without making a copy. Thank you.
>
> ----- Original Message ----- From: "gregory hans"
> To: "Tomcat Users List"
> Sent: Friday, June 29, 2007 9:37 AM
> Subject: Re: Update Tomcat 5 -> 6 .. JDBC driver problem
>
>
>> i using tomcat6 right now and i put my jdbc in my lib directory and
>> that's okay. can you post your error to me so i can figure what's
>> going on.
>>
>> David Smith wrote: In tomcat 6, the new common/lib is simply lib as
>> I understand it. Could you post your config? The error you originally
>> posted typically indicates a misconfiguration as opposed to not being
>> able to find the driver class.
>>
>> --David
>>
>> Rene Guenther wrote:
>>> Alas, still the same error.
>>>
>>> So you think, that I get this error because tomcat isnt able to find
>>> the .jar file with the MySQL driver? Maybe something changed between
>>> Tomcat 5 and 6 related to ?
>>>
>>> Regards
>>> René
>>>
>>> On Thu, 28 Jun 2007 18:37:21 +0800
>>> "Allen åT" wrote:
>>>> Put your jars into: *apache-tomcat-6.x.x/lib* will be just fine.
>>>>
>>>>
>>>> 2007/6/28, Rene Guenther :
>>>>>
>>>>> Thanks for your reply. Unfortunately I am still getting the same
>>>>> error with tomcat 6.0.13
>>>>>
>>>>> Regards
>>>>> René
>>>>>
>>>>> On Thu, 28 Jun 2007 02:34:10 -0700 (PDT) gregory hans wrote:
>>>>> > try to put your jdbc in your web application (WEB-INF/LIB/).
>>>>> >stop the service first, put the jdbc then start again...
>>>>> >
>>>>> > Rene Guenther wrote:
>>>>> >Hello,
>>>>> >
>>>>> > I am getting the following exception with tomcat 6.0.13:
>>>>> >
>>>>> > Cannot create JDBC driver of class '' for connect URL 'null'
>>>>> >
>>>>> > This exception I dont get with tomcat 5.5.23
>>>>> >
>>>>> > I put the mysql jdbc driver (version 5.x) into
>>>>> > apache-tomcat-x.x.x/common/lib
>>>>> >
>>>>> > Anyone knows what the problem could be?
>>>>> >
>>>>> > (OS: Linux Debian, Java Version 1.5)
>>>>> >
>>>>> > Regards
>>>>> > René
>>>>> >
>>>>> >
>>>>> >
>>>>> ------------------------------------------------------------------
>>>>> ---
>>>>> > To start a new topic, e-mail: [email protected] To
>>>>> >unsubscribe, e-mail:
>>>>> >[EMAIL PROTECTED]
>>>>> >For additional commands, e-mail:
>>>>> >[EMAIL PROTECTED]
>>>>> >
>>>>> >
>>>>> >
>>>>> >
>>>>> > --------------------------------- Don't pick lemons.
>>>>> > See all the new 2007 cars at Yahoo! Autos.
>>>>>
>>>>>
>>>>> ------------------------------------------------------------------
>>>>> --- To start a new topic, e-mail: [email protected] To
>>>>> unsubscribe, e-mail: [EMAIL PROTECTED]
>>>>> For additional commands, e-mail: [EMAIL PROTECTED]
>>>>>
>>>>>
>>>>
>>>>
>>>> --
>>>> Sincerely yours åT
>>>
>>>
>>> --------------------------------------------------------------------
>>> - To start a new topic, e-mail: [email protected] To
>>> unsubscribe, e-mail: [EMAIL PROTECTED]
>>> For additional commands, e-mail: [EMAIL PROTECTED]
>>>
>>
>>
>> ---------------------------------------------------------------------
>> To start a new topic, e-mail: [email protected] To unsubscribe,
>> e-mail: [EMAIL PROTECTED]
>> For additional commands, e-mail: [EMAIL PROTECTED]
>>
>>
>>
>>
>> ---------------------------------
>> TV dinner still cooling?
>> Check out "Tonight's Picks" on Yahoo! TV.
>
>
> ---------------------------------------------------------------------
> To start a new topic, e-mail: [email protected] To unsubscribe,
> e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
---------------------------------------------------------------------
To start a new topic, e-mail: [email protected] To unsubscribe, e-mail:
[EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------
Shape Yahoo! in your own image. Join our Network Research Panel today!
---------------------------------------------------------------------
To start a new topic, e-mail: [email protected]
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
