"Wrong data type: TEXT" while trying to deploy example

[hean]

Hi!

I am trying to deploy the cmp2 template with PostgreSQL 7.2 and JBoss 3.0.2 but I'm getting:

21:54:57,576 INFO [EjbModule] Creating
21:54:57,867 INFO [EjbModule] Deploying OrganizationEJB
21:54:59,235 INFO [EjbModule] Deploying GangsterEJB
21:54:59,450 INFO [EjbModule] Deploying JobEJB
21:54:59,712 INFO [EjbModule] Deploying EJBTestRunnerEJB
21:55:00,814 INFO [EjbModule] Created
21:55:00,820 INFO [EjbModule] Starting
21:55:12,132 WARN [ServiceController] Problem starting service jboss.j2ee:service=EJB,jndiName=crimeportal/Job
org.jboss.deployment.DeploymentException: Error while creating table; - nested throwable: (java.sql.SQLException: Wrong data type: TEXT in statement [CREATE TABLE ORGANIZATION (name TEXT NOT NULL, descr TEXT NOT NULL, the_boss INT4, CONSTRAINT PK_ORGANIZATION PRIMARY KEY (name))])
at org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.createTable(JDBCStartCommand.java:175)

Anyone knows what I have done wrong? I tried to follow the instructions in http://www.jboss.org/modules/bb/index.html?module=bb&op=viewtopic&t=forums/

[delirium]

It sounds like the JBoss deployer doesn't recognize the PostgreSQL data types... make sure you're pointing to the correct datasource in the jbosscmp-jdbc.xml file for the cmp2 example, and make sure the datasource-mapping is set to "PostgreSQL 7.2". If PostgreSQL is your default datasource, you also need to change the datasource-mapping in standardjbosscmp-jdbc.xml (in the conf directory). Other than that I don't know what the problem could be...

[hean]

I had forgotten a line where it still stood Hypersonic.

Thanks a lot!