| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| JDBC 4 connection with SQL Server |
« View previous topic :: View next topic » |
| Author |
Message
|
| new_to_wmb8 |
 Posted: Fri Nov 29, 2013 2:02 am Post subject: JDBC 4 connection with SQL Server |
 |
|
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 |
|
 |
| new_to_wmb8 |
| Posted: Fri Nov 29, 2013 2:04 am Post subject: |
|
|
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 |
|
|
| Simbu |
| Posted: Fri Nov 29, 2013 3:33 am Post subject: |
|
|
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 |
|
|
| new_to_wmb8 |
| Posted: Fri Nov 29, 2013 3:52 am Post subject: |
|
|
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 |
|
|
| new_to_wmb8 |
| Posted: Fri Nov 29, 2013 3:57 am Post subject: |
|
|
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 |
|
|
|
|
|
| |
|
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
|
|
|
|
