Topic
  • 2 replies
  • Latest Post - ‏2012-11-05T10:12:06Z by Muk1234
SystemAdmin
SystemAdmin
4179 Posts

Pinned topic db2 jdbc provider connection via javaCompute node

‏2012-10-19T12:31:39Z |
Hi everybody!
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
Updated on 2012-11-05T10:12:06Z at 2012-11-05T10:12:06Z by Muk1234
  • fjb_saper
    fjb_saper
    125 Posts

    Re: db2 jdbc provider connection via javaCompute node

    ‏2012-10-25T08:23:37Z  
    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
    Muk1234
    12 Posts

    Re: db2 jdbc provider connection via javaCompute node

    ‏2012-11-05T10:12:06Z  
    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.