DbFit Connection for Remote Oracle Server via SSH
NickName:user1842137 Ask DateTime:2020-02-28T16:43:44

DbFit Connection for Remote Oracle Server via SSH

Please help me connecting to remote Oracle Server.

Oracle 11g is hosted on a Unix Server, which we access

  1. Creating a SSH session . See Attachment 'Remote Host Connection.jpg'enter image description here
  2. Creating a SSH tunnel.. See attachment 'Tunneling.jpg'enter image description here

After the tunnel is established (2nd method), I though we should be able to establish connection from DbFit to DB server, but its not working. Connection timeout error is show.

Please help me to get the connection established

  1. Either directly creating a SSH tunnel from DbFit if possible.
  2. Or connect to DB server using the SSH tunnel created.

Below is the code used for testing

!path lib/*.jar
!|dbfit.OracleTest|

!|Connect|localhost:5000|<DB user name>|<password>|dbfit|

!|Query|select 'test' as x|
|x                        |
|test                     |

Please find attached screenshot with error displayed. enter image description here

Copyright Notice:Content Author:「user1842137」,Reproduced under the CC 4.0 BY-SA copyright license with a link to the original source and this disclaimer.
Link to original article:https://stackoverflow.com/questions/60448044/dbfit-connection-for-remote-oracle-server-via-ssh

More about “DbFit Connection for Remote Oracle Server via SSH” related questions

DbFit Connection for Remote Oracle Server via SSH

Please help me connecting to remote Oracle Server. Oracle 11g is hosted on a Unix Server, which we access Creating a SSH session . See Attachment 'Remote Host Connection.jpg' Creating a SSH tunn...

Show Detail

Spring Boot Connection to MySQL on remote SSH server

I am trying to connect to MySQL server at remote machine using spring-boot application.properties but it is failing with error o.s.b.a.orm.jpa.DatabaseLookup: Unable to determine jdbc url from data...

Show Detail

Execute command on remote server via ssh

I am attempting to execute a command on a remote linux server via an ssh command on a local server like this: ssh myremoteserver 'type ttisql' where ttisql is an executable on the path of my re...

Show Detail

Connection to remote server via file client

I have little problem. I am using Putty for connection to remote server. ssh xxx.xx.xxx.xxx After connection and login with password, I need to use command: ssh username@servername After this,...

Show Detail

Kubernetes - Connecting to a remote database server via ssh

We're in the process of migrating our web app to a distributed application model using gcloud/docker/K8. We've got a remote database server that is configured to only accept connections from another

Show Detail

SSH to remote server refused if done via GitLab CI

We have a RHEL 7 remote server where I created a dummy user called gitlabci. While SSH'd into the remote server, I generated a public-private key pair (for use when grabbing files from GitLab) Up...

Show Detail

SSH remote connection to server with vscromium

Hello i like to change to VSCodium with linux but i have a problem, in VSCODE i use remote-ssh and works fine, but this same package in VSCodium doesn't work. It ask me password and after i have a ...

Show Detail

Start and stop Tomcat via SSH on remote server

I have a Tomcat webserver running on an Ubuntu machine. How can I restart the server via SSH from gitlab-ci? I am deploying various war &amp; jar files to the server via ssh on gitlab-ci and need...

Show Detail

How to connect to remote MySQL server via SSH using JPA?

I'm trying to connect to a remote MySQL server via SSH in my Java project. How can I integrate SSH connection with JPA? I'm using Netbeans 6.9.1, JPA, MySQL 5.2.

Show Detail

VS Code Remote-SSH: The vscode server failed to start SSH

I'm trying to connect to a server via remote-ssh extension for Visual Studio Code, however, I'm getting the following error: The vscode server failed to start SSH Everything is fine on the server...

Show Detail