Joachim,

>
>I have found that an undeclared VARCHAR is not accepted, so I will
>replace those with VARCHAR(50), but there are other stuff, which I
>don't even know what they are doing in HSQLDB, like this column phrase
>for example: "BATCHTRADEVOLUMEBUY VARCHAR(255),AK_INTERNALBATCHID
>INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0)  NOT NULL
>PRIMARY KEY)"
>  
>

AK_INTERNALBATCHID INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0)

would become:

AK_INTERNALBATCHID INTEGER GENERATED ALWAYS AS IDENTITY(START WITH 0)



Ed