Re: Insert row with autoincrement pk column....

[padhu vinirs]

This thread discusses the issue I have.   http://forum.java.sun.com/thread.jsp?forum=13&thread=298230     I also found out that in MySQL, If you insert NULL into an AUTO_INCREMENT column, the next number in the sequence is inserted. How does one insert the NULL value when the id is of type Integer ???     -- padhu       ----- Original Message ----- From: Evan Ireland To: [EMAIL PROTECTED] Sent: Tuesday, December 03, 2002 6:19 PM Subject: Re: Insert row with autoincrement pk column.... Which J2EE container are you using? ----- Original Message ----- From: padhu vinirs To: [EMAIL PROTECTED] Sent: Wednesday, December 04, 2002 6:09 PM Subject: Insert row with autoincrement pk column....   I have a table in MySQL with columns "id" and "symbol". The "id" column is set to autoincrement from 1000. I have an entity bean with a create(String symbol) which I assume will do a insert with only the "symbol" value, but it fails with the error that the id needs to be set. How do I take advantage of the table's autoincrement pk column ???   Thanks   -- padhu