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: users@tomcat.apache.org
>>>>> > 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: users@tomcat.apache.org
>>>>> To unsubscribe, e-mail: [EMAIL PROTECTED]
>>>>> For additional commands, e-mail: [EMAIL PROTECTED]
>>>>>
>>>>>
>>>>
>>>>
>>>> --
>>>> Sincerely yours åT
>>>
>>>
>>> ---------------------------------------------------------------------
>>> To start a new topic, e-mail: users@tomcat.apache.org
>>> To unsubscribe, e-mail: [EMAIL PROTECTED]
>>> For additional commands, e-mail: [EMAIL PROTECTED]
>>>
>>
>>
>> ---------------------------------------------------------------------
>> To start a new topic, e-mail: users@tomcat.apache.org
>> 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: users@tomcat.apache.org
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
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!
