|
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.internalDoFilter(ApplicationFilterChain.java:247) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:243) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:201) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566) at org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:246) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2344) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:164) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566) at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:170) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:462) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:163) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) at org.apache.catalina.connector.http.HttpProcessor.process(HttpProcessor.java:1011) at org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor.java:1106) at java.lang.Thread.run(Thread.java:536) Peter Vilim Email: [EMAIL PROTECTED] |
- RE: NullPointerException after retrieving resultset from st... Peter Vilim
- RE: NullPointerException after retrieving resultset fr... Paskamp, Marco
- RE: NullPointerException after retrieving resultset fr... Paskamp, Marco
