'JDBC in Android with SSL Certificates
I am able to connect to postgresql in my Android App using JDBC:
import android.Manifest;
import android.content.pm.PackageManager;
import android.os.StrictMode;
import android.support.v4.app.ActivityCompat;
import android.support.v7.app.AppCompatActivity;
import android.os.Bundle;
import android.view.View;
import android.widget.Toast;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
public class MainActivity extends AppCompatActivity {
private static String ip = "HOST_IP";
private static String port = "5432";
private static String Classes = "org.postgresql.Driver";
private static String database = "DATABASE_NAME";
private static String username = "USERNAME";
private static String password = "PASSWORD";
private static String url = "jdbc:postgresql://"+ip+":"+port+"/"+database;
private Connection connection = null;
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main);
}
public void start(View view) {
ActivityCompat.requestPermissions(this,new String[]{Manifest.permission.INTERNET}, PackageManager.PERMISSION_GRANTED);
StrictMode.ThreadPolicy policy = new StrictMode.ThreadPolicy.Builder().permitAll().build();
StrictMode.setThreadPolicy(policy);
try {
Class.forName(Classes);
connection = DriverManager.getConnection(url, username,password);
Toast.makeText(this, "Connected", Toast.LENGTH_SHORT).show();
} catch (ClassNotFoundException e) {
e.printStackTrace();
Toast.makeText(this, "Class fail", Toast.LENGTH_SHORT).show();
} catch (SQLException e) {
e.printStackTrace();
Toast.makeText(this, "Connected no", Toast.LENGTH_SHORT).show();
}
}
}
It works fine. But how can i manage it to use SSL (verify-ca)? I have all 3 certificates (server, client and key) in .pem format. Where should i store these certificates and how to use wit JDBC?
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
