Trapping oracle11g password about to expire warnings (ora-28002 and 28011) in AbtOracle8DatabaseConnection on login

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

Trapping oracle11g password about to expire warnings (ora-28002 and 28011) in AbtOracle8DatabaseConnection on login

fiona.shaw@feenyx.com.au
We are having trouble with password expiry in oracle 11g. On connect and disconnect, the user will get an ora-28002 or ora-28011 respectively, if the user's account has entered the grace period for expiry.  These messages are warnings only.

In the AbtOracle8DatabaseConnection class, the connection happens in #connectUsing: aDataSourceName id: aUserId pw: aPassword ifError: errorBlock and the return code is checked by #verifyReturnCode: rc ifError: errorBlock.  There is a hard-coded test for two return codes - no data found and fetch past end of cursor.  Any other sql code results in a AbtError being passed to the errorblock and so the connection is not made.

I can fix this by patching AbtOracle8DatabaseConnection to allow for the two 'warning' codes. But I was wondering if there was anything in the pipeline (maybe an AbtOracle11DatabaseConnection class?) that may handle this?

Or if anyone else has a neat solution, would they like to pass it on?

regards
Fiona

--
You received this message because you are subscribed to the Google Groups "VA Smalltalk" group.
To view this discussion on the web visit https://groups.google.com/d/msg/va-smalltalk/-/pNzKNpHdUaIJ.
To post to this group, send email to [hidden email].
To unsubscribe from this group, send email to [hidden email].
For more options, visit this group at http://groups.google.com/group/va-smalltalk?hl=en.