-
1. Re: Changing to Postgres
acristi Jul 19, 2003 12:54 PM (in response to joeyt)I have the same configuration and it works great. Did you use in defaults body standardjbosscmp-jdbc.xml:
java:/jdbc/NetBizDS
<datasource-mapping>PostgreSQL 7.2</datasource-mapping>
<create-table>true</create-table>
<remove-table>false</remove-table>
<read-only>false</read-only>
<time-out>300</time-out>
<pk-constraint>true</pk-constraint>
<fk-constraint>true</fk-constraint>
<row-locking>true</row-locking>
<preferred-relation-mapping>foreign-key</preferred-relation-mapping>
<read-ahead>
on-load
<page-size>1000</page-size>
<eager-load-group>*</eager-load-group>
</read-ahead>
<list-cache-max>1000</list-cache-max>
<unknown-pk>
<key-generator-factory>UUIDKeyGeneratorFactory</key-generator-factory>
<unknown-pk-class>java.lang.String</unknown-pk-class>
<jdbc-type>VARCHAR</jdbc-type>
<sql-type>VARCHAR(32)</sql-type>
</unknown-pk>
<entity-command name="default"/>
You should use <datasource-mapping>PostgreSQL 7.2</datasource-mapping> ... it's type mapping is defined somewhere down to the end of file. Do not change their order!
JBoss uses Hypersonic for JMS. In order to use PostgreSQL in your EJBs you have to specify in ejb deployment files this datasource and datasource-mapping ... (PostgreSQL 7.2)