Hi Peter and ty. I would also like to know if there is no recommended default based on version of postgresql being used? Additionally i would appreciate if someone could explain the optional "<!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml (optional) -->
<metadata>
<type-mapping>PostgreSQL 7.2</type-mapping>
</metadata>
</local-tx-datasource>"