Re: How to Insert the Row in ResultSet by moveToInsertRow() ... insertRow()?
От | Dave Cramer |
---|---|
Тема | Re: How to Insert the Row in ResultSet by moveToInsertRow() ... insertRow()? |
Дата | |
Msg-id | 6FBFEA2D-BAE3-4420-9685-3FA10E070A54@fastcrypt.com обсуждение исходный текст |
Ответ на | How to Insert the Row in ResultSet by moveToInsertRow() ... insertRow()? (vasylenko@uksatse.org.ua) |
Список | pgsql-jdbc |
On 10-Jan-07, at 5:47 AM, vasylenko@uksatse.org.ua wrote: > > > Hello! > |--------------------------------------------------------------------- > -----| > | > | > | > | > | > | > | > | > | > | > | > | > | > | > | > | > | I've got the Postgre database and table > insdide | > | > | > | > code: | > | > | > | > | > | > | > | > | > | CREATE TABLE > groups | > | > ( | > | id int4 NOT NULL DEFAULT nextval > ('seq_group_id'::regclass), | > | g_name text NOT > NULL, | > | CONSTRAINT i_group PRIMARY KEY > (id) | > | ) > | > | WITHOUT > OIDS; | > | ALTER TABLE groups OWNER TO > vasylenko; | > | COMMENT ON TABLE groups IS 'Группы > работников (объект, смена | > | ...)'; > | > | > | > | > | > | > | > | > | > | As You can see: 2 > fields | > | id - it's an autofill > field. | > | > | > | But when I try to insert the new Row in code putting > under It | > | generete the SQLException, that "id" filed was not found > in | > | ResultSet. But it mustn't be there as for > me. | > | I created the id field with default value from the > sequence | > | > code: | > | > | > | > | > | > | > | CREATE SEQUENCE > seq_group_id | > | INCREMENT > 1 | > | MINVALUE > 1 | > | MAXVALUE > 9223372036854775807 | > | START > 26 | > | CACHE > 1; | > | ALTER TABLE seq_group_id OWNER TO > vasylenko; | > | > | > | > | > | > | > | > | > | The Code > is: | > | > code: | > | > | > | > | > | > | > | ResultSet > rs; | > | Statement stat > = | > | conn.createStatement > (ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CO| > | > NCUR_UPDATABLE); | You only selected g_name , not id, g_name Dave > | rs = stat.executeQuery("Select g_name FROM > groups"); | > | try > { | > | rs.moveToInsertRow > (); | > | / > ** | > | ** !!!!!!!The exception generated > there !!!!!!!!! | > | > */ | > | } > | > | catch(SQLException ex) > { | > | > | > | System.out.print(ex.getMessage() > +"\n"); | > | > return; | > | } > | > | > | > | try > { | > | String temp = "New > Group"; | > | > | > | rs.updateObject(i+1, > temp); | > | } > | > | > | > | catch(SQLException ex) > { | > | > | > | System.out.print(ex.getMessage() > +"\n"); | > | > return; | > | } > | > | > | > | > | > | try > { | > | rs.insertRow > (); | > | } > | > | catch(SQLException > ex) | > | > { | > | > | > | System.out.print(ex.getMessage() > +"\n"); | > | > | > | } > | > | > | > | > | > | > | > | > | > | > | > | I don't neew to make the ResultSet with both fields... > 'cos I use| > | this ResultSet Data in JTable table > model. | > | How to solve the > problem? | > | > Thanks. | > | > | > | > | > | > | > | > | > |--------------------------------------------------------------------- > -----| > > > > > ---------------------------(end of > broadcast)--------------------------- > TIP 2: Don't 'kill -9' the postmaster
В списке pgsql-jdbc по дате отправления: