SQLException : not all variables bound

[Bhavik Patel]

I am getting SQLException while trying to insert a record in student table

output:
SQLException caught : not all variables bound

public boolean addUser()
{
try
{
String sid="";
sid=getSid();
String sname="";
sname= getSname();
int year=0;
year = getYear();
String address = "";
address = getAddress();
String bdate = "";
bdate = getBdate();
String phone = "";
phone = getPhone();
String email = "";
email = getEmail();          
String ssn = "";
ssn=getSsn();            
double gpa = getGpa();            
String semcode = getSemcode();        
System.out.println("calling fssn");
String fssn = getFssn();           
String username = getUsername();          
String password =  getPassword();
int deptid =  getDeptid();
String insertdata = "INSERT INTO STUDENT(SID,SNAME,YEAR,ADDRESS,"+
"BDATE,PHONE,EMAIL,SSN,GPA,SEMCODE,FSSN,DEPTID,UNAME,PASSWORD) VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?,?)";
        
Connection tempCon = DBConnection.con;
PreparedStatement insertStatement = tempCon.prepareStatement(insertdata);
 insertStatement.setString(1,sid);
         insertStatement.setString(2,sname);
 insertStatement.setInt(3,year);
 insertStatement.setString(4,address);
 insertStatement.setString(5,bdate);
 insertStatement.setString(6,phone);
 insertStatement.setString(7,email);
 insertStatement.setString(8,ssn);
 insertStatement.setDouble(9,gpa);
 insertStatement.setString(10,semcode);
 insertStatement.setString(11,fssn);
  insertStatement.setInt(12,deptid);
 insertStatement.setString(13,username);
         insertStatement.setString(14,password);
 
 insertStatement.executeUpdate(insertdata);
 
          return true;
}
catch(SQLException e) 
{ 
System.out.println("SQLException caught: " + e.getMessage());
System.out.println("stack trace12");
 e.printStackTrace();
 return false;
}
catch(Exception e)
{
System.out.println("Exception Occurred");
e.printStackTrace();
return false;
}


}

ng an Exception while trying to add a record into a database

[edited to add code tags]

[ April 12, 2005: Message edited by: Jeanne Boyarsky ]
[ April 14, 2005: Message edited by: Bear Bibeault ]

[Jeanne Boyarsky]

Bhavik,
This line of code is causing the error.

insertStatement.executeUpdate(insertdata);

For a prepared statement, you need to call the executeUpdate() method without any parameters.

[Bhavik Patel]

Thanks Jeanne....Thank you for pointing out syntax error....i don'tunderstand why i was not getting any syntax error for that statement

[Shailesh Chandra]

Originally posted by bhavik patel:
i don'tunderstand why i was not getting any syntax error for that statement

You will not get a syntax error because PreparedStatement interface extends Statement interface, and Statement interface has method executeUpdate(String sql)


thanks