Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 94640 invoked from network); 5 Dec 2006 08:47:22 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 5 Dec 2006 08:47:22 -0000 Received: (qmail 42161 invoked by uid 500); 5 Dec 2006 08:47:29 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 42128 invoked by uid 500); 5 Dec 2006 08:47:29 -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 Delivered-To: moderator for derby-user@db.apache.org Received: (qmail 38255 invoked by uid 99); 5 Dec 2006 08:43:38 -0000 X-ASF-Spam-Status: No, hits=0.6 required=10.0 tests=NO_REAL_NAME X-Spam-Check-By: apache.org Received-SPF: pass (herse.apache.org: local policy) Subject: XJ200 error To: derby-user@db.apache.org X-Mailer: Lotus Notes Release 6.5.3 September 14, 2004 Message-ID: From: jorge.martindelrio@telvent.abengoa.com Date: Tue, 5 Dec 2006 09:43:03 +0100 X-MIMETrack: Serialize by Router on Internet/Siatec/Abengoa(Release 6.5.4|March 27, 2005) at 05/12/2006 09:43:27 MIME-Version: 1.0 Content-type: text/plain; charset=ISO-8859-1 Content-transfer-encoding: quoted-printable X-Virus-Checked: Checked by ClamAV on apache.org Hi all, after using Apache Derby some time i have the following error: "Exceeded maximum number of sections 32K" The sql sentence that i want to run is the following: UPDATE ALARM_STATISTICS SET MOMENT =3D TO_DATE ('20060526 00:00','yyyyM= Mdd HH24:Mi'),COUNTER =3D CASE WHEN MOMENT =3D TO_DATE ('20060526 00:00','yyyyMMdd HH24:Mi') THEN COUNTER + 1 ELSE 1 END WHERE EOP_TYPE = =3D 'ATA_STAT_LEVEL_5' AND EOP_CODE =3D '20060526' AND STAT_LEVEL =3D '5' A= ND DATE_TO_CHAR (MOMENT,'HH24:MI') =3D DATE_TO_CHAR (TO_DATE ('20060526 00:00','yyyyMMdd HH24:Mi'),'HH24:MI') AND CPY_CODE =3D '00' AND DEVICE_= TYPE =3D '1223' AND NODE_CODE =3D '001000021000090' AND NODE_TYPE =3D 301 AND DEVICE_CODE =3D 1 AND EVENT_CODE =3D 127 AND ACTIVE =3D 1 AND EVENT_TYP= E =3D 2 AND DATE_TO_CHAR (MOMENT,'D') =3D DATE_TO_CHAR (to_date('20060526 00:00','yyyyMMDD HH24:mi'),'D'); DATE_TO_CHAR is a user defined function that works fine. This is the content of the derby.properties file: derby.connection.requireAuthentication=3Dtrue derby.authentication.provider=3DBUILTIN derby.user.PEPE=3Dpepito derby.drda.host=3D0.0.0.0 derby.storage.pageSize=3D32768 derby.storage.pageCacheSize=3D5000 I need help to determine which the problem is and what do i have to do = to solve the problem. Thanks in advance, Best Regards, Jorge Martin del R=EDo ***********Internet Email Confidentiality Footer************* This email and any files transmitted with it are confidential and inten= ded solely for the use of the organization or individual to whom they are addressed. It is expressly forbidden to retransmit or copy email and/o= r this attached files without our permission . If you are not the addressee indicated in this message (or responsible for delivery of the= message to such person), you may not copy or deliver this message to anyone. In such case, you should destroy this message and kindly notify the sender by reply email. Please advise immediately if you or your employer does not consent to Internet email for messages of this kind. Opinions, conclusions and other information in this message that= do not relate to the official business of my firm shall be understood a= s neither given nor endorsed by it.=