Secure Connection via JDBC

Hello all,

I don't know in which forum to post this, if this a JDBC-Question or rather security-related.

I have a root-windows2003-server which is connected to the Internet. This server runs an instance of Microsoft SQL Server 2005.

I want to establish a secure connection to this MSSQL-Server instance while using jdbc.

Other serives on this server (e.g. subversion) are "protected" by using OpenSSL which runs also on the machine. For example I need a public key for authentication with the subversion on this server.

All I want is to "talk" securely to the server having ResultSets which come over the internet crypted etc..

Is this possible somehow? Would be nice if you could point me to the right direction for further inverstigation of this problem or having an direct answer to this.

Thanks all!

[853 byte] By [AlexGerharda] at [2007-11-26 22:23:34]
# 1
You'll need to run some client software to do it - JDBC doesn't provide for encryption directly. I believe PuTTY can be used to set up SSL tunnels. http://www.chiark.greenend.org.uk/~sgtatham/putty/
dcmintera at 2007-7-10 11:23:03 > top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...
# 2

Thank you for your answer, I also made a deeper search on this topic and found out that there is a jdbc-driver for ms-sql server available which is able to create the jdbc-connection by using SSL, it's called jTDS. Did not try this yet though.

http://jtds.sourceforge.net/index.html

Other input concerning this issue is welcome.

AlexGerharda at 2007-7-10 11:23:03 > top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...
# 3
Ok, jTDS has a good reputation - I didn't know it could do that though. Go with that - PuTTY will probably be fiddly to set up.
dcmintera at 2007-7-10 11:23:03 > top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...
# 4
maybe, http://javatoolbox.com/tools/jsecureconnect http://javatoolbox.com/tools/ids-jdbc-driver http://today.java.net/pub/a/2007/03/20/javadb-end-to-end-security.html
mchan0a at 2007-7-10 11:23:03 > top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...