MQSeries.net :: View topic - Broken Connection found at transaction start

Archu

I am using Microsoft SQL server

With below statement in the esql (compute node), I am gettig "Broken Connection found at transaction start " error with BIP6268

con = getJDBCType4Connection("Microsoft_SQL_ESB_DB", JDBC_TransactionType.MB_TRANSACTION_AUTO);

There is connectivity to database & below statements work fine

Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
con = DriverManager.getConnection("jdbc:sqlserver://10.226.123.42:1433;databaseName=ESB_DB", "Esb", "pwd2011");

If above statement works, why is it not working with getJDBCType4Connection??

I have set the mqsisetdbparms for security identity & below are the properties

JDBCProviders
Microsoft_SQL_ESB_DB
connectionUrlFormat='jdbc:sqlserver://[serverName]:[portNumber];DatabaseName
=[databaseName];user=[user];password=[password]'
connectionUrlFormatAttr1=''
connectionUrlFormatAttr2=''
connectionUrlFormatAttr3=''
connectionUrlFormatAttr4=''
connectionUrlFormatAttr5=''
databaseName='ESB_DB'
databaseType='Microsoft SQL Server'
databaseVersion='default_Database_Version'
description='default_Description'
environmentParms='default_none'
jarsURL='D:\sqljdbc_3.0\enu'
maxConnectionPoolSize='0'
portNumber='1433'
securityIdentity='jdbcid'
serverName='10.226.123.42'
type4DatasourceClassName='com.microsoft.sqlserver.jdbc.SQLServerXADataSource
'
type4DriverClassName='com.microsoft.sqlserver.jdbc.SQLServerDriver'

please guide me to resolve this.