// Call from
java //Success - Created Connection
//Error - SQLException: Callable statments not supported.
/* java version JDK 1.5
MYSQL version 5.0.22
*/
procedure already created inmy sql. But when i have call in java that time give me error "SQLException: Callable statments not supported."
java program
import java.sql.*;
import java.sql.CallableStatement;
import exception.Excephandling;
public class Createpro {
/**
* @param args
* @throws Exception
* @throws ClassNotFoundException
* @throws SQLException
*/
CallableStatement cs = null;
public static void main(
String[] args) throws Exception {
Createpro obj = new Createpro();
obj.get();
}
public void get() throws Excephandling {
Connection con = null;
Statement stmt = null;
CallableStatement cs = null;
String driverName = "com.mysql.jdbc.Driver";
try {
Class.forName(driverName);
} catch (ClassNotFoundException e) {
throw new Excephandling("SYS_1", "Driver class not found", e);
}
String url = "jdbc:mysql://localhost/yatra1";
String user = "root";
String pwd = "local";
try {
con = DriverManager.getConnection(url, user, pwd);
System.out.print("connection created");
stmt = con.createStatement();
stmt.execute("insert into test3 values(7,7,'2007-08-08')");
cs = con.prepareCall("{call p2()}");
} catch (SQLException e) {
System.err.println(" SQLException: " + e.getMessage());
// e.printStackTrace();
}
}
}
pls replay me what problems