Re: [JBoss-user] Auto Incrementing Primary Key with PostgreSQL a nd JBoss

2001-07-27 Thread Hermann RANGAMANA
IL PROTECTED]> Sent: Friday, July 27, 2001 11:10 AM Subject: Re: [JBoss-user] Auto Incrementing Primary Key with PostgreSQL a nd JBoss > Database independent way: > Create a sequence bean that has a name and a counter. The PK is the name, > and you can get a next value of the counter.

Re: [JBoss-user] Auto Incrementing Primary Key with PostgreSQL a nd JBoss

2001-07-27 Thread Maurice le Rutte
2001 10:27 AM Subject: RE: [JBoss-user] Auto Incrementing Primary Key with PostgreSQL a nd JBoss > Hi. > Maybe someone might be interested to the solution I adopted: > > String nextStatement="select nextval('project_idproject_seq')"; > > __

RE: [JBoss-user] Auto Incrementing Primary Key with PostgreSQL a nd JBoss

2001-07-27 Thread Federico Vesco
Hi. Maybe someone might be interested to the solution I adopted: private Integer insertRow (String projectName,int budget,java.sql.Date start,java.sql.Date end) throws SQLException { String nextStatement="select nextval('project_idproject_seq')"; String insertStatement =

RE: [JBoss-user] Auto Incrementing Primary Key with PostgreSQL a nd JBoss

2001-07-26 Thread Maraya Michael
om: Jean-Noël Heyraud[SMTP:[EMAIL PROTECTED]] > Reply To: [EMAIL PROTECTED] > Sent: Thursday, July 26, 2001 12:34 PM > To: '[EMAIL PROTECTED]' > Subject: AW: [JBoss-user] Auto Incrementing Primary Key with > PostgreSQL a nd JBoss > > i had

AW: [JBoss-user] Auto Incrementing Primary Key with PostgreSQL a nd JBoss

2001-07-26 Thread Jean-Noël Heyraud
? Jean-Noel -Ursprüngliche Nachricht- Von: Maraya Michael [mailto:[EMAIL PROTECTED]] Gesendet: Donnerstag, 26. Juli 2001 17:50 An: '[EMAIL PROTECTED]' Betreff: RE: [JBoss-user] Auto Incrementing Primary Key with PostgreSQL a nd JBoss I don't use Postgres but on MS SQL