Sam C
2013-03-28 12:49:18 UTC
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]
"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]