i havea jsp page to registere a new user.while accepting user name & password from the jsp page.........the JDBC is throwing a below mentioned error.
Exception is ;com.mysql.jdbc.MysqlDataTruncation: Data truncation: Truncated incorrect DOUBLE value: 'rocker'
i have made some changes in query & now the same is working fine.
The changes which i have made is mentioned below.
String sql = "INSERT INTO user(user,password) VALUES ('"+username+"','"+password+"' )";
String sql1 = "insert into user_info(FNAME,MNAME,LNAME, user)values('"+firstname+"','"+middlename+"','"+lastname+"','"+username+"')";