S
Seref Arikan
Hi,
I am trying to update some data in db using cachedrowset, and somehow, i
could not manage to get it work. I am getting X number of conflicts
exception, X being whatever the number of rows cachedrowset instance
includes.
It seems to be a bug or maybe something about drivers ? any ideas ?
Info is as follows :
Windows xp, j2se 1.5 (call it 5 if you like oracle db version 8.1.7
code and exception are as follows
----------------------------------------------------------------------------
-----------------------
Class.forName("oracle.jdbc.driver.OracleDriver");
// Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
CachedRowSet wrs = new CachedRowSetImpl();
wrs.setCommand("select * from emp where ename='SMITH'");
wrs.setUsername("scott");
wrs.setPassword("tiger");
wrs.setUrl("jdbcracle:thinlocalhost:1521:Oralocal");
wrs.execute();
wrs = wrs;
wrs.setKeyColumns(new int[]{1});
wrs.absolute(1);
wrs.updateString(2,"Ahha update");
wrs.updateRow();
wrs.acceptChanges();
----------------------------------------------------------------------------
-----------------------
javax.sql.rowset.spi.SyncProviderException: 1 conflicts while synchronizing
any help is appreciated a lot
Best Regards
I am trying to update some data in db using cachedrowset, and somehow, i
could not manage to get it work. I am getting X number of conflicts
exception, X being whatever the number of rows cachedrowset instance
includes.
It seems to be a bug or maybe something about drivers ? any ideas ?
Info is as follows :
Windows xp, j2se 1.5 (call it 5 if you like oracle db version 8.1.7
code and exception are as follows
----------------------------------------------------------------------------
-----------------------
Class.forName("oracle.jdbc.driver.OracleDriver");
// Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
CachedRowSet wrs = new CachedRowSetImpl();
wrs.setCommand("select * from emp where ename='SMITH'");
wrs.setUsername("scott");
wrs.setPassword("tiger");
wrs.setUrl("jdbcracle:thinlocalhost:1521:Oralocal");
wrs.execute();
wrs = wrs;
wrs.setKeyColumns(new int[]{1});
wrs.absolute(1);
wrs.updateString(2,"Ahha update");
wrs.updateRow();
wrs.acceptChanges();
----------------------------------------------------------------------------
-----------------------
javax.sql.rowset.spi.SyncProviderException: 1 conflicts while synchronizing
any help is appreciated a lot
Best Regards