PostgreSQL datasource configuration

[b_boyle18]

Hi!

I am setting a CMP application with JBoss 3.0.8. I am using PostgreSQL 7.2 as my database. What I need to find out is how to set up my datasource configuration for PostgreSQL. Up until now I have just been using the default datasource Hypersonic so I'm not sure how to configure PostgreSQL. So far I have added the following to mt jbosscmp-jdbc.xml:

<defaults>
 <datasource>java:/PostgresDS</datasource>
 <datasource-mapping>PostgreSQL</datasource-mapping>
 <preferred-relation-mapping>foreign-key</preferred-relation-mapping>
 </defaults>

Does anyone have any experience with PostgreSQL and CMP?
Thanks for your help,
B

[b_boyle18]

I found out how to do it. There is a file called PostgreSQL-service.aml in jboss and I just modified it and put it in my deploy directory.