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 4 connection with SQL Server

Post new topic  Reply to topic
 JDBC 4 connection with SQL Server « View previous topic :: View next topic » 
Author Message
new_to_wmb8
PostPosted: Fri Nov 29, 2013 2:02 am    Post subject: JDBC 4 connection with SQL Server Reply with quote

Centurion

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

Hi All,

i am getting below when i am trying to connect to SQL Server using JDBC. the JDBCProfiler is created,
Code:

JDBCProviders
  Microsoft_SQL_Server
    connectionUrlFormat='jdbc:sqlserver://[serverName]:[portNumber];DatabaseName=[databaseName];user=[user];password=[password]'
    connectionUrlFormatAttr1=''
    connectionUrlFormatAttr2=''
    connectionUrlFormatAttr3=''
    connectionUrlFormatAttr4=''
    connectionUrlFormatAttr5=''
    databaseName='ISCM'
    databaseType='Microsoft SQL Server'
    databaseVersion='9.00.5292.00'
    description='default_Description'
    environmentParms='default_none'
    jarsURL='/home/kkapoor/sqljdbc4.jar'
    jdbcProviderXASupport='false'
    maxConnectionPoolSize='0'
    portNumber='0'
    securityIdentity='mySecurityIdentity'
    serverName='XXXX\CSSDEV01'
    type4DatasourceClassName='com.microsoft.sqlserver.jdbc.SQLServerXADataSource'
    type4DriverClassName='com.microsoft.sqlserver.jdbc.SQLServerDriver'

below error i am getting,
Code:

Nov 29 04:22:18 njidlesbapp01 WebSphere Broker v8002[12659]: (MBDEV01.POT_WEB)[6]BIP6233E: An error occurred in node: Java Compute There was a problem establishing a connection to the given database URL: datasource URL = jdbc:sqlserver://XXXCSSDEV01:0/ISCM:user=XXX Exception details: No suitable driver : MBDEV01.c64d7e80-4201-0000-0080-a32734a13ae2: /build/slot1/S800_P/src/DataFlowEngine/NativeTrace/ImbNativeTrace.cpp: 739: JDBCType4Connection::createNonXAConnection: :
Quote:
Exception details: No suitable driver :

Any one plz help..i have followed all the steps as written in infocentre.
Back to top
View user's profile Send private message
new_to_wmb8
PostPosted: Fri Nov 29, 2013 2:04 am    Post subject: Reply with quote

Centurion

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

Java Code :
Code:
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
            
            
         } catch (ClassNotFoundException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
         }
         
         Connection conn = getJDBCType4Connection("Microsoft_SQL_Server",JDBC_TransactionType.MB_TRANSACTION_AUTO);
Back to top
View user's profile Send private message
Simbu
PostPosted: Fri Nov 29, 2013 3:33 am    Post subject: Reply with quote

Master

Joined: 17 Jun 2011
Posts: 289
Location: Tamil Nadu, India

jarsURL should only point to the local directory path, on the system on which the broker is running but not the jar file
Back to top
View user's profile Send private message
new_to_wmb8
PostPosted: Fri Nov 29, 2013 3:52 am    Post subject: Reply with quote

Centurion

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

now i have changed the JarsURL:
Code:
JDBCProviders
  Microsoft_SQL_Server
    connectionUrlFormat='jdbc:sqlserver://[serverName]:[portNumber];DatabaseName=[databaseName];user=[user];password=[password]'
    connectionUrlFormatAttr1=''
    connectionUrlFormatAttr2=''
    connectionUrlFormatAttr3=''
    connectionUrlFormatAttr4=''
    connectionUrlFormatAttr5=''
    databaseName='ISCM'
    databaseType='Microsoft SQL Server'
    databaseVersion='9.00.5292.00'
    description='default_Description'
    environmentParms='default_none'
    jarsURL='C:\kkapoor'
    jdbcProviderXASupport='false'
    maxConnectionPoolSize='0'
    portNumber='0'
    securityIdentity='mySecurityIdentity'
    serverName='XXXX\CSSDEV01'
    type4DatasourceClassName='com.microsoft.sqlserver.jdbc.SQLServerXADataSource'
    type4DriverClassName='com.microsoft.sqlserver.jdbc.SQLServerDriver'
Back to top
View user's profile Send private message
new_to_wmb8
PostPosted: Fri Nov 29, 2013 3:57 am    Post subject: Reply with quote

Centurion

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

right now i am using DatabaseRetrieve Node, getting below erron in Exception list :
Code:
ExceptionList
   RecoverableException
         File:CHARACTER:/build/slot1/S800_P/src/DataFlowEngine/ImbDataFlowNode.cpp
         Line:INTEGER:1154
         Function:CHARACTER:ImbDataFlowNode::createExceptionList
         Type:CHARACTER:ComIbmDatabaseRetrieveNode
         Name:CHARACTER:READ_DATA_FROM_STARS_DB_MF#FCMComposite_1_1
         Label:CHARACTER:READ_DATA_FROM_STARS_DB_MF.Database Retrieve
         Catalog:CHARACTER:BIPmsgs
         Severity:INTEGER:3
         Number:INTEGER:2230
         Text:CHARACTER:Node throwing exception
         DatabaseException
               File:CHARACTER:JDBCCommon.java
               Line:INTEGER:558
               Function:CHARACTER:JDBCConnection::createConnection
               Type:CHARACTER:
               Name:CHARACTER:
               Label:CHARACTER:
               Catalog:CHARACTER:BIPmsgs
               Severity:INTEGER:3
               Number:INTEGER:6232
               Text:CHARACTER:Problem encountered obtaining JDBC connection
               Insert
                     Type:INTEGER:5
                     Text:CHARACTER:Broker 'MBDEV01'; Execution Group 'POT_WEB'; Message Flow 'READ_DATA_FROM_STARS_DB_MF'; Node 'Database Retrieve'; Node Type 'DatabaseRetrieve
               Insert
                     Type:INTEGER:5
                     Text:CHARACTER:com.microsoft.sqlserver.jdbc.SQLServerDriver
               Insert
                     Type:INTEGER:5
                     [b]Text:CHARACTER:  error message: No suitable driver, [/b]SQLState value: 08001, stack trace: [com.ibm.broker.jdbcnodes.JDBCConnection.createConnection(JDBCConnection.java:224)
com.ibm.broker.jdbcnodes.JDBCConnection.getNodeConnection(JDBCConnection.java:137)
com.ibm.broker.jdbcnodes.DatabaseRetrieveNode.evaluate(DatabaseRetrieveNode.java:407)
com.ibm.broker.plugin.MbNode.evaluate(MbNode.java:1480)]
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 4 connection with SQL Server
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.