Encrypted JDBC connection

Question

I do a lot of work on databases over the internet. My company is instituting a policy of not sending any non-encrypted information (including vanilla JDBC). I currently connect to MS SQL Server and IBM DB2 databases (both LUW and AS/400). Is there an easy way to encrypt/decrypt these connections?

Edit: Found an interesting and relatively simple SSH tunnelling article that may be of some help. http://www.ibm.com/developerworks/data/library/techarticle/dm-0312lurie/index.html

Answer 1

Maybe JDBC over SSL, if your databases support SSL and your JDBC drivers too. A fast googling shows that Microsoft SQL Server JDBC Driver 1.2 has support for SSL encryption and that the IBM DB2 JDBC Driver 9.1 includes SSL support to database servers that also have SSL support.

Some links :

• SQL Server 2005 JDBC driver v1.2 Aug CTP is LIVE (2007-09-04)
• SSL in Microsoft SQL Server JDBC 1.2 driver (2008-02-04)
• What's new for V9.1: JDBC and SQLJ enhancements (2008-10-01)