Re: [Squirrel-sql-users] Two quick questions

[Robert M. <rob...@gm...>]

On Dec 12, 2007 7:54 AM, Dula, Shane <sha...@ba...> wrote:
> Thanks.  I just downloaded  the 2.6 version.  So I will install that
> version.  I'm assuming that I will need to redo my Alias' ?
>

No; driver and alias definitions should be preserved when upgrading.
They are stored in your user profile (platform-specific) directory and
not in the SQuirreL installation directory.

> For question 2. I'm using Oracle Thin driver on for Oracle 9i.
>

We have a feature request for handling password expiration.
Unfortunately, JDBC doesn't specify how this is done, so at the moment
it is database-specific.  I found a thread which discusses a possible
implementation using JDBC in Oracle:

http://forum.java.sun.com/thread.jspa?threadID=455430&messageID=2078732

In summary, for JDBC clients, it is a problem to use the "normal"
connection API since an expired password means that you cannot
connect, which also implies that you cannot change your password.
However, Oracle seems to provide a special connection property which
allows you to specify a new password (OCINewPassword).  That's not
documented by the driver, so SQuirreL doesn't let you specify a value.
 However, the JDBC FAQ references it:

http://www.oracle.com/technology/tech/java/sqlj_jdbc/htdocs/jdbc_faq.htm#05_05

We could probably support this by augmenting the list that we get from
the driver - the problem is that it's specific to Oracle, so we
probably want to add an plugin API for plugins to do this.  Stay
tuned!

Rob