[architect-01]

Hi Riyad,
I am able to connect to a Derby 10.1 database I created called restaurants but I can not use the Edit Data feature in MyEclipse. I get this error Error: not valid sql statement: The result set is not updatable. in the where condition I just typed id > 0. id is the primary key and I have 3 records in the database why wont it retrieve any data ??

Thanks

Paul

[Riyad Kalla]

Paul,
It depends on the JDBC driver you are using. Not every one supports updatable result sets, which is what it sounds like is going on here.

[Author]

Posts