4 messages in com.mysql.lists.javaRe: tomcat datasource resource (fwd)
FromSent OnAttachments
joe pribele23 Sep 2002 20:49 
William R. Mussatto24 Sep 2002 08:38 
William R. Mussatto25 Sep 2002 08:12 
joe pribele25 Sep 2002 09:33 
Subject:Re: tomcat datasource resource (fwd)
From:William R. Mussatto (muss@csz.com)
Date:09/25/2002 08:12:35 AM
List:com.mysql.lists.java

I think he means you?

Sincerely,

William Mussatto, Senior Systems Engineer CyberStrategies, Inc ph. 909-920-9154 ext. 27

---------- Forwarded message ---------- Date: Wed, 25 Sep 2002 12:26:45 +0530 From: Shridhar.. <shri@hotmail.com> To: "William R. Mussatto" <muss@csz.com> Subject: Re: tomcat datasource resource

Hello William,

Can U send me a sample java code, as to how to use DataSource..

Regards, Shridhar..

----- Original Message ----- From: "William R. Mussatto" <muss@csz.com> To: "joe pribele" <jpri@sympatico.ca> Cc: <ja@lists.mysql.com> Sent: Tuesday, September 24, 2002 21:08 Subject: Re: tomcat datasource resource

How would this change if you were trying to limit it to a given "context"? Any thoughts?

On Mon, 23 Sep 2002, joe pribele wrote:

Date: Mon, 23 Sep 2002 23:50:09 -0400 From: joe pribele <jpri@sympatico.ca> To: ja@lists.mysql.com Subject: tomcat datasource resource

It took a bit a of digging but I figured out how to setup a jndi datasource with only using the supplied Mysql classes add the following to any context. you have to have all the parameters

<Resource name="jdbc/TestDB" auth="Container" type="com.mysql.jdbc.jdbc2.optional.MysqlConnectionPoolDataSource"/>

<ResourceParams name="jdbc/TestDB"> <parameter> <name>factory</name> <value>com.mysql.jdbc.jdbc2.optional.MysqlDataSourceFactory</value> </parameter>

<parameter> <name>port</name> <value>3306</value> </parameter>

<parameter> <name>user</name> <value>XXXX</value> </parameter>

<parameter> <name>password</name> <value>XXXX</value> </parameter>

<parameter> <name>serverName</name> <value>XXXX</value> </parameter>

<parameter> <name>databaseName</name> <value>XXXXX</value> </parameter> </ResourceParams>

Sincerely,

William Mussatto, Senior Systems Engineer CyberStrategies, Inc ph. 909-920-9154 ext. 27