If we have 10 servlets, and we need to use database connection. Then Where should I write the JDBC code that must be established from a servlet and need to utilize in all other servlets

You can create a Connection Class, keep one getConnection method there which has JDBC code and
whenever u want to create a connection then make object of that class
and call that function.

If you are going for big projects then you can use connection pooling!

thanks

__________________
:)
NEVER SAY DIE.

Write a separate java class with the static getConn() method. u can get the connection object by Connection con = MyConnection.getConn()
or
use context param in deployment descriptor file(web.xml) outside all servlet tags add the details about ur database later get the parameter values in init() using getInitParameter()
here is the sample code
<context-param>
<param-name>url</param-name>
<param-value>sun.jdbc.odbc.JdbcOdbcDriver</param-value>
<param-name>connstring</param-name>
<param-value>jdbcdbc:mydsn</param-value>
</context-param>

Do one thing write a simple java class and put all the JDBC code and use the class in servlets where u want.
if you are using the application Servler better to use the Connection Pooling which ipmroves the performance of the application.
It may helps you..
Thanks..

Hi,

use a seperate class which makes JDBC Connection.
then call that class from all other servlets which needs to access database

how to configure the jdbc in weblogicserver

hi,

for JDBC COnnection in WebLogic,

go to Services,

First set Connection Pool and then Set DataSource.

try to use DAO s