How To Set No-Standards Properties for a DataSource (Doc ID 1664506.1)

Last updated on FEBRUARY 24, 2017

Applies to:

Oracle GlassFish Server - Version 2.1.1 and laterInformation in this document applies to any platform.

Goal

How to set no-standards properties for the Datasource in Glassfish 3.1.2.x?

Previously GlassFish could inject settings to JDBC Datasource that have method with setXXXX and with the input parameter with String only. However, in certain JDBC driver implementations, setting methods that takes in java.util.Properties exists but these are not configurable by GlassFish. Take for example, Oracle JDBC drivers have the setConnectionProperties(java.util.Properties) method that can be used to configure the DataSource for Fast Connection Failover (FCF), encryption and also the very import net.oracle.readTimeout properties. It is quite limiting if such settings cannot be configured (or implemented) when it is required.

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a Million Knowledge Articles and hundreds of Community platforms