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

Last updated on JULY 24, 2023

Applies to:

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.