AIX

AIX

Connect with fellow AIX users and experts to gain knowledge, share insights, and solve problems.


#Power
#Power
#Operatingsystems
#Servers
 View Only
Back to discussions
Expand all | Collapse all

Informix store procedure called from java program.

  • 1.  Informix store procedure called from java program.

    Posted 05/18/12 03:40 AM

    Originally posted by: sachin_131011


    Hello All,

    I have written a store procedure in informix with a calling function in it and the called fucntion also calls another function in it.

    When i execute above scenario from informix dbaccess it works fine , but when it is executed from java program(MQ Controller) it gives an exception as,

    User Defined Routine (called_proc) execution failed.

    Basically , IBM MQ is sending message to java program to execute the procedure with send parameters.

    Any solution on this would help.

    My informix version is : IBM Informix Dynamic Server Version : 11.10.FC2
    IBM Websphere MQ Server Version : 6.0
    JDK Version : 1.6.7

    I checked on IBM site for this exception , solution was to upgrade the informix server to higehr version 11.50.xC7.

    Please let me know if there is any alternative solution for this ?
    #AIX-Forum


Related Content