p2p.wrox.com: Archives - servlets archive

servlets thread: Error inserting data into database through servlet
Message #1 by "Huma H" <shehuma32@y...> on Thu, 16 May 2002 16:58:14
--0-1145381330-1021582599=:68180
Content-Type: text/plain; charset=us-ascii


 No the user_id field is not null
  John Cardona <jojaca@s...> wrote: It seems that your table has a field name user_id and you are letting it
null and It produce a sql error.

> java.sql.SQLException: [Microsoft][ODBC SQL Server Driver][SQL
> Server]Cannot insert the value NULL into column 'user_id', table
> 'HUMA.hhamid.Users'; column does not allow nulls. INSERT fails.
> 
is it true?

> ----------
> From: huma
> Reply To: Servlets
> Sent: Thursday, May 16, 2002 3:15 PM
> To: Servlets
> Cc: jojaca@s...
> Subject: [servlets] RE: Error inserting data into database through
> servlet
> 
> I tried but still am getting errors as follows 
> 
> 
> 
> ERROR: Problems with adding new entry
> 
> java.sql.SQLException: [Microsoft][ODBC SQL Server Driver][SQL
> Server]Cannot insert the value NULL into column 'user_id', table
> 'HUMA.hhamid.Users'; column does not allow nulls. INSERT fails.
> 
> 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(Applicati
> onFilterChain.java:247)
> 
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilter
> Chain.java:193)
> 
> at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.
> java:243)
> 
> at
> org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java
> :566)
> 
> at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472
> )
> 
> at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
> 
> at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.
> java:190)
> 
> at
> org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java
> :566)
> 
> at
> org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java
> :246)
> 
> at
> org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java
> :564)
> 
> at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472
> )
> 
> at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
> 
> at
> org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2343)
> 
> at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:1
> 80)
> 
> at
> org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java
> :566)
> 
> at
> org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValv
> e.java:170)
> 
> at
> org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java
> :564)
> 
> at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:1
> 70)
> 
> at
> org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java
> :564)
> 
> at
> org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:468)
> 
> at
> org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java
> :564)
> 
> at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472
> )
> 
> at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
> 
> at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.ja
> va:174)
> 
> at
> org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java
> :566)
> 
> at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472
> )
> 
> at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
> 
> at
> org.apache.catalina.connector.http.HttpProcessor.process(HttpProcessor.jav
> a:1012)
> 
> at
> org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor.java:11
> 07)
> 
> at java.lang.Thread.run(Thread.java:536)
> 
> ERROR: Problems with adding new entry
> 
> java.lang.IllegalStateException: Current state = FLUSHED, new state 
> CODING_END
> 
> at
> java.nio.charset.CharsetEncoder.throwIllegalStateException(CharsetEncoder.
> java:933)
> 
> at java.nio.charset.CharsetEncoder.encode(CharsetEncoder.java:529)
> 
> at
> sun.nio.cs.StreamEncoder$CharsetSE.flushLeftoverChar(StreamEncoder.java:35
> 6)
> 
> at sun.nio.cs.StreamEncoder$CharsetSE.implClose(StreamEncoder.java:413)
> 
> at sun.nio.cs.StreamEncoder.close(StreamEncoder.java:158)
> 
> at java.io.OutputStreamWriter.close(OutputStreamWriter.java:222)
> 
> at java.io.PrintWriter.close(PrintWriter.java:137)
> 
> at
> org.apache.catalina.connector.ResponseBase.finishResponse(ResponseBase.jav
> a:482)
> 
> at
> org.apache.catalina.connector.HttpResponseBase.finishResponse(HttpResponse
> Base.java:236)
> 
> at
> org.apache.catalina.connector.http.HttpResponseImpl.finishResponse(HttpRes
> ponseImpl.java:288)
> 
> at
> org.apache.catalina.connector.http.HttpProcessor.process(HttpProcessor.jav
> a:1039)
> 
> at
> org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor.java:11
> 07)
> 
> at java.lang.Thread.run(Thread.java:536)
> 
> java.sql.SQLException: [Microsoft][ODBC SQL Server Driver][SQL
> Server]Cannot insert the value NULL into column 'user_id', table
> 'HUMA.hhamid.Users'; column does not allow nulls. INSERT fails.
> 
> 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(Applicati
> onFilterChain.java:247)
> 
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilter
> Chain.java:193)
> 
> at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.
> java:243)
> 
> at
> org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java
> :566)
> 
> at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472
> )
> 
> at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
> 
> at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.
> java:190)
> 
> at
> org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java
> :566)
> 
> at
> org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java
> :246)
> 
> at
> org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java
> :564)
> 
> at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472
> )
> 
> at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
> 
> at
> org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2343)
> 
> at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:1
> 80)
> 
> at
> org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java
> :566)
> 
> at
> org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValv
> e.java:170)
> 
> at
> org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java
> :564)
> 
> at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:1
> 70)
> 
> at
> org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java
> :564)
> 
> at
> org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:468)
> 
> at
> org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java
> :564)
> 
> at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472
> )
> 
> at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
> 
> at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.ja
> va:174)
> 
> at
> org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java
> :566)
> 
> at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472
> )
> 
> at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
> 
> at
> org.apache.catalina.connector.http.HttpProcessor.process(HttpProcessor.jav
> a:1012)
> 
> at
> org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor.java:11
> 07)
> 
> at java.lang.Thread.run(Thread.java:536)
> 
> John Cardona wrote: 
> 
> I seems the error is in the following line of code, you are using at
> not
> necesary semicolon.
> 
> statement.execute("INSERT INTO Users
> (FirstName,LastName,Email,Login,Password) values (" + stringtoinsert
> 
> + ");");
> 
> try this, without a one of the semicolon.
> 
> statement.execute("INSERT INTO Users
> (FirstName,LastName,Email,Login,Password) values (" + stringtoinsert
> 
> + ")");
> 
> > ----------
> > From: Huma H
> > Reply To: Servlets
> > Sent: Thursday, May 16, 2002 11:58 AM
> > To: Servlets
> > Subject: [servlets] Error inserting data into database through
> > servlet
> > 
> > tis is the code i have wriiten but am getting errors
> > 
> > this is the code I have written:
> > 
> > 
> > import java.util.*;
> > import javax.servlet.*;
> > import javax.servlet.http.*;
> > import java.io.*;
> > import java.sql.*;
> > 
> > public class Register extends HttpServlet
> > {
> > public static Statement statement;
> > private Connection DBConn;
> > 
> > public void init(ServletConfig config) throws ServletException
> > {
> > super.init(config);
> > 
> > try {
> > Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
> > DBConn=DriverManager.getConnection
> > ("jdbc:odbc:Challenge");
> > }
> > catch(Exception e) {
> > e.printStackTrace();
> > DBConn=null;
> > }
> > }
> > 
> > public void doPost(HttpServletRequest req, HttpServletResponse
> res)
> > throws ServletException, IOException
> > {
> > String FirstName,LastName, Email, Login, Password;
> > 
> > 
> > FirstName = req.getParameter("FirstName");
> > LastName = req.getParameter("LastName");
> > Email = req.getParameter("Email");
> > Login = req.getParameter("Login");
> > Password = req.getParameter("Password");
> > 
> > PrintWriter output = res.getWriter();
> > res.setContentType("text/html");
> > 
> > if //user_id.equals("")||
> > (FirstName.equals("") ||
> > LastName.equals("") ||
> > 
> > Email.equals("") ||
> > Login.equals("") ||
> > Password.equals(""))
> > {
> > output.println(" 
> 
> Please click back " 
> > + "button and fill in all " + "fileds.
> 
> ");
> > output.close();
> > return;
> > }
> > boolean success = insertIntoDB("'" + FirstName 
> > + "','" + LastName + "','" + Email + "','" + Login + "','" +
> Password 
> > + "'");
> > if (success)
> > {
> > output.print(" 
> 
> Thank You " + FirstName 
> > + " for registering.
> 
> ");
> > res.sendRedirect("file:///Register.html");
> > }
> > else
> > {
> > output.print(" 
> 
> An error occured. " 
> > + "Please try again later.
> 
> ");
> > 
> > output.close();
> > }
> > }
> > private boolean insertIntoDB(String stringtoinsert)
> > {
> > try
> > {
> > statement = DBConn.createStatement();
> > statement.execute("INSERT INTO Users
> > (FirstName,LastName,Email,Login,Password) values (" +
> stringtoinsert 
> > + ");");
> > statement.close();
> > }
> > catch (Exception e)
> > {
> > System.err.println("ERROR: Problems with 
> > adding new entry");
> > e.printStackTrace();
> > return false;
> > }
> > return true;
> > }
> > public void destroy()
> > {
> > try
> > {
> > DBConn.close();
> > }
> > catch(Exception e)
> > {
> > System.err.println("Problem closing the 
> > database");
> > }
> > }
> > }
> > 
> > 
> > 
> 
> 
> 
> 
> 
> 
> _____ 
> 
> Do You Yahoo!?
> LAUNCH - Your Yahoo! Music Experience --- 
> http://p2p.wrox.com/manager.asp or 
> 





---------------------------------
Do You Yahoo!?
LAUNCH - Your Yahoo! Music Experience
Return to Index
P2P Archives
