0 Replies Latest reply on May 7, 2002 7:39 PM by gmulchan

    Connecting to oracle database problem

    gmulchan

      Hi.
      I am trying to connect to the oracle database (8.1.7) using jboss 2.4.4. I added the following to the jboss.jcml file:

      oracle.jdbc.driver.OracleDriver



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

      jdbc:oracle:thin:@localhost:1521:ORCL
      1200000
      scott
      10
      tiger
      false
      false
      false
      true
      120000
      1800000
      false
      false
      1.0
      0


      I also added the line
      jboss.xa.xidclass=oracle.jdbc.xa.OracleXid
      to jboss.properties. This was as given in the instructions and in another post. I also removed the corresponding entries for Hypersonic? db.

      However when i start jboss I get the following exception:

      java.lang.IllegalStateException: Cannot start XA Connection Pool; there is no Tr
      ansactionManager in JNDI!
      at org.jboss.jdbc.XADataSourceLoader.startService(XADataSourceLoader.jav
      a:401)
      at org.jboss.util.ServiceMBeanSupport.start(ServiceMBeanSupport.java:103
      )
      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.start(Unknown Source)
      at org.jboss.util.ServiceControl.start(ServiceControl.java:79)
      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:208)
      at org.jboss.Main$1.run(Main.java:110)
      at java.security.AccessController.doPrivileged(Native Method)
      at org.jboss.Main.main(Main.java:106)

      Can someone point out what I need to do to make this work. Do I need to add some more config info to jboss.jcml? I have copied classes12.zip in the lib/ext/ directory.

      Thx for all your help
      Gautam