Details

    • Type: Task Task
    • Status: Open
    • Priority: Critical Critical
    • Resolution: Unresolved
    • Affects Version/s: v2.1.1
    • Fix Version/s: None
    • Component/s: jdbc
    • Labels:
      None
    • Environment:

      Solaris

      Description

      Hi Team ,

      while creating oracle connection pool in glassfish v2.1.1 getting the below error

      sun-appserver2.1|javax.enterprise.system.stream.err|_ThreadID=23;_ThreadName=httpWorkerThread-8001-4;_RequestID=55bd50e7-6738-4444-a558-7
      8b0f9ad0d8b;|
      java.lang.RuntimeException: javax.resource.ResourceException: 4
      at com.sun.enterprise.tools.admingui.util.JMXUtil.invoke(JMXUtil.java:124)
      at com.sun.enterprise.tools.admingui.util.JMXUtil.invoke(JMXUtil.java:75)
      at com.sun.enterprise.tools.admingui.handlers.JdbcHandlers.pingJdbcConnectionPool(JdbcHandlers.java:530)
      at sun.reflect.GeneratedMethodAccessor2055.invoke(Unknown Source)

      Please find the attached logs for more information.

      your help is highly appreciated .

      1. domain.xml related to connection pool.txt
        2 kB
        msr
      2. Error logs.txt
        8 kB
        msr
      3. server.log
        8 kB
        msr

        Activity

        Hide
        gtulasidhar added a comment -

        below is the domain.xml.

        <jdbc-connection-pool allow-non-component-callers="false" associate-with-thread="false" connection-creation-retry-attempts="0" connection-creation-retry-interval-in-seconds=
        "10" connection-leak-reclaim="false" connection-leak-timeout-in-seconds="0" connection-validation-method="table" datasource-classname="oracle.jdbc.pool.OracleDataSource" fail-al
        l-connections="false" idle-timeout-in-seconds="300" is-connection-validation-required="true" is-isolation-level-guaranteed="false" lazy-connection-association="false" lazy-conne
        ction-enlistment="false" match-connections="false" max-connection-usage-count="0" max-pool-size="32" max-wait-time-in-millis="60000" name="test_ds" non-transactional-connection
        s="false" pool-resize-quantity="2" res-type="javax.sql.DataSource" statement-timeout-in-seconds="-1" steady-pool-size="8" validate-atmost-once-period-in-seconds="0" validation-t
        able-name="DUAL" wrap-jdbc-objects="false">
        <property name="DataSourceName" value="OracleDataSource"/>
        <property name="ImplicitCachingEnabled" value="false"/>
        <property name="NetworkProtocol" value="tcp"/>
        <property name="Password" value="ehelp"/>
        <property name="LoginTimeout" value="0"/>
        <property name="URL" value="jdbc:oracle:thin:@(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = hostname)(PORT = 1521)) )(CONNECT_DATA =(SERV
        ICE_NAME = test) ) )"/>
        <property name="User" value="test"/>
        <property name="ExplicitCachingEnabled" value="false"/>
        <property name="PortNumber" value="0"/>
        <property name="MaxStatements" value="0"/>
        </jdbc-connection-pool>

        Show
        gtulasidhar added a comment - below is the domain.xml. <jdbc-connection-pool allow-non-component-callers="false" associate-with-thread="false" connection-creation-retry-attempts="0" connection-creation-retry-interval-in-seconds= "10" connection-leak-reclaim="false" connection-leak-timeout-in-seconds="0" connection-validation-method="table" datasource-classname="oracle.jdbc.pool.OracleDataSource" fail-al l-connections="false" idle-timeout-in-seconds="300" is-connection-validation-required="true" is-isolation-level-guaranteed="false" lazy-connection-association="false" lazy-conne ction-enlistment="false" match-connections="false" max-connection-usage-count="0" max-pool-size="32" max-wait-time-in-millis="60000" name="test_ds" non-transactional-connection s="false" pool-resize-quantity="2" res-type="javax.sql.DataSource" statement-timeout-in-seconds="-1" steady-pool-size="8" validate-atmost-once-period-in-seconds="0" validation-t able-name="DUAL" wrap-jdbc-objects="false"> <property name="DataSourceName" value="OracleDataSource"/> <property name="ImplicitCachingEnabled" value="false"/> <property name="NetworkProtocol" value="tcp"/> <property name="Password" value="ehelp"/> <property name="LoginTimeout" value="0"/> <property name="URL" value="jdbc:oracle:thin:@(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = hostname)(PORT = 1521)) )(CONNECT_DATA =(SERV ICE_NAME = test) ) )"/> <property name="User" value="test"/> <property name="ExplicitCachingEnabled" value="false"/> <property name="PortNumber" value="0"/> <property name="MaxStatements" value="0"/> </jdbc-connection-pool>
        Hide
        Shalini added a comment -

        Please post the exact domain.xml configuration of the jdbc connection pool you are trying to use.

        Show
        Shalini added a comment - Please post the exact domain.xml configuration of the jdbc connection pool you are trying to use.
        Hide
        gtulasidhar added a comment -

        Hi Shalini I am also getting same error,if possible escalate to next level.
        your help is highly appreciated .

        Thanks,
        Tulasidhar

        Show
        gtulasidhar added a comment - Hi Shalini I am also getting same error,if possible escalate to next level. your help is highly appreciated . Thanks, Tulasidhar
        Hide
        msr added a comment -

        i tried the url which mentioned the above , stilll getting same issue

        Show
        msr added a comment - i tried the url which mentioned the above , stilll getting same issue
        Hide
        Shalini added a comment -

        Could you try specifying something like jdbc:oracle:thin:@DB_HOSTNAME:1521:DATABASE_NAME for the URL? Looks like URL property is erroneous.

        Show
        Shalini added a comment - Could you try specifying something like jdbc:oracle:thin:@DB_HOSTNAME:1521:DATABASE_NAME for the URL? Looks like URL property is erroneous.
        Hide
        Shalini added a comment -

        Could you please attach the domain.xml configuration for this jdbc connection pool? And the full server.log would help as I am unable to see the actual cause of the exception.

        Show
        Shalini added a comment - Could you please attach the domain.xml configuration for this jdbc connection pool? And the full server.log would help as I am unable to see the actual cause of the exception.

          People

          • Assignee:
            sfelts
            Reporter:
            msr
          • Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

            • Created:
              Updated: