1 Reply Latest reply on Dec 14, 2005 9:33 AM by Michal Glowacki

    Application is using wrong login data for Postgres DB

    Michal Glowacki Novice


      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):

      <!-- jboss:service=Postgres -->
      <!-- driver-class>org.postgresql.Driver</driver-class -->

      <type-mapping>PostgreSQL 8.0</type-mapping>


      So I user-name from this file is not used, why?