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

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

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
>> >>>>
>> >>>
>> >>
>> >
>>
>