[TORQUE-340] Not all DBCP properties are supported for connection pools

• Type: New Feature
• Status: Closed
• Priority: Minor
• Resolution: Cannot Reproduce
• Affects Version/s: 4.0
• Component/s: Runtime
• Assignee: Unassigned
• Reporter: Rob Decker
• Created: 25/Aug/15 14:56
• Updated: 23/Apr/16 00:55
• Resolved: 23/Apr/16 00:55

Description

While the documentation for SharedPoolDataSourceFactory referes to the DBCP documentation (http://commons.apache.org/dbcp/configuration.html) for properties that can be set I tried to use connectionInitSqls (and the form connectInitSqls) and it is not supported:

Property: connectionInitSqls value: BEGIN;DBMS_SESSION.SET_NLS('NLS_COMP' is not supported by DataSource: org.apache.commons.dbcp.datasources.SharedPoolDataSource

It would be nice if it supported this as it's a simple way to get case-insensitive queries in Oracle.