Re: How to add data with ResultSet object?

[Kris Jurka <books(at)ejurka(dot)com>]

On Mon, 26 Nov 2007, vasylenko(at)uksatse(dot)org(dot)ua wrote:

> I use "SELECT * from ONLY forcehol" to see raws.
>
> -->     //here we have exception    with the text "No primary key found for table ONLY"
>        rs.moveToInsertRow();
>
> How can I beat such exception about unccorect analysing of my query with
> ONLY syntax?

This is a known driver bug.  The parser to determine the base table of an 
updatable result set is *very* easily confused.  Aside from fixing the 
driver the only way to fix this would be to use a view to hide the ONLY 
from the driver.  CREATE VIEW myonlyview AS SELECT * FROM ONLY forcehol 
and then writing appropriate insert rules on it so that you can have the 
driver select from and insert into the view.

Kris Jurka