Two Laptop Bag
The moose likes JDBC and Relational Databases and the fly likes Callable statement in Servlet throws exception Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Elasticsearch in Action this week in the Big Data forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Callable statement in Servlet throws exception" Watch "Callable statement in Servlet throws exception" New topic
Author

Callable statement in Servlet throws exception

carina caoor
Ranch Hand

Joined: Jun 23, 2007
Posts: 300

Hi i am trying to call a procedure from servlet but getting sql exception, my procedure is working fine ,i am able to connect to the database but unable to make out why am i getting these exceptions
Servlet [code]

CallableStatement cstmt = d.connection.prepareCall("{call sp_rs_AreaCodeMasterDMLs(?,?,?,?,?,?,?,?,?,?,?,?,?)}");
cstmt.setLong(1,areacodeplotid);
cstmt.setString(2, areacode);
cstmt.setString(3,plotno);
cstmt.setString(4,muncipalityareacode);
cstmt.setString(5,muncipalityplotno);
cstmt.setInt(6,Integer.parseInt(insewernetworkrange));


if(phase.equalsIgnoreCase(null))
{
System.out.println("inside if"+phase);
cstmt.setInt(7,0);
}
else
{
System.out.println("inside else"+phase);
cstmt.setInt(7,Integer.parseInt(phase));


}

cstmt.setString(8,username);

cstmt.setInt(9,Integer.parseInt(comment));
cstmt.setString(10,userdefcomment);
cstmt.setString(11,dmlaction);
cstmt.setString(12,copydetail);
cstmt.setString(13,rowstatus);

System.out.println(areacodeplotid+" "+areacode+ " "+plotno+" "+muncipalityareacode+" "+muncipalityplotno+" "+insewernetworkrange+" "+comment+" "+userdefcomment+" "+dmlaction+" "+copydetail+" "+rowstatus);

cstmt.execute();

d.connection.close();



and the execption that i am getting is

java.sql.SQLException: No Action specified to be Performed on AreaCode Master!
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2816)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2254)
at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:636)
at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:584)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:546)
at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.execute(JtdsPreparedStatement.java:562)
at PlotManagement.AddNewPlot.doGet(AddNewPlot.java:91)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:874)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
at java.lang.Thread.run(Unknown Source)


Can anybody please help me out with this issue.
Jan Cumps
Bartender

Joined: Dec 20, 2006
Posts: 2531
    
  10

You have successfully called your stored procedure.
But your stored procedure has thrown an exception.
You will have to check - in the stored procedure, not in your java code - why this exception is thrown.


OCUP UML fundamental and ITIL foundation
youtube channel
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: Callable statement in Servlet throws exception