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

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

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