JMS error with SQL Server 2005 SP1

[kc]

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

[Jayan_Kandathil]

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

[kc]

Hi again Jayan,



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



Sincerely

Kim

[_jerome_dinnat_]

Hi,



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



Thanks 🙂

[_jerome_dinnat_]

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]

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_]

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]

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