AppletTalk.com Java discussions newsgroups   Archives   FAQ   Search   Memberlist   Usergroups   Register   Profile   Log in to check your private messages   Log in  Stored procedure error ....          AppletTalk.com Forum Index -> Java and Databases View previous topic :: View next topic   Author Message Raquel Guest Posted: Wed Jun 09, 2004 6:14 am    Post subject: Stored procedure error .... Trying to use the "DB2 Development Center" on UDB V8 on my Windows XP. I am new to java stored procedures. The stored procedure code I am using is at: https://www6.software.ibm.com/dw/education/dm/db2spdc/sp.java I was able to successfully 'build' the stored procedure that I created using Development Center, however, at run time it is showing the following error: A database manager error occurred.[IBM][CLI Driver][DB2/NT] SQL4302N Java stored procedure or user-defined function "DB2ADMIN.CHECKRETAILERCREDIT", specific name "SQL040608143836354" aborted with an exception "". SQLSTATE=38501 Following is the output from db2diag.log: /Output-start/ 2004-06-09-09.48.39.030000 Instance:DB2 Node:000 PID:2512(db2fmp.exe) TID:1884 Appid:none BSU Java support sqlejCallJavaRoutine_dll Probe:315 Exception thrown during routine invocation: 0x0012F2EC : 0x00E9D060 `... 2004-06-09-09.48.39.186000 Instance:DB2 Node:000 PID:2512(db2fmp.exe) TID:1884 Appid:none BSU Java support sqlejLogException Probe:10 ADM10000W A Java exception has been caught. The Java stack traceback has been written to the db2diag.log. 2004-06-09-09.48.39.186001 Instance:DB2 Node:000 PID:2512(db2fmp.exe) TID:1884 Appid:none BSU Java support sqlejLogException Probe:10 java.lang.NullPointerException at CheckRetailerCredit.checkRetailerCredit(CheckRetailerCredit.java:42) 0x0012F13C : 0x00000000 .... 2004-06-09-09.48.39.201000 Instance:DB2 Node:000 PID:2512(db2fmp.exe) TID:1884 Appid:none routine_infrastructure sqlerJavaCallRoutine Probe:30 Error from DB2ER CallUDF. RC: 0x0012F3F8 : 0xFFFFEF32 2... /Output-end/ Guess, it can be surmised that it is a NullPointerException. Any ideas why it could be so? TIA Raquel. Back to top Raquel Guest Posted: Thu Jun 10, 2004 5:05 am    Post subject: Re: Stored procedure error .... ok Jim, I did not get the pun. Are you suggesting that "rs1 = stmt.getResultSet();" should HAVE been there in the stored procedure code or are you suggesting that it is redundant. TIA Raquel. Back to top Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year Oldest FirstNewest First         AppletTalk.com Forum Index -> Java and Databases All times are GMT Page 1 of 1   Jump to: Select a forum Java Newsgroups----------------Java DiscussionsWeb-based java games comp.lang.java 3D Graphics API's for Java Java: Support and criticism Java System Announcements comp.lang.java.api JavaBeans Java and CORBA Java and Databases comp.lang.java.developer Java GUI Toolkits Java Help comp.lang.java.javascript JVM, native methods and hardware comp.lang.java.misc Java Language Programming Security and Java comp.lang.java.setup Java Software Tools comp.lang.java.tech ibm.software.java.linux  Non-English Java Newsgroups----------------Java Language (German)Language Java (Français)Java (Italian)  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 Powered by phpBB © 2001, 2006 phpBB Group SEO toolkit © 2004-2006 webmedic.