0 Replies Latest reply on Aug 18, 2008 3:38 PM by Joey Chew

    Cannot configure Crystal Reports 2008 to work with JBoss 4.0

    Joey Chew Newbie

      Hi there,

      I'm new to JBoss and have been trying to configure a connection from Crystal Reports 2008 to JBoss 4.0.4 using JNDI connection with JTDS (open-source JDBC driver) to Microsoft SQL Server 2000 for the past week with no success.

      I have also tried it with Crystal Reports XI Release 2 Service Pack 2. It looks like from the log on my JBoss server it's probably just a step or two from successfully connecting.

      Platform Specifications:
      - CR2008
      - JBoss 4.0.4 GA as dated 2006-05-15
      - Microsoft SQL Server 2000
      - both CR and JBoss are installed on the same machine (Windows 2003 Server SP2)
      - JDK 1.5 update 6 (jdk-1_5_0_06-windows-i586-p.exe)


      Here's what I have done:

      On CR2008:
      - configure it in CRConfig.xml as follows (only showing the relevant parts):

      C:\Program Files\Java\jdk1.5.0_06\bin
      C:\jboss-4.0.4.GA\client\jbossall-client.jar;..(omitting unecessary clutter here)..;C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\msbase.jar;C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\mssqlserver.jar;C:\Program Files\Microsoft SQL
      Server 2000 Driver for JDBC\lib\msutil.jar;${CLASSPATH}

      100
      jdbc:jtds:sqlserver://localhost:1433/Xtreme
      net.sourceforge.jtds.jdbc.Driver
      sa
      jnp://localhost:1099
      org.jnp.interfaces.NamingContextFactory
      /
      sa ...(omitting unnecessary clutter)....




      On JBoss 4.0.4:
      - set JAVA_HOME in system environment variable as C:\Program Files\Java\jdk1.5.0_06

      - set JBOSS_HOME in system environment variable as C:\jboss-4.0.4.GA

      - set Path in system environment variable as %JAVA_HOME%\bin;%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem;C:\Program
      Files\Microsoft SQL Server\80\Tools\BINN

      - installed JTDS 1.2.2 driver to C:\Media\jtds-1.2.2-dist
      - copied JTDS (jtds-1.2.2.jar) and MS JDBC drivers (msbase.jar, msutil.jar, mssqlserver.jar) to C:\jboss-4.0.4.GA\server\default\lib

      - copied, edited mssql-ds.xml from C:\jboss-4.0.4.GA\docs\examples\jca

      - the edited mssql-ds.xml is then renamed as jtds_mssql-ds.xml
      - its relevant configurations are as follows:

      <local-tx-datasource>
      <jndi-name>MSSQLDS</jndi-name> <connection-url>jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=Xtreme</connection-url>
      <driver-class>net.sourceforge.jtds.jdbc.Driver</driver-class>
      <user-name>sa</user-name>
      sa


      - jtds_mssql-ds.xml is placed in C:\jboss-4.0.4.GA\server\default\deploy

      - started off JBoss server

      - when trying to connect from Crystal Reports 2008 using JDBC, it works

      - but when trying to connect using JNDI, it does not show a connection to connect to

      - therefore, proceeding further shows a "Failed to open the connection. Details: Invalid connection" error

      - as JBoss is booting up, shows the following error:
      11:25:50,656 ERROR [MainDeployer] Could not create deployment: file:/C:/jboss-4.
      0.4.GA/server/default/deploy/jtds_mssql-ds.xml
      org.jboss.deployment.DeploymentException: Trying to install an already registere
      d mbean: jboss.jca:service=LocalTxCM,name=MSSQLDS
      at org.jboss.system.ServiceCreator.install(ServiceCreator.java:103)
      at org.jboss.system.ServiceConfigurator.internalInstall(ServiceConfigura
      tor.java:449)
      at org.jboss.system.ServiceConfigurator.install(ServiceConfigurator.java
      :171)
      at org.jboss.system.ServiceController.install(ServiceController.java:226
      )
      at sun.reflect.GeneratedMethodAccessor54.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
      sorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:585)
      at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatch
      er.java:155)
      at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
      at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
      at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.
      java:264)
      at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
      at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
      at $Proxy4.install(Unknown Source)
      at org.jboss.deployment.SARDeployer.create(SARDeployer.java:249)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
      java:39)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
      sorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:585)
      at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatch
      er.java:155)
      at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
      at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractIntercept
      or.java:133)
      at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
      at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelM
      BeanOperationInterceptor.java:142)
      at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
      at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.
      java:264)
      at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
      at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
      at $Proxy42.create(Unknown Source)
      at org.jboss.deployment.XSLSubDeployer.create(XSLSubDeployer.java:192)
      at org.jboss.deployment.MainDeployer.create(MainDeployer.java:953)
      at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:807)
      at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:771)
      at sun.reflect.GeneratedMethodAccessor55.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
      sorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:585)
      at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatch
      er.java:155)
      at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
      at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractIntercept
      or.java:133)
      at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
      at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelM
      BeanOperationInterceptor.java:142)
      at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
      at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.
      java:264)
      at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
      at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
      at $Proxy8.deploy(Unknown Source)
      at org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymen
      tScanner.java:421)
      at org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentS
      canner.java:634)
      at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.
      doScan(AbstractDeploymentScanner.java:263)
      at org.jboss.deployment.scanner.AbstractDeploymentScanner.startService(A
      bstractDeploymentScanner.java:336)
      at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanS
      upport.java:289)
      at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMB
      eanSupport.java:245)
      at sun.reflect.GeneratedMethodAccessor2.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
      sorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:585)
      at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatch
      er.java:155)
      at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
      at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
      at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.
      java:264)
      at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
      at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceControl
      ler.java:978)
      at $Proxy0.start(Unknown Source)
      at org.jboss.system.ServiceController.start(ServiceController.java:417)
      at sun.reflect.GeneratedMethodAccessor9.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
      sorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:585)
      at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatch
      er.java:155)
      at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
      at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
      at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.
      java:264)
      at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
      at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
      at $Proxy4.start(Unknown Source)
      at org.jboss.deployment.SARDeployer.start(SARDeployer.java:302)
      at org.jboss.deployment.MainDeployer.start(MainDeployer.java:1007)
      at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:808)
      at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:771)
      at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:755)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
      java:39)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
      sorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:585)
      at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatch
      er.java:155)
      at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
      at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractIntercept
      or.java:133)
      at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
      at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelM
      BeanOperationInterceptor.java:142)
      at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
      at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.
      java:264)
      at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
      at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
      at $Proxy5.deploy(Unknown Source)
      at org.jboss.system.server.ServerImpl.doStart(ServerImpl.java:482)
      at org.jboss.system.server.ServerImpl.start(ServerImpl.java:362)
      at org.jboss.Main.boot(Main.java:200)
      at org.jboss.Main$1.run(Main.java:464)
      at java.lang.Thread.run(Thread.java:595)
      11:25:50,718 INFO [TomcatDeployer] deploy, ctxPath=/jmx-console, warUrl=.../dep
      loy/jmx-console.war/
      11:25:50,843 ERROR [URLDeploymentScanner] Incomplete Deployment listing:

      --- Incompletely deployed packages ---
      org.jboss.deployment.DeploymentInfo@31885f6c { url=file:/C:/jboss-4.0.4.GA/serve
      r/default/deploy/jtds_mssql-ds.xml }
      deployer: org.jboss.deployment.XSLSubDeployer@381a9c
      status: Deployment FAILED reason: Trying to install an already registered mbea
      n: jboss.jca:service=LocalTxCM,name=MSSQLDS
      state: FAILED
      watch: file:/C:/jboss-4.0.4.GA/server/default/deploy/jtds_mssql-ds.xml
      altDD: null
      lastDeployed: 1219083950656
      lastModified: 1219083950640
      mbeans:


      11:25:50,906 INFO [Http11BaseProtocol] Starting Coyote HTTP/1.1 on http-0.0.0.0
      -8080
      11:25:50,968 INFO [ChannelSocket] JK: ajp13 listening on /0.0.0.0:8009
      11:25:50,984 INFO [JkMain] Jk running ID=0 time=0/31 config=null
      11:25:51,000 INFO [Server] JBoss (MX MicroKernel) [4.0.4.GA (build: CVSTag=JBos
      s_4_0_4_GA date=200605151000)] Started in 8s:594ms


      I have poured through the web and gone through JBoss forums and cannot find the cause of the problem.

      I suspect that I may be missing a configuration or two and is probably easily identifiable by someone with more seasoned JBoss experience.

      If anyone can provide me with useful insights, it will be most appreciated!

      Thank you very much for reading this post.