Thread: Updateable ResultSet
Hi I use the same Postgresql and JDBC versions and get the same error message.But, if I once call updateRow, then moveToInsertRow works without errors. Juhani Merilinnajuhani.merilinna.adulta.fi >I used postgresql 7.21 version on Redhat 7.1 system,>got same error. I used JDBC development version. >ERROR: Got exception: Result Set not updateable. The>query that gene>rated this result set must select only one table, and>must select all primary ke>ys from that table. See the JDBC 2.1 API
>Specification, section 5.6 for more details. >But I only select one table, and I select all columns>include primary key. >How can I get "Updateable ResultSet" works? >Thanks! >Zengfa --- Dave Cramer <Dave@micro-automation.net> wrote:> It's possible it doesn't work with a 7.0 database.> Why are you using> such an old version?> > Dave> On Thu, 2002-08-15 at 14:21, Zengfa Gao wrote:
> > Hi, all:> > > > >From JDBC website, I got> > > > Latest Java/JDBC news > > Jun 23 Updated dev drivers that include callable> > statement support and updatable result set support> > > > > Then I downloaded 7.3Dev version of JDBC driver> and> > try to use updatable result set. > > > > When I run> > > > ResultSet rs = stmt.executeQuery(selectStat);> > > > rs.moveToInsertRow();> > > > I got:> > > > > > ERROR: Got exception: Result Set not> > updateable. The query that gene
> > rated this result set must select only one table,> and> > must select all primary ke> > ys from that table. See the JDBC 2.1 API
> > Specification, section 5.6 for more det> > ails. > > > > > > But I only select from one table, and I select all> > columns from that table include primary key. Does> > anyone know why it failed at here?> > > > I used PostgreSQL 7.0.3 on Redhat system.> > > > Thanks,> > > > Zengfa> >
###########################################
This message has been scanned by F-Secure Anti-Virus for Microsoft Exchange.
For more information, connect to http://www.F-Secure.com/
Yes, I have a patch for this, and just have to get around to applying it. Dave On Fri, 2002-08-23 at 03:00, Merilinna, Juhani wrote: > Hi > > I use the same Postgresql and JDBC versions and get the same error message. > But, if I once call updateRow, then moveToInsertRow works without errors. > > Juhani Merilinna > juhani.merilinna.adulta.fi > > > >I used postgresql 7.21 version on Redhat 7.1 system, > >got same error. I used JDBC development version. > > >ERROR: Got exception: Result Set not updateable. The > >query that gene > >rated this result set must select only one table, and > >must select all primary ke > >ys from that table. See the JDBC 2.1 API > >Specification, section 5.6 for more details. > > >But I only select one table, and I select all columns > >include primary key. > > >How can I get "Updateable ResultSet" works? > > >Thanks! > > >Zengfa > > --- Dave Cramer <Dave@micro-automation.net> wrote: > > It's possible it doesn't work with a 7.0 database. > > Why are you using > > such an old version? > > > > Dave > > On Thu, 2002-08-15 at 14:21, Zengfa Gao wrote: > > > Hi, all: > > > > > > >From JDBC website, I got > > > > > > Latest Java/JDBC news > > > Jun 23 Updated dev drivers that include callable > > > statement support and updatable result set support > > > > > > > > Then I downloaded 7.3Dev version of JDBC driver > > and > > > try to use updatable result set. > > > > > > When I run > > > > > > ResultSet rs = stmt.executeQuery(selectStat); > > > > > > rs.moveToInsertRow(); > > > > > > I got: > > > > > > > > > ERROR: Got exception: Result Set not > > > updateable. The query that gene > > > rated this result set must select only one table, > > and > > > must select all primary ke > > > ys from that table. See the JDBC 2.1 API > > > Specification, section 5.6 for more det > > > ails. > > > > > > > > > But I only select from one table, and I select all > > > columns from that table include primary key. Does > > > anyone know why it failed at here? > > > > > > I used PostgreSQL 7.0.3 on Redhat system. > > > > > > Thanks, > > > > > > Zengfa > > > > > ########################################### > > This message has been scanned by F-Secure Anti-Virus for Microsoft Exchange. > For more information, connect to http://www.F-Secure.com/
Thanks, Dave and Juhani. I put resultset.updateRow() before resultset.moveToInsertRow(), everything works fine now. I only have two resultset.moveToInsertRow() lines, so it's easy for me. When I get the patch, I can just remove these two resultset.updateRow() lines. Zengfa --- Dave Cramer <Dave@micro-automation.net> wrote: > Yes, I have a patch for this, and just have to get > around to applying > it. > > Dave > On Fri, 2002-08-23 at 03:00, Merilinna, Juhani > wrote: > > Hi > > > > I use the same Postgresql and JDBC versions and > get the same error message. > > But, if I once call updateRow, then > moveToInsertRow works without errors. > > > > Juhani Merilinna > > juhani.merilinna.adulta.fi > > > > > > >I used postgresql 7.21 version on Redhat 7.1 > system, > > >got same error. I used JDBC development version. > > > > >ERROR: Got exception: Result Set not > updateable. The > > >query that gene > > >rated this result set must select only one table, > and > > >must select all primary ke > > >ys from that table. See the JDBC 2.1 API > > >Specification, section 5.6 for more details. > > > > >But I only select one table, and I select all > columns > > >include primary key. > > > > >How can I get "Updateable ResultSet" works? > > > > >Thanks! > > > > >Zengfa > > > > --- Dave Cramer <Dave@micro-automation.net> wrote: > > > It's possible it doesn't work with a 7.0 > database. > > > Why are you using > > > such an old version? > > > > > > Dave > > > On Thu, 2002-08-15 at 14:21, Zengfa Gao wrote: > > > > Hi, all: > > > > > > > > >From JDBC website, I got > > > > > > > > Latest Java/JDBC news > > > > Jun 23 Updated dev drivers that include > callable > > > > statement support and updatable result set > support > > > > > > > > > > > Then I downloaded 7.3Dev version of JDBC > driver > > > and > > > > try to use updatable result set. > > > > > > > > When I run > > > > > > > > ResultSet rs = stmt.executeQuery(selectStat); > > > > > > > > rs.moveToInsertRow(); > > > > > > > > I got: > > > > > > > > > > > > ERROR: Got exception: Result Set > not > > > > updateable. The query that gene > > > > rated this result set must select only one > table, > > > and > > > > must select all primary ke > > > > ys from that table. See the JDBC 2.1 API > > > > Specification, section 5.6 for more det > > > > ails. > > > > > > > > > > > > But I only select from one table, and I select > all > > > > columns from that table include primary key. > Does > > > > anyone know why it failed at here? > > > > > > > > I used PostgreSQL 7.0.3 on Redhat system. > > > > > > > > Thanks, > > > > > > > > Zengfa > > > > > > > > ########################################### > > > > This message has been scanned by F-Secure > Anti-Virus for Microsoft Exchange. > > For more information, connect to > http://www.F-Secure.com/ > > > > > ---------------------------(end of > broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster __________________________________________________ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.yahoo.com