may i know how to use connetor/J?
From: umesh balasubramaniam <[EMAIL PROTECTED]>
Reply-To: "Tomcat Users List" <users@tomcat.apache.org>
To: Tomcat Users List <users@tomcat.apache.org>
Subject: Re: JNDI Datasource Problem
Date: Fri, 24 Feb 2006 21:55:15 -0800
Try using connector/J and the configuration below:
<Resource name="jdbc/galleryDB" auth="Container" type="
javax.sql.DataSource"/>
<ResourceParams name="jdbc/galleryDB">
<parameter>
<name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory
</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>com.mysql.jdbc.Driver</value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc:mysql://localhost/Gallery?autoReconnect=true</value>
</parameter>
<parameter>
<name>username</name>
<value>GalleryUser</value>
</parameter>
<parameter>
<name>password</name>
<value>hwaying</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>20</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>10</value>
</parameter>
<parameter>
<name>maxWait</name>
<value>-1</value>
</parameter>
</ResourceParams>
</Context>
On 2/24/06, lee hwaying <[EMAIL PROTECTED]> wrote:
>
> ERROR JDBCExceptionReporter - Cannot create JDBC driver of class '' for
> connect URL 'null'
>
> I still get the above error in Tomcat 5.5.15 after doing the below.
Please
> help
>
> web.xml :
> ...
>
> <resource-ref>
>
> <res-ref-name>jdbc/galleryDB</res-ref-name>
> <res-type>javax.sql.DataSource</res-type>
> <res-auth>Container</res-auth>
> <res-sharing-scope>Shareable</res-sharing-scope>
>
>
> </resource-ref>
> ...
>
>
> C:\apache-tomcat-5.5.15\conf\server.xml :
> ...
> <!-- Global JNDI resources -->
> <GlobalNamingResources>
>
> <!-- Test entry for demonstration purposes -->
>
>
> <Environment name="simpleValue" type="java.lang.Integer"
value="30"/>
>
> <!-- Editable user database that can also be used by
> UserDatabaseRealm to authenticate users -->
>
>
> <Resource name="UserDatabase" auth="Container"
> type="org.apache.catalina.UserDatabase"
> description="User database that can be updated and saved"
>
>
> factory="org.apache.catalina.users.MemoryUserDatabaseFactory"
> pathname="conf/tomcat-users.xml" />
>
>
> <Resource auth="Container" name="jdbc/galleryDB" type="
>
> javax.sql.DataSource"
> factory="org.apache.commons.dbcp.BasicDataSourceFactory"
> driverClassName="org.gjt.mm.mysql.Driver"
> url="jdbc:mysql://localhost/Gallery?autoReconnect=true"
>
>
> username="GalleryUser"
> password="hwaying"
> maxActive="50"
> maxIdle="10"
> maxWait="10000"
> removeAbandoned="true"
> removeAbandonedTimeout="60"
>
>
> logAbandoned="true"/>
>
> </GlobalNamingResources>
> ...
>
> C:\apache-tomcat-5.5.15\conf\Catalina\localhost\root.xml
> <Context debug="0" displayName="gallery" path="/gallery"
> docbase="C:\apache-
>
> tomcat-5.5.15\webapps\gallery" reloadable="true">
>
> <!-- Link to the user database we will get roles from -->
> <ResourceLink name="jdbc/galleryDB" global="galleryDB"
>
>
> type="javax.sql.DataSource"/>
> </Context>
>
> Please help
>
> many thansk
>
> _________________________________________________________________
> Find love online with MSN Personals.
> http://match.msn.com.my/match/mt.cfm?pg=channel
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
>
_________________________________________________________________
Find love online with MSN Personals.
http://match.msn.com.my/match/mt.cfm?pg=channel
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
