password authentication error

From: "Sriram Dandapani" <sdandapani(at)counterpane(dot)com>
To: <pgsql-jdbc(at)postgresql(dot)org>
Subject: password authentication error
Date: 2006-05-16 20:44:06
Message-ID: 6992E470F12A444BB787B5C937B9D4DF045AEFCA@ca-mail1.cis.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Hi

I keep getting this error

Could not create connection; - nested throwable: (Something unusual has
occured to cause the driver to fail. Please report this exception:
Exception: java.sql.SQLException: FATAL: password authentication failed
for user "dataman" Stack Trace: java.sql.SQLException: FATAL: password
authentication failed for user "dataman" at
org.postgresql.Connection.openConnection(Connection.java:178) at
org.postgresql.Driver.connect(Driver.java:149) at
org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.crea
teManagedConnection(LocalManagedConnectionFactory.java:150) at
org.jboss.resource.connectionmanager.InternalManagedConnectionPool.creat
eConnectionEventListener(InternalManagedConnectionPool.java:455) at
org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getCo
nnection(InternalManagedConnectionPool.java:214) at
org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BasePool
.getConnection(JBossManagedConnectionPool.java:496) at
org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedCo
nnection(BaseConnectionManager2.java:425) at
org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConne
ction(TxConnectionManager.java:318) at
org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConn
ection(BaseConnectionManager2.java:477) at
org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionMa
nagerProxy.allocateConnection(BaseConnectionManager2.java:814) at
org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperD
ataSource.java:102) at

<local-tx-datasource>

<jndi-name>fwdb01DS</jndi-name>


<connection-url>jdbc:postgresql://fwdb10.sv.counterpane.com:5432/fwdb01<
/connection-url>

<driver-class>org.postgresql.Driver</driver-class>

<user-name>dataman</user-name>

<password>0rak1ller</password>


<transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation
>

<max-pool-size>25</max-pool-size>

<min-pool-size>5</min-pool-size>

</local-tx-datasource>

This happens sporadically.. I have to reload pg_hba.conf and restart
jboss for the error to go away..and after a few minutes, it reappears.

The postgres driver is postgresql-8.1-404.jar and my pg_hba allows
trusted access to the box issuing this jdbc connections.

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Dave Cramer 2006-05-16 21:47:06 Re: COPY rehashed
Previous Message Chuck Davis 2006-05-16 19:06:00 Re: JDBC driver and java strings