• 2 replies
  • Latest Post - ‏2012-11-05T10:12:06Z by Muk1234
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 < 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
    155 Posts

    Re: db2 jdbc provider connection via javaCompute node

    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
    12 Posts

    Re: db2 jdbc provider connection via javaCompute node

    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.