1 Reply Latest reply on Jan 24, 2004 10:16 AM by b_boyle18

    PostgreSQL datasource configuration

    b_boyle18 Newbie

      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