Oracle JDBC Connection pool in Sun Java System Application Server

Configuring Oracle JDBC Connection pool in Sun Java System Application Server This article might help some one finding difficult to create a JDBC connection pool in Sun Java System Application server Follow these steps to create JDBC connection pool from admin console Copy the drivers to domain lib folder Modify JVM settings and add jar location to classpath suffix. The entry should look similar to this ${com.sun.aas.installRoot}/domains/domain1/lib/ojdbc14.jar In JVM options tab specify -Doracle.jdbc.J2EE13Compliant=true Specify name for connection pool In resource type select javax.sql.Datasource Select oracle as vendor Use the default Datasource classname entry oracle.jdbc.pool.OracleDataSource Specify only these 3 properties User: user name Password: password URL: jdbc:oracle:thin:@<hostname>:<port>:<database name> Test your connection by using Ping button References: 1. http://docs.sun.com/app/docs/doc/819-2641/6n4trr8kt?a=view (Sun Java System Application Server Platform Edition 8.1 2005Q2 Update 2 >> Sun Java System Application Server Platform Edition 8.1 2005Q2 Update 2 Administration Guide >> 3. JDBC Resources >> Setting Up Database Access >> To integrate a JDBC driver) 2. Using the JDBC API for Database Access Oracle JDBC Connection pool in Sun Java System Application Server - Wednesday, October 12, 2005 -

Post a Comment