Hi Alexey, thanks for your answer. Mysql is definitly able to do it. A "insert into" command can be used on such a table like on any other table. The difference is that you are able to get the generated primary key if it had to be generated afterwards using a mysql specific command. Of course I am not sure how and if this can be used using Java... I thought MSSQL2000 should be able to do it then as well, but I am not sure. I thought of having two creater methods, one with a parameter for the primary key and one without. It has to through an exception if the primary key exists but that is something I could handle then. Best regards, Carsten
"Alexey Loubyansky" <[EMAIL PROTECTED]> schrieb im Newsbeitrag news:[EMAIL PROTECTED] Hello Carsten, by autoincrement you mean that the column is autoincremented by the database, right? My question is, does the database you use allow you to write to a column that is managed by the database? I would guess, the answer is no. And, hence, JBoss can do nothing with it. alex Monday, July 14, 2003, 6:26:53 PM, Carsten Hammer wrote: CH> Hi JBoss Gurus, CH> is it possible to use autoincrement on a column for cases I donīt get a CH> primary key and in cases where I do get primary keys try to use them? CH> I need to import a lot of data containing primary keys and after that I need CH> to create primary keys myself in my application to be able to create CH> additional rows. CH> Thanks in advance, CH> Carsten ------------------------------------------------------- This SF.Net email sponsored by: Parasoft Error proof Web apps, automate testing & more. Download & eval WebKing and get a free book. www.parasoft.com/bulletproofapps1 ------------------------------------------------------- This SF.Net email sponsored by: Parasoft Error proof Web apps, automate testing & more. Download & eval WebKing and get a free book. www.parasoft.com/bulletproofapps1 _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
