corrupted tables

[Döme <do...@gmail.com>]

Hi!

One of my client had a virus on his pc and his derby db has injured....

Symptoms are: two tables cannot be dropped at all.

When I run a "select" on "PKG_JAR" table I get following exception and 
connection will close immediately:
dbedit.core.DataException: Unable to retrieve result values for 
IBEXDERBYCONN.PKG_JAR
dbedit.core.DataException: Couldn't execute query:select 
"PKG_ID","JAR_ID" from "IBEXDERBYCONN"."PKG_JAR"



How can I recover or heal the db structure? At least I would like to 
drop that 2 tables.


Janos

Re: corrupted tables

["Dag H. Wanvik" <Da...@Sun.COM>]

Döme <do...@gmail.com> writes:

> Hi!
>
> One of my client had a virus on his pc and his derby db has injured....
>
> Symptoms are: two tables cannot be dropped at all.
>
> When I run a "select" on "PKG_JAR" table I get following exception and
> connection will close immediately:
> dbedit.core.DataException: Unable to retrieve result values for
> IBEXDERBYCONN.PKG_JAR
> dbedit.core.DataException: Couldn't execute query:select
> "PKG_ID","JAR_ID" from "IBEXDERBYCONN"."PKG_JAR"

This doesn't look like an error message from Derby
(dbedit.core.DataException is not a Derby class). Maybe you can print
all nested exceptions, so we can see what the root cause is.

Dag