`<%@page import="java.sql.CallableStatement"%> <%@page language="java" import="com.DBConnection"%> <% DBConnection dbc = null; java.sql.Connection con = null; java.sql.Statement stmt = null; java.sql.ResultSet rst = null, rstInnr = null; try { dbc = new DBConnection(); con = dbc.getConnection(); stmt = con.createStatement(); CallableStatement statement = con.prepareCall("{call SP_CustomerDetails(NULL,'919673677400',NULL)}"); rst = statement.executeQuery(); if (rst.next()) { rst.beforeFirst(); %> <table border=1 align="center" cellspacing="0" cellpadding="1"> <tr> <th>Name</th> <th>Address</th> <th>TELE</th> </tr> <% while(rst.next()) { %> <tr> <td> <%=rst.getString("CustomerName")%></td> <td> <%=rst.getString("CustomerAddress")%></td> <td> <%=rst.getString("TELEPHONE1")%></td> </tr> <% } rst.close(); %> </table> <% } } catch(Exception e) { out.println("Error in RESULT : " + e.getMessage()); } %> ` above is my JSP file when I run I got ERROR : Error in RESULT: Callable statements not supported. I am using JSP front end and for Backend using MYSQL 5.6 Please Help me
prepareCall
CallableStatement statement = con.prepareCall("{call SP_CustomerDetails(?, ?, ?)}"); statement.setString(2, "919673677400"); // ...
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)