Problem with Update/Insert stored procedure using JCC driver

Ankukr Solanki · New User Joined: 31 Mar 2011 Posts: 3 Location: India

Hi ,

My application is a Java front End & Mainframe back end application.

We were using a type 2 driver with Db2 client version 8 to invoke the SP on mainframe.

We are now upgrading the db2 Client version to 9.5 with type 4 jcc universal driver.

All the stored procedures which are used to select data are working fine , but the SP having update/insert are giving issue.

The main issue is the SP invokes properly but after execution it fails before the control is passed back to java side.

I am not sure whether the new JCC driver handles some parameter differently from type 2 driver.

Can anyone help me out for the possible reason/solution.

Thanks ...

enrico-sorichetti · Posted: Thu Mar 31, 2011 1:21 pm

Ankukr Solanki · New User Joined: 31 Mar 2011 Posts: 3 Location: India

Thanks Enrico for the response..

I Couldn't trace the Line no. in my PGM, My SP is a plain cobol program.

enrico-sorichetti · Posted: Thu Mar 31, 2011 2:14 pm

Ankur, You seem to lack a bit of sense of humor

my suggestion was a nonsense reply to a nonsense question

You described You problem as ...
I had something working
I changed something
now it does not work any longer
help me to yak yak yak ( equivalent to blah blah blah )

You will find very little help and sympathy if You ask questions in that way
to get help You must provide facts, You just whined/vented Your disappointment

to make the most out of the questions You ask it might be helful to read and meditate on
How To Ask Questions The Smart Way
catb.org/~esr/faqs/smart-questions.html

Ankukr Solanki · New User Joined: 31 Mar 2011 Posts: 3 Location: India

All ,

The Issue was happening because the new JCC type 4 driver does not allow the type mismatch which was allowed in the previous versions.

Thanks...