CachedRowSet Problem
I am trying to learn how to use a CachedRowSet class and am having a problem. The error I get is this: javax.sql.rowset.spi.SyncProviderException: 1 conflicts while synchronizing
I am using java version: java version "1.5.0_11"
Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0_11-b03)
Java HotSpot(TM) Client VM (build 1.5.0_11-b03, mixed mode, sharing).
ojdbc14.jar
What I am trying to do is update an oracle table. There are 5 columns in the table. My query is a "select * from table". I am updating a string column. The updating code works fine when I dont have an oracle date type column in the table. Once I have an oracle date column, I get the above error. I am not updating the date field at all. Just a string field. If I remove the date field, the update works.
If I do a "select column1, column2, .." it still doesn't work when I have the date column.
I am accessing an oracle 10g database: Oracle Database 10g Release 10.2.0.3.0 - Production
[1017 byte] By [
Theobonea] at [2007-11-27 8:52:33]
This is the code:
import java.sql.*;
import javax.sql.rowset.*;
import javax.sql.rowset.spi.*;
import com.sun.rowset.*;
import java.util.*;
public class TestCache
{
public static void main(String[] args)
{
// make sure oracle driver exists
try
{
Class.forName("oracle.jdbc.driver.OracleDriver");
}
catch(ClassNotFoundException e)
{
e.printStackTrace();
System.out.println("Driver Problem!");
}
try
{
Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@db02:1521:comsat",
"acnymgr","acnymgr");
Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_UPDATABLE);
CachedRowSetImpl crs = new CachedRowSetImpl();
String sql = "Select * from ny_weather";
crs.setCommand(sql);
crs.execute(conn);
while(crs.next())
{
if (crs.getString(3).equals("0068798"))
{
System.out.println("found it!");
crs.updateString(1, "katie@aaany.com");
crs.updateRow();
crs.acceptChanges();
crs.close();
}
}
}
catch(Exception e)
{
e.printStackTrace();
System.out.println("Problem with caching row set!");
}
}
}
