hai david,
 thank for sending those help files.now we are using tomcat 5.0.x.
our database is mysql and the Driver is com.sql.jdbc.Driver.

when i am calling the jsp pages in my project its working fine,if i am
trying to communicate with database errorpage  is thrown.
******************
i had tried to create new *jndi* name through tomcat admin page.but the
changes are not reflecting in the usr/j-tomcat5.0/config/server.xml

instead linux is creating a new xml file named as server.xml(plus date and
time of creation) inthe same directory  Even in that  xml file also i cont
see the jndi name and other changes, which i had done through admin page.

i want to know how to configure the jndi name in the server.xml file

since i am new to linux with tomcat i cont proceed with things, please guide
me in the right direction

bye
with regards
prakash s


On 9/26/06, David Smith <[EMAIL PROTECTED]> wrote:

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]




--
Thanks and Regards
S.Prakash

Reply via email to