Tuesday, January 27, 2009

Creating Oracle DataSource in Glassfish

To setup an Oracle Datasource in Glassfish, follow these steps:1. Copy the Oracle JDBC drivers to /glassfish/domains/domain1/lib/ext directory. You may need to change the directory /glassfish/domains/domain1 to match your installation of Glassfish and the domain name.
2. Start Glassfish.
3. Login to the admin interface and create a JDBC Connection Pool.Delete all properties, and add following properties:user - set this to Oracle useridpassword - set this to Oracle passwordURL - set this to the URL, example jdbc:oracle:thin:@localhost:1521:xe.xa-driver-does-not-support-non-tx-operations - set this to true.Test the connection pool using ping.
4. Create a JDBC DataSource using the Connection Pool.


Ujjwal B Soni

No comments: