1 Reply Latest reply on Mar 27, 2002 3:32 AM by bartmann_d

    Oracle configuration problem on 2.4.4.

    leetatyi

      I encountered the following problem on 2.4.4 in configurating oracle DS. I have classes12.zip in classpath already:

      [ERROR,OracleDS] Initialization failed
      javax.management.MalformedObjectNameException: ObjectName: Name cannot be null
      at javax.management.ObjectName.(ObjectName.java:90)
      at org.jboss.resource.ConnectionFactoryLoader.initService(ConnectionFact
      oryLoader.java:408)
      at org.jboss.util.ServiceMBeanSupport.init(ServiceMBeanSupport.java:77)
      at java.lang.reflect.Method.invoke(Native Method)
      at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:16
      28)
      at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:15
      23)
      at org.jboss.configuration.ConfigurationService$ServiceProxy.invoke(Conf
      igurationService.java:967)
      at $Proxy0.init(Unknown Source)
      at org.jboss.util.ServiceControl.init(ServiceControl.java:54)
      at java.lang.reflect.Method.invoke(Native Method)
      at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:16
      28)
      at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:15
      23)
      at org.jboss.Main.(Main.java:207)
      at org.jboss.Main$1.run(Main.java:110)
      at java.security.AccessController.doPrivileged(Native Method)
      at org.jboss.Main.main(Main.java:106)
      [ERROR,ConfigurationService] Unexpected error
      javax.management.MalformedObjectNameException: ObjectName: Name cannot be null
      at javax.management.ObjectName.(ObjectName.java:90)
      at org.jboss.resource.ConnectionFactoryLoader.initService(ConnectionFact
      oryLoader.java:408)
      at org.jboss.util.ServiceMBeanSupport.init(ServiceMBeanSupport.java:77)
      at java.lang.reflect.Method.invoke(Native Method)
      at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:16
      28)
      at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:15
      23)
      at org.jboss.configuration.ConfigurationService$ServiceProxy.invoke(Conf
      igurationService.java:967)
      at $Proxy0.init(Unknown Source)
      at org.jboss.util.ServiceControl.init(ServiceControl.java:54)
      at java.lang.reflect.Method.invoke(Native Method)
      at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:16
      28)
      at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:15
      23)
      at org.jboss.Main.(Main.java:207)
      at org.jboss.Main$1.run(Main.java:110)
      at java.security.AccessController.doPrivileged(Native Method)
      at org.jboss.Main.main(Main.java:106)
      [INFO,AutoDeployer] Initializing

      This is my mbean session of my jboss.jcml for oracle DS:

      OracleDS

      ConnectionURL=jdbc:oracle:thin:@su03:1521:cp2
      DriverClass=oracle.jdbc.driver.OracleDriver

      OracleDS
      OracleDS
      java:/TransactionManager
      <mbean-ref name="ResourceAdapterName">JCA:service=RARDeployment,name=Minerva JDBC LocalTransaction ResourceAdapter</mbean-ref>
      <mbean-ref name="ConnectionManagerFactoryLoaderName">JCA:service=ConnectionManagerFactoryLoader,name=MinervaSharedLocalCMFactory</mbean-ref>

      BlockingTimeoutMillis=50000
      IdleTimeoutMinutes=30
      MaxSize=10
      CleanupIntervalMinutes=10
      MinSize=0
      MaxIdleTimeoutPercent=1.0


      org.jboss.resource.security.ManyToOnePrincipalMapping

      userName=cp_adm
      password=cp_adm



      OracleDS
      org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl

      jdbc:oracle:thin:@su03:1521:cp2
      cp_adm
      cp_adm


      Please Help. Thanks alot.

        • 1. Re: Oracle configuration problem on 2.4.4.
          bartmann_d

          Your configuration looks a bit strange to me. AFAIK there is no Oracle JDBC resource adapter. You have to use the Oracle JDBC Driver:


          oracle.jdbc.OracleDriver



          OracleDS
          org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl

          jdbc:oracle:thin:@su03:1521:cp2
          cp_adm
          cp_adm


          Notes:
          - comment out your ConnectionFactoryLoader mbean
          - at least since Oracle JDBC driver version 9.0.1 (perhaps already some releases earlier) the driver class oracle.jdbc.driver.OracleDriver has been deprecated and you should use oracle.jdbc.OracleDriver instead
          - using the jboss XADataSourceImpl you wont have distributed transactions with 2pc
          - client side UserTransactions will not work properly (see http://main.jboss.org/thread.jsp?forum=46&thread=10351 )

          Hope this helps, Dieter