Hello guys!
I have a sql query which inserts a record in a table in a MSSQL database. This table has its primary key column as autoincrement. Obviously, I don't mention about the autoincrement column while inserting data. i.e. the 'executeUpdate' query will have all the column names and values except this autoincrement column(in this case the column name is messageID and table name is tDiscussion). This code works perfectly fine at my office. It gives problem when hosted on a different server. At both sides the server running the
JSP pages is
TOMCAT. I will write my query below and the error under it. Please... help.
QUERY:
String query="INSERT INTO tDiscussion(parent,subject,name,email,date,message,category)"
+"VALUES ('0','"+subject+"','"+name+"','"+email+"','"+datee+"','"+message+"','"+category+"')";
ERROR:
Internal
Servlet Error:
javax.servlet.ServletException: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert the value NULL into column 'messageID', table 'photo.photo.tDiscussion'; column does not allow nulls. INSERT fails.
