db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From jorge.martindel...@telvent.abengoa.com
Subject XJ200 error
Date Tue, 05 Dec 2006 08:43:03 GMT


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 = TO_DATE ('20060526 00:00','yyyyMMdd
HH24:Mi'),COUNTER =   CASE WHEN MOMENT = TO_DATE ('20060526
00:00','yyyyMMdd HH24:Mi') THEN COUNTER + 1 ELSE 1 END  WHERE EOP_TYPE =
'ATA_STAT_LEVEL_5' AND EOP_CODE = '20060526' AND STAT_LEVEL = '5' AND
DATE_TO_CHAR (MOMENT,'HH24:MI') = DATE_TO_CHAR (TO_DATE ('20060526
00:00','yyyyMMdd HH24:Mi'),'HH24:MI') AND CPY_CODE = '00' AND DEVICE_TYPE =
'1223' AND NODE_CODE = '001000021000090' AND NODE_TYPE = 301 AND
DEVICE_CODE = 1 AND EVENT_CODE = 127 AND ACTIVE = 1 AND EVENT_TYPE = 2 AND
DATE_TO_CHAR (MOMENT,'D') = 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=true
derby.authentication.provider=BUILTIN
derby.user.PEPE=pepito
derby.drda.host=0.0.0.0
derby.storage.pageSize=32768
derby.storage.pageCacheSize=5000


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ío

***********Internet Email Confidentiality Footer*************
This email and any files transmitted with it are confidential and intended
solely for the use of the organization or individual to whom they are
addressed.  It is expressly forbidden to retransmit or copy email and/or
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 as
neither given nor endorsed by it.


Mime
View raw message