problem in Datasource configuration.

[dinsceg]

Hi,

I am using

     JBoss- 5.1.0GA.

     Oracle -10g,ojdbc14.jar

     Java - jdk 1.6           

If i start the jboss server i m getting this exception.I configured data source file .

Can anyone tell me what this error means..

22:58:12,694 ERROR [DataSourceIdentityStore] [getDBConnection()]:0/null]Unable to get managed connection for jdbc/SSO; - nested throwable: (javax.resource.ResourceException: Unable to get managed connection for jdbc/SSO)

22:58:12,694 ERROR [SSOIdentityManagerSOAPBindingImpl] Exception while getting connection:

Unable to get managed connection for jdbc/SSO; - nested throwable: (javax.resource.ResourceException: Unable to get managed connection for jdbc/SSO)

org.josso.gateway.identity.exceptions.SSOIdentityException: Exception while getting connection:

Unable to get managed connection for jdbc/SSO; - nested throwable: (javax.resource.ResourceException: Unable to get managed connection for jdbc/SSO).

This is my oracle-ds.xml

<?xml version="1.0" encoding="UTF-8"?>

<datasources>

<local-tx-datasource>

<jndi-name>jdbc/SSO</jndi-name>

<connection-url>jdbc:oracle:thin:@localhost:1521:crm</connection-url>

<driver-class>oracle.jdbc.OracleDriver</driver-class>

<user-name>*****</user-name>

<password>*****</password>

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

<max-pool-size>20</max-pool-size>

<idle-timeout-minutes>1</idle-timeout-minutes>

</local-tx-datasource>

</datasources>

[jaikiran]

The root cause isn't shown in that error message. Please post the entire exception stacktrace.

[dinsceg]

Hi jaikiran,

Thanks for your reply..

22:58:12,692 WARN [JBossManagedConnectionPool] Throwable while attempting to get a new connection: null
org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: Io exception: Got minus one from a read call)
at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.getLocalManagedConnection(LocalManagedConnectionFactory.java:225)
at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:195)
at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.createConnectionEventListener(InternalManagedConnectionPool.java:633)
at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getConnection(InternalManagedConnectionPool.java:267)
at org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BasePool.getConnection(JBossManagedConnectionPool.java:622)
at org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:404)
at org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionManager.java:381)
at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:496)
at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:941)
at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:89)
at org.josso.gateway.identity.service.store.db.DataSourceIdentityStore.getDBConnection(DataSourceIdentityStore.java:105)
at org.josso.gateway.identity.service.store.db.AbstractDBIdentityStore.loadUser(AbstractDBIdentityStore.java:91)
at org.josso.gateway.identity.service.SSOIdentityManagerImpl.findUserInSession(SSOIdentityManagerImpl.java:100)
at org.josso.gateway.ws._1_2.wsdl.SSOIdentityManagerSOAPBindingImpl.findRolesBySSOSessionId(SSOIdentityManagerSOAPBindingImpl.java:152)
at org.josso.gateway.ws._1_2.wsdl.SSOIdentityManagerSOAPBindingSkeleton.findRolesBySSOSessionId(SSOIdentityManagerSOAPBindingSkeleton.java:170)
at sun.reflect.GeneratedMethodAccessor521.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.axis.providers.java.RPCProvider.invokeMethod(RPCProvider.java:397)
at org.apache.axis.providers.java.RPCProvider.processMessage(RPCProvider.java:186)
at org.apache.axis.providers.java.JavaProvider.invoke(JavaProvider.java:323)
at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:32)
at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118)
at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83)
at org.apache.axis.handlers.soap.SOAPService.invoke(SOAPService.java:454)
at org.apache.axis.server.AxisServer.invoke(AxisServer.java:281)
at org.apache.axis.transport.http.AxisServlet.doPost(AxisServlet.java:699)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:235)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:190)
at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:92)
at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.process(SecurityContextEstablishmentValve.java:126)
at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.invoke(SecurityContextEstablishmentValve.java:70)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:158)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:330)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:829)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:598)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
at java.lang.Thread.run(Thread.java:619)
Caused by: java.sql.SQLException: Io exception: Got minus one from a read call
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:255)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:387)
at oracle.jdbc.driver.PhysicalConnection.(PhysicalConnection.java:414)
at oracle.jdbc.driver.T4CConnection.(T4CConnection.java:165)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)
at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.getLocalManagedConnection(LocalManagedConnectionFactory.java:207)
... 49 more
22:58:12,694 ERROR [DataSourceIdentityStore] [getDBConnection()]:0/null]Unable to get managed connection for jdbc/SSO; - nested throwable: (javax.resource.ResourceException: Unable to get managed connection for jdbc/SSO)
22:58:12,694 ERROR [SSOIdentityManagerSOAPBindingImpl] Exception while getting connection:
Unable to get managed connection for jdbc/SSO; - nested throwable: (javax.resource.ResourceException: Unable to get managed connection for jdbc/SSO)
org.josso.gateway.identity.exceptions.SSOIdentityException: Exception while getting connection:
Unable to get managed connection for jdbc/SSO; - nested throwable: (javax.resource.ResourceException: Unable to get managed connection for jdbc/SSO)

Thanks in Advance

Dinesh.

[jaikiran]

Caused by: java.sql.SQLException: Io exception: Got minus one from a read call
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)

Looks like the JDBC driver problem. Make sure you are using the correct driver version and driver jar file.

[dinsceg]

Thanks for your reply.

I m using ojdbc14.jar and oracle 10g in jdk 1.6 environment.

I need one more clarification.

Jboss 4.2.3 and 5.1.0GA will work on jdk 1.6 environment..?

Thanks in advance

Dinesh.

[peterj]

Jboss 4.2.3 and 5.1.0GA will work on jdk 1.6 environment..?

Yes, if you downloaded the jdk6 package (the one with 'jdk6' in the zip file name.

Also, I google the error message for you and came across this post that suggests a configuraiton change ot Oracle:

http://forums.oracle.com/forums/thread.jspa?threadID=431151