Cannot configure Crystal Reports 2008 to work with JBoss 4.0
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.