2 Replies Latest reply on Oct 19, 2002 4:21 AM by Henrik Andersson

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

    Henrik Andersson Newbie


      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/