2 Replies Latest reply on Nov 22, 2001 10:21 PM by frank_y

    Need help with Pool configuration

    frank_y Newbie

      Hi all,
      I am using Jconnect5.5 (provided with Sybase) as the datasource with JBOSS.
      I am having problem with configuration. I am specifying the following as the configuration information in jboss.jcml:

      org.hsql.jdbcDriver,org.enhydra.instantdb.jdbc.idbDriver,com.sybase.jdbc2.jdbc.SybDriver



      org.opentools.minerva.jdbc.xa.wrapper.XADataSourceImpl
      SybaseDS
      jdbc:sybase:Tds:192.168.0.26:5000/ETAS
      sa



      The server generates exception given below. I guess there is a problem with the URL. Can someone help me out with the configuration.
      thanks.

      [ManageEnergy] java.lang.NullPointerException
      [ManageEnergy] at org.opentools.minerva.jdbc.xa.XAPoolDataSource.getConnection(
      XAPoolDataSource.java:178)
      [ManageEnergy] at com.interpower.etas2000.electricpowerloss.ManageEnergyBean.ge
      tTopBureauId(ManageEnergyBean.java:71)
      [ManageEnergy] at java.lang.reflect.Method.invoke(Native Method)
      [ManageEnergy] at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.
      invoke(StatelessSessionContainer.java:472)
      [ManageEnergy] at org.jboss.ejb.plugins.TxInterceptorBMT.invoke(TxInterceptorBM
      T.java:261)
      [ManageEnergy] at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.inv
      oke(StatelessSessionInstanceInterceptor.java:87)
      [ManageEnergy] at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInte
      rceptor.java:190)
      [ManageEnergy] at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.ja
      va:195)
      [ManageEnergy] at org.jboss.ejb.StatelessSessionContainer.invoke(StatelessSessi
      onContainer.java:271)
      [ManageEnergy] at org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invoke
      (JRMPContainerInvoker.java:392)
      [ManageEnergy] at java.lang.reflect.Method.invoke(Native Method)
      [ManageEnergy] at sun.rmi.server.UnicastServerRef.dispatch(Unknown Source)
      [ManageEnergy] at sun.rmi.transport.Transport$1.run(Unknown Source)
      [ManageEnergy] at java.security.AccessController.doPrivileged(Native Method)
      [ManageEnergy] at sun.rmi.transport.Transport.serviceCall(Unknown Source)
      [ManageEnergy] at sun.rmi.transport.tcp.TCPTransport.handleMessages(Unknown Sou
      rce)
      [ManageEnergy] at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(Unkn
      own Source)
      [ManageEnergy] at java.lang.Thread.run(Unknown Source)
      [ManageEnergy] java.lang.NullPointerException
      [ManageEnergy] at org.opentools.minerva.jdbc.xa.XAPoolDataSource.getConnection(
      XAPoolDataSource.java:178)
      [ManageEnergy] at com.interpower.etas2000.electricpowerloss.ManageEnergyBean.ge
      tTopBureauId(ManageEnergyBean.java:71)
      [ManageEnergy] at java.lang.reflect.Method.invoke(Native Method)
      [ManageEnergy] at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.
      invoke(StatelessSessionContainer.java:472)
      [ManageEnergy] at org.jboss.ejb.plugins.TxInterceptorBMT.invoke(TxInterceptorBM
      T.java:261)
      [ManageEnergy] at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.inv
      oke(StatelessSessionInstanceInterceptor.java:87)
      [ManageEnergy] at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInte
      rceptor.java:190)
      [ManageEnergy] at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.ja
      va:195)
      [ManageEnergy] at org.jboss.ejb.StatelessSessionContainer.invoke(StatelessSessi
      onContainer.java:271)
      [ManageEnergy] at org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invoke
      (JRMPContainerInvoker.java:392)
      [ManageEnergy] at java.lang.reflect.Method.invoke(Native Method)
      [ManageEnergy] at sun.rmi.server.UnicastServerRef.dispatch(Unknown Source)
      [ManageEnergy] at sun.rmi.transport.Transport$1.run(Unknown Source)
      [ManageEnergy] at java.security.AccessController.doPrivileged(Native Method)
      [ManageEnergy] at sun.rmi.transport.Transport.serviceCall(Unknown Source)
      [ManageEnergy] at sun.rmi.transport.tcp.TCPTransport.handleMessages(Unknown Sou
      rce)
      [ManageEnergy] at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(Unkn
      own Source)
      [ManageEnergy] at java.lang.Thread.run(Unknown Source)
      [ManageEnergy] java.lang.NullPointerException
      [ManageEnergy] at org.opentools.minerva.jdbc.xa.XAPoolDataSource.getConnection(
      XAPoolDataSource.java:178)
      [ManageEnergy] at com.interpower.etas2000.electricpowerloss.ManageEnergyBean.ge
      tPointParents(ManageEnergyBean.java:566)
      [ManageEnergy] at java.lang.reflect.Method.invoke(Native Method)
      [ManageEnergy] at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.
      invoke(StatelessSessionContainer.java:472)
      [ManageEnergy] at org.jboss.ejb.plugins.TxInterceptorBMT.invoke(TxInterceptorBM
      T.java:261)
      [ManageEnergy] at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.inv
      oke(StatelessSessionInstanceInterceptor.java:87)
      [ManageEnergy] at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInte
      rceptor.java:190)
      [ManageEnergy] at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.ja
      va:195)
      [ManageEnergy] at org.jboss.ejb.StatelessSessionContainer.invoke(StatelessSessi
      onContainer.java:271)
      [ManageEnergy] at org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invoke
      (JRMPContainerInvoker.java:392)
      [ManageEnergy] at java.lang.reflect.Method.invoke(Native Method)
      [ManageEnergy] at sun.rmi.server.UnicastServerRef.dispatch(Unknown Source)
      [ManageEnergy] at sun.rmi.transport.Transport$1.run(Unknown Source)
      [ManageEnergy] at java.security.AccessController.doPrivileged(Native Method)
      [ManageEnergy] at sun.rmi.transport.Transport.serviceCall(Unknown Source)
      [ManageEnergy] at sun.rmi.transport.tcp.TCPTransport.handleMessages(Unknown Sou
      rce)
      [ManageEnergy] at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(Unkn
      own Source)
      [ManageEnergy] at java.lang.Thread.run(Unknown Source)

        • 1. Re: Need help with Pool configuration
          Peet Denny Newbie

          That NullPointerException looks like it could be a missing driver.
          Are you getting a message like this?:
          [JdbcProvider] Loaded JDBC-driver:com.sybase.jdbc2.jdbc.SybDriver
          just after you start your server?

          If so, where have you got you driver jar? Have you tried putting it in the jboss/lib/ext dir?

          Cheers

          • 2. Re: Need help with Pool configuration
            frank_y Newbie

            1¡¢[SybaseDS] Starting
            [SybaseDS] XA Connection pool SybaseDS bound to java:/SybaseDS
            [SybaseDS] Stopped
            [SybaseDS] java.lang.NullPointerException
            [SybaseDS] at org.opentools.minerva.jdbc.xa.XAPoolDataSource.getConnection
            XAPoolDataSource.java:165)
            [SybaseDS] at org.jboss.jdbc.XADataSourceLoader.startService(XADataSourceL
            ader.java:330)
            [SybaseDS] at org.jboss.util.ServiceMBeanSupport.start(ServiceMBeanSupport
            java:93)
            [SybaseDS] at java.lang.reflect.Method.invoke(Native Method)
            [SybaseDS] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImp
            .java:1628)
            [SybaseDS] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImp
            .java:1523)
            [SybaseDS] at org.jboss.util.ServiceControl.start(ServiceControl.java:97)
            [SybaseDS] at java.lang.reflect.Method.invoke(Native Method)
            [SybaseDS] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImp
            .java:1628)
            [SybaseDS] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImp
            .java:1523)
            [SybaseDS] at org.jboss.Main.(Main.java:203)
            [SybaseDS] at org.jboss.Main$1.run(Main.java:107)
            [SybaseDS] at java.security.AccessController.doPrivileged(Native Method)
            [SybaseDS] at org.jboss.Main.main(Main.java:103)

            2¡¢I have got My driver jar in Jconnect\classes\jconn2.jar and putting it in the jboss/lib/ext dir.

            How do it?