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]

Atlassian JIRA | Jeff Turner | 10 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    In our [OC4J 10.x installation instructions|http://www.atlassian.com/software/jira/docs/latest/servers/oc4j101.html] 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|http://www.atlassian.com/software/jira/docs/latest/oracle10g-datasource.html#orion]. Unfortunately our workaround was written for OC4J 9.x, and doesn't work in 10.1.3.x. Our docs say: {quote}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.{quote} But this doesn't work. Using: {code:xml} <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"/> {code} 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) ....

    Atlassian JIRA | 10 years ago | Jeff Turner
    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]
  2. 0

    In our [OC4J 10.x installation instructions|http://www.atlassian.com/software/jira/docs/latest/servers/oc4j101.html] 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|http://www.atlassian.com/software/jira/docs/latest/oracle10g-datasource.html#orion]. Unfortunately our workaround was written for OC4J 9.x, and doesn't work in 10.1.3.x. Our docs say: {quote}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.{quote} But this doesn't work. Using: {code:xml} <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"/> {code} 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) ....

    Atlassian JIRA | 10 years ago | Jeff Turner
    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]

    Root Cause Analysis

    1. 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()
    2. com.evermind.server
      ApplicationStateRunning.initConnector
      1. com.evermind.server.ApplicationStateRunning.initDataSourceConnectionPool(ApplicationStateRunning.java:2072)
      2. com.evermind.server.ApplicationStateRunning.initDataSourceConnector(ApplicationStateRunning.java:2017)
      3. com.evermind.server.ApplicationStateRunning.initConnector(ApplicationStateRunning.java:1272)
      3 frames