Details
-
Suggestion
-
Resolution: Fixed
-
None
-
None
-
None
Description
In our OC4J 10.x installation instructions we tell Oracle users that they need to set the setBigStringTryClob flag, and due to OC4J brokenness, they have to use Atlassian's JDBC wrapper which recognises the setBigStringTryClob flag.
Unfortunately our workaround was written for OC4J 9.x, and doesn't work in 10.1.3.x. Our docs say:
OC4J 10.1.x no longer uses the <data-source> element, but the same property can be set with a <property name="setBigStringTryClob value="true"/>element nested within the <connection-factory> element.
But this doesn't work. Using:
<connection-pool name="JiraPool"> <connection-factory factory-class="oracle.jdbc.pool.OracleDataSource" user="jiradb" password="jiradb" url="jdbc:oracle:thin:@127.0.0.1:1521:jiradb"> <property name="setBigStringTryClob" value="true"/> <property name="loginTimeout" value="30"/> </connection-factory> </connection-pool> <managed-data-source name="JiraPool" jndi-name="jdbc/JiraDS" connection-pool-name="JiraPool"/>
results in this error in 10.1.3.2:
ERROR J2EE DS-00020 Exception setting the property 'setBigStringTryClob' on the DataSource.
Exception: java.lang.IllegalArgumentException: No such property: setBigStringTryClob, existing writable properties are: [TNSEntryName, URL, connectionCacheName, connectionCacheProperties, connectionCachingEnabled, connectionProperties, dataSourceName, databaseName, description, driverType, explicitCachingEnabled, fastConnectionFailoverEnabled, implicitCachingEnabled, logWriter, loginTimeout, maxStatements, networkProtocol, password, portNumber, serverName, serviceName, user]
2007-04-15 23:49:19.865 WARNING J2EE OJR-00107 Exception creating connection pool. Exception: oracle.oc4j.sql.DataSourceException: Exception setting the property 'setBigStringTryClob' on the DataSource. Exception: java.lang.IllegalArgument Exception: No such property: setBigStringTryClob, existing writable properties are: [TNSEntryName, URL, connectionCacheName, connectionCacheProperties, connectionCachingEnabled, connectionProperties, dataSourceName, databaseName, description, driverType, explicitCachingEnabled, fastConnectionFailoverEnabled, implicitCachingEnabled, logWriter, loginTimeout, maxStatements, networkProtocol, password,
portNumber, serverName, serviceName, user]
07/04/15 23:49:19 SEVERE: ApplicationStateRunning.initConnector Error occurred initializing connectors. Exception is: Exception creating connection pool. Exception: oracle.oc4j.sql.DataSourceException: Exception setting the property 'setBigStringTryClob' on the DataSource. Exception: java.lang.IllegalArgumentException: No such property: setBigStringTryClob, existing writable properties are: [TNSEntryName, URL, connectionCacheName, connectionCacheProperties, connectionCachingEnabled, connectionProperties, dataSourceName, databaseName, description, driverType, explicitCachingEnabled, fastConnectionFailoverEnabled, implicitCachingEnabled, logWriter, loginTimeout, maxStatements, networkProtocol, password, portNum ber, serverName, serviceName, user]
07/04/15 23:49:19 SEVERE: ApplicationStateRunning.initConnector Stack trace: oracle.oc4j.sql.DataSourceException: Exception creating connection pool. Exception: oracle.oc4j.sql.DataSourceException: Exception setting the property 'setBigStringTryClob' on the DataSource. Exception: java.lang.IllegalArgumentException: No such property: setBigStringTryClob, existing writable properties are: [TNSEntryName, URL, connectionCacheName, connectionCacheProperties, connectionCachingEnabled, connectionProperties, dataSourceName, databaseName, description, driverType, explicitCachingEnabled, fastConnectionFailoverEnabled, implicitCachingEnabled, logWriter, loginTimeout, maxStatements, networkProtocol, password, portNumber, serverName, serviceName, user]
at com.evermind.server.ApplicationStateRunning.initDataSourceConnectionPool(ApplicationStateRunning.java:2072)
at com.evermind.server.ApplicationStateRunning.initDataSourceConnector(ApplicationStateRunning.java:2017)
at com.evermind.server.ApplicationStateRunning.initConnector(ApplicationStateRunning.java:1272)
....