Re: How to add data with ResultSet object?

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