Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE DEFINER=`root`@`localhost` PROCEDURE `instert_student`(IN rollno int(12), IN stdname varchar(45), IN age int(2))
- BEGIN
- insert into student values(rollno,stdname,age);
- END
- package Call_Ststement;
- import java.sql.*;
- public class Callable {
- public static void main(String[] args) throws Exception{
- Class.forName("com.mysql.jdbc.Driver");
- Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/Milan","root","naruto");
- CallableStatement stmt=con.prepareCall("{insert_student(?,?,?)}");
- stmt.setInt(1,6);
- stmt.setString(2,"Milan");
- stmt.setInt(3,19);
- stmt.execute();
- System.out.println("data base updated");
- }
- }
- Exception in thread "main" com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '{insert_student(6,'kanji',19)}' at line 1
- at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
- at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
- at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
- at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
- at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
- at com.mysql.jdbc.Util.getInstance(Util.java:408)
- at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:944)
- at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973)
- at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909)
- at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2527)
- at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2680)
- at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2484)
- at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1858)
- at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1197)
- at com.mysql.jdbc.CallableStatement.execute(CallableStatement.java:837)
- at Call_Ststement.Callable.main(Callable.java:11)
Add Comment
Please, Sign In to add comment