[jboss-user] [Installation, Configuration & Deployment] - Re: Setting DefaultDS to use Postgresql in JBoss AS 5.0.0 Be

[PeterJ]

Do this:

1) Copy docs/examples/jca/postgres-ds.xml to server/xxx/deploy

2) Edit the postgres-ds.xml to contain information for your database.

3) Add a < metadata > entry to postgres-ds.xml (you need this to get some of the services to work correctly):

<datasources>
  |   <local-tx-datasource>
  |     . . .
  |     <metadata>
  |       <type-mapping>PostgreSQL 8.0</type-mapping>
  |     </metadata>
  |   </local-tx-datasource>
  | </datasources>

4) Delete the server/xxx/deploy/hsqldb-ds.xml file

5) Start the server. Any required tables are created automatically. 

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4049380#4049380

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4049380