oracle.oc4j.sql.DataSourceException

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • 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) ....
    via by Jeff Turner,
  • 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) ....
    via by Jeff Turner,
  • Failed to install Workflow
    via by Cheney Shue,
    • 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)
    No Bugmate found.