Hi This feature is difficult to implement because there is no standard in the DBs. Some do like Oracle, PostgreSQL, some do it differentely like M$ SQL-Server and Sybase with the "Identity" table attribute and some do not provide anything like M$ Access.
It becomes more difficult if you need autogeneraed PK spawning over more than one DB. AFAIK there is a EJB around in JBoss generating PKs but I did not use it. I don't think there is a general solution possible but I would suggest that you create a SLSB delivering the generated PK and encapsulate the implementation in this EJB to separate DB specific details from your application. Andy ----- Original Message ----- From: "Lennart Petersson" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, January 11, 2002 1:41 AM Subject: Re: [JBoss-dev] Autogenerated primary keys etc > Is this a feature supported by other J2EE servers? If so, we should have it also. > If not, should we be first? I'm now in a situation that i actually myself would like to > have that feature, but can't cover all the pros and cons with it. Any comments from > others already been this way, i mean there has been plenty of discussions... > > /Lennart > > Den 2002-01-11 08:27:02 skrev Alexey Yudichev <[EMAIL PROTECTED]>: > > > Is somebody going to integrate autogenerated primary key support to jaws > >like patch #473280? A very useful feature, I wonder why jboss still doesn't > >have one. > > > >Best wishes, > > Alexei Yudichev mailto:[EMAIL PROTECTED] > > > > > > > _______________________________________________ > Jboss-development mailing list > [EMAIL PROTECTED] > https://lists.sourceforge.net/lists/listinfo/jboss-development > _______________________________________________ Jboss-development mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-development
