Fixedstring Property Ignored When Using Class Oracle.Jdbc.Pool.Oracleconnectioncacheimpl In Oracle Application Server 10.1.2.3 (Doc ID 1329168.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Containers for J2EE - Version: 10.1.2.3.0 and later   [Release: AS10gR2 and later ]
Information in this document applies to any platform.

Symptoms

Trying to set fixedstring property for driver oracle.jdbc.pool.OracleConnectionCacheImpl in Oracle Application Server 10.1.2.3 datasource, but the property is ignored.
Patch:10222534: UNABLE TO SET FIXEDSTRING PROPERTY IN DATASOURCE is installed.

Steps to reproduce :
1. Create datasource with datasource class oracle.jdbc.pool.OracleConnectionCacheImpl and property fixedString=true,default1BatchValue=15.
2.Restart container
3. Deploy the following jsp page to the same container and test it with the datasource created in step 1:


<%@ page
import="javax.naming.Context,javax.naming.InitialContext,javax.sql.DataSource,java.sql.Connection,oracle.jdbc.pool.*,java.util.Properties,oracle.jdbc.OracleConnection" %>
<%
System.out.println (" Start test ");
try {
Context context = new InitialContext();
DataSource ds = (DataSource) context.lookup("jdbc/myDS2");
Connection conna = ds.getConnection();
OracleConnection oconn = (OracleConnection) conna ;
Properties p = oconn.getProperties() ;
System.out.println (" connection p = " + p );
conna.close();
}
catch (Throwable t) {
System.out.println (" Throwable exception " + t);
}
System.out.println (" End test ");
%>


The fixedstring property is not shown.

Cause

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