Webical with a Derby database?

[Harm-Jan Zwinderman]

Hi,

Searching for an agenda application I did encounter Webical.
It looks very nice and well suited for my needs.

I downloaded the .war 0.4.1 download and tried to use it with a Derby
database on Tomcat.

Webical throws a HibernateException exception because it encounters a
wrong column type for field customPageTitle. It needs a mediumtext
data type for that field.

Now mediumtext is not a data type known in Derby.
Therefore I defined the field as VARCHAR (also tried CLOB) in my Derby
database.

Changing in file applicationContext(-release).xml the property
'hibernate.dialect' from 'org.hibernate.dialect.MySQLDialect' to
org.hibernate.dialect.DerbyDialect changed the text of the
HibernateException to
customPageTitle, expected: varchar(2000000).

The Derby database does not allow VARCHAR larger than 32,672
characters.
So I am now stuck on how to continue.

If there are still active members in this project.
Does anybody know how I can use Webical with a Derby Database?

Kind regards,

--
Harm-Jan Zwinderman
http://Cebuned.svipr.nl