QuestionAsk Questions?
REKHA
MYSQL EXCEPTION -DATA TRUNCATION..pls resolve it
0 Answer(s) 6 months and 22 days ago
Posted in : SQL
0 Answer(s) 6 months and 22 days ago
Posted in : SQL
while running my program as follows Register1.html
<!DOCTYPE html> <html lang="en"><head> <meta charset="utf-8"> <title>JavaScript Form Validation using a sample registration form</title> <meta name="keywords" content="example, JavaScript Form Validation, Sample registration form" /> <meta name="description" content="This document is an example of JavaScript Form Validation using a sample registration form. " /> <link rel='stylesheet' href='style.css' type='text/css' /> <script src="Validation.js"></script> </head> <body onload="document.registration.userid.focus();"> <form name='registration' action="regdat.jsp" onSubmit="return formValidation();"> <table border="1" align="center"> <tr align="center"> <div class="ab"> <td> <a href="E:\JE project\Home Page.html">Home</a></td>     <td><a href="E:\JE project\Register.html">Register</a> </td>     <td><a href="E:\JE project\Login.html">Login</a> </td> <td><a href="E:\JE project\About Us.html">About Us</a> </td>     <td><a href="E:\JE project\Contact Us.html">Contact Us</a></td>     <td><a href="E:\JE project\College Features.html">Features</a> </td>     <td><a href="E:\JE project\Gallery.html">Gallery</a> </td> </div> </tr> <tr></tr> <tr></tr> <tr></tr> <tr></tr> <tr></tr> <tr></tr> <tr></tr> <tr></tr> <tr></tr> </table> <h1 class="s1">Registration Form</h1> <table> <tr> <td class="s2">User id:</td> <td class ="s3"><input type="text" name="userid" size="12" /> </td> </tr> <tr> <td calss="s2">Password:</td> <td class="s3"><input type="password" name="passid" /></td> </tr> </table> <hr> <table> <h4 class="s4">PERSONAL DETAILS</h4> <tr><td class="s2">Name:</td> <td class="S3"><input type="text" name="username"/></td> </tr> <tr><td class="s2">DOB:</td> <td class="s3"><select name="dob" > <option selected =" " value="date">Date</option> <option value="01">01</option> <option value="02">02</option> <option value="03">03</option> <option value="04">04</option> <option value="05">05</option> <option value="06">06</option> <option value="07">07</option> <option value="08">08</option> <option value="09">09</option> <option value="10">10</option> <option value="11">11</option> <option value="12">12</option> <option value="13">13</option> <option value="14">14</option> <option value="15">15</option> <option value="16">16</option> <option value="17">17</option> <option value="18">18</option> <option value="19">19</option> <option value="20">20</option> <option value="21">21</option> <option value="22">22</option> <option value="23">23</option> <option value="24">24</option> <option value="25">25</option> <option value="26">26</option> <option value="27">27</option> <option value="28">28</option> <option value="29">29</option> <option value="30">30</option> <option value="31">31</option> </select> <select name="dob" > <option selected="" value="month">Month</option> <option value="Janurary">Janurary</option> <option value="February">February</option> <option value="March">March</option> <option value="April">April</option> <option value="May">May</option> <option value="June">June</option> <option value="July">July</option> <option value="August">August</option> <option value="September">September</option> <option value="October">October</option> <option value="November">November</option> <option value="December">December</option> </select> <select name="dob" > <option selected="" value="year">Year</option> <option value="1985">1985</option> <option value="1986">1986</option> <option value="1987">1987</option> <option value="1988">1988</option> <option value="1989">1989</option> <option value="1990">1990</option> <option value="1991">1991</option> <option value="1992">1992</option> <option value="1993">1993</option> </select> </tr> <tr><td class="s2">Nationality:</td> <td class="s3"><select name="nationality"> <option selected="" value="Default"></option> <option value="Indian">Indian</option> <option value="Others">Others</option> </td> </tr> <tr><td class="s2">Sex:</ltd> <td class="s3"><input type="radio" name="sex" value="Male" />Male</td> <td class="S3"><input type="radio" name="sex" value="Female" />Female</td> </tr> <tr><td class="s2">Address:</td> <td class="s3"><input type="textarea" name="address" rows="4" cols="10" /></td> </tr> <tr><td class="s2">ZIP Code:</td> <td class="s3"><input type="text" name="zip"/></td> </tr> <tr><td class="s2">State</td> <td class="s3"><Select id="Stat" name="country"> <option name="select" selected="true">Select</option> <option name="Andaman & Nicobar ">Andaman & Nicobar </option> <option name="Andhra Pradesh">Andhra Pradesh </option> <option name="Arunachal Pradesh">Arunachal Pradesh </option> <option name="Assam">Assam </option> <option name="Bihar">Bihar </option> <option name="Chhattisgarh">Chhattisgarh </option> <option name="Goa">Goa </option> <option name="Gujarat">Gujarat </option> <option name="Haryana">Haryana </option> <option name="Himachal Pradesh">Himachal Pradesh </option> <option name="Jammu & Kashmir">Jammu & Kashmir </option> <option name="Jharkhand">Jharkhand </option> <option name="Karnataka">Karnataka </option> <option name="Kerala">Kerala </option> <option name="Madhya Pradesh">Madhya Pradesh </option> <option name="Maharashtra">Maharashtra </option> <option name="Manipur">Manipur </option> <option name="Meghalaya">Meghalaya </option> <option name="Mizoram">Mizoram </option> <option name="Nagaland">Nagaland </option> <option name="Orissa">Orissa </option><option name="Punjab">Punjab </option> <option name="Rajasthan">Rajasthan </option> <option name="Sikkim">Sikkim </option> <option name="Tamil Nadu">Tamil Nadu </option> <option name="Tripura">Tripura </option> <option name="Uttar Pradesh">Uttar Pradesh </option> <option name="Uttaranchal">Uttaranchal </option> <option name="West Bengal">West Bengal </option> </select> </td> </tr> <tr><td class="s2">MobileNo.</td> <td class="s3"><input type="text" name="mobile" size="16"/></td> </tr> <tr><td class="s2">Email:</td> <td class="s3"><input type="text" name="email"/></td> </tr> </table> <hr> <h4> EDUCATION DETAILS</h4> <table border="1"> <tr> <th>Degree</th> <th>Institution Name</th> <th>Percentage</th> <th>YearofPassing</th> </tr> <tr> <td class="s2">SSLC</td> <td class="s3"><input type="text" name="XSchoolName"></td> <td class="s3"><select name="Xpercentage"> <option name="" selected="true"></option> <option value="<50"><50</option> <option value=">50">>50</option> <option value=">60">>60</option> <option value=">70">>70</option> <option value=">80">>80</option> <option value=">90">>90</option> </select> </td> <td class="s3"><input type="text" name="Xyop"></td> </tr> <tr> <td class="s2">HSC</td> <td class="s3"><input type="text" name="XIISchool Name"></td> <td class="s3"><select name="XIIpercentage"> <option name="" selected="true"></option> <option value="<50"><50</option> <option value=">50">>50</option> <option value=">60">>60</option> <option value=">70">>70</option> <option value=">80">>80</option> <option value=">90">>90</option> </select> </td> <td class="s3"><input type="text" name="XIIyop"></td> </tr> <tr> <td class="s2">UG</td> <td class="s3"><input type="text" name="UInstitutionName"></td> <td class="s3"><select name="Upercentage"> <option name="" selected="true"></option> <option value="<50"><50</option> <option value=">50">>50</option> <option value=">60">>60</option> <option value=">70">>70</option> <option value=">80">>80</option> <option value=">90">>90</option> </select> </td> <td class="s3"><input type="text" name="Uyop"></td> </tr> <tr> <td class="s2">PG</td> <td class="s3"><input type="text" name="PInstitutionName"></td> <td class="s3"><select name="Ppercentage"> <option name="" selected="true"></option> <option value="<50"><50</option> <option value=">50">>50</option> <option value=">60">>60</option> <option value=">70">>70</option> <option value=">80">>80</option> <option value=">90">>90</option> </select> </td> <td class="S3"><input type="text" name="Pyop"></td> </tr> </table> <table> <tr> <td><input type="submit" name="submit" value="Submit" /></td> </tr> </table> </form> </body> </html>
redata.jsp
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<%@ page import="java.sql.*" %>
<%@ page import="java.io.*" %>Â
<html>
<head>
<title>Connection with mysql database</title>
</head>
<body>
<h1>Connection status</h1>
<%
String userid=request.getParameter("userid");
String passid=request.getParameter("passid");
String username=request.getParameter("username");
String dob=request.getParameter("dob");
String nationality=request.getParameter("nationality");
String sex=request.getParameter("sex");
String address=request.getParameter("address");
String zip=request.getParameter("zip");
String country=request.getParameter("country");
String mobile=request.getParameter("mobile");
String email=request.getParameter("email");
String instution=request.getParameter("instution");
String XSchoolName=request.getParameter("XSchoolName");
String Xpercentage=request.getParameter(" Xpercentage");
String Xyop=request.getParameter("Xyop");
String XIISchoolName=request.getParameter("XIISchoolName");
String XIIpercentage=request.getParameter("XIIpercentage");
String XIIyop=request.getParameter("XIIyop");
String UInstutionName=request.getParameter("UInstutionName");
String Upercentage=request.getParameter("Upercentage");
String Uyop=request.getParameter("Uyop");
String PInstutionName=request.getParameter("PInstutionName");
String Ppercentage=request.getParameter("Ppercentage");
String Pyop=request.getParameter("Pyop");
try
{
String connectionURL = "jdbc:mysql://localhost:3306/stu";
// declare a connection by using Connection interface
Connection connection = null;
//Â Load JBBC driver "com.mysql.jdbc.Driver"
Class.forName("com.mysql.jdbc.Driver").newInstance();
/* Create a connection by using getConnection() method that takes parameters of string type connection url, user name and password to connect to database. */
connection = DriverManager.getConnection(connectionURL, "root", "");
// check weather connection is established or not by isClosed() method
if(!connection.isClosed())
%>
<%
out.println("successsfully connected");
ResultSet rs = null;
PreparedStatement ps;
ps = connection.prepareStatement("INSERT INTO candP (userid,passid,username,dob,nationality,sex,address,zip,country,mobile,email,instution,XSchoolName,Xpercentage,Xyop,XIISchoolName,XIIpercentage,XIIyop,UInstutionName,Upercentage,Uyop,PInstutionName,Ppercentage,Pyop) values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)");
ps.setString(1,userid);
ps.setString(2,passid);
ps.setString(3,username);
ps.setString(4,dob);
ps.setString(5,nationality);
ps.setString(6,sex);
ps.setString(7,address);
ps.setString(8,zip);
ps.setString(9,country);
ps.setString(10,mobile);
ps.setString(11,email);
ps.setString(12,instution);
ps.setString(13,XSchoolName);
ps.setString(14,Xpercentage);
ps.setString(15,Xyop);
ps.setString(16,XIISchoolName);
ps.setString(17,XIIpercentage);
ps.setString(18,XIIyop);
ps.setString(19,UInstutionName);
ps.setString(20,Upercentage);
ps.setString(21,Uyop);
ps.setString(22,PInstutionName);
ps.setString(23,Ppercentage);
ps.setString(24,Pyop);
int i = ps.executeUpdate();
out.println("Welcome");
out.println(i);
if(i!=0)
{
out.println("your Data has been successfully stored in database");
out.println("Hello"+username);
}
else
{
out.println("Try again");
}
}
catch(Exception ex)
{
ex.printStackTrace(response.getWriter());
out.println("unable to connect database");
}
%>
</body>
</html>
while running this program in tomcat server i got the following exception:
com.mysql.jdbc.MysqlDataTruncation: Data truncation: Out of range value for column 'zip' at row 1 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2983) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723) at com.mysql.jdbc.Connection.execSQL(Connection.java:3283) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1332) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1604) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1519) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1504) at org.apache.jsp.regdatjsp.jspService(regdat_jsp.java:138) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:388) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293) at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:879) at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:600) at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1703) at java.lang.Thread.run(Thread.java:662)
Connection status
successsfully connected unable to connect database
Pls say whts wrong??? thanks in advance
View Answers
Related Pages:
If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.
Ask your questions, our development team will try to give answers to your questions.
Tutorial Topics
