AppletTalk.com Java discussions newsgroups   Archives   FAQ   Search   Memberlist   Usergroups   Register   Profile   Log in to check your private messages   Log in  Problem with jdbc, RowSet and Oracle          AppletTalk.com Forum Index -> Java and Databases View previous topic :: View next topic   Author Message Guest Posted: Tue Dec 12, 2006 3:31 am    Post subject: Problem 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 Back to top kuassi.mensah@gmail.com Guest Posted: Wed Dec 13, 2006 12:08 am    Post subject: 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 (AT) wp (DOT) pl wrote: Quote: 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 Back to top Guest Posted: Wed Dec 13, 2006 4:12 pm    Post subject: Re: Problem with jdbc, RowSet and Oracle kuassi.mensah (AT) gmail (DOT) com napisal(a): Quote: 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) Quote: 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? Back to top kuassi.mensah@gmail.com Guest Posted: Wed Dec 13, 2006 11:14 pm    Post subject: 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 (AT) wp (DOT) pl wrote: Quote: kuassi.mensah (AT) gmail (DOT) 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. 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? Back to top kuassi.mensah@gmail.com Guest Posted: Wed Dec 13, 2006 11:15 pm    Post subject: 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 (AT) wp (DOT) pl wrote: Quote: kuassi.mensah (AT) gmail (DOT) 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. 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? Back to top Guest Posted: Thu Dec 14, 2006 7:55 pm    Post subject: Re: Problem with jdbc, RowSet and Oracle kuassi.mensah (AT) gmail (DOT) com napisal(a): Quote: 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 Back to top kuassi.mensah@gmail.com Guest Posted: Sat Dec 16, 2006 5:49 am    Post subject: Re: Problem with jdbc, RowSet and Oracle Then we have a bug! przemmal (AT) wp (DOT) pl wrote: Quote: kuassi.mensah (AT) gmail (DOT) 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 Back to top Guest Posted: Sun Dec 17, 2006 12:02 am    Post subject: Re: Problem with jdbc, RowSet and Oracle kuassi.mensah (AT) gmail (DOT) com napisal(a): Quote: Then we have a bug! Thanks Kuassi for answer. I have read first chapter of your book. I think that you did great job. Back to top Guest Posted: Sun Dec 17, 2006 12:46 am    Post subject: Re: Problem with jdbc, RowSet and Oracle Kuassi do you know how this bug can be reported to Oracle's support? Back to top kuassi.mensah@gmail.com Guest Posted: Mon Dec 18, 2006 3:01 am    Post subject: Re: Problem with jdbc, RowSet and Oracle 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 przemmal (AT) wp (DOT) pl wrote: Quote: kuassi.mensah (AT) gmail (DOT) 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. Back to top Guest Posted: Mon Dec 18, 2006 11:14 pm    Post subject: Re: Problem with jdbc, RowSet and Oracle kuassi.mensah (AT) gmail (DOT) com napisal(a): Quote: 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. thanks for help Przemm Back to top Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year Oldest FirstNewest First         AppletTalk.com Forum Index -> Java and Databases All times are GMT Page 1 of 1   Jump to: Select a forum Java Newsgroups----------------Java DiscussionsWeb-based java games comp.lang.java 3D Graphics API's for Java Java: Support and criticism Java System Announcements comp.lang.java.api JavaBeans Java and CORBA Java and Databases comp.lang.java.developer Java GUI Toolkits Java Help comp.lang.java.javascript JVM, native methods and hardware comp.lang.java.misc Java Language Programming Security and Java comp.lang.java.setup Java Software Tools comp.lang.java.tech ibm.software.java.linux  Non-English Java Newsgroups----------------Java Language (German)Language Java (Français)Java (Italian)  You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum Powered by phpBB © 2001, 2006 phpBB Group SEO toolkit © 2004-2006 webmedic.