|
From: Robert M. <rob...@gm...> - 2008-03-05 16:33:33
|
On Wed, Mar 5, 2008 at 9:06 AM, Jay Mallar <jay...@gm...> wrote: > Any thoughts?? > ---- > > I have an Oracle JDBC connection I'd like to use, but not sure if I can > or how I would do it using SquirrelSQL. > > My jdbc connection info is (we're using ABATIS): > > driver=oracle.jdbc.driver.OracleDriver > url=jdbc:oracle:thin:@hostname.here.com:port:dbname > username=username > password=encryptedpasswordstring > alg=PBEWithSHA256And256bitAES-CBC-BC > > (Obviously I took out any sensitive info). > > I tried just using the encryptedpasswordstring as it when i connected to > my alias, but got invalid username/pw errors. I suspect it's because > it's expecting the unencrypted pw. > > How would I go about setting this connection up? Hello Jay, This document (http://download.oracle.com/docs/cd/B19306_01/java.102/b14355/clntsec.htm#i1022564) lists the properties that can be specified when connecting. However, the Driver Properties tab of the Alias properties window doesn't allow you to add "optional" driver properties to be used when connecting. You can submit a feature request for this capability here: http://sourceforge.net/tracker/?func=add&group_id=28383&atid=393417 Rob |
