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.