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

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

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