Trying to connect Jboss to sybase with JConnect 5.2 drivers
bchand Jan 23, 2002 12:20 PMAll,
I tried to configure JBoss 3.0 alpha (RabbitHole) to open a connection pool to our Sybase server.
Here is the errors I get from the server.log file
[2002-01-23 11:11:57,718,AutoDeployer,INFO] Auto deploy of file:/C:/cygwin/home/Gtsofladm/buildenv/jboss-3.0.0alpha/deploy/sybase-default-service.xml
[2002-01-23 11:11:57,718,ServiceDeployer,DEBUG] deploying document file:/C:/cygwin/home/Gtsofladm/buildenv/jboss-3.0.0alpha/deploy/sybase-default-service.xml
[2002-01-23 11:11:57,734,ServiceDeployer,DEBUG] jars from deployment: []
[2002-01-23 11:11:57,734,ServiceDeployer,DEBUG] xml's from deployment: [file:/C:/cygwin/home/Gtsofladm/buildenv/jboss-3.0.0alpha/tmp/deploy/ServiceDeployer/deploy.54/sybase-default-service.xml]
[2002-01-23 11:11:57,734,ServiceDeployer,DEBUG] found classpath
[2002-01-23 11:11:57,734,ServiceDeployer,DEBUG] setting up classpath
[2002-01-23 11:11:57,734,ServiceDeployer,DEBUG] codebase is
[2002-01-23 11:11:57,734,ServiceDeployer,DEBUG] archives are jconn2.jar
[2002-01-23 11:11:57,734,ServiceDeployer,DEBUG] deploying document file:/C:/cygwin/home/Gtsofladm/buildenv/jboss-3.0.0alpha//lib/ext/jconn2.jar
[2002-01-23 11:11:57,781,ServiceDeployer,DEBUG] jars from deployment: [file:/C:/cygwin/home/Gtsofladm/buildenv/jboss-3.0.0alpha/tmp/deploy/ServiceDeployer/deploy.55/jconn2.jar]
[2002-01-23 11:11:57,781,ServiceDeployer,DEBUG] xml's from deployment: []
[2002-01-23 11:11:57,781,Default,INFO] Libraries adding URLClassLoader 831397760 key URL file:/C:/cygwin/home/Gtsofladm/buildenv/jboss-3.0.0alpha//lib/ext/jconn2.jar
[2002-01-23 11:11:57,781,ServiceDeployer,DEBUG] deployed classes for file:/C:/cygwin/home/Gtsofladm/buildenv/jboss-3.0.0alpha//lib/ext/jconn2.jar
[2002-01-23 11:11:57,781,ServiceDeployer,DEBUG] about to copy 0 local directories
[2002-01-23 11:11:57,781,ServiceDeployer,DEBUG] addMBeans: url file:/C:/cygwin/home/Gtsofladm/buildenv/jboss-3.0.0alpha/deploy/sybase-default-service.xml
[2002-01-23 11:11:57,781,ServiceDeployer,DEBUG] deploying with ServiceController mbean
ConnectionURL=jdbc:sybase:Tds:140.175.68.15:4325/oper2
DriverClass=com.sybase.jdbc2.jdbc.SybDriver
SybaseDS
java:/TransactionManager
<depends optional-attribute-name="ResourceAdapterName">jboss.jca:service=RARDeployment,name=Minerva JDBC LocalTransaction ResourceAdapter
<depends optional-attribute-name="ConnectionManagerFactoryLoaderName">jboss.jca:service=ConnectionManagerFactoryLoader,name=MinervaSharedLocalCMFactory
#
#Wed Aug 15 16:17:29 EDT 2001
BlockingTimeoutMillis=50000
IdleTimeoutMinutes=30
MaxSize=10
CleanupIntervalMinutes=10
MinSize=0
MaxIdleTimeoutPercent=1.0
org.jboss.resource.security.ManyToOnePrincipalMapping
UserName=wbteam01 Password=wbteam01*ab
[2002-01-23 11:11:57,781,AutoDeployer,DEBUG] Received notification of mbean ZClassLoaders:id=-746558022's deployment.
[2002-01-23 11:11:57,781,ServiceCreator,INFO] About to create the beanjboss.jca:service=ConnectionFactoryLoader,name=SybaseDS
[2002-01-23 11:11:57,781,AutoDeployer,DEBUG] Received notification of mbean jboss.jca:service=ConnectionFactoryLoader,name=SybaseDS's deployment.
[2002-01-23 11:11:57,781,ServiceCreator,INFO] Created the beanjboss.jca:service=ConnectionFactoryLoader,name=SybaseDS
[2002-01-23 11:11:57,812,Configurator,DEBUG] ManagedConnectionFactoryProperties set to ConnectionURL=jdbc:sybase:Tds:ip.addr.x.x:4325/oper2
DriverClass=com.sybase.jdbc2.jdbc.SybDriver in jboss.jca:service=ConnectionFactoryLoader,name=SybaseDS
[2002-01-23 11:11:57,843,Configurator,DEBUG] JndiName set to SybaseDS in jboss.jca:service=ConnectionFactoryLoader,name=SybaseDS
[2002-01-23 11:11:57,859,Configurator,DEBUG] TransactionManagerName set to java:/TransactionManager in jboss.jca:service=ConnectionFactoryLoader,name=SybaseDS
[2002-01-23 11:11:57,890,Configurator,DEBUG] ConnectionManagerProperties set to #
#Wed Aug 15 16:17:29 EDT 2001
BlockingTimeoutMillis=50000
IdleTimeoutMinutes=30
MaxSize=10
CleanupIntervalMinutes=10
MinSize=0
MaxIdleTimeoutPercent=1.0 in jboss.jca:service=ConnectionFactoryLoader,name=SybaseDS
[2002-01-23 11:11:57,906,Configurator,DEBUG] PrincipalMappingClass set to org.jboss.resource.security.ManyToOnePrincipalMapping in jboss.jca:service=ConnectionFactoryLoader,name=SybaseDS
[2002-01-23 11:11:57,937,Configurator,DEBUG] PrincipalMappingProperties set to UserName= Password=********* in jboss.jca:service=ConnectionFactoryLoader,name=SybaseDS
[2002-01-23 11:11:57,937,Configurator,DEBUG] found 0 mbean-ref elements
[2002-01-23 11:11:57,937,ConnectionFactoryLoader,INFO] Starting
[2002-01-23 11:11:57,937,SybaseDS,ERROR] Stopped
javax.management.RuntimeOperationsException: Object name cannot be null
at com.sun.management.jmx.MBeanServerImpl.isRegistered(MBeanServerImpl.java:1096)
at org.jboss.resource.ConnectionFactoryLoader.startService(ConnectionFactoryLoader.java:402)
at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:117)
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.system.ServiceController$ServiceProxy.invoke(ServiceController.java:775)
at $Proxy0.start(Unknown Source)
at org.jboss.system.ServiceController.start(ServiceController.java:479)
at org.jboss.system.ServiceController.registerAndStartService(ServiceController.java:273)
at org.jboss.system.ServiceController.deploy(ServiceController.java:257)
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.deployment.ServiceDeployer.invoke(ServiceDeployer.java:732)
at org.jboss.deployment.ServiceDeployer.addMBeans(ServiceDeployer.java:668)
at org.jboss.deployment.ServiceDeployer.deploy(ServiceDeployer.java:215)
at org.jboss.deployment.DeployerMBeanSupport.deploy(DeployerMBeanSupport.java:107)
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.deployment.AutoDeployer.deploy(AutoDeployer.java:654)
at org.jboss.deployment.AutoDeployer.run(AutoDeployer.java:327)
at org.jboss.deployment.AutoDeployer.startService(AutoDeployer.java:509)
at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:117)
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.system.ServiceController$ServiceProxy.invoke(ServiceController.java:775)
at $Proxy0.start(Unknown Source)
at org.jboss.system.ServiceController.start(ServiceController.java:479)
at org.jboss.system.ServiceController.registerAndStartService(ServiceController.java:273)
at org.jboss.system.ServiceController.deploy(ServiceController.java:257)
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.deployment.ServiceDeployer.invoke(ServiceDeployer.java:732)
at org.jboss.deployment.ServiceDeployer.addMBeans(ServiceDeployer.java:668)
at org.jboss.deployment.ServiceDeployer.deploy(ServiceDeployer.java:215)
at org.jboss.deployment.DeployerMBeanSupport.deploy(DeployerMBeanSupport.java:107)
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:199)
at org.jboss.Main$1.run(Main.java:411)
at java.security.AccessController.doPrivileged(Native Method)
at org.jboss.Main.main(Main.java:406)
and now here is the Sybase-service.xml file in the deploy directory
<?xml version="1.0" encoding="UTF-8"?>
ConnectionURL=jdbc:sybase:Tds:ip.addr.x.x:4325/oper2
DriverClass=com.sybase.jdbc2.jdbc.SybDriver
SybaseDS
java:/TransactionManager
<depends optional-attribute-name="ResourceAdapterName">jboss.jca:service=RARDeployment,name=Minerva JDBC LocalTransaction ResourceAdapter
<depends optional-attribute-name="ConnectionManagerFactoryLoaderName">jboss.jca:service=ConnectionManagerFactoryLoader,name=MinervaSharedLocalCMFactory
#
#Wed Aug 15 16:17:29 EDT 2001
BlockingTimeoutMillis=50000
IdleTimeoutMinutes=30
MaxSize=10
CleanupIntervalMinutes=10
MinSize=0
MaxIdleTimeoutPercent=1.0
org.jboss.resource.security.ManyToOnePrincipalMapping
UserName= Password=******
HELELLLLP! :)
Thanks
Brian