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 help me in this regard..
it will be very much helpful for me if u do this..
Can you mention what you mean by not working.The resource configuration in application definition file will look like
So there is nothing here regarding operating system.You nee to tell us what exception or problem you are facing.
I am using Tomcat 5.0.5 as Web Server ,MySQL 4 as Backend ...
Actually My project is an application like project it will be accessed via intranet by
lot of users at the same time..
So connection related problem occurs
when more than one user is trying to access the db at the same time..
So i thought of implementing Connection Pooling Concept Using jndi..
So i opened the admin page of tomcat and configured datasource for
that particular web-apps..
Automatically new tags related to that
jndi DataSource are generated in CATALINA-HOME/conf/server.xml file..
Then i have include tag web.xml file of my web-apps..
Then in all java and jsp files i have established connection by getting reference
of DataSource as in the following segment of code..
Context envCtx = (Context) new InitialContext().lookup("java:comp/env");
DataSource ds = (DataSource) envCtx.lookup("mine");
where "mine" is the jndi name created in Tomcat admin page...
It worked well in my system which is having OS as Windows xp...
Now i have to upload the same application in Tomcat in Server
where the OS is RedHat Linux...
I followed the same steps as what i did in my windows machine...After making all the changes I restarted the server after which
when i am calling the jsp pages in my project its working fine,if i am trying to communicate with database it throws errorpage which I had designed
and another important thing I noticed is I 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