>From what I read this is what I do...

place this (postgres-ds.xml) file in deploy-hasingleton

  <?xml version="1.0" encoding="UTF-8" ?> 
  | - <!--  
===================================================================== 
  |   --> 
  | - <!--                                                                      
  
  |   --> 
  | - <!--   JBoss Server Configuration                                         
  
  |   --> 
  | - <!--                                                                      
  
  |   --> 
  | - <!--  
===================================================================== 
  |   --> 
  | - <!--  $Id: postgres-ds.xml,v 1.3.2.1 2006/02/07 14:23:00 acoliver Exp $ 
  |   --> 
  | - <!--  
==================================================================== 
  |   --> 
  | - <!--   Datasource config for Postgres                                     
 
  |   --> 
  | - <!--  
==================================================================== 
  |   --> 
  | - <datasources>
  | - <local-tx-datasource>
  |   <jndi-name>PostgresDS</jndi-name> 
  |   <connection-url>jdbc:postgresql://localhost:5432/test</connection-url> 
  |   <driver-class>org.postgresql.Driver</driver-class> 
  |   <user-name>dev</user-name> 
  |   <password>dev</password> 
  | - <!--  sql to call when connection is created.  Can be anything, select 1 
is valid for PostgreSQL
  |         <new-connection-sql>select 1</new-connection-sql>
  |         
  |   --> 
  | - <!--  sql to call on an existing pooled connection when it is obtained 
from pool.  Can be anything, select 1 is valid for PostgreSQL
  |         <check-valid-connection-sql>select 1</check-valid-connection-sql>
  |         
  |   --> 
  | - <!--  corresponding type-mapping in the standardjbosscmp-jdbc.xml 
(optional) 
  |   --> 
  | - <metadata>
  |   <type-mapping>PostgreSQL 8.0</type-mapping> 
  |   </metadata>
  |   </local-tx-datasource>
  |   </datasources>

place the postgres jdbc driver in server/all/lib

When I start JBoss I see the following in the output:

15:47:53,515 INFO  [ConnectionFactoryBindingService] Bound ConnectionManager 
'jboss.jca:service=DataSourceBinding,name=PostgresDS' to JNDI name 
'java:PostgresDS'

Is that all there is too it? If so great, I'm ready to rock-n-roll and thanks 
for the help. If there's more, please let me know. 

Thanks for the quick response.

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

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


_______________________________________________
JBoss-user mailing list
JBoss-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jboss-user

Reply via email to