posted 10 years ago
Hi,
I was hoping someone could help me out with calling a Stored Procedure that accepts 2 timestamps as inputs and returns a refcursor as the output.
On executing this DAO using my Main class I get the following error
Executing Stored Procedure
Stored Procedure ae.nbad.apm.StoredProcedureDAO$ServiceCountStoredProcedure@2330633a
Calling execute method - internal
retrieveServiceInvocations() : Exception occurred
java.lang.NullPointerException
at org.springframework.jdbc.core.CallableStatementCreatorFactory$CallableStatementCreatorImpl.createCallableStatement(CallableStatementCreatorFactory.java:167)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:1014)
at org.springframework.jdbc.core.JdbcTemplate.call(JdbcTemplate.java:1070)
at org.springframework.jdbc.object.StoredProcedure.execute(StoredProcedure.java:144)
at ae.apm.StoredProcedureDAO$ServiceCountStoredProcedure.execute(StoredProcedureDAO.java:84)
at ae.apm.StoredProcedureDAO.retrieveServiceInvocations(StoredProcedureDAO.java:46)
at ae.apm.MainApp.main(MainApp.java:30)
The Stored Procedure I am trying to call is as follows
Additional Classes if required
Can someone help me identify where I am going wrong? Let me know if I need to provide any further information.
Thanks in advance.