[GLASSFISH-18700] Connection pool issue with oracle Created: 08/May/12  Updated: 10/Feb/13

Status: Open
Project: glassfish
Component/s: jdbc
Affects Version/s: v2.1.1
Fix Version/s: None

Type: Task Priority: Critical
Reporter: msr Assignee: sfelts
Resolution: Unresolved Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

Solaris


Attachments: Text File domain.xml related to connection pool.txt     Text File Error logs.txt     Text File server.log    

 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 .



 Comments   
Comment by Shalini [ 08/May/12 ]

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.

Comment by Shalini [ 08/May/12 ]

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

Comment by msr [ 08/May/12 ]

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

Comment by gtulasidhar [ 28/May/12 ]

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

Thanks,
Tulasidhar

Comment by Shalini [ 29/May/12 ]

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

Comment by gtulasidhar [ 07/Sep/12 ]

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>

Generated at Sun Apr 23 10:18:40 UTC 2017 using JIRA 6.2.3#6260-sha1:63ef1d6dac3f4f4d7db4c1effd405ba38ccdc558.