It's not a secret anymore!*
The moose likes Servlets and the fly likes SQL Error!! Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Java » Servlets
Bookmark "SQL Error!!" Watch "SQL Error!!" New topic
Author

SQL Error!!

Advait Chitalia
Greenhorn

Joined: Mar 24, 2001
Posts: 13
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.
Mark Simms
Ranch Hand

Joined: Jul 20, 2000
Posts: 36
I'll bet the version of the jdbc driver for the MS/SQL implementation is different on each machine.


Mark
Peter den Haan
author
Ranch Hand

Joined: Apr 20, 2000
Posts: 3252
Are you using the same database in each case, and if not, did you double-check that the primary key is really an identity column in the second database?
- Peter
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: SQL Error!!
 
Similar Threads
Problem with OJB
one-to-many relation
Hibernate :Mapping Multiple Table for single POJO class(with my problem explanation )
complex one-to-many
Calling Stored procedure from Hibernate