From derby-user-return-2931-apmail-db-derby-user-archive=db.apache.org@db.apache.org Wed Dec 07 16:08:50 2005 Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 97819 invoked from network); 7 Dec 2005 16:08:49 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 7 Dec 2005 16:08:49 -0000 Received: (qmail 46340 invoked by uid 500); 7 Dec 2005 12:04:39 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 46129 invoked by uid 500); 7 Dec 2005 12:04:37 -0000 Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: List-Id: Reply-To: "Derby Discussion" Delivered-To: mailing list derby-user@db.apache.org Received: (qmail 46116 invoked by uid 99); 7 Dec 2005 12:04:37 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 07 Dec 2005 04:04:37 -0800 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: local policy) Received: from [200.192.140.24] (HELO adsl.plugin.com.br) (200.192.140.24) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 07 Dec 2005 04:04:35 -0800 Received: from [192.168.0.75] ([201.40.179.141]) (authenticated bits=0) by adsl.plugin.com.br (8.12.8/8.13.1) with ESMTP id jB7C42dE015988 for ; Wed, 7 Dec 2005 10:04:03 -0200 Message-ID: <4396CF07.7000508@mgrinformatica.com.br> Date: Wed, 07 Dec 2005 10:01:11 -0200 From: Edson Carlos Ericksson Richter User-Agent: Mozilla Thunderbird 1.0.6 (Windows/20050716) X-Accept-Language: pt-br, pt MIME-Version: 1.0 To: derby-user@db.apache.org Subject: ClassCastException in CountAggregator Content-Type: multipart/mixed; boundary="------------010303030509070808040602" X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N This is a multi-part message in MIME format. --------------010303030509070808040602 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit 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. --------------010303030509070808040602 Content-Type: text/x-vcard; charset=utf-8; name="edson.richter.vcf" Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename="edson.richter.vcf" begin:vcard fn:Edson Carlos Ericksson Richter n:Richter;Edson org;quoted-printable:MGR Inform=C3=A1tica Ltda;Desenvolvimento adr:Cristo Redentor;;Assis Brasil, 3257, Sala 409;Porto Alegre;RS;91010007;Brasil email;internet:edson.richter@mgrinformatica.com.br title:Diretor de Sistemas tel;work:(51)3347-0446 tel;cell:(51)9259-2993 x-mozilla-html:FALSE url:http://www.mgrinformatica.com.br version:2.1 end:vcard --------------010303030509070808040602--