Re: Problem with jdbc, RowSet and Oracle

JDBCRowSet objects are by default scrollable (i.e.,
ResultSet.TYPE_SCROLL_SENSITIVE) and read-only (i.e.,
ResultSet.CONCUR_READ_ONLY) but can be made updatable by calling
setReadOnly (false).

przemmal@xxxxx wrote:
kuassi.mensah@xxxxxxxxx napisal(a):
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?

I'm useing JdbcRowSet (OracleJDBCRowSet in implementation of Oracle)


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


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?

.

Relevant Pages

  • 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)
  • Re: Multiple RowSets redux...
    ... It's going to be a fairly large database. ... Wouldn't I want to use JdbcRowSet? ... What are its advantages over regular RowSet or ResultSet? ... I'm coming from JBuilder where all the database stuff was "behind the ...
    (comp.lang.java.databases)
  • Re: Multiple RowSets redux...
    ... tables in a single Derby database. ... Each TableModels will get their data from a JDBCRowSet ... should each TableModel have it's own ... If you reuse a RowSet, or any ResultSet,> A ResultSet object is automatically closed when the Statement object ...
    (comp.lang.java.databases)
  • Re: Problem with jdbc, RowSet and Oracle
    ... I'm useing JdbcRowSet (OracleJDBCRowSet in implementation of Oracle) ... RowSet (both Sun and Oracle implementation). ...
    (comp.lang.java.databases)
  • Re: Problem with jdbc, RowSet and Oracle
    ... JoinRowSet and FileterdRowSet). ... RowSet (both Sun and Oracle implementation). ... When I use Statement and ResultSet everything is OK. ...
    (comp.lang.java.databases)