|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
 |
|
STORED PROCEDURE CALL THROUGH A JCN |
« View previous topic :: View next topic » |
Author |
Message
|
rajeshwmb3 |
Posted: Tue Nov 20, 2012 9:30 pm Post subject: STORED PROCEDURE CALL THROUGH A JCN |
|
|
Newbie
Joined: 20 Nov 2012 Posts: 4
|
Hi All,
Im trying to call a stored procedure through a JCN, im able to connect to the DataBase but not able to retrieve the values because of the error
"Array index out of range: 373".
I get the error when i call the getAttributes() method....
Im able to retrieve the values when im executing the same java program (which im using in MB) as stand alone.There is no error persisting when i execute the program as stand alone. |
|
Back to top |
|
 |
lancelotlinc |
Posted: Wed Nov 21, 2012 5:55 am Post subject: |
|
|
 Jedi Knight
Joined: 22 Mar 2010 Posts: 4941 Location: Bloomington, IL USA
|
put all your code into a plain old Jar. Call the Jar from a JCN. If the Jar works stand-alone, it will also work when called from the JCN. _________________ http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER |
|
Back to top |
|
 |
rajeshwmb3 |
Posted: Wed Nov 21, 2012 9:21 pm Post subject: |
|
|
Newbie
Joined: 20 Nov 2012 Posts: 4
|
Thanks for the Reply,
Jar is working from stand alone. Im using the same jar in JCN.
Still the same error.
Please suggest so that i can overcome the problem.
Thanks&Regards |
|
Back to top |
|
 |
lancelotlinc |
Posted: Mon Nov 26, 2012 5:52 am Post subject: |
|
|
 Jedi Knight
Joined: 22 Mar 2010 Posts: 4941 Location: Bloomington, IL USA
|
If the jar works standalone, and your calling the same Jar function that is called by the command line when the command line calls the Jar, then you need to look at your environment settings. Turn up debug in the Jar. Does the Jar use log4j? If not, insert some Log4j statements in the code.
Can you post the Jar function's signature so we can see what arguments you are passing in from the JCN? _________________ http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER |
|
Back to top |
|
 |
|
|
 |
|
Page 1 of 1 |
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
|
|
|