(Android™) SSH Tunnel for Database Connection (such as ADO, ODBC, JDBC, etc.)

Demonstrates how to create an SSH tunneling client in a background thread of your application. This makes it possible to SSH tunnel database connections without the need for separate software (such as PuTTY) to be running.

Chilkat Android™ Downloads Android™ Java Libraries Android C/C++ Libraries

// Important: Don't forget to include the call to System.loadLibrary
// as shown at the bottom of this code sample.
package com.test;

import android.app.Activity;
import com.chilkatsoft.*;

import android.widget.TextView;
import android.os.Bundle;

public class SimpleActivity extends Activity {

  private static final String TAG = "Chilkat";

  // Called when the activity is first created.
  @Override
  public void onCreate(Bundle savedInstanceState) {
    super.onCreate(savedInstanceState);

    CkGlobal chilkatGlob = new CkGlobal();
    boolean success = chilkatGlob.UnlockBundle("Anything for 30-day trial.");
    if (success != true) {
        Log.i(TAG, chilkatGlob.lastErrorText());
        return;
        }

    CkSshTunnel tunnel = new CkSshTunnel();

    String sshHostname = "www.my-ssh-server.com";
    int sshPort = 22;

    //  Connect to an SSH server and establish the SSH tunnel:
    success = tunnel.Connect(sshHostname,sshPort);
    if (success != true) {
        Log.i(TAG, tunnel.lastErrorText());
        return;
        }

    //  Authenticate with the SSH server via a login/password
    //  or with a public key.
    //  This example demonstrates SSH password authentication.
    success = tunnel.AuthenticatePw("mySshLogin","mySshPassword");
    if (success != true) {
        Log.i(TAG, tunnel.lastErrorText());
        return;
        }

    //  The destination host/port is the database server.
    //  The DestHostname may be the domain name or
    //  IP address (in dotted decimal notation) of the database
    //  server.
    tunnel.put_DestPort(1433);
    tunnel.put_DestHostname("myDbServer.com");

    //  Start accepting connections in a background thread.
    //  The SSH tunnels are autonomously run in a background
    //  thread.  There is one background thread for accepting
    //  connections, and another for managing the tunnel pool.
    int listenPort = 3316;
    success = tunnel.BeginAccepting(listenPort);
    if (success != true) {
        Log.i(TAG, tunnel.lastErrorText());
        return;
        }

    //  At this point the app may connect to the database server through
    //  the SSH tunnel.  The database connection string would
    //  use "localhost" for the hostname and 3316 for the port.
    //  We're not going to show the database coding here,
    //  because it can vary depending on the API you're using
    //  (ADO, ODBC, OLE DB, etc. )

    //  This is where the application's database code would go...

    //  Stop the background listen/accept thread:
    boolean waitForThreadExit = true;
    success = tunnel.StopAccepting(waitForThreadExit);
    if (success != true) {
        Log.i(TAG, tunnel.lastErrorText());
        return;
        }

    //  Close the SSH tunnel (would also kick any remaining connected clients).
    success = tunnel.CloseTunnel(waitForThreadExit);
    if (success != true) {
        Log.i(TAG, tunnel.lastErrorText());
        return;
        }


  }

  static {
      System.loadLibrary("chilkat");

      // Note: If the incorrect library name is passed to System.loadLibrary,
      // then you will see the following error message at application startup:
      //"The application <your-application-name> has stopped unexpectedly. Please try again."
  }
}