[bobcoss]

I was working on the WebStock tutorials and wanted to create tables using a lightweight database, so I installed Apache Derby and the Derby Eclipse Plugin. It seems to be working ok in that I can add the Derby nature to my project, start up the server, add tables and query using the ij interface.

I noticed however that I cannot use the database explorer “edit table” feature of ME. I get an error message that says:

Error: Can’t edit: the result set is not updatable.

I can run queries that show me the data that I inserted by hand, but not use the editor.

I did verify that the ME database explorer option for “autocommit” is turned on.

I’m using the Eclilpse 3.1, and ME 4.1.

Thank you in advance for your support.

Bob

[Riyad Kalla]

Bob,
We’ll look into it.

[Haris Peco]

Bob,

Derby jdbc driver doesn’t support updatable result set – MyEclipse support editing for updatable resultset only. This can be changed in futures releases.You can try IBM universal driver

Best

[Haris Peco]

Bob,

I have tried IBM universal drivers for derby and it doesn’t support updatable result sets, too
You can’t use ‘edit data’ with Derby, for now

Best

[bobcoss]

Thank you!

[Author]

Posts