1 . Copy JDBC Oracle driver to GLASSFISH/lib, for example, copy ojdbc14.jar to /usr/local/glassfish/lib.
2. Restart Glassfish, log on to Glassfish admin interface, create a new JDBC Connection Pool.
Delete all properties, and add following properties:
user – set this to Oracle userid
password – set this to Oracle password
URL – set this to the URL, Format : jdbc:oracle:thin:@HOSTNAME:PORT:SID.
Test the connection pool by clicking the “ping” button to get the verify message.
3. Create a JDBC DataSource using the JDBC Connection Pool.
Full details for creating an Oracle connection pool in Glassfish2.1.1 can be found from the link below:
Full details for creating MySQL connection pool in Glassfish can be found from the link below: