"jaikiran" wrote : What does your datasource file look like? And also which jars
did you copy to the server/< serverName>/lib folder?
|
My postgres-ds.xml looks:
| <?xml version="1.0" encoding="UTF-8"?>
|
| <!-- Datasource config for Postgres -->
|
| <datasources>
| <local-tx-datasource>
| <jndi-name>DefaultDS</jndi-name>
| <connection-url>jdbc:postgresql://[servername]:[port]/[database
name]</connection-url>
| <driver-class>org.postgresql.Driver</driver-class>
| <user-name>jboss</user-name>
| <password>jboss</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 -->
| <metadata>
| <type-mapping>PostgreSQL 8.0</type-mapping>
| </metadata>
| </local-tx-datasource>
|
| </datasources>
|
I copied postgresql-8.1-412.jdbc3.jar into lib directory (I'm using PostgreSQL 8.1.11
on Solaris10)
A DB connection with psql client works fine
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4160866#...
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...