Re: [Squirrel-sql-users] SSL With Oracle JDBC Thin Driver

[Stephen M. <ste...@gm...>]

Reading closer in the oracle docs:

"Unless you are using the 11.1.0.7 (and onwards) JDBC thin driver,
before creating
a new connection, you also need to instantiate OraclePKIProvider so
that the class
gets loaded and initialized:
new oracle.security.pki.OraclePKIProvider();"

I am using Oracle version 10.2.0.3.

How can I instantiate OraclePKIProvider in SQuirreL ? Would this
require a custom plugin ?



On Wed, Jul 7, 2010 at 9:55 AM, Stephen More <ste...@gm...> wrote:
> In my test code I have a line:
>    java.security.Security.addProvider( new
> oracle.security.pki.OraclePKIProvider() );
>
> If I comment out this line, I get the same error as squirrel.
>
> I have tried setting this statically by editing
>    C:\Program Files\Java\jre6\lib\security\java.security
> and adding
>    security.provider.10=oracle.security.pki.OraclePKIProvider
>
> but it does not seem to have any effect.
>
>
> On Wed, Jul 7, 2010 at 9:23 AM, Robert Manning
> <rob...@gm...> wrote:
>> Is Oracle configured properly to do the SSL Handshake ? Can you
>> connect to that port from your client machine ?  There are any number
>> of reasons for this exception, which may or may not have to do with
>> SSL configuration.
>>
>> Rob
>>
>> On 7/7/10, Stephen More <ste...@gm...> wrote:
>>> I added those parameters to the startup script. I also verified they
>>> show up in the "About/System tab".
>>>
>>> But I am not able to connect.
>>>
>>> java.sql.SQLException: Io exception: The Network Adapter could not
>>> establish the connection
>>>        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
>>>        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
>>>        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:255)
>>>        at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:387)
>>>        at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:439)
>>>        at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:165)
>>>        at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35)
>>>        at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)
>>>        at net.sourceforge.squirrel_sql.fw.sql.SQLDriverManager.getConnection(SQLDriverManager.java:133)
>>>        at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.execute(OpenConnectionCommand.java:97)
>>>        at net.sourceforge.squirrel_sql.client.mainframe.action.ConnectToAliasCommand$SheetHandler.run(ConnectToAliasCommand.java:280)
>>>        at net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82)
>>>        at java.lang.Thread.run(Unknown Source)
>>>
>>>
>>> On Tue, Jul 6, 2010 at 7:20 PM, Robert Manning
>>> <rob...@gm...> wrote:
>>> > Stephen,
>>> >
>>> > You could edit the launch script to add
>>> >
>>> > -Djavax.net.ssl.trustStore=/tmp/cwallet.sso -Djavax.net.ssl.trustStoreType=SSO
>>> >
>>> > to the line that invokes the JVM.  Anywhere on the last line with
>>> > JAVACMD, after JAVACMD, but before
>>> > net.sourceforge.squirrel_sql.client.Main.
>>> >
>>> > Rob
>>> >
>>> > On Tue, Jul 6, 2010 at 3:13 PM, Stephen More <ste...@gm...> wrote:
>>> >> Thanks,
>>> >>    Any idea how to set javax.net.ssl.trustStore or
>>> >> javax.net.ssl.trustStoreType properties ?
>>> >>
>>> >> On Tue, Jul 6, 2010 at 2:56 PM, Robert Manning
>>> >> <rob...@gm...> wrote:
>>> >>> You can add them in the "Extra Class Path" tab of the Oracle JDBC
>>> >>> driver definition.
>>> >>>
>>> >>> Rob
>>> >>>
>>> >>> On 7/6/10, Stephen More <ste...@gm...> wrote:
>>> >>>> I am trying to use SQuirreL to connect to SSL With Oracle JDBC Thin Driver:
>>> >>>>    http://www.oracle.com/technology/tech/java/sqlj_jdbc/pdf/wp-oracle-jdbc_thin_ssl.pdf
>>> >>>>
>>> >>>> I have java code working. The code requires extra properties to be set
>>> >>>>               - props.setProperty( "javax.net.ssl.trustStore",
>>> >>>> "/tmp/cwallet.sso" );
>>> >>>>               - props.setProperty( "javax.net.ssl.trustStoreType", "SSO" );
>>> >>>>   how can I set these properties in the SQuirreL GUI ?
>>> >>>>
>>> >>>> It also requires ojpse.jar and oraclepki.jar to be in the classpath.
>>> >>>> Where would be the best location to put these jars to enable SQuirreL
>>> >>>> to connect to Oracle using SSL ?
>>> >>>>
>>> >>>> -Thanks
>>> >>>> Stephen More
>>> >>>>
>>> >>>> ------------------------------------------------------------------------------
>>> >>>> This SF.net email is sponsored by Sprint
>>> >>>> What will you do first with EVO, the first 4G phone?
>>> >>>> Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first
>>> >>>> _______________________________________________
>>> >>>> Squirrel-sql-users mailing list
>>> >>>> Squ...@li...
>>> >>>> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>>> >>>>
>>> >>>
>>> >>
>>> >
>>>
>>
>