2 Replies Latest reply on Apr 18, 2002 5:38 AM by tosht

    CMP 2.0 Oracle JDBC Configuration

    Christoph Henrici Newbie

      It would be great, if somebody could give me some links to documentation
      and/or hints for configuring CMP 2.0 to be used with the Oracle JDBC Thin Driver.

        • 1. Re: XA or not XA data source
          tosht Newbie

          Hi David,

          I have the same problem with configuring datasource with JBoss 2.4.4_Tomcat4.0.1. I tried to do what you've suggested, set blocking=true. However, JBoss server hangs at here:
          [INFO,MSSQLPool] Starting
          [INFO,MSSQLPool] XA Connection pool MSSQLPool bound to java:/MSSQLPool

          I wonder what has gone wrong. Previously, when I have not set blocking=true, it throws me a NullPointerException and I've tried to search through the forum, have yet find any solutions. Basically I'm trying to configure MS SQL 7 datasource, which resides on another machine (Windows platform), with JBoss2.4.4_Tomcat4.0.1 under Linux platform (RedHat 7.2). I changed all the things that I've found from the forum but it still throws NullPointerException and until now it hangs there. Therefore, I'm hoping someone where I can consult with to have a look at my jboss.jcml's JDBC config portion. Please tell me where have I missed. Would really appreciate if there's anyone who can help, thank you!

          p/s: Below is previous's testing result when I have not set blocking=true

          Regards,
          Karen

          ###### JBoss output ########
          ...
          [INFO,JdbcProvider] Initializing
          [INFO,JdbcProvider] Loaded JDBC-driver:com.microsoft.jdbc.sqlserver.SQLServerDriver
          [INFO,JdbcProvider] Loaded JDBC-driver:org.postgresql.Driver
          [INFO,JdbcProvider] Initialized
          [INFO,MSSQLPool] Initializing
          [INFO,MSSQLPool] Initialized
          [INFO,PostgreSQLPool] Initializing
          [INFO,PostgreSQLPool] Initialized
          ...
          ...
          ...
          [INFO,JdbcProvider] Starting
          [INFO,JdbcProvider] Started
          [INFO,MSSQLPool] Starting
          [INFO,MSSQLPool] XA Connection pool MSSQLPool bound to java:/MSSQLPool
          [ERROR,MSSQLPool] Stopped
          java.lang.NullPointerException
          at org.jboss.pool.jdbc.xa.XAPoolDataSource.getConnection(Unknown Source)
          at org.jboss.jdbc.XADataSourceLoader.startService(XADataSourceLoader.java:412)
          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:1628)
          at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
          at org.jboss.configuration.ConfigurationService$ServiceProxy.invoke(ConfigurationService.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:1628)
          at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
          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)
          [ERROR,ConfigurationService] Unexpected error
          java.lang.NullPointerException
          at org.jboss.pool.jdbc.xa.XAPoolDataSource.getConnection(Unknown Source)
          at org.jboss.jdbc.XADataSourceLoader.startService(XADataSourceLoader.java:412)
          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:1628)
          at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
          at org.jboss.configuration.ConfigurationService$ServiceProxy.invoke(ConfigurationService.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:1628)
          at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
          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)
          [INFO,PostgreSQLPool] Starting
          [INFO,PostgreSQLPool] XA Connection pool PostgreSQLPool bound to java:/PostgreSQLPool
          [INFO,PostgreSQLPool] Started

          ####### jboss.jcml #######



          com.microsoft.jdbc.sqlserver.SQLServerDriver,
          org.postgresql.Driver




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

          jdbc:microsoft:sqlserver://PA2300:1433;DatabaseName=MASTERDB;SelectMethod=cursor
          1200000
          sa
          100
          sa
          false
          false
          true
          false
          120000
          1800000
          true
          false
          1.0
          0