Hello Everyone,
I have a BugTracking project I generated from CodeCharge that is up and
running on our WebLogic6.0 server. I have the tables on a SQL Server 2000
database and the program works fine, except when I go to enter a new bug
report, which is an INSERT operation on the table - I get this error
message:
java.sql.SQLException: Cannot insert the value NULL into column 'bug_id',
table 'BugTrack does not allow nulls. INSERT fails. Severity 16, State 2,
Procedure 'DB1 null', Line 1
The column 'bug_id' in this table is an int field, with nulls not allowed. I
allowed nulls, and I don't get the error message, but then I don't get an
auto-incremented ID number which I need to have for the Bug ID#. Because I
had upsized this table from MSAccess 2000, I also tried creating a new table
and replacing this 'bug_id'(int) field with a (uniquedentifier) field and
tried the original (int) field, but that didn't work either. So, how can I
get the JSP page(s) to write an incremental ID number to this table? When I
generated the code for this project, it created table records (in the
BugTrack table there were already 8 records to begin with, with ('bug_id' 1
through 8), but I am unable to add any more without this error.
Thanks in advance,
John Wilson
Programmer/Analyst
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
