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
Application Engineer
Synergy Information Services, Inc.

 Email: [EMAIL PROTECTED]

Reply via email to