5 Replies Latest reply on Jun 21, 2011 11:38 AM by Peter Johnson

    problem in Datasource configuration.

    Dinesh venkatesan Newbie

      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>

        • 1. Re: problem in Datasource configuration.
          jaikiran pai Master

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

          • 2. Re: problem in Datasource configuration.
            Dinesh venkatesan Newbie

            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.

            • 3. Re: problem in Datasource configuration.
              jaikiran pai Master

              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.

              • 4. Re: problem in Datasource configuration.
                Dinesh venkatesan Newbie

                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.

                • 5. Re: problem in Datasource configuration.
                  Peter Johnson Master
                  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