You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@empire-db.apache.org by Francis De Brabandere <fr...@gmail.com> on 2009/02/25 00:39:29 UTC
update on the new drivers (h2, postgresql, derby)
postgresql now works with both demo apps (had to tweak the apps)
derby now works with both demo apps
h2 fails on the advanced app:
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]
Make exception in the example code for this driver?
--
http://www.somatik.be
Microsoft gives you windows, Linux gives you the whole house.
Re: update on the new drivers (h2, postgresql, derby)
Posted by Francis De Brabandere <fr...@gmail.com>.
ok, this has all been taken care of
On Wed, Feb 25, 2009 at 9:46 AM, Rainer Döbele <do...@esteam.de> wrote:
> 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)
>>
>> postgresql now works with both demo apps (had to tweak the apps)
>> derby now works with both demo apps
>>
>> h2 fails on the advanced app:
>>
>> 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]
>>
>> Make exception in the example code for this driver?
>>
>>
>>
>> --
>> http://www.somatik.be
>> Microsoft gives you windows, Linux gives you the whole house.
>
--
http://www.somatik.be
Microsoft gives you windows, Linux gives you the whole house.
re: update on the new drivers (h2, postgresql, derby)
Posted by Rainer Döbele <do...@esteam.de>.
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)
>
> postgresql now works with both demo apps (had to tweak the apps)
> derby now works with both demo apps
>
> h2 fails on the advanced app:
>
> 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]
>
> Make exception in the example code for this driver?
>
>
>
> --
> http://www.somatik.be
> Microsoft gives you windows, Linux gives you the whole house.