| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| JDBC TYPE 4 SQL Server 2008 Connection Problem in Broker v8 |
« View previous topic :: View next topic » |
| Author |
Message
|
| new_to_wmb8 |
 Posted: Wed Jul 10, 2013 4:10 am Post subject: JDBC TYPE 4 SQL Server 2008 Connection Problem in Broker v8 |
 |
|
Centurion
Joined: 28 May 2013
Posts: 127
Location: Hyderabad, India
|
Hi All,
i have seen all the previous post related to this issue, i have followed all the steps creating the JDBC provider connection.
below is the JDBC provider property,
$ mqsireportproperties MBDEV01 -c JDBCProviders -o Microsoft_SQL_Server -r
| Code: |
JDBCProviders
Microsoft_SQL_Server
connectionUrlFormat='jdbc:sqlserver://[serverName]:[portNumber];DatabaseName=[databaseName];user=[user];password=[password]'
connectionUrlFormatAttr1=''
connectionUrlFormatAttr2=''
connectionUrlFormatAttr3=''
connectionUrlFormatAttr4=''
connectionUrlFormatAttr5=''
databaseName='PPDB'
databaseType='Microsoft SQL Server'
databaseVersion='default_Database_Version'
description='default_Description'
environmentParms='default_none'
jarsURL='XXXX'
jdbcProviderXASupport='false'
maxConnectionPoolSize='0'
portNumber=''
securityIdentity='mySecurityIdentity'
serverName='XXXXXX'
type4DatasourceClassName='com.microsoft.sqlserver.jdbc.SQLServerXADataSource'
type4DriverClassName='com.microsoft.sqlserver.jdbc.SQLServerDriver’
|
Exception list Error below:
| Code: |
ExceptionList
RecoverableException
File:CHARACTER:/build/slot1/S800_P/src/DataFlowEngine/ImbDataFlowNode.cpp
Line:INTEGER:1154
Function:CHARACTER:ImbDataFlowNode::createExceptionList
Type:CHARACTER:ComIbmMQInputNode
Name:CHARACTER:SAP_2_PPDB_VENDOR_MF#FCMComposite_1_1
Label:CHARACTER:SAP_2_PPDB_VENDOR_MF.MQ Input
Catalog:CHARACTER:BIPmsgs
Severity:INTEGER:3
Number:INTEGER:2230
Text:CHARACTER:Node throwing exception
RecoverableException
File:CHARACTER:/build/slot1/S800_P/src/DataFlowEngine/PluginInterface/ImbJniNode.cpp
Line:INTEGER:1267
Function:CHARACTER:ImbJniNode::evaluate
Type:CHARACTER:ComIbmMSLMappingNode
Name:CHARACTER:SAP_2_PPDB_VENDOR_MF#FCMComposite_1_3
Label:CHARACTER:SAP_2_PPDB_VENDOR_MF.Mapping
Catalog:CHARACTER:BIPmsgs
Severity:INTEGER:3
Number:INTEGER:2230
Text:CHARACTER:Caught exception and rethrowing
RecoverableException
File:CHARACTER:MbErrorHandler.java
Line:INTEGER:154
Function:CHARACTER:evaluate
Type:CHARACTER:
Name:CHARACTER:
Label:CHARACTER:
Catalog:CHARACTER:BIPmsgs
Severity:INTEGER:3
Number:INTEGER:3947
Text:CHARACTER:Caught BrokerXCIDynamicException
Insert
Type:INTEGER:5
Text:CHARACTER:{default}:SAP_2_PPDB_VENDOR_Mapping
Insert
Type:INTEGER:5
Text:CHARACTER:Static namespace declarations: let $dbinsert1 := jdbc:insert('PPDB', 'insert into dbo.Vendor Table ', $dbinsert1_var_params, xs:int('0'),false(),'', xs:int('2') )
RecoverableException
File:CHARACTER:MbErrorHandler.java
Line:INTEGER:281
Function:CHARACTER:throwableToMbException
Type:CHARACTER:
Name:CHARACTER:
Label:CHARACTER:
Catalog:CHARACTER:BIPmsgs
Severity:INTEGER:3
Number:INTEGER:3949
Text:CHARACTER:Caught BrokerXCIDynamicException
Insert
Type:INTEGER:5
Text:CHARACTER:com.ibm.broker.xci.BrokerXCIException: <com.ibm.broker.plugin.MbRecoverableException class:com.ibm.broker.jdbctype4.jdbcdbasemgr.JDBCType4Connection@57bd57bd method:JDBCType4Connection::createXAConnection source:BIPmsgs key:6231 >
<com.ibm.broker.plugin.MbRecoverableException class:com.ibm.broker.jdbctype4.jdbcdbasemgr.JDBCType4Connection@57bd57bd method:JDBCType4Connection::createXAConnection source:BIPmsgs key:6231 >
RecoverableException
File:CHARACTER:JDBCCommon.java
Line:INTEGER:527
Function:CHARACTER:JDBCType4Connection::createXAConnection
Type:CHARACTER:
Name:CHARACTER:
Label:CHARACTER:
Catalog:CHARACTER:BIPmsgs
Severity:INTEGER:3
Number:INTEGER:6231
Text:CHARACTER:Problem encountered obtaining JDBC connection
Insert
Type:INTEGER:5
Text:CHARACTER:Broker 'MBDEV01'; Execution Group 'SAP_GENERIC'; Message Flow 'SAP_2_PPDB_VENDOR_MF'; Node 'Mapping'; Node Type 'Mapping
Insert
Type:INTEGER:5
Text:CHARACTER: message: com.microsoft.sqlserver.jdbc.SQLServerXADataSource stack trace: [java.net.URLClassLoader.findClass(URLClassLoader.java:434)
com.ibm.broker.classloading.JavaResourceClassLoader.findClass(JavaResourceClassLoader.java:155)
com.ibm.broker.classloading.SharedClassLoader.findClass(SharedClassLoader.java:195)
java.lang.ClassLoader.loadClass(ClassLoader.java:660)
java.lang.ClassLoader.loadClass(ClassLoader.java:626)
com.ibm.broker.jdbctype4.jdbcdbasemgr.JDBCType4Connection.createXAConnection(JDBCType4Connection.java:189)
com.ibm.broker.jdbctype4.jdbcdbasemgr.JDBCType4DatabaseManager.getThreadOwnedConnections(JDBCType4DatabaseManager.java:333)
com.ibm.broker.jdbctype4.localtrxn.JDBCType4SinglePhaseTrxnHandler.getConnection(JDBCType4SinglePhaseTrxnHandler.java:268)
com.ibm.broker.jdbctype4.localtrxn.JDBCType4SinglePhaseTrxnHandler.getConnection(JDBCType4SinglePhaseTrxnHandler.java:154)
com.ibm.broker.jdbctype4.connfact.JDBCType4ConnectionFactory.getConnection(JDBCType4ConnectionFactory.java:163)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
java.lang.reflect.Method.invoke(Method.java:611)
com.ibm.broker.plugin.MbNode.getJDBCType4Connection(MbNode.java:1564)
com.ibm.broker.ct.mapping.MappingNode.getDBConnection(MappingNode.java:1208)
com.ibm.broker.ct.mapping.JDBCWrapper.prepare(JDBCWrapper.java:1972)
com.ibm.broker.ct.mapping.JDBCWrapper.insert(JDBCWrapper.java:562)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
java.lang.reflect.Method.invoke(Method.java:611)
com.ibm.xml.xci.exec.BasicMutableDynamicContext$JavaMethodExecutable.execute(BasicMutableDynamicContext.java:936)
com.ibm.xml.xci.exec.BasicDynamicContext$ExternalFunction.execute(BasicDynamicContext.java:361)
xmap2108587438_Common_Partition0.xslt2$24$contact admin(com_ibm_xmlns_prod_xltxe_j_linetable)
xmap2108587438_Common_Partition0.xmap2108587438$24$$24$function$24$__xquery_result_fun__$2d$3(com_ibm_xmlns_prod_xltxe_j_linetable:16)
xmap2108587438.evaluate(xmap2108587438.java)
com.ibm.xltxe.rnm1.xtq.xquery.drivers.XQueryExecutable.execute(XQueryExecutable.java:220)
com.ibm.xltxe.rnm1.xtq.xquery.drivers.XQueryExecutable.execute(XQueryExecutable.java:97)
com.ibm.broker.ct.mapping.MappingNode.evaluate(MappingNode.java:393)
com.ibm.broker.plugin.MbNode.evaluate(MbNode.java:1480)]
|
can any one please help in understanding what is the error causing this issue.  |
|
| Back to top |
|
 |
| new_to_wmb8 |
| Posted: Wed Jul 10, 2013 4:16 am Post subject: |
|
|
Centurion
Joined: 28 May 2013
Posts: 127
Location: Hyderabad, India
|
sorry posted on wrong forum , how can i delete this  |
|
| Back to top |
|
|
| mqjeff |
| Posted: Wed Jul 10, 2013 4:18 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
You can't delete the post, mods will be along to move it to the right forum or lock it if you've created a duplicate.
SQLServer is not supported for XA connections from JDBC. |
|
| 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
|
|
|
|
