| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| SQL Server (jdbcProviderXASupport) |
« View previous topic :: View next topic » |
| Author |
Message
|
| 3junior |
 Posted: Thu May 30, 2013 10:05 am Post subject: SQL Server (jdbcProviderXASupport) |
 |
|
Novice
Joined: 28 May 2013
Posts: 16
|
Hi all,
When I enable jdbcProviderXASupport for a SQL Server 2008 JDBC connection it fails with message "Login failed for user '3junior'". Does anyone know why this happens when I enable XAsupport? Is there a different JDBC string for XA supporT? Also on broker does anyone know how I can enable JDBC driver trace?
Exception details: Login failed for user '3junior'
connectionUrlFormat='jdbc:sqlserver://[serverName];instanceName=[connectionUrlFormatAttr1];databaseName=[databaseName];User=[user];Password=[password]'
connectionUrlFormatAttr1='dont'
connectionUrlFormatAttr2=''
connectionUrlFormatAttr3=''
connectionUrlFormatAttr4=''
connectionUrlFormatAttr5=''
databaseName='ls'
databaseSchemaNames='useProvidedSchemaNames'
databaseType='Microsoft SQL Server'
databaseVersion='10.5'
description='default_Description'
environmentParms='default_none'
jarsURL='/var/mqsi/drivers/'
jdbcProviderXASupport='false'
maxConnectionPoolSize='0'
portNumber='1433'
securityIdentity='dsdsdsSecurity'
serverName='red'
type4DatasourceClassName='com.microsoft.sqlserver.jdbc.SQLServerXADataSource'
type4DriverClassName='com.microsoft.sqlserver.jdbc.SQLServerDriver' |
|
| Back to top |
|
 |
| lancelotlinc |
| Posted: Thu May 30, 2013 10:25 am Post subject: |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
|
| Back to top |
|
|
| mqjeff |
| Posted: Thu May 30, 2013 10:37 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
| lancelotlinc wrote: |
http://publib.boulder.ibm.com/infocenter/wmbhelp/v8r0m0/index.jsp?topic=%2Fcom.ibm.etools.mft.doc%2Fbn58360_.htm
XA support is only available for the following:
| Quote: |
DB2®
Oracle
Sybase |
|
Except that page refers specifically to ODBC...
On distributed platforms, only DB2 and Oracle are supported.
ANd on the same page
| Quote: |
| On a single broker, you can use ODBC XA, or JDBC XA, but not both. This restriction applies to all supported platforms, and to all database servers for which XA is supported. |
|
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
