ASG
IBM
Zystems
Cressida
Icon
Netflexity
 
  MQSeries.net
Search  Search       Tech Exchange      Education      Certifications      Library      Info Center      SupportPacs      LinkedIn  Search  Search                                                                   FAQ  FAQ   Usergroups  Usergroups
 
Register  ::  Log in Log in to check your private messages
 
RSS Feed - WebSphere MQ Support RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » STORED PROCEDURE CALL THROUGH A JCN

Post new topic  Reply to topic
 STORED PROCEDURE CALL THROUGH A JCN « View previous topic :: View next topic » 
Author Message
rajeshwmb3
PostPosted: Tue Nov 20, 2012 9:30 pm    Post subject: STORED PROCEDURE CALL THROUGH A JCN Reply with quote

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
View user's profile Send private message
lancelotlinc
PostPosted: Wed Nov 21, 2012 5:55 am    Post subject: Reply with quote

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
View user's profile Send private message Send e-mail
rajeshwmb3
PostPosted: Wed Nov 21, 2012 9:21 pm    Post subject: Reply with quote

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
View user's profile Send private message
lancelotlinc
PostPosted: Mon Nov 26, 2012 5:52 am    Post subject: Reply with quote

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
View user's profile Send private message Send e-mail
Display posts from previous:   
Post new topic  Reply to topic Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » STORED PROCEDURE CALL THROUGH A JCN
Jump to:  



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
Protected by Anti-Spam ACP
 
 


Theme by Dustin Baccetti
Powered by phpBB © 2001, 2002 phpBB Group

Copyright © MQSeries.net. All rights reserved.