i goofed
i forgot to put 2 lines in my server.xml file.
inside the global naming resources
<Resource auth="Container" description="User database that can be updated
and saved" name="UserDatabase" type="org.apache.catalina.UserDatabase"/>
<Resource auth="Container" name="jdbc/TSRDATA" type="javax.sql.DataSource"/>


thanks

daniel

Schulken

----- Original Message ----- 
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, March 04, 2004 2:57 PM
Subject: DataSource not found


background info

tomcat 5.0.19
mysql 4.0.15 a
on slackware 9.0 i think(not totally sure about this)
jndi datasource not found is what i am getting
server.xml
<GlobalNamingResources>
<Resource name="UserDatabase" auth="Container"
type="org.apache.catalina.UserDatabase"
description="User database that can be updated and saved">
</Resource>
<ResourceParams name="UserDatabase">
<parameter>
<name>factory</name>
<value>org.apache.catalina.users.MemoryUserDatabaseFactory</value>
</parameter>
<parameter>
<name>pathname</name>
<value>conf/tomcat-users.xml</value>
</parameter>
</ResourceParams>
<ResourceParams name="jdbc/TSRDATA">
<parameter>
<name>url</name>
<value>jdbc:mysql://*.*.*.*:3306/TSRDATA?autoReconnect=true</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>30</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>100</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>org.gjt.mm.mysql.Driver</value>
</parameter>
<parameter>
<name>maxWait</name>
<value>10000</value>
</parameter>
<parameter>
<name>removeAbandoned</name>
<value>true</value>
</parameter>
<parameter>
<name>username</name>
<value>*****</value>
</parameter>
<parameter>
<name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter>
<parameter>
<name>logAbandoned</name>
<value>true</value>
</parameter>
<parameter>
<name>removeAbandonedTimeout</name>
<value>60</value>
</parameter>
<parameter>
<name>password</name>
<value>*****</value>
</parameter>
</ResourceParams>
</GlobalNamingResources>
web.xml has

<resource-ref>

<description>DB connection </description>

<res-ref-name>jdbc/TSRDATA</res-ref-name>

<res-type>javax.sql.DataSource</res-type>

<res-auth>Container</res-auth>

<resource-ref>

its autodeployed thru war file.

the context file has

<ResourceLink name="jdbc/TSRDATA" global="jdbc/TSRDATA"
type="javax.sql.DataSource"/>

and the jar file is mysql-connector-java-3.0.10-stable-bin.jar

and is located in the common/lib dir

did i miss something or did i do to much?



thanks

Daniel Schulken


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.598 / Virus Database: 380 - Release Date: 2/28/2004


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to