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
What is wrong? JBoss's autonumber EJB seems to deploy fine, but then again I don't think it uses the double type.