On JNDI connection problems: We'll need to see more. Specifically the
jsp code calling for the sql connection and the web.xml. A full stack
trace of the error you get would be excellent as well. Lastly, confirm
the mysql jdbc driver is in common/lib of the tomcat directory, not
WEB-INF/lib of your webapp.
On configuring in server.xml, this is fast becoming a file that should
be left alone for all but general server configuration. JNDI resources
should be defined either in your [webapp_name].xml file in
conf/Catalina/localhost or a context.xml file placed in the META-INF
directory of a .war file unless you really want the resource available
to all web applications in tomcat.
On the admin webapp problems: I don't use it, so I can't help. Maybe
someone else could comment?
--David
prakash shanmugam wrote:
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]
---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]