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>
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.