how to configure ssl between jboss and db

[vaerssv]

Hi All,

I've to secure the connection between my jboss instances and the data base running on another vlan. bo clear data can be sent on the network.
I heard that there are no possiblities to configure this in the connection pool and that we have to use an ssh tunnel.

But are ssh tunnel enough stable ?

did someone already configured this ?

many thanks for your help

Brgds

JF

[peterj]

What database are you using? Many database vendors provide SSL support within their JDBC drivers. For example, with MySQL see: http://dev.mysql.com/doc/refman/5.0/en/connector-j-reference-using-ssl.html

[vaerssv]

hello,

we are using an oracle 10.
but my issue is more on the jboss side, how can i configure that i want to connect to the db using ssl? is it possible to manage certificates for this jdbc connection in the jboss config ?

or if someone did a secure connection between jboss and the db, can he tell me how ?

many thanks for your help

JF

[peterj]

There is nothing in JBossAS to configure SSL for the database connection - that has to be done by the JDBC driver because it has to be coordinated with the database. I would be very surprised if the Oracle JDBC driver (actually, one of the Oracle JDBC drivers because I think there are several) does not provide a means of connecting to the database using SSL.

Or maybe you already know that but do not know how to set up the configuration in *-ds.xml. In that case, there are two possibilities. First, I seem to recall that with Oracle you can add database properties to the connection URL. Second, you can use the config-property element to set JDBC driver configuration options. Several of the *-ds.xml files in docs/examples/jca use this element.