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.createManagedConnection(LocalManagedConnectionFactory.java:150) at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.createConnectionEventListener(InternalManagedConnectionPool.java:455) at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getConnection(InternalManagedConnectionPool.java:214) at org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BasePool.getConnection(JBossManagedConnectionPool.java:496) at org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:425) at org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionManager.java:318) at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:477) at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:814) at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.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.