MQSeries.net :: View topic - Connect To SQL Server 2005 thru Java Compute JDBC Type 4

lalitdowlani · Posted: Tue Feb 22, 2011 12:04 am Post subject:

I am trying to connect to SQL Server with Windows Authentication thru Java Compute using JDBC Type 4 Driver without XA.

Message Broker V 6.1
SQL Server 2005
Windows Platform

I have created a MsSql_Test

connectionUrlFormat='jdbc qlserver://172.16.10.67:1433;DatabaseName=Horizo
Test;integrationSecurity=true'
connectionUrlFormatAttr1=''
connectionUrlFormatAttr2=''
connectionUrlFormatAttr3=''
connectionUrlFormatAttr4=''
connectionUrlFormatAttr5=''
databaseName='HorizonTest'
databaseType='Microsoft SQL Server'
databaseVersion='default_Database_Version'
description='default_Description'
environmentParms='default_none'
jarsURL='E:\WebSphere\jars'
portNumber='1433'
securityIdentity='default_User@default_Server'
serverName='172.16.10.67'

type4DatasourceClassName='com.microsoft.sqlserver.jdbc.SQLServerDataSource'
type4DriverClassName='com.microsoft.sqlserver.jdbc.SQLServerDriver'

'E:\WebSphere\jars' consits of Sqljdbc.jar and sqljdbc_auth.dll (required for Windows Authentication)

Below is the Java Compute Code written to connect .

public void evaluate(MbMessageAssembly assembly) throws MbException {
MbOutputTerminal out = getOutputTerminal("out");

try
{
Connection conn = null;
/**Getting a JDBC Type 4 Connection**/
conn = getJDBCType4Connection("MsSql_Test", JDBC_TransactionType.MB_TRANSACTION_AUTO);

System.out.println("connected");

conn.close();
out.propagate(assembly);
}catch(SQLException se)
{
throw new MbUserException(se,"","","",se.toString(), null);
}

}

Below is the excrption list :-

ExceptionList
RecoverableException
File:CHARACTER:F:\build\S610_P\src\DataFlowEngine\ImbDataFlowNode.cpp
Line:INTEGER:957
Function:CHARACTER:ImbDataFlowNode::createExceptionList
Type:CHARACTER:ComIbmMQInputNode
Name:CHARACTER:Test_Jdbc_Flow#FCMComposite_1_1
Label:CHARACTER:Test_Jdbc_Flow.MQInput
Catalog:CHARACTER:BIPv610
Severity:INTEGER:3
Number:INTEGER:2230
Text:CHARACTER:Node throwing exception
RecoverableException
File:CHARACTER:F:\build\S610_P\src\DataFlowEngine\PluginInterface\ImbJniNode.cpp
Line:INTEGER:1028
Function:CHARACTER:ImbJniNode::evaluate
Type:CHARACTER:ComIbmJavaComputeNode
Name:CHARACTER:Test_Jdbc_Flow#FCMComposite_1_4
Label:CHARACTER:Test_Jdbc_Flow.JavaCompute
Catalog:CHARACTER:BIPv610
Severity:INTEGER:3
Number:INTEGER:2230
Text:CHARACTER:Caught exception and rethrowing
RecoverableException
File:CHARACTER:MbNode.java
Line:INTEGER:1569
Function:CHARACTER:getJDBCType4Connection
Type:CHARACTER:
Name:CHARACTER:
Label:CHARACTER:
Catalog:CHARACTER:BIPv610
Severity:INTEGER:3
Number:INTEGER:6233
Text:CHARACTER:Failed to obtain JDBC Connection
Insert
Type:INTEGER:5
Text:CHARACTER:JavaCompute
Insert
Type:INTEGER:5
Text:CHARACTER:MsSql_Test
Insert
Type:INTEGER:5
Text:CHARACTER:java.lang.reflect.InvocationTargetException
Insert
Type:INTEGER:5
Text:CHARACTER:No Details

Please let me know what needs to be done .