Return-Path: Delivered-To: apmail-incubator-empire-db-dev-archive@minotaur.apache.org Received: (qmail 2726 invoked from network); 25 Feb 2009 08:47:28 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 25 Feb 2009 08:47:28 -0000 Received: (qmail 9598 invoked by uid 500); 25 Feb 2009 08:47:27 -0000 Delivered-To: apmail-incubator-empire-db-dev-archive@incubator.apache.org Received: (qmail 9438 invoked by uid 500); 25 Feb 2009 08:47:27 -0000 Mailing-List: contact empire-db-dev-help@incubator.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: empire-db-dev@incubator.apache.org Delivered-To: mailing list empire-db-dev@incubator.apache.org Received: (qmail 9408 invoked by uid 99); 25 Feb 2009 08:47:26 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 25 Feb 2009 00:47:26 -0800 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: local policy) Received: from [217.7.226.111] (HELO mail.esteam.de) (217.7.226.111) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 25 Feb 2009 08:47:16 +0000 Content-class: urn:content-classes:message Subject: re: update on the new drivers (h2, postgresql, derby) MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Date: Wed, 25 Feb 2009 09:46:55 +0100 X-MimeOLE: Produced By Microsoft Exchange V6.5 Message-ID: In-Reply-To: <3ab983230902241539i6364916dv4d7f10b47ac7627e@mail.gmail.com> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: re: update on the new drivers (h2, postgresql, derby) Thread-Index: AcmW2TbdBTpiPnGhQ3G3seIjlxsoxwAS+JvQ References: <3ab983230902241539i6364916dv4d7f10b47ac7627e@mail.gmail.com> From: =?iso-8859-1?Q?Rainer_D=F6bele?= To: X-Virus-Checked: Checked by ClamAV on apache.org Hi Francis, yes, this is nothing we can handle in the core. I would catch the exception, and then check if it's the h2 driver and = give a hint, that this is a known limitation of h2. Regards, Rainer Francis De Brabandere wrote: > re: update on the new drivers (h2, postgresql, derby) >=20 > postgresql now works with both demo apps (had to tweak the apps) > derby now works with both demo apps >=20 > h2 fails on the advanced app: >=20 > DEBUG [2009/02/25 00:25]: Executing: ALTER TABLE EMPLOYEES ADD FOO > VARCHAR(20) at > org.apache.empire.db.DBSQLScript.run(DBSQLScript.java:112) > ERROR [2009/02/25 00:25]: org.h2.jdbc.JdbcSQLException: Operation not > supported for table EMPLOYEES when there are views on the table: > EMPLOYEE_INFO_VIEW [90122-107] >=20 > Make exception in the example code for this driver? >=20 >=20 >=20 > -- > http://www.somatik.be > Microsoft gives you windows, Linux gives you the whole house.