| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| setting JDBC type 4 driver issue |
« View previous topic :: View next topic » |
| Author |
Message
|
| Raj2000 |
 Posted: Tue Sep 29, 2009 5:53 pm Post subject: setting JDBC type 4 driver issue |
 |
|
Apprentice
Joined: 03 Aug 2009
Posts: 47
|
I am trying to access the database at remote location for that i am trying to set the JDBC type 4 driver and i am following the instructions provided in the below doc:
http://publib.boulder.ibm.com/infocenter/wmbhelp/v6r1m0/index.jsp?topic=/com.ibm.etools.mft.doc/ah61310_.htm
and when i followed the instructions and executed the commands i am getting the following errror:
C:\Program Files\IBM\MQSI\6.1>mqsicreateconfigurableservice BROKER1 -c JDBCProv
iders -o DB2 -n connectionUrlFormat,databaseName,databaseType,databaseVersion,ja
rsURL,portNumber,serverName,type4DatasourceClassName,type4DriverClassName -v 'jd
bc:db2://vrtn247:50000/dbvrt456:user=peter;password=********;','dbvrt456',
'DB2','9.1','C:\Progra~1\IBM\SQLLIB\java','50010','vrtn247','com.ibm.db2.jcc.DB
2XADataSource','com.ibm.db2.jcc.DB2Driver'
BIP2051E: Broker BROKER1 (UUID 10fe1ba1-2301-0000-0080-a9549f393e2a) could not p
rocess an internal configuration message to completion, the problem was caused b
y 'Create : connectionUrlFormat : '.
The configuration message could not be processed and was rejected.
Use the inserts within this message to determine the cause of the problem. Corr
ect the broker's configuration and redeploy using the Message Brokers Toolkit, m
qsideploy command or Config Manager Proxy application. Contact your IBM support
center if you are unable to resolve the problem.
BIP2087E: Broker BROKER1 was unable to process the internal configuration messag
e.
The entire internal configuration message failed to be processed successfully.
Use the messages following this message to determine the reasons for the failure
. If the problem cannot be resolved after reviewing these messages, contact your
IBM Support center. Enabling service trace may help determine the cause of the
failure.
BIP8036E: Negative response received.
This command sends an internal configuration message to the broker, the response
received indicated that the internal configuration message was unsuccessful.
Check that the WebSphere MQ transport is available. Check the system log for fur
ther information.
any suggestion??  |
|
| Back to top |
|
 |
| WMBDEV1 |
| Posted: Wed Sep 30, 2009 12:12 am Post subject: |
|
|
Sentinel
Joined: 05 Mar 2009
Posts: 888
Location: UK
|
|
| Back to top |
|
|
| mqjeff |
| Posted: Wed Sep 30, 2009 2:43 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
DO NOT CHANGE THE CONNECTION URL FORMAT PATTERN.
Leave it AS IS and AS SPECIFIED in the manual.
It is the job of BROKER to do replacement on [user], [server] and etc, NOT YOU.
It REQUIRES the text "[user]" so that it knows where to insert the value that you have specied for the User on the OTHER parameter of the configurable service, and likewise with everything else.
DO NOT CHANGE connectionURLFormat
WMBDEV1's lovely suggestion about double-quotes also applies.
Quoting again from the manual:
| Quote: |
A pattern that represents the connection URL definition, which is specific to a particular database type. For example, the pattern for DB2® is defined with the following fixed content:
jdbc:db2://[serverName]:[portNumber]/[databaseName]:user=[user];password=[password];
Do not use the mqsichangeproperties command to change the pattern itself; changes made to the pattern might cause unpredictable results. |
My emphasis added. |
|
| Back to top |
|
|
| Raj2000 |
| Posted: Wed Sep 30, 2009 10:45 pm Post subject: |
|
|
Apprentice
Joined: 03 Aug 2009
Posts: 47
|
Hello guys thank you for the valuable input the issue is resolved!!!
cheers!! |
|
| 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
|
|
|
|
, enclose the entire string in quotation marks, as shown in the following example:"