Re: Problem with jdbc, RowSet and Oracle



Assuming we are not talking about ResultSet, as described in my
following blog entry
http://db360.blogspot.com/2006/09/manipulating-tabular-data-using-jdbc_03.html
there are 5 RowSet model (JdbcRowSet, CachedRowSet, WebRowSet,
JoinRowSet and FileterdRowSet). Which one are you using?

Fwiw, I have working examples in chapter 8 of my book.

Kuassi
przemmal@xxxxx wrote:
Hi.

I have a problem with data modification in Oracle while useing jdbc and
RowSet (both Sun and Oracle implementation). RowSet is not updatable.
When I use Statement and ResultSet everything is OK. Oracle in 10g
version (with v9 is the same), jdbc - ojdbc14.jar. With jdbc drivers
from commercial developers there is no problem. Any ideas?

thanks
Przemm

.



Relevant Pages

  • Re: Using ResultSet in a TableModel?
    ... in a ResultSet using JDBC with an SQL query is read and placed in a ... Can't you simply keep the ResultSet and work with ... Yes, but that requires keeping the connection open, and connections tend to be both scarce and expensive. ... Such a rowset is called a disconnected rowset. ...
    (comp.lang.java.databases)
  • Re: recordset not opening even though query analyzer returns resultset
    ... execute a query the SQL engine returns a resultset. ... If the resultset has a rowset, ... you still get an "open" Recordset. ...
    (microsoft.public.vb.database.ado)
  • Re: Wie schreibt man eine Datenbank-Wrapper-Klasse?
    ... Für ein DDL Sttement wuerde ich kein Rowset benutzen, ... sinnvolles Resultset als Ergebnis. ... Eventell reicht es dir mit CachedRowSet#populate zu arbeiten? ...
    (de.comp.lang.java)
  • Re: connectionless resultset [please help]
    ... What you are looking for is a RowSet implementation. ... A RowSet can be populated from a ResultSet, ... used with any JDBC driver. ...
    (comp.lang.java.databases)
  • Re: Problem with jdbc, RowSet and Oracle
    ... JDBCRowSet objects are by default scrollable (i.e., ... I'm useing JdbcRowSet (OracleJDBCRowSet in implementation of Oracle) ... RowSet (both Sun and Oracle implementation). ...
    (comp.lang.java.databases)