incubator-empire-db-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rainer Döbele <doeb...@esteam.de>
Subject re: update on the new drivers (h2, postgresql, derby)
Date Wed, 25 Feb 2009 08:46:55 GMT
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.

Mime
View raw message