Hello, are you sure that the version of your JDBC-driver and your database kernel (!!!) is >= 7.3.0.24. DBProcedures with resultsets and jdbc will only work with the newest available version. If you use the newest version (database kernel and jdbc) please send me a JDBC-trace( http://sapdb.2scale.net/moin.cgi/JdbcTrace ) and if possible a vtrace http://sapdb.2scale.net/moin.cgi/VTrace).
Regards, Marco ---------------------------------------------- Marco PASKAMP SAP DB, SAP Labs Berlin > -----Original Message----- > From: Paskamp, Marco > Sent: Dienstag, 11. Juni 2002 16:18 > To: Paskamp, Marco > Subject: FW: NullPointerException after retrieving resultset > from stored > procedure > > > > -----Original Message----- > From: Peter Vilim [mailto:[EMAIL PROTECTED]] > Sent: Dienstag, 11. Juni 2002 16:07 > To: [EMAIL PROTECTED] > Subject: NullPointerException after retrieving resultset from > stored procedure > > > Hi all, > > I'm using the latest JDBC driver for working with SAPDB. > After calling stored procedure from Java code I get > NullPointerException error. There is how my code, stored > procedure and error message look like. Do you have any ideas? > > Stored procedure: > CREATE DBPROC SP_COMPANY_EDIT (IN COMPANY_ID INT) RETURNS CURSOR AS > BEGIN > SET $CURSOR = 'MYCURSOR'; > DECLARE :$CURSOR CURSOR FOR SELECT * FROM DBA.COMPANY WHERE > COMPANY_ID = :COMPANY_ID; > END; > > Java code: > cstmt = m_conDb.prepareCall("{call SP_COMPANY_EDIT (?)}"); > cstmt.setString(1,sCompanyId); > cstmt.execute(); > rs= cstmt.getResultSet(); > rs.next(); > CompanyListBean clbObj = new CompanyListBean(); > clbObj = getListBean (rs); > > Error Code: > java.lang.NullPointerException > at > com.synfoserv.actions.CompanyAction.companyEdit(CompanyAction. > java:357) > at > com.synfoserv.actions.CompanyAction.perform(CompanyAction.java:52) > at > com.synfoserv.actions.ActionServlet.service(ActionServlet.java:77) > at > javax.servlet.http.HttpServlet.service(HttpServlet.java:853) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilt > er(ApplicationFilterChain.java:247) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(Appli > cationFilterChain.java:193) > at > org.apache.catalina.core.StandardWrapperValve.invoke(StandardW > rapperValve.java:243) > at > org.apache.catalina.core.StandardPipeline.invokeNext(StandardP > ipeline.java:566) > at > org.apache.catalina.core.StandardPipeline.invoke(StandardPipel > ine.java:472) > at > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) > at > org.apache.catalina.core.StandardContextValve.invoke(StandardC > ontextValve.java:201) > at > org.apache.catalina.core.StandardPipeline.invokeNext(StandardP > ipeline.java:566) > at > org.apache.catalina.valves.CertificatesValve.invoke(Certificat > esValve.java:246) > at > org.apache.catalina.core.StandardPipeline.invokeNext(StandardP > ipeline.java:564) > at > org.apache.catalina.core.StandardPipeline.invoke(StandardPipel > ine.java:472) > at > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) > at > org.apache.catalina.core.StandardContext.invoke(StandardContex > t.java:2344) > at > org.apache.catalina.core.StandardHostValve.invoke(StandardHost > Valve.java:164) > at > org.apache.catalina.core.StandardPipeline.invokeNext(StandardP > ipeline.java:566) > at > org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDi > spatcherValve.java:170) > at > org.apache.catalina.core.StandardPipeline.invokeNext(StandardP > ipeline.java:564) > at > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReport > Valve.java:170) > at > org.apache.catalina.core.StandardPipeline.invokeNext(StandardP > ipeline.java:564) > at > org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValv > e.java:462) > at > org.apache.catalina.core.StandardPipeline.invokeNext(StandardP > ipeline.java:564) > at > org.apache.catalina.core.StandardPipeline.invoke(StandardPipel > ine.java:472) > at > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) > at > org.apache.catalina.core.StandardEngineValve.invoke(StandardEn > gineValve.java:163) > at > org.apache.catalina.core.StandardPipeline.invokeNext(StandardP > ipeline.java:566) > at > org.apache.catalina.core.StandardPipeline.invoke(StandardPipel > ine.java:472) > at > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) > at > org.apache.catalina.connector.http.HttpProcessor.process(HttpP > rocessor.java:1011) > at > org.apache.catalina.connector.http.HttpProcessor.run(HttpProce > ssor.java:1106) > at java.lang.Thread.run(Thread.java:536) > > > Peter Vilim > Application Engineer > Synergy Information Services, Inc. > Email: [EMAIL PROTECTED] > _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
