Return-Path: X-Original-To: apmail-db-derby-user-archive@www.apache.org Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 6B749C769 for ; Fri, 18 May 2012 10:33:35 +0000 (UTC) Received: (qmail 67548 invoked by uid 500); 18 May 2012 10:33:35 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 67132 invoked by uid 500); 18 May 2012 10:33:30 -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 78327 invoked by uid 99); 18 May 2012 08:32:42 -0000 X-ASF-Spam-Status: No, hits=0.6 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_MED,SPF_NEUTRAL X-Spam-Check-By: apache.org Received-SPF: neutral (nike.apache.org: local policy) X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.4325 Content-Class: urn:content-classes:message Content-Transfer-Encoding: 7bit MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01CD34D0.B84657B4" Subject: a few questions to Apache Derby Database Date: Fri, 18 May 2012 10:32:11 +0200 Message-ID: <94DBD686F51F7D48BD50AEF5903779F301789CFE@he-mail2.mkliniken.loc> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: a few questions to Apache Derby Database thread-index: Ac000BZJAZD5xIzSQsaAXy9OWyq2VA== X-Priority: 1 Priority: Urgent Importance: high From: "Awad, Luay" To: This is a multi-part message in MIME format. ------_=_NextPart_001_01CD34D0.B84657B4 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable Dear All, I have the following questions to Apache Derby Database: 1. Does Derby have any limit on the database size? ( the size of = our Database is about 3,1 GB ) 2. Dose Derby have any problems to manage database sizes over 1GB? 3. We have with Derby database many performance problems, we got = some times an Out of Memory Error because of Java heap space, and our = Server was down, the error was like follows: =20 2012-02-23 12:41:58,353 ERROR - Error in ID LOGIK call: 2012-02-23 12:41:58,353 ERROR - Service: scores.GetAllCasesFiltered 2012-02-23 12:41:58,353 ERROR - Parameter: {IP=3D192.168.144.72, = MODULE_ACTIVE=3Dtrue, CASE_ID=3D*,=20 SESSION_ID=3Dzisruwoldl_C0A89048_1329995925686, DEPARTMENT=3D*, = MODUL=3D9, PROXY_MODULES=3DID_SCORER_PKMS, LASTNAME=3D*, FIRSTNAME=3D*, = WARD=3D*} 2012-02-23 12:41:58,353 ERROR - Throwable: Java heap space java.lang.OutOfMemoryError: Java heap space =20 Is it because of the size of our database (3,1 GB!)? and what can I do = to improve the performance of the Derby Database, and to resolve the = error? =20 =20 Thanks, and best regards =20 =20 Mit freundlichen Gr=C3=BC=C3=9Fen i.A. Luay Awad Informationstechnologie M=C3=A4rkische Gesundheitsholding=20 GmbH & Co. KG=20 Paulmannsh=C3=B6her Str. 14=20 D-58515 L=C3=BCdenscheid=20 Fon +49 (0) 2351- 462148 =20 =20 M=C3=A4rkische Gesundheitsholding GmbH & Co. KG Sitz und Gerichtsstand: L=C3=BCdenscheid Aufsichtsratsvorsitzender: Detlef Seidel Gesch=C3=A4ftsf=C3=BChrer: Robert Sch=C3=BCwer, PD Dr. Bernhard Schwilk, = Dr. G=C3=BCnter Peters, Matthias Germer, Johannes Josef Wittenbrink Pers=C3=B6nlich haftender Gesellschafter: M=C3=A4rkische = Gesundheitsholding Verwaltungs GmbH Amtsgericht Iserlohn HRA 4297 ------_=_NextPart_001_01CD34D0.B84657B4 Content-Type: text/html; charset="utf-8" Content-Transfer-Encoding: quoted-printable

Dear All,

I have the following questions to Apache Derby = Database:

1.       = Does Derby have any limit on the database = size? ( the size of our Database is about 3,1 = GB )

2.       = Dose Derby have any = problems to manage database sizes over 1GB?

3.       = We have with Derby = database many performance problems, we got some times  an Out of = Memory Error because of Java heap space, and our Server was down, the = error was like follows:

 

2012-02-23 12:41:58,353 = ERROR - Error in ID LOGIK call:

2012-02-23 12:41:58,353 ERROR - Service: scores.GetAllCasesFiltered<= /span>

2012-02-23 12:41:58,353 ERROR - Parameter: = {IP=3D192.168.144.72, MODULE_ACTIVE=3Dtrue, CASE_ID=3D*, =

SESSION_ID=3Dzisruwoldl_C0A89048_1329995925686, = DEPARTMENT=3D*, MODUL=3D9, PROXY_MODULES=3DID_SCORER_PKMS, LASTNAME=3D*, = FIRSTNAME=3D*, WARD=3D*}

2012-02-23 12:41:58,353 = ERROR - Throwable: Java heap = space

java.lang.OutOfMemoryError: Java heap = space

 

Is it because of the = size of our database (3,1 GB!)? and what can I do to improve the = performance of the Derby Database, and to resolve the = error?

 

 

Thanks,

and best = regards

 

 

Mit freundlichen = Gr=C3=BC=C3=9Fen
i.A.
Luay = Awad
Informationstechnologie

<= p class=3DMsoNormal>M=C3=A4rkische = Gesundheitsholding

GmbH & Co. KG =

Paulmannsh=C3=B6her= Str. 14

D-58515 = L=C3=BCdenscheid

Fon +49 (0) 2351- = 462148<= /p>

 

 
M=C3=A4rkische Gesundheitsholding = GmbH & Co. KG
Sitz und Gerichtsstand: = L=C3=BCdenscheid
Aufsichtsratsvorsitzender: Detlef = Seidel
Gesch=C3=A4ftsf=C3=BChrer: Robert = Sch=C3=BCwer, PD Dr. Bernhard Schwilk, Dr. G=C3=BCnter Peters, Matthias = Germer, Johannes Josef Wittenbrink
Pers=C3=B6nlich haftender = Gesellschafter: M=C3=A4rkische Gesundheitsholding Verwaltungs = GmbH
Amtsgericht Iserlohn HRA = 4297
------_=_NextPart_001_01CD34D0.B84657B4--