Tomcat - Database Connection Pooling- Question

[foramit]

I am considering to use a Shared hosted Environment for my website- currently in very early stage ( Tomcat,MYSQL and JSP)

I know that in shared environment, we do not get access to server.xml file if I want to use Connection Pooling.

Is there an alternative way that I can use ?
Or do I need to design my application and use java Bean for establishing Connection ?

Will appreciate any ideas or suggestions on this.
Thanks,
A

 

[sedj]

ASFAIK, you cannot set up JNDI based connection pooling without modifications to server.xml ...

--------------------------------------------------
Free Java/J2EE Database Connection Pooling Software

http://www.primrose.org.uk

 

[foramit]

I was reading on tomcat forum.

http://jakarta.apache.org/tomcat/tomcat-5.5-doc/jndi-datasource-examples-howto.html

If you scroll to the part under PostGreSQl it as a topic "2b. Application-specific resource configuration"

Would you know what exactly they mean by that ?

Thanks for your earlier reply.
So for above, if I dont have accces to server.xml I am pretty much writing all the code for connection pooling - Correct?

 

[sedj]

Hmm, interesting ...
I wasn't aware you could do that. I'll have a play and see.

Which pooling system were you planning on using ?

--------------------------------------------------
Free Java/J2EE Database Connection Pooling Software

http://www.primrose.org.uk

 

[foramit]

Truthfully, I dont know the answer to your question as I dont know much about it.

What are the different types? Can you prvide me some info ? OR where can I look up?

All I I want to do is Define a Datasource by going in Tomcat Admin ( under data source). MYSQL and ODBC driver

And once done, create a War of my application with the xml as per the post in the forum.

Dont know if I interpreted the solution in above forum I pasted the link for correctly.

Thanks a lot.