ASG
IBM
Zystems
Cressida
Icon
Netflexity
 
  MQSeries.net
Search  Search       Tech Exchange      Education      Certifications      Library      Info Center      SupportPacs      LinkedIn  Search  Search                                                                   FAQ  FAQ   Usergroups  Usergroups
 
Register  ::  Log in Log in to check your private messages
 
RSS Feed - WebSphere MQ Support RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » JDBC TYPE 4 SQL Server 2008 Connection Problem in Broker v8

Post new topic  Reply to topic
 JDBC TYPE 4 SQL Server 2008 Connection Problem in Broker v8 « View previous topic :: View next topic » 
Author Message
new_to_wmb8
PostPosted: Wed Jul 10, 2013 4:10 am    Post subject: JDBC TYPE 4 SQL Server 2008 Connection Problem in Broker v8 Reply with quote

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
View user's profile Send private message
new_to_wmb8
PostPosted: Wed Jul 10, 2013 4:16 am    Post subject: Reply with quote

Centurion

Joined: 28 May 2013
Posts: 127
Location: Hyderabad, India

sorry posted on wrong forum , how can i delete this
Back to top
View user's profile Send private message
mqjeff
PostPosted: Wed Jul 10, 2013 4:18 am    Post subject: Reply with quote

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
View user's profile Send private message
Display posts from previous:   
Post new topic  Reply to topic Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » JDBC TYPE 4 SQL Server 2008 Connection Problem in Broker v8
Jump to:  



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
Protected by Anti-Spam ACP
 
 


Theme by Dustin Baccetti
Powered by phpBB © 2001, 2002 phpBB Group

Copyright © MQSeries.net. All rights reserved.