Integration of MQ Server and Informix stored proce

We need some assistence from your side regarding the following issue: We encounter some problem during the integration testing for informix stored procedure with MQ server Currently we are setting up 1 connection and create 1 session only. Once it set up,all the stored procedure being called will reuse back the same connection and session. FYI, we already turn JDBC autocommit off. When we put the commit work inside the stored procedure. Example, CREATE PROCEDURE SHDACIDSCHS1_PRC(mystr varchar(20),out outstr varchar(20)); let outstr = 'result'; insert into t1 values(mystr);commit work; END PROCEDURE The first call will success. The second one will return 'cannot commit work' May I know what is the current industry practice? Is it multiple connection&session need to be set up when multiple stored procedure called? . Pls assist. Thanks.