This is well documented on the tomcat site. What you've included below
works on tomcat 5.0, but not 5.5. See the online docs:
Tomcat 5.5 --
http://tomcat.apache.org/tomcat-5.5-doc/jndi-datasource-examples-howto.html
Tomcat 5.0 --
http://tomcat.apache.org/tomcat-5.0-doc/jndi-datasource-examples-howto.html
What version of tomcat are you working with?
--David
prakash shanmugam wrote:
hai Li,
ur gussing is correct, i am using JNDI DS, here by i had pasted the
code
which is appended in the *server.xml. *
*server.xml*
<Context className="org.apache.catalina.core.StandardContext"
cachingAllowed="true" charsetMapperClass="
org.apache.catalina.util.CharsetMapper" cookies="true"
crossContext="false"
debug="0" displayName="Project Tracking System" docBase="opts7"
mapperClass="org.apache.catalina.core.StandardContextMapper"
path="/opts7"
privileged="false" reloadable="true" swallowOutput="false"
useNaming="true"
wrapperClass="org.apache.catalina.core.StandardWrapper">
<Resource name="mine" scope="Shareable"
type="javax.sql.DataSource
"/>
<ResourceParams name="mine">
<parameter>
<name>maxWait</name>
<value>5000</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>200</value>
</parameter>
<parameter>
<name>password</name>
<value></value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc:mysql://100.100.100.6:3306/opts</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>com.mysql.jdbc.Driver</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>10</value>
</parameter>
<parameter>
<name>username</name>
<value>dav</value>
</parameter>
</ResourceParams>
</Context>
</Host>
</Engine>
*web.xml*
<resource-ref>
<description> DB Connection Pooling</description>
<res-ref-name>mine</res-ref-name>
<res-type> javax.sql.DataSource</res-type>
<res-auth> Container</res-auth>
</resource-ref>
The above pasted code is working fine in windows, but our server in
linux.
we cont able to communicate to the database. please, check where i had
went
wrong...
bye
with regrds
prakash
On 9/26/06, Li <[EMAIL PROTECTED]> wrote:
depends on what pool you use ...
If use JNDI DS, you have to create a resource section in your
server.xml:
....
<engin ...>
<host ...>
<context ...>
<Resource
name="..."
auth="Container"
type="javax.sql.DataSource"
username="..."
password="..."
driverClassName="..."
url="..."
maxActive="..."
maxIdle="..."
maxWait="..."
... />
</context>
</host>
</engine>
...
if you use other data source like hibernate's ... see their manual
good luck
On 9/26/06, prakash shanmugam <[EMAIL PROTECTED]> wrote:
>
> hai all,
>
> can u do one help ...
> i need details about how to configure Connection Pooling in
> Tomcat with MySQL in Linux platform...
> i have done in windows platform..its working well..
> i followed the same concepts in linux server also..
> but it is not working... can u u hepl me in this regard..
> it will be very much helpful for me if u do this..
>
> with regards
> prakash
>
>
--
When we invent time, we invent death.
---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]