Need help with Pool configuration

[frank_y]

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)

[hraun]

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

[frank_y]

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?