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

JMS error with SQL Server 2005 SP1

kc
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
Jayan_Kandathil
Level 4
Level 4
You might be using the XA version of the Microsoft JDBC driver for SQL Server 2005.
kc
Level 8
Level 8
Hi again Jayan,



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



Sincerely

Kim
_jerome_dinnat_
Level 5
Level 5
Hi,



I have the same issue, did you find a solution ?



Thanks 🙂
_jerome_dinnat_
Level 5
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
kc
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
_jerome_dinnat_
Level 5
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.
kc
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