Protocol Violation when user password is expired

From: Bob Rivers <bobrivers_at_pobox.com>
Date: 10 Feb 2004 10:30:35 -0800
Message-ID: <aa669e9b.0402101030.3f135719@posting.google.com>

Hi,

I have an application that uses jdbc (9.2.0.3/classes12) to connect to an Oracle db (9i). It works fine, except when the user password is going to expire.

Let me try to explain (sorry my poor english): my oracle db manages the users passwords, and this passwords are configured to expire every 90 days. So, when the password are going to expire, oracle asks to users if they want to change it.

If I try to use a JDBC connection with this user, I receive a protocol violation.

I was taking a look into the jdbc api, but I was not able to find a way to test the user before I try to use it into the connection.

I don't want to use a user that never goes expired.

Any hints?

TIA, Bob Received on Tue Feb 10 2004 - 12:30:35 CST