Thursday, March 6

How to configure a DB connection pool?

ANSWER :

1) Choose the DB type (Oracle, Sybase, Mysql, etc...).
2)Then choose the driver type for the DB.
3) Give the connection pool name.
4) Give the DB Service ID, schema name and password.
5)Then it will ask for testing the connection pool/DataSource.
6) After successful connection, it will ask you to create and deploy the connection pool target to server or cluster. After creating new connection pool always point the jdbc-store to the connection pool created. This is required because A JMS JDBC store will be used for persistent messaging.
7)After each JDBC connection, we have to restart the server if there is startup classes dependency exists otherwise no restart required in WebLogic 9.x and higher versions.

No comments:

Post a Comment