1 Reply Latest reply on Jan 11, 2005 5:30 AM by rolf huijbrechts

    Oracle10g SetBigStringTryClob Properties with JBoss 3.0.6

    keepcool Newbie

      Hi,

      I am developping an application J2EE and I would like to try to use the new property SetBigStringTryClob of the Oracle 10g to handle easily Clob datatype.
      Here the link from Oracle about the new property http://otn.oracle.com/sample_code/tech/java/codesnippet/jdbc/clob10g/handlingclobsinoraclejdbc10g.html

      My configuration is the following:
      - Oracle Database 10g(10.1.0.2.0)
      - JBoss 3.0.6
      - JDK 1.4
      - Oracle Driver 10g JDBC Driver (ojdbc.jar)

      The access to the DB is done by a Datasource, the xml file works fine(without the line in bold :( ) and looks like this :

      <?xml version="1.0" encoding="UTF-8"?>
      <server>
       <mbean code="org.jboss.resource.connectionmanager.LocalTxConnectionManager" name="jboss.jca:service=LocalTxCM,name=ORALIPS3DS">
       <depends optional-attribute-name="ManagedConnectionFactoryName">
       <!--embedded mbean-->
       <mbean code="org.jboss.resource.connectionmanager.RARDeployment" name="jboss.jca:service=LocalTxDS,name=ORALIPS3DS">
       <attribute name="JndiName">ORALIPS3DS</attribute>
       <attribute name="ManagedConnectionFactoryProperties">
       <properties>
       <config-property name="ConnectionURL" type="java.lang.String">jdbc:oracle:thin:@//localhost:1521/LIPS3</config-property>
       <config-property name="DriverClass" type="java.lang.String">oracle.jdbc.driver.OracleDriver</config-property>
       <config-property name="UserName" type="java.lang.String">toma</config-property>
       <config-property name="Password" type="java.lang.String">pretty</config-property>
       <config-property name="SetBigStringTryClob" type="java.lang.String">true</config-property>
       <config-property name="TransactionIsolation" type="java.lang.String">TRANSACTION_READ_COMMITTED</config-property>
       </properties>
       </attribute>
       <depends optional-attribute-name="OldRarDeployment">jboss.jca:service=RARDeployment,name=JBoss LocalTransaction JDBC Wrapper</depends>
       <depends>jboss:service=Hypersonic</depends>
       </mbean>
       </depends>
      
       <depends optional-attribute-name="ManagedConnectionPool">
       <mbean code="org.jboss.resource.connectionmanager.JBossManagedConnectionPool" name="jboss.jca:service=LocalTxPool,name=ORALIPS3DS">
       <attribute name="MinSize">0</attribute>
       <attribute name="MaxSize">50</attribute>
       <attribute name="BlockingTimeoutMillis">5000</attribute>
       <attribute name="IdleTimeoutMinutes">15</attribute>
       <attribute name="Criteria">ByContainer</attribute>
       </mbean>
       </depends>
       <depends optional-attribute-name="CachedConnectionManager">jboss.jca:service=CachedConnectionManager</depends>
       <depends optional-attribute-name="JaasSecurityManagerService">jboss.security:service=JaasSecurityManager</depends>
       <attribute name="TransactionManager">java:/TransactionManager</attribute>
       <depends>jboss.jca:service=RARDeployer</depends>
       </mbean>
      </server>
      


      The actual setString is limited to 32765 bytes. I have read that a new properties(10g) can be set, SetBigStringTryClob to true. I have tried to add the following line :

      <config-property name="SetBigStringTryClob" type="java.lang.String">true</config-property>

      But no way, when I had the line in bold I get the following error :

      23:13:21,742 WARN [RARDeployment] The class 'class org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory' has no setter for config property 'SetBigStringTryClob'
      23:13:21,742 ERROR [LocalTxConnectionManager] Starting failed
      java.lang.IllegalArgumentException: The class 'class org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory' has no setter for config property 'SetBigStringTryClob'
       at org.jboss.resource.connectionmanager.RARDeployment.setManagedConnectionFactoryAttribute(RARDeployment.java:666)
       at org.jboss.resource.connectionmanager.RARDeployment.setMcfProperties(RARDeployment.java:834)
       at org.jboss.resource.connectionmanager.RARDeployment.startManagedConnectionFactory(RARDeployment.java:563)
       at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
       at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
       at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
       at java.lang.reflect.Method.invoke(Method.java:324)
       at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
       at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:517)
       at org.jboss.resource.connectionmanager.BaseConnectionManager2.startService(BaseConnectionManager2.java:382)
       at org.jboss.resource.connectionmanager.LocalTxConnectionManager.startService(LocalTxConnectionManager.java:179)
       at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:165)
       at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)
       at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
       at java.lang.reflect.Method.invoke(Method.java:324)
       at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
       at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:517)
       at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:1003)
       at $Proxy4.start(Unknown Source)
       at org.jboss.system.ServiceController.start(ServiceController.java:413)
       at org.jboss.system.ServiceController.start(ServiceController.java:433)
       at org.jboss.system.ServiceController.start(ServiceController.java:433)
       at sun.reflect.GeneratedMethodAccessor3.invoke(Unknown Source)
       at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
       at java.lang.reflect.Method.invoke(Method.java:324)
       at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
       at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:517)
       at org.jboss.util.jmx.MBeanProxy.invoke(MBeanProxy.java:174)
       at $Proxy7.start(Unknown Source)
       at org.jboss.resource.RARDeployer.start(RARDeployer.java:212)
       at org.jboss.deployment.MainDeployer.start(MainDeployer.java:814)
       at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:627)
       at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:591)
       at sun.reflect.GeneratedMethodAccessor18.invoke(Unknown Source)
       at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
       at java.lang.reflect.Method.invoke(Method.java:324)
       at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
       at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:517)
       at org.jboss.util.jmx.MBeanProxy.invoke(MBeanProxy.java:174)
       at $Proxy3.deploy(Unknown Source)
       at org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentScanner.java:435)
       at org.jboss.deployment.scanner.URLDeploymentScanner.scanDirectory(URLDeploymentScanner.java:656)
       at org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScanner.java:507)
       at org.jboss.deployment.scanner.AbstractDeploymentScanner.startService(AbstractDeploymentScanner.java:261)
       at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:165)
       at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)
       at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
       at java.lang.reflect.Method.invoke(Method.java:324)
       at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
       at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:517)
       at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:1003)
       at $Proxy0.start(Unknown Source)
       at org.jboss.system.ServiceController.start(ServiceController.java:413)
       at sun.reflect.GeneratedMethodAccessor3.invoke(Unknown Source)
       at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
       at java.lang.reflect.Method.invoke(Method.java:324)
       at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
       at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:517)
       at org.jboss.util.jmx.MBeanProxy.invoke(MBeanProxy.java:174)
       at $Proxy2.start(Unknown Source)
       at org.jboss.deployment.SARDeployer.start(SARDeployer.java:230)
       at org.jboss.deployment.MainDeployer.start(MainDeployer.java:814)
       at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:627)
       at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:591)
       at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:575)
       at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
       at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
       at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
       at java.lang.reflect.Method.invoke(Method.java:324)
       at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
       at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:517)
       at org.jboss.system.server.ServerImpl.doStart(ServerImpl.java:325)
       at org.jboss.system.server.ServerImpl.start(ServerImpl.java:222)
       at org.jboss.Main.boot(Main.java:148)
       at org.jboss.Main$1.run(Main.java:381)
       at java.lang.Thread.run(Thread.java:536)
      ...
      23:14:00,528 ERROR [URLDeploymentScanner] MBeanException: Exception in MBean operation 'checkIncompleteDeployments()'
      Cause: Incomplete Deployment listing:
      Packages waiting for a deployer:
       <none>
      Incompletely deployed packages:
       <none>
      MBeans waiting for classes:
       <none>
      MBeans waiting for other MBeans:
      [ObjectName: jboss.jca:service=LocalTxCM,name=ORALIPS3DS
       state: FAILED
       I Depend On: jboss.jca:service=LocalTxDS,name=ORALIPS3DS
       jboss.jca:service=LocalTxPool,name=ORALIPS3DS
       jboss.jca:service=CachedConnectionManager
       jboss.security:service=JaasSecurityManager
       jboss.jca:service=RARDeployer
      
       Depends On Me: java.lang.IllegalArgumentException: The class 'class org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory' has no setter for config property 'SetBigStringTryClob']
      



      I can't see where the problem comes, could someone help me

      Thanks a lot
      Frane



        • 1. Re: Oracle10g SetBigStringTryClob Properties with JBoss 3.0.
          rolf huijbrechts Newbie

          KeepCool,
          did you find a solution?

          <config-property name="SetBigStringTryClob" type="java.lang.String">true</config-property>


          java.lang.IllegalArgumentException: The class 'class org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory' has no setter for config property 'SetBigStringTryClob'
          at org.jboss.resource.connectionmanager.RARDeployment.setManagedConnectionFactoryAttribute(RARDeployment.java:577)