ok, i got the problem.... it wasn't the data source configuration, that one worked already fine....
but my jdbc-tracer tool unveiled the problem:
one of my entity bean had a CMP Field date, and RI creates a table as follows:
CREATE TABLE (..., "date" DATE, ...)
but JBoss creates tables slightly different:
CREATE TABLE (..., date DATE, ...)
HyperSonicDB doesn't care about a column name equaling a data type, but cloudscape *DOES*.
So I changed the name of the CMP Field and it works fine now. But is there a way to make JBoss use the quotation marks too?
greets - torben