 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
Java Forum / Databases / December 2006Problem with jdbc, RowSet and Oracle
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 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 > Hi. > [quoted text clipped - 6 lines] > thanks > Przemm kuassi.mensah@gmail.com 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. > [quoted text clipped - 3 lines] > > version (with v9 is the same), jdbc - ojdbc14.jar. With jdbc drivers > > from commercial developers there is no problem. Any ideas? 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). > kuassi.mensah@gmail.com napisal(a): > > Assuming we are not talking about ResultSet, as described in my [quoted text clipped - 12 lines] > > > version (with v9 is the same), jdbc - ojdbc14.jar. With jdbc drivers > > > from commercial developers there is no problem. Any ideas? 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). > kuassi.mensah@gmail.com napisal(a): > > Assuming we are not talking about ResultSet, as described in my [quoted text clipped - 12 lines] > > > version (with v9 is the same), jdbc - ojdbc14.jar. With jdbc drivers > > > from commercial developers there is no problem. Any ideas? kuassi.mensah@gmail.com napisal(a): > 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). I have tried setReadOnly(false) and setConcurrency(ResulSet.CONCUR_UPDATABLE), but that does not work :( Then we have a bug! > kuassi.mensah@gmail.com napisal(a): > > JDBCRowSet objects are by default scrollable (i.e., [quoted text clipped - 4 lines] > I have tried setReadOnly(false) and > setConcurrency(ResulSet.CONCUR_UPDATABLE), but that does not work :( kuassi.mensah@gmail.com napisal(a): > Then we have a bug! Thanks Kuassi for answer. I have read first chapter of your book. I think that you did great job. Kuassi do you know how this bug can be reported to Oracle's support? Hi, Thanks for your appreciation of the first chapter of book; the other chapters are as good/useful :) Regarding the bug, i am following up internally with the lead developer, so it will be fixed as soon as possible but if this is urgent, please log a TAR and bug with Oracle support. Cheers, Kuassi > kuassi.mensah@gmail.com napisal(a): > > Then we have a bug! > > Thanks Kuassi for answer. I have read first chapter of your book. I > think that you did great job. kuassi.mensah@gmail.com napisal(a): > Hi, > [quoted text clipped - 4 lines] > developer, so it will be fixed as soon as possible but if this is > urgent, please log a TAR and bug with Oracle support. thanks for help Przemm Free MagazinesGet these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...
|
Reply to this Message
|
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.