MQSeries.net :: View topic

KIT_INC · Posted: Tue Oct 06, 2009 10:27 am Post subject:

I am deploying a flow with Database retrieve node on WINXP running WMB 6.1. The flow is accessing my local oracle XE database

I got the following error

BIP6253E: Error in node: Broker '61BRK'; Execution Group 'default'; Message Flow 'DB_TEST_MF'; Node 'GET_DB_SF.DatabaseRetrieve'; Node Type 'DatabaseRetrieve. Could not locate JDBC Provider entry 'XE' in the broker registry, which was given for the data source name property for this node.

I have created a JDBCProviders service called LocalXE. Here is its properties

C:\Program Files\IBM\MQSI\6.1\bin>mqsireportproperties 61BRK -c JDBCProviders -o LocalXE -r

JDBCProviders
LocalXE
connectionUrlFormat='jdbc:oracle:thin:[user]/[password]@[serverName]:[portNu
mber]:[connectionUrlFormatAttr1]'
connectionUrlFormatAttr1='XE'
connectionUrlFormatAttr2=''
connectionUrlFormatAttr3=''
connectionUrlFormatAttr4=''
connectionUrlFormatAttr5=''
databaseName='XE'
databaseType='oracle'
databaseVersion='default_Database_Version'
description='default_Description'
environmentParms='default_none'
jarsURL='C:\Progra~1\oraclexe\app\oracle\product\10.2.0\server\jdbc\lib'
portNumber='1521'
securityIdentity='default_User@default_Server'
serverName='localhost'
type4DatasourceClassName='oracle.jdbc.xa.client.OracleXADataSource'
type4DriverClassName='oracle.jdbc.OracleDriver'

BIP8071I: Successful command completion..

Is there anything else I have to do to get this to work?