I'm new here in the forum as well as with the message broker technology.
I've got a nooby problem trying to make a simple insert into a db2 database, in localhost, from a Java Compute node.
I'm using WMQ 8.0 and db2 10.1, I've created a configurable service for the database but when I try to getJDBCType4Connection I get a nice <com.ibm.broker.plugin.MbRecoverableException class:com.ibm.broker.jdbctype4.jdbcdbasemgr.JDBCType4Connection@75367536 method:JDBCType4Connection::createXAConnection source:BIPmsgs key:6231 > exception.
I suppose there is some wrong parameter in the configurable service, my question is, is it there a command to test it and getting some more detailed output, so that I can understand if there is a wrong parameter?
Thanks in advance
Pinned topic db2 jdbc provider connection via javaCompute node
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2012-11-05T10:12:06Z at 2012-11-05T10:12:06Z by Muk1234
fjb_saper 110000H916135 Posts
Re: db2 jdbc provider connection via javaCompute node2012-10-25T08:23:37ZThis is the accepted answer. This is the accepted answer.Can you post how you set up the configurable service?
Most errors come from the fact that the connection template is being confused with a connection string.
Muk1234 270005QJJK12 Posts
Re: db2 jdbc provider connection via javaCompute node2012-11-05T10:12:06ZThis is the accepted answer. This is the accepted answer.Open your Broker Explorer then go to Broker once you expand beneath the broker you will see execution groups and Configurable Services,
within configurable service you can see the jdbc provider, there you can change the properties ,they are similar to any db client would require to connect to db.