Hi
I want to connect to postgres in my stateless session, I have put postgres-ds.xml in deploy directory already, and I have following problem. I have username and password "root" in my postgres-ds.xml, and application is trying to connect with username "postgres" and no password and I get the error (from server log):
[...]
2005-12-13 00:52:32,531 DEBUG [org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory] Using properties: {user=postgres, password=--hidden--}
2005-12-13 00:52:32,546 WARN [org.jboss.resource.connectionmanager.JBossManagedConnectionPool] Throwable while attempting to get a new connection: null
org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (org.postgresql.util.PSQLException: Connection refused: FATAL: password authentication failed for user "postgres".)
[...]
This error occurs in following line:
final String dbName = "java:/PostgresDS";
try {
InitialContext ic = new InitialContext();
DataSource ds = (DataSource) ic.lookup(dbName);
Connection conn = ds.getConnection("root","root");
}
and that's my postgres-ds.xml file (in server/default/deploy directory):
<local-tx-datasource>
<!-- jboss:service=Postgres -->
<jndi-name>PostgresDS</jndi-name>
<connection-url>jdbc:postgresql://localhost:5432/my_db</connection-url>
<!-- driver-class>org.postgresql.Driver</driver-class -->
<driver-class>org.postgresql.jdbc3.Jdbc3PoolingDataSource</driver-class>
<user-name>root</user-name>
root
<security-domain>PostgresDbRealm</security-domain>
<type-mapping>PostgreSQL 8.0</type-mapping>
</local-tx-datasource>
So I user-name from this file is not used, why?
don't know why, but BB has cut password tags in postgres-ds.xml, but I have got them in file, so it's not the cause.