First things first, ensure that you can actually connect to the database 
instance using the address and port you have given in the jboss-jdbc.xml file 
by using the psql commandline utility (psql -H A -p P D).

Secondly, I have mine working on windows with the following connection settings 
in $(jboss)/server/default/deploy/postgres-ds.xml:


  | <datasources>
  |   <local-tx-datasource>
  |     <jndi-name>ModularEVD</jndi-name>
  |     
<connection-url>jdbc:postgresql://192.168.62.54:5432/evd</connection-url>
  |     <driver-class>org.postgresql.Driver</driver-class>
  |     <user-name>evd</user-name>
  |     <password>evd</password>
  |   </local-tx-datasource>
  |   
  |   <local-tx-datasource>
  |     <jndi-name>PostgresDS</jndi-name>
  |     
<connection-url>jdbc:postgresql://192.168.62.54:5432/evd</connection-url>
  |     <driver-class>org.postgresql.Driver</driver-class>
  |     <user-name>jboss</user-name>
  |     <password>jboss</password>
  |         <!-- sql to call when connection is created
  |         <new-connection-sql>some arbitrary sql</new-connection-sql>
  |         -->
  | 
  |         <!-- sql to call on an existing pooled connection when it is 
obtained from pool 
  |         <check-valid-connection-sql>some arbitrary 
sql</check-valid-connection-sql>
  |         -->
  | 
  |   </local-tx-datasource>
  | 
  | </datasources>
  | 
  | 

I have never seen it done through a property-ds.xml file but that's probably 
just me :P

Hope it helps.

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

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


-------------------------------------------------------
This SF.Net email is sponsored by Yahoo.
Introducing Yahoo! Search Developer Network - Create apps using Yahoo!
Search APIs Find out how you can build Yahoo! directly into your own
Applications - visit http://developer.yahoo.net/?fr=offad-ysdn-ostg-q22005
_______________________________________________
JBoss-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/jboss-user

Reply via email to