[bettyboop]

Or must I have Oracle client on my box locally ? I can establish this connection through ssh and sql plus but was hoping to see the dbase and schema within the IDE.

Thanks

[Riyad Kalla]

I don’t know if we support SSH connections, I will check.

[support-jeff]

No, ssh is not (directly) supported. This is just plain ol’ JDBC. I suppose it is not out of the question that Oracle has a custom SSH implementation of their JDBC drivers, but you would have to check with them.

[kookaburra]

I do the following-
db is a host with Oracle DB on a remote network
gw is also on remote network.
ssh -L1522:db:1521 -l username gw

Then define you connection in database explorer to use –
Driver – Rcale Thin Driver
USR – jdbc:oracle:thin:@localhost:1522:geo

I use port 1522 on my localhost but anything else will do.
You need to add the Oracle Thin Driver by referencing the ojdbc.jar file when adding a Driver.

Colin Ruthven

[Author]

Posts