Wrox Home  
Search P2P Archive for: Go

  Return to Index  

servlets thread: Error inserting data into database through servlet,pls help


Message #1 by "Huma H" <shehuma32@y...> on Thu, 16 May 2002 16:50:26
Hello Everybody

I am having real problems inserting data in a database(SQL Server7.0) 
through a servlet(Registeration form).It is supposedto take the parameters 
and when submit is click it should insert it into database.I dont know 
what i am doing wrong here.I am really new to servlet technology can 
anybody please
help This is the error I am having in tomcat 4.0:

 (java.sql.SQLException: [Microsoft][ODBC SQL Server Driver][SQL Server]
String or binary data would be truncated.
	at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6106)
	at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:6263)
	at sun.jdbc.odbc.JdbcOdbc.SQLExecDirect(JdbcOdbc.java:2525)
	at sun.jdbc.odbc.JdbcOdbcStatement.execute
(JdbcOdbcStatement.java:337)
	at Register.insertIntoDB(Register.java:71)
	at Register.doPost(Register.java:53)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter
(ApplicationFilterChain.java:247)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter
(ApplicationFilterChain.java:193)
	at 

  Return to Index