Satheesh Bandaram wrote:

A full exception trace (from derby.log) would help. I have not seen this
kind of error for this usage...

Satheesh

Jean T. Anderson wrote:

Edson Carlos Ericksson Richter wrote:

I solved my problem not using derby :(
Appear the list is more interested in voting logos, than solving
critical bugs.
Your frustration is understandable -- it must have seemed like Derby
was doing nothing else today but looking at logos.

I suspect the real reason for silence on the issue you posted was
nobody immediately recognized the problem given the information
provided. The turnaround for a given problem often depends on if
someone has encountered it or something similar before.

Did you try running the same query in ij? and did it get the same error?

regards,

-jean

Richter


Edson Carlos Ericksson Richter escreveu:

the error message is:

select count(*) from TB_BIBLIO_AUTORIZACAO: Exception
"java.lang.ClassCastException:
org.apache.derby.impl.sql.execute.CountAggregator' was emited
evaluating expression.

The table TB_BIBLIO_AUTORIZACAO has 8 records, with 3 columns (one
integer, 2 varchar). There are no null values on contents.

I recently upgraded derby to 10.1.2.1 (from 10.1.1). I tried to
"downgrade" to 10.1.1, but gives same error. The app is being
developed under Apache Tomcat 5.5.9, and derby libraries are under
$JAKARTA/commons/lib. Other queries (for authentication, as example)
are working fine.

I'll appreciate any help.




Hi -
Some time ago I encountered similar inexplicable ClassCastExceptions that stemed from having multiple versions of derby classes loaded. Check to be sure that the only file containing Derby classes in your Tomcat system is the derby.jar file in $JAKARTA/commons/lib (check the webapp WEB_INF/lib directory too). If I recall correctly my problem resulted from trying to have two versions of derby available in a single server by renaming the jars derby100.jar and derby101.jar. The server loaded classes from both jarfiles that 'stepped on each other' resulting in casting and security violations while processing internal manipulations (like aggregation).

Hope this helps

Reply via email to