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
BedrockMission!

Learn More

View all

Sign in to view all badges

JMS error with SQL Server 2005 SP1

Avatar

Avatar
Validate 1
Level 7
kc
Level 7

Likes

0 likes

Total Posts

402 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile

Avatar
Validate 1
Level 7
kc
Level 7

Likes

0 likes

Total Posts

402 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile
kc
Level 7

23-07-2008

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

Replies

Avatar

Avatar
Level 4
Jayan_Kandathil
Level 4

Likes

0 likes

Total Posts

140 posts

Correct Reply

0 solutions
View profile

Avatar
Level 4
Jayan_Kandathil
Level 4

Likes

0 likes

Total Posts

140 posts

Correct Reply

0 solutions
View profile
Jayan_Kandathil
Level 4

23-07-2008

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

Avatar

Avatar
Validate 1
Level 7
kc
Level 7

Likes

0 likes

Total Posts

402 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile

Avatar
Validate 1
Level 7
kc
Level 7

Likes

0 likes

Total Posts

402 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile
kc
Level 7

23-07-2008

Hi again Jayan,



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



Sincerely

Kim

Avatar

Avatar
Level 5
_jerome_dinnat_
Level 5

Likes

0 likes

Total Posts

180 posts

Correct Reply

0 solutions
View profile

Avatar
Level 5
_jerome_dinnat_
Level 5

Likes

0 likes

Total Posts

180 posts

Correct Reply

0 solutions
View profile
_jerome_dinnat_
Level 5

20-08-2008

Hi,



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



Thanks 🙂

Avatar

Avatar
Level 5
_jerome_dinnat_
Level 5

Likes

0 likes

Total Posts

180 posts

Correct Reply

0 solutions
View profile

Avatar
Level 5
_jerome_dinnat_
Level 5

Likes

0 likes

Total Posts

180 posts

Correct Reply

0 solutions
View profile
_jerome_dinnat_
Level 5

21-08-2008

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

Avatar
Validate 1
Level 7
kc
Level 7

Likes

0 likes

Total Posts

402 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile

Avatar
Validate 1
Level 7
kc
Level 7

Likes

0 likes

Total Posts

402 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile
kc
Level 7

26-08-2008

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

Avatar
Level 5
_jerome_dinnat_
Level 5

Likes

0 likes

Total Posts

180 posts

Correct Reply

0 solutions
View profile

Avatar
Level 5
_jerome_dinnat_
Level 5

Likes

0 likes

Total Posts

180 posts

Correct Reply

0 solutions
View profile
_jerome_dinnat_
Level 5

26-08-2008

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

Avatar
Validate 1
Level 7
kc
Level 7

Likes

0 likes

Total Posts

402 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile

Avatar
Validate 1
Level 7
kc
Level 7

Likes

0 likes

Total Posts

402 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile
kc
Level 7

27-08-2008

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