I am running Java 1.4 and cannot upgrade to 1.5 right now at work. I
have version 2.3 final. Is there a version that will allow me to save
as a spreadsheet without upgrading JAVA? If so where can I find this
version as I couldn't see it in the older versions link?
From: Robert Manning [mailto:robert.m.manning@...]
Sent: Wednesday, December 12, 2007 8:44 AM
To: Dula, Shane
Cc: squirrel-sql-users@...; squirrel-sql-develop
Subject: Re: [Squirrel-sql-users] Two quick questions
On Dec 12, 2007 7:54 AM, Dula, Shane <shane.dula@...>
> 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:
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:
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!