| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Unable to locate details for JDBCProvider registry entry |
« View previous topic :: View next topic » |
| Author |
Message
|
| shashivarungupta |
 Posted: Tue Aug 04, 2015 6:48 pm Post subject: Unable to locate details for JDBCProvider registry entry |
 |
|
Grand Master
Joined: 24 Feb 2009
Posts: 1343
Location: Floating in space on a round rock.
|
Hi,
I've a Broker on my local and from one of the broker project/Mflow, I am trying to connect to database view (on a table) using Graphical Mapper, to select the data from a view and do the mapping accordingly.
Broker v8.0.0.4
Database : Oracle v11
Platform : Windows
Connection : JDBC
I've got the configurable service created on that broker and set the securityIdentity using mqsisetdbparms command., and restarted the broker after that.
| Code: |
mqsichangeproperties MB8BROKER -c JDBCProviders -o DTDB -n connectionUrlFormat,
connectionUrlFormatAttr1,connectionUrlFormatAttr2,connectionUrlFormatAttr3,connectionUrlFormatAttr4,connectionUrlFormatAttr5,
databaseName,databaseSchemaNames,databaseType,databaseVersion,description,environmentParms,
jarsURL,jdbcProviderXASupport,maxConnectionPoolSize,portNumber,securityIdentity,serverName,type4DatasourceClassName,type4DriverClassName -v "jdbc:oracle:thin:[user]/[password]@[serverName]:[portNumber]:[connectionUrlFormatAttr1]",
"D4UCV","","","","","default_Database_Name","useProvidedSchemaNames","default_Database_Type","default_Database_Version",
"DTdatabase","default_none","D:\DBJars","true","10","1521","DTSecurityIdentity","a.b.c.d","oracle.jdbc.xa.client.OracleXADataSource","oracle.jdbc.OracleDriver"
|
(where a.b.c.d is the name of the server where that db schema is created)
| Code: |
| mqsisetdbparms MB8BROKER -n jdbc::DTSecurityIdentity -u User1 -p Password1 |
(having dummy username and password).
To refer the database/schema/view from the graphical mapper, I've created the database design project from Broker Toolkit and tried to ping the database/schema from 'Data Source Explorer' successfully. Also used the 'SQL Scrapbook' to connect to that database/schema/view from Toolkit, Successfully.
But when I deploy the Project in the 'default' EG of that Broker, I see following exception, when I execute it by providing the Input Message:
Failure happens when Broker tries to find the database/schema/view over Map:
| Quote: |
Unable to locate details for JDBCProvider registry entry: D4UCV, in JDBCDatabaseManager constructor. Which exception code 6253.
Broker 'MB8BROKER'; Execution Group 'default'; Message Flow 'V1.MF_Flow1'; Node 'V1/SF_Process.Map'; Node Type 'Mapping , D4UCV |
I've used the same userid/password to test the credentials and test connection over SQL Developer Tool, Successfully.
I've checked Broker Properties using following mqsi command and it displays the corresponding Entry there:
| Code: |
D:\apps\IBM\MQSI\8.0.0.4>mqsireportproperties MB8BROKER -o DTDB -c JDBCProviders -r
JDBCProviders
DTDB
connectionUrlFormat='jdbc:oracle:thin:[user]/[password]@[serverName]:[portNumber]:[connectionUrlFormatAttr1]'
connectionUrlFormatAttr1='D4UCV'
connectionUrlFormatAttr2=''
connectionUrlFormatAttr3=''
connectionUrlFormatAttr4=''
connectionUrlFormatAttr5=''
databaseName='default_Database_Name'
databaseSchemaNames='useProvidedSchemaNames'
databaseType='default_Database_Type'
databaseVersion='default_Database_Version'
description='DTdatabase'
environmentParms='default_none'
jarsURL='D:\DBJars'
jdbcProviderXASupport='true'
maxConnectionPoolSize='10'
portNumber='1521'
securityIdentity='DTSecurityIdentity'
serverName='a.b.c.d'
type4DatasourceClassName='oracle.jdbc.xa.client.OracleXADataSource'
type4DriverClassName='oracle.jdbc.OracleDriver'
BIP8071I: Successful command completion. |
But I'm not sure Whatelse Broker is looking for in the JDBCProvider registry. Please suggest , Any Clue?
Thank you.
_________________
*Life will beat you down, you need to decide to fight back or leave it. |
|
| Back to top |
|
 |
| shashivarungupta |
| Posted: Tue Aug 04, 2015 7:41 pm Post subject: |
|
|
Grand Master
Joined: 24 Feb 2009
Posts: 1343
Location: Floating in space on a round rock.
|
There was a similar old post
And I have found a solution (of atleast of my issue) :
The Data Design Project, Physical Model Name should be same of what we have in the Configurable Service (for JDBCProviders) at Broker. (This information I don't seem to find in the Info Center at
URL )
_________________
*Life will beat you down, you need to decide to fight back or leave it. |
|
| 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
|
|
|
|
