[jboss-user] [JCA/JBoss] - Re: MSSQL XA datasource throws RollbackException on cluster

2007-12-14 Thread ratrask
I tried setting CREATE_TABLES_ON_STARTUP = FALSEthat did not seem to have any impact. I was concerned about the error, because it was evident that it stopped processing the initialization at the point of the error, because there were other errors that would have been reported had it continued.

[jboss-user] [JCA/JBoss] - Re: MSSQL XA datasource throws RollbackException on cluster

2007-11-30 Thread ratrask
If I delete the table it will recreate it without an error, but the next time that it starts up it will throw the same exception again. The point of a persistant queue is tjhat the state is stored in it. :) So I guess the question now is more a matter of what is the state of the system has it

[jboss-user] [JCA/JBoss] - Re: MSSQL XA datasource throws RollbackException on cluster

2007-11-30 Thread ratrask
I realized after I submitted the post, that I did not have the portion of the server.log that overlaps the time when the exception is logged. 2007-11-30 10:35:20,138 DEBUG [org.jboss.resource.adapter.jdbc.remote.WrapperDataSourceService] Started jboss.jca:service=DataSourceBinding,name=DefaultD

[jboss-user] [JCA/JBoss] - Re: MSSQL XA datasource throws RollbackException on cluster

2007-11-30 Thread ratrask
Last things first: anonymous wrote : Do you mean to say that every time you restart the MSSQL server it listens on different ports? There should be some way to configure the fixed port , I wanted to try this but I have fedora installed on my laptop . | | Ronald , I don't believe that the MS

[jboss-user] [JCA/JBoss] - Re: MSSQL XA datasource throws RollbackException on cluster

2007-11-29 Thread ratrask
you can find out what port it is listening on by going to the Configuration manager and following the links for Protocolse for MSSQLSERVER->TCP/IP Properties and clicking on the IP Address tab. Ronald Trask XAware inc Professional Services. View the original post : http://www.jboss.com/index.

[jboss-user] [JCA/JBoss] - Re: MSSQL XA datasource throws RollbackException on cluster

2007-11-29 Thread ratrask
One thing that you have to be careful of, SQL Server will frequently change the port that it listens on to some other number (that's Microsoft for ya) if you get a connection refused on startup check and see what port it is actually listening on. This happened to me when I tried to configure it

[jboss-user] [Clustering/JBoss] - Re: For JBoss 4.2.1, will either SQL Server 2005 or MySQL 5.

2007-11-29 Thread ratrask
Well no responses, but I guess that is what is to be expected when I don't gather my thoughts properly before I post. Here is some additional information that I posted on the JCA forum. I'm not sure that that is the right place, so I'll update this topic as well. -- I am trying to get the Micr

[jboss-user] [JCA/JBoss] - MSSQL XA datasource throws RollbackException on cluster star

2007-11-29 Thread ratrask
I am trying to get the Microsoft 1.2 JDBC driver configured for xa-datasource to function as the DefaultDS for an 4.2.1.GA jboss cluster, and I have run into an issue that I hope you can help with. On the second and all subsequent attempts at starting the server I get a javax.transaction.Rollba

[jboss-user] [Clustering/JBoss] - Re: For JBoss 4.2.1, will either SQL Server 2005 or MySQL 5.

2007-11-25 Thread ratrask
I'm sorry my topic got truncated, and it is not the easiest to follow. Perhaps I can simplify and clarify. 1.) has anyone been able to get a 4.2.1 cluster to work with an XA default datasource using either SQL Server 2005, or MySQL 5.0 2.) is an XA datasource a prerequisite for a cluster View

[jboss-user] [Clustering/JBoss] - For JBoss 4.2.1, will either SQL Server 2005 or MySQL 5.0 a

2007-11-25 Thread ratrask
I'm going to post this in the JCA / Datasource forum as well, but I think it is possibly more relevant here. I hope this is OK. I have a very simple cluster with 3 nodes. 1 of the nodes only runs a JCA adapter to access a heavy weight application on that node and does no database access. so re

[jboss-user] [Clustering/JBoss] - How does the Election Policy Feature work in 4.2.X

2007-10-04 Thread ratrask
I recently had a problem with no node wanting to become the master. As I investigated the issue I found that there was a back port from 5.0 of a mechanism to control the election policy, but I have found no information about how to use this feature. Below is a snipit from an earlier post on this

[jboss-user] [JNDI/Naming/Network] - Re: HAJMS is broken under 4.2.X - no node will act as the Ma

2007-10-04 Thread ratrask
Sorry for posting this to the wrong forumn. It was an accident. Brian Stansberry has helped me resolve this issue. See http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4091790#4091790 View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4091791#4091791 Reply

[jboss-user] [Clustering/JBoss] - Re: HA-JMS

2007-10-04 Thread ratrask
Thanks Brian, I did not see your reply until today. it would have saved me sme pretty frustrating intervening days. When I try the -b option, either of them it works with no problems, if I remove the -b option the problem recurs. The problem was pretty vexing, because it occurred on two diff

[jboss-user] [JNDI/Naming/Network] - HAJMS is broken under 4.2.X - no node will act as the Master

2007-10-03 Thread ratrask
I am pretty confident that this is a bug, but it is possible that I have missed something. In brief, the the problem is that no node will act as the MasterNode if there is more than 1 node in the cluster. Here's what I have run into: After configuring the nodes to be identical as per the docume

[jboss-user] [Clustering/JBoss] - Re: HA-JMS

2007-09-28 Thread ratrask
Just to clarify here are some snipits of a log that show the problem. Install 2 virgin copies of Jboss on separate nodes. Then bring up the first node with the all configuration (run.bat ?c all). Note that is elected the Master 2007-09-24 06:48:09,718 DEBUG [org.jboss.ha.singleton.HASingletonCo

[jboss-user] [Clustering/JBoss] - Re: HA-JMS

2007-09-27 Thread ratrask
Hi Brian, I'm sleep deprived and having a very hard time so please excuse me if I sound like an idiot, but I really need some help. What you describe here does not seem to happen by default, and I can't figure out how to make it so. I have a 4.2.1 cluster, using MySQL as the DefaultDS. the c