Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Adobe Summit 2023 [19th to 23rd March, Las Vegas and Virtual] | Complete AEM Session & Lab list

JMS error with SQL Server 2005 SP1

Avatar

Level 8
Level 8
Hi all,



I have set up LC 8.0 with a SQL Server and the server seems to be running, however I get some errors in the log that I don't like. Can you help me fix this problem?



2008-07-23 12:06:49,197 INFO [org.jboss.ejb.plugins.jms.JMSContainerInvoker] Trying to reconnect to JMS provider

2008-07-23 12:06:49,213 ERROR [org.jboss.ejb.plugins.jms.JMSContainerInvoker] Reconnect failed: JMS provider failure detected:

javax.naming.NameNotFoundException: XAConnectionFactory

at org.jboss.ha.jndi.TreeHead.lookup(TreeHead.java:223)

at org.jboss.ha.jndi.HAJNDI.lookup(HAJNDI.java:134)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:585)

at org.jboss.ha.framework.interfaces.HARMIClient.invoke(HARMIClient.java:229)

at $Proxy181.lookup(Unknown Source)

at org.jnp.interfaces.NamingContext.lookup(NamingContext.java:610)

at org.jnp.interfaces.NamingContext.lookup(NamingContext.java:572)

at javax.naming.InitialContext.lookup(InitialContext.java:351)

at org.jboss.ejb.plugins.jms.DLQHandler.createService(DLQHandler.java:151)

at org.jboss.system.ServiceMBeanSupport.jbossInternalCreate(ServiceMBeanSupport.java:245)

at org.jboss.system.ServiceMBeanSupport.create(ServiceMBeanSupport.java:173)

at org.jboss.ejb.plugins.jms.JMSContainerInvoker.innerStartDelivery(JMSContainerInvoker.java:605)

at org.jboss.ejb.plugins.jms.JMSContainerInvoker$ExceptionListenerImpl.run(JMSContainerInvoker.java:1471)



Sincerely

Kim
7 Replies

Avatar

Level 4
You might be using the XA version of the Microsoft JDBC driver for SQL Server 2005.

Avatar

Level 8
Level 8
Hi again Jayan,



That might be the case, how can I check this?



Sincerely

Kim

Avatar

Level 5
Hi,



I found that in the log file. I follow the preparing to install livecycle Es guide to configure JMS with SqlServer 2005 SP1



jboss.mq:service=DestinationManager



--- MBEANS THAT ARE THE ROOT CAUSE OF THE PROBLEM ---

ObjectName: jboss.jca:service=DataSourceBinding,name=DefaultDS

State: NOTYETINSTALLED

Depends On Me:

jboss.ejb:service=EJBTimerService,persistencePolicy=database

jboss:service=juddi

jboss:service=KeyGeneratorFactory,type=HiLo

jboss.mq:service=StateManager

jboss.mq:service=PersistenceManager

Avatar

Level 8
Level 8
Hi again Jerome,



I have not yet found a solution to the problem - did you succeed following your last post?



Thanks in advance



Sincerely

Kim

Avatar

Level 5
Yes, I replaced in the file mssql-ds in JNDI name MSSQLDS by DefaultDS and jdbc.microsoft.sqlserver by jdbc.sqlserver.microsoft. LiveCycle didn't connect to sql server with the user I created so I put the authentification of the database server in mixte mode even if it is recommanded to be in windows authentification.

Avatar

Level 8
Level 8
OK - this might also do the trick for me. But how did you setup your user and password to conform to the windows authentication?



I have a domain user which has access to the db (my user is: myDomain\myUser). So I wonder how I make LC connect to the database with this user. How should the connection url and user/password look like?



Thanks in advance



Sincerely

Kim

The ultimate experience is back.

Join us in Vegas to build skills, learn from the world's top brands, and be inspired.

Register Now