HOW-TO: CONNECTING SQL SERVER 2005 JDBC to JBOSS

re: HOW-TO: CONNECTING SQL SERVER 2005 JDBC to JBOSS

zAkMjGZExLkacJJY — Tue, 15 Sep 2009 09:50:14 GMT

doors.txt;10;15

re: HOW-TO: CONNECTING SQL SERVER 2005 JDBC to JBOSS

rtrask — Mon, 17 Dec 2007 05:08:44 GMT

Whoops, I apologize for not doing a better of looking before I lept. :)

It turns out that there is a recent thread that was started on this very topic. For the interested reader, here is the link.

http://www.jboss.com/index.html?module=bb&op=viewtopic&t=125595

re: HOW-TO: CONNECTING SQL SERVER 2005 JDBC to JBOSS

rtrask — Mon, 17 Dec 2007 04:46:15 GMT

Hi,

I'm trying to get SQL Server 2005 with the latest Microsoft JDBC driver (released October 2007) configured for XA to work with JBoss 4.2.1 transactions.

I get the feeling that I am plowing new ground, and I was wondering if any one else has had any success with even a remotely similar combination.

I have had quite a bit of success with blue sky scenarios, but I am running into issues with recovery.

This is the datasource configuration that I have been using.

<xa-datasource>

<jndi-name>DefaultDS</jndi-name>

<track-connection-by-tx/>

<isSameRM-override-value>false</isSameRM-override-value>

<xa-datasource-class>com.microsoft.sqlserver.jdbc.SQLServerXADataSource</xa-datasource-class>

<xa-datasource-property name="ServerName">localhost</xa-datasource-property>

<xa-datasource-property name="DatabaseName">jboss</xa-datasource-property>

<xa-datasource-property name="SelectMethod">cursor</xa-datasource-property>

<xa-datasource-property name="User">jboss</xa-datasource-property>

<xa-datasource-property name="Password">jboss</xa-datasource-property>

<xa-datasource-property name="URL">jdbc:sqlserver://localhost:1961</xa-datasource-property>

<new-connection-sql>select 1</new-connection-sql>

<check-valid-connection-sql>select 1</check-valid-connection-sql>

<type-mapping>MS SQLSERVER2000</type-mapping>

</metadata>

</xa-datasource>

An example of what I am running into is as follows:

following the directions in http://wiki.jboss.org/wiki/Wiki.jsp?page=JBossTSRecovery

When I run the test, the first step works perfectly. The transactions to the point where a transaction attempts to commit, and then blocks as appropriate. Then in the next step after initiating the recovery via Test -recover, it proceeds to DONE, but never recovers the transaction, and the entry remains in the Object Store.

I'm new to Port 25, and I am not sure if this is the correct place to post this or not. Please forgive me if I am out of bounds here.

Any help is greatly appreciated.

re: HOW-TO: CONNECTING SQL SERVER 2005 JDBC to JBOSS

johndpalm — Tue, 19 Sep 2006 02:54:41 GMT

Does the MS JDBC driver support SQL 2005 mirroring failover?

re: HOW-TO: CONNECTING SQL SERVER 2005 JDBC to JBOSS

hjanssen — Fri, 16 Jun 2006 00:14:39 GMT

Have you checked http://us2.php.net/mssql_connect ? If that does not have your anwser, let me know and give me the specifics on what it is you where trying to do and I can see if we can figure it out for for you at the labs here.

Hank.

re: HOW-TO: CONNECTING SQL SERVER 2005 JDBC to JBOSS

JonTheNiceGuy — Thu, 15 Jun 2006 08:29:10 GMT

Any chance of a similar howto for PHP? I've been trying on-and-off for about 4 years to do it, and never succeeded!

Thanks :)

Jon "The Nice Guy"