 | Mailing List | | Home | | Forum Home | | JBoss - Java Application Server | | Struts - A MVC web framework | | Tomcat - JSP/Servlet container | | iText - An open source PDF Java Library | | JDOM - JDOM XML Parser | | J2EE - A mailing list for Java(tm) 2 Platform, Enterprise Edition | | J2EE Pattern - An interest list for Sun Java Center J2EE Pattern Catalog | | Servlet - A mailing list for discussion about Sun Microsystem's Java Servlet API Technology | | JSP - A mailing list about Java Server Pages specification and reference | |
Struts & Hibernate
|
|
|
| | | Connection pooling tag in EJB 's !! | Connection pooling tag in EJB 's !! 2004-08-30 - By Gernot Schwed
Back
Hello Jagannath,
if you follow the link you will find a nice description to create a
connection pool.
http://docs.sun.com/source/817-1243-10/dvlpdply.html#44824
1. You can configure it manually like described in the document:
Create the JDBC Connection Pool (cargoline-pool, ordercenter-pool)
1. Go the Application Server's administration screen http://<host>:4848/
and login as admin.
2. Go to App Server Instances > server1 > JDBC > Connection pool.
3. Create a new jdbc connection pool.
4. Click New.
5. In the Name field, enter cargoline-pool, Database Vendor as PointBase.
6. Select Next.
7. Configure the following properties:
user: PBPUBLIC
password: PBPUBLIC
databaseName: jdbc:pointbase://<host>:9099/cargoline
8. Click FINISH.
9. Repeat steps 1 through 6 to create ordercenter-pool (change pool name
in step 4).
2. or you can create a server.xml and deploy it with an ant task (something
like this):
--snip--
<jdbc-resource enabled="true" pool-name="jdbc/inventory_connection_pool"
jndi-name="jdbc/inventory_database_resource"/>
<jdbc-connection-pool
steady-pool-size="2"
max-pool-size="32"
max-wait-time-in-millis="60000"
pool-resize-quantity="2"
idle-timeout-in-seconds="300"
is-isolation-level-guaranteed="false"
is-connection-validation-required="false"
connection-validation-method="auto-commit"
fail-all-connections="false"
datasource-classname="oracle.jdbc.xa.client.OracleXADataSource"
name="jdbc/inventory_connection_pool"
res-type="javax.sql.XADataSource  ">
<property value="${application.dbUser}" name="user"/>
<property value="${application.dbPassword}" name="password"/>
<property value="${application.dbUrl}" name="url"/>
</jdbc-connection-pool>
--snap--
The ant task merely replaces the variables and copies the server.xml to the
sun-one directory.
Hope this will help you...
Regards,
Gernot
===========================================================================
To unsubscribe, send email to listserv@(protected) and include in the body
of the message "signoff J2EE-INTEREST". For general help, send email to
listserv@(protected) and include in the body of the message "help".
|
|
|
