| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| JDBC and IMS using cacjdbc21.jar |
« View previous topic :: View next topic » |
| Author |
Message
|
| nickkirk |
 Posted: Tue Feb 16, 2010 5:04 am Post subject: JDBC and IMS using cacjdbc21.jar |
 |
|
Apprentice
Joined: 26 Sep 2008
Posts: 48
|
I am trying to connect from WMB v6.1 to IMS using the cacjdbc21.jar driver (WSClassic95).
I can connect using the following java;
Class.forName("com.ibm.cac.jdbc.Driver");
Connection conn = DriverManager.getConnection("jdbc:cac:CFEDYIMS:tcp/URL/9082", "username", "password");
However, when using the broker I can not connect.
I have set the following;
mqsicreateconfigurableservice BEC_MB -c JDBCProviders -o CAC -n connectionUrlFormat -v "jdbc:cac:CFEDYIMS:tcp/URL/9082:user=username;password=password;"
and I try connecting using a Java Compute node;
Connection conn = getJDBCType4Connection("CAC",JDBC_TransactionType.MB_TRANSACTION_AUTO);
The error I get is;
"Failed to obtain JDBC Connection" 6233
Please help
 |
|
| Back to top |
|
 |
| mqjeff |
| Posted: Tue Feb 16, 2010 5:10 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
The connectionURLFormat is wrong.
It should be a *pattern* to define the tokens that get added from the rest of the JDBCProvider.
It should not be a *fully qualified and correct URL*.
Start over, with the assumption that things like "host" and "port" and "username" will be properties of the provider, and not character data in the connectionURLFormat. |
|
| Back to top |
|
|
| nickkirk |
| Posted: Tue Feb 16, 2010 5:28 am Post subject: |
|
|
Apprentice
Joined: 26 Sep 2008
Posts: 48
|
| what is the correct connectionURLFormat for IMS using the cac driver ? |
|
| Back to top |
|
|
| mqjeff |
| Posted: Tue Feb 16, 2010 5:42 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
I can only guess.
Again, your value "dbc:cac:CFEDYIMS:tcp/URL/9082:user=username;password=password;" has *hardcoded* information.
If I were to *guess*, I would try something like "jdbc:cac:[connectionUrlFormatAttr1]:tcp/[connectionUrlFormatAttr2]/[portNumber]:user=[user];password=[password]"
But you might need to use "[databaseName]" for the CFEDYIMS value instead.
I don't know IMS, so I don't really understand the meaning of your URL.
The important point is to make sure you are using the [param] tokens instead of hardcoding the values, and then filling in the matching properties of the configurable service. |
|
| Back to top |
|
|
| nickkirk |
| Posted: Tue Feb 16, 2010 6:05 am Post subject: |
|
|
Apprentice
Joined: 26 Sep 2008
Posts: 48
|
Thanks mqjeff.
The important thing now is to find the correct connectionURLFormat for IMS using the cac driver. |
|
| 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
|
|
|
|
