0 Replies Latest reply on Jan 23, 2002 12:20 PM by Brian Hand

    Trying to connect Jboss to sybase with JConnect 5.2 drivers

    Brian Hand Newbie

      All,

      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