CachedRowSet wont update data source

[diamonddragon]

While experimenting with CachedRowSet object, I got this error message, when try to update data source:

This is code that I use for this purpose:

String cn = crs.getString("COF_NAME");
                if (cn.equals("Colombian")) {
                    crs.updateFloat("PRICE", 888);      
                    crs.updateRow();                    
                    crs.acceptChanges();
                }

And this is error message:

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near '.coffees WHERE COF_NAME = 'Colombian' AND SUP_ID = 101
AND PRICE = 777.00 AND SA' at line 1
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:525)
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
	at com.mysql.jdbc.Util.getInstance(Util.java:386)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3609)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3541)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2002)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2163)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2624)
	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2127)
	at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2293)
	at com.sun.rowset.internal.CachedRowSetWriter.updateOriginalRow(CachedRowSetWriter.java:517)
	at com.sun.rowset.internal.CachedRowSetWriter.writeData(CachedRowSetWriter.java:361)
	at com.sun.rowset.CachedRowSetImpl.acceptChanges(CachedRowSetImpl.java:880)
	at package1.ViewTable.getRowSet(ViewTable.java:232)
	at package1.ViewTable.main(ViewTable.java:247)
javax.sql.rowset.spi.SyncProviderException: 9conflicts while synchronizing

Any idea why this happened?

[DarrylBurke]

Just might be related to this reported bug: MySQL Bugs: #43571: Driver attempts to perform SHOW FULL COLUMNS on a non-existent temporary table.

You could try the suggestion near the bottom of that page (if for nothing else, then to assure yourself it's NOT related to the bug)

db

[diamonddragon]

I'v tried to use url like suggested:
"jdbc:mysql://localhost:3306/test?"+"useDynamicCharsetInfo=false"

but no help.

[Tolls]

What's the query used to populate the CRS?

[diamonddragon]

What's the query used to populate the CRS?

Here:

crs.setCommand("select * from test.coffees");

[Tolls]

Wonder what the actual UPDATE SQL is that has been generated.
Pity MySQL doesn't print the whole thing.