code for Database connection

[Rekha Gaikwad]

Hi,
I am developing an application using Java/JSP and web container is tomcat. Can anybody guide me how should I go abt writing connection class?
Is it ok to make connection through servlet init method?

[Scott Selikoff]

Do you want to write your own connection class? Unless you're developing your own database, you generally want to use an exisitng Connection class with a JDBC driver that comes with your database.

I'd recommenting using lazy instantiation (only create it the first time you need it) for your database connection for two reasons: 1) better performance overall 2) better control- you can close it after you are done so that you dont run out of connections

[Milan Jagatiya]

better you refer below link ...and go for "JDBC Data Sources"...
it helps....
TOMCAT JNDI-RESOURCES

[Rekha Gaikwad]

Thanks for your help guys.Really Appreciate it!!!