[jboss-user] [Datasource Configuration] - IJ000453: Unable to get managed connection for java:jboss/datasources/<DataSource>

[Sam C]

Sam C [https://community.jboss.org/people/darkcloudi] created the discussion

"IJ000453: Unable to get managed connection for java:jboss/datasources/<DataSource>"

To view the discussion, visit: https://community.jboss.org/message/805286#805286

--------------------------------------------------------------
I am trying to setup JBOSS connection to postgres, connection details below, but get an error where it is failing to connect. Any ideas what needs to be done? i am new to JBoss and Postgres. I got data in my STOCK schema but cannot figure out why it cannot make a connection when I go to the webpage localhost:8080/example 

This is a very simple app and does nothing exciting other then authenticate.

web.xml contains the following with some other stuff but this is the authentication
  <login-config>
       <auth-method>BASIC</auth-method>
       <realm-name>Stock</realm-name>
  </login-config>

Stock-ds.xml (Found in deployments directory)
<?xml version="1.0" encoding="UTF-8"?>
<datasources xmlns=" http://www.jboss.org/ironjacamar/schema http://www.jboss.org/ironjacamar/schema">
 <datasource jndi-name="java:jboss/datasources/StockDatasource" enabled="true" 
     use-java-context="true" pool-name="StockDatasource">
  <connection-url>jdbc:postgresql://localhost:5432/postgres</connection-url>
  <driver>postgresql-8.4-703.jdbc4.jar</driver>
  <pool></pool>
  <security>
   <user-name>postgres</user-name>
   <password>password</password>
  </security>
 </datasource>
</datasources>

standalone.xml
|              | <security-domain name="Stock" cache-type="default"> |
|                  | <authentication> |
|                      | <login-module code="Database" flag="required"> |
|                          | <module-option name="dsJndiName" value="java:jboss/datasources/StockDatasource"/> |
|                          | <module-option name="principalsQuery" value="select password from STOCK.USER where username=?"/> |
|                          | <module-option name="rolesQuery" value="select rolename, 'Roles' from STOCK.ROLE r, STOCK.USER u where u.userid=r.userid and u.username=?"/> |
|                      | </login-module> |
|                  | </authentication> |
|              | </security-domain> |

The error i get is:
*Caused by: javax.resource.ResourceException: IJ000453: Unable to get managed connection for java:jboss/datasources/StockDatasource*
    at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.getManagedConnection(AbstractConnectionManager.java:390)
    at org.jboss.jca.core.connectionmanager.tx.TxConnectionManagerImpl.getManagedConnection(TxConnectionManagerImpl.java:368)
    at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.allocateConnection(AbstractConnectionManager.java:464)
    at org.jboss.jca.adapters.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:139)
    ... 29 more
Caused by: javax.resource.ResourceException: IJ000658: Unexpected throwable while trying to create a connection: null
    at org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreArrayListManagedConnectionPool.getConnection(SemaphoreArrayListManagedConnectionPool.java:371)
    at org.jboss.jca.core.connectionmanager.pool.AbstractPool.getSimpleConnection(AbstractPool.java:397)
    at org.jboss.jca.core.connectionmanager.pool.AbstractPool.getConnection(AbstractPool.java:365)
    at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.getManagedConnection(AbstractConnectionManager.java:329)
    ... 32 more
Caused by: javax.resource.ResourceException: Could not create connection
    at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.getLocalManagedConnection(LocalManagedConnectionFactory.java:277)
    at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:235)
    at org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreArrayListManagedConnectionPool.createConnectionEventListener(SemaphoreArrayListManagedConnectionPool.java:761)
    at org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreArrayListManagedConnectionPool.getConnection(SemaphoreArrayListManagedConnectionPool.java:343)
    ... 35 more
Caused by: org.postgresql.util.PSQLException: FATAL: Ident authentication failed for user "postgres"
--------------------------------------------------------------

Reply to this message by going to Community
[https://community.jboss.org/message/805286#805286]

Start a new discussion in Datasource Configuration at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2077]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-user/attachments/20130328/b97b51a1/attachment.html