Hi
I am new to Java and I want to ask while creating a website or any of the project i want to setup the connection only once. I mean connection should be made in only one class and to be provided to all the classes and need not to be made in all classes. How can i do that?
Regards and thanks
Shaveta
This is probably not a good idea , especially if there is going to some sort of lag (time difference) between hits on the database. If you are going to do it then just like everything else, pass the connection as a parameter.
If you are using tomcat as the deployment server for your website, you can use the connection pooling provided by Jakarta Commons DBCP libraries.
Refer to this link
http://tomcat.apache.org/tomcat-4.1-doc/jndi-datasource-examples-howto.html
