> -----Original Message-----
> From: Koon Yue Lam [mailto:[EMAIL PROTECTED]
> Sent: Monday, July 19, 2004 12:46 PM
> To: Struts Users Mailing List
> Subject: Datasource problem again..
>
> >
> Do I need to modify the web.xml under $Tomcat/conf ??
You have to add a "Resource" element in your context in server.xml. Here's the sort of
thing that works for us:
<Context path="/TDX" docBase="TDX" debug="0"
reloadable="true" crossContext="true">
<Resource name="jdbc/tdxDB" auth="Container"
type="javax.sql.DataSource" />
<ResourceParams name="jdbc/tdxDB">
<parameter>
<name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter>
<parameter>
<name>serverName</name>
<value>localhost</value>
</parameter>
<parameter>
<name>username</name>
<value>TheUserName</value>
</parameter>
<parameter>
<name>password</name>
<value>ThePassword</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>com.sybase.jdbc2.jdbc.SybDriver</value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc:sybase:Tds:MyServername:portname?servicename=MyServiceName</value>
</parameter>
<parameter>
<name>validationQuery</name>
<value>select count(*) from a tablename where
something</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>1</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>1</value>
</parameter>
<parameter>
<name>removeAbandoned</name>
<value>true</value>
</parameter>
<parameter>
<name>removeAbandonedTimeout</name>
<value>60</value>
</parameter>
</ResourceParams>
</Context>
>
> Regards
Let me know if you need additional info and I can send you a link where I read up on
these details: in a rush now for a meeting..(:(
Geeta
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
