[JBoss-user] parser error SOLVED => this is not funny

[SainTiss]

Hi,

I found out what caused the parser error in my previous post by enabling
postgreSQL's logging...

The point is that JBoss is issuing the following query to postgreSQL:


CREATE TABLE adres (ADRES_ID VARCHAR(255) NOT NULL, STRAAT VARCHAR(255),
HUISNUMMER INTEGER(9) NOT NULL, BUS INTEGER(9) NOT NULL, POSTCODE
INTEGER(9) NOT NULL, GEMEENTE VARCHAR(255), KLANT_PER_EVD_FK
VARCHAR(255), CONSTRAINT pk_adres PRIMARY KEY (ADRES_ID));


PostgreSQL, however, doesn't recognize INTEGER(9), and gives "parse
error at '('"...

So I guess this is a JBoss bug then, but how do I fix it?

I didn't find something like "INTEGER(9)" in standardjbosscmp-jdbc.xml
for example...

Thanks

Hans

signature.asc
Description: This is a digitally signed message part