0 Replies Latest reply on Feb 28, 2003 10:41 AM by Jan Nielsen

    "Unable to locate type name 'double' in catalog"

    Jan Nielsen Newbie

      I wanted to switch my JBoss 3.0.6 from using HypersonicDB to PostgreSQL 7.2.1 running on a Linux box.

      I just removed "server/default/deploy/hypersonic-service.xml" and moved "docs/examples/jca/postgres-service.xml" into "server/default/deploy" after I changed the JNDI name of the service to "DefaultDS". Then I changed data type mapping to "PostgreSQL 7.2" in "server/default/conf/standardjaws.xml" and "server/default/conf/standardjbosscmp-jdbc.xml".

      When when I deploy my EJBs at this point, I get the following exception:

      org.jboss.deployment.DeploymentException: Error while creating table; - nested throwable: (java.sql.SQLException: ERROR: Unable to locate type name 'double' in catalog
      at org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.createTable(JDBCStartCommand.java:175)
      at org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.execute(JDBCStartCommand.java:84)

      What is wrong? JBoss's autonumber EJB seems to deploy fine, but then again I don't think it uses the double type.

      Best regards,
      Jan Nielsen