Bug 403662 - sybase password expiry - query retry until sybase runs out of user connections
Summary: sybase password expiry - query retry until sybase runs out of user connections
Status: NEW
Alias: None
Product: z_Archived
Classification: Eclipse Foundation
Component: Eclipselink (show other bugs)
Version: unspecified   Edit
Hardware: All All
: P2 blocker (vote)
Target Milestone: ---   Edit
Assignee: Project Inbox CLA
QA Contact:
URL:
Whiteboard: sybase
Keywords:
Depends on:
Blocks:
 
Reported: 2013-03-18 13:08 EDT by sai potluri CLA
Modified: 2022-06-09 10:09 EDT (History)
2 users (show)

See Also:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description sai potluri CLA 2013-03-18 13:08:26 EDT 
When connecting to sybase ASE and with a login for which the password expired, login works fine but after login, any read query outside transaction will fail with exception that password expired and eclipselink automatically retries continuously with new connection every time until Sybase runs out of user connections. 
Even after explicitly setting queryRetryAttemptCount to a value, eclipselink doesn't honor the value and retries until Sybase eventually runs out of user connections
Comment 1 sai potluri CLA 2013-03-18 13:10:28 EDT 
more details on exception
Error Code: 7742
Call: SELECT query
Query: ReadAllQuery(referenceClass=TrdrPortGrp sql="SELECT query").
[EL Info]: 2013-03-18 20:16:43.028--DatabaseSessionImpl(15082333)--Communication failure detected when attempting to perform read query outside of a transaction. Attempting to retry query. Error was: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.3.2.v20111125-r10461): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: com.sybase.jdbc2.jdbc.SybSQLException: You must change your password using the sp_password system stored procedure before you can continue.
Comment 2 Tom Ware CLA 2013-04-03 09:10:34 EDT 
Setting target and priority.  See the following page for the meanings of these fields:

http://wiki.eclipse.org/EclipseLink/Development/Bugs/Guidelines

Community: Please vote for this bug if it is important to you.  Votes are one of the main criteria we use to determine which bugs to fix next.
Comment 3 Eclipse Webmaster CLA 2022-06-09 10:09:57 EDT 
The Eclipselink project has moved to Github: https://github.com/eclipse-ee4j/eclipselink