Connect JBOSS to Oracle by SSL

[fedex]

Hi for everyone!

I 've a new problem , really I didn't investigate enough... but also found information about "how connect jboss through SSL".

My jboss version is: 4.2. ...

And de the Oracle DB is 10.2.0.4

Have you any way?

Thanks!

[peterj]

Check the documents on the Oracle JDBC driver, it should tell you how you can set up an SSL connection between an application (which is JBoss AS in this case) and the database. Most likely it is an extra set of parameters you can add to the URL in the *-ds.xml file.

[fedex]

Still could not find anything about it.

Sure, I must to configure de *-ds.xml, but What is the parameter that indicate the certificate or keytore?? It's necesary a certificate, (server and client), its' OK, I've them in my WALLET (I'm created and I added with OWM).

But the big problem it's How connect Jboss with oracle by SSL??

[peterj]

First you have to find out how the SSL-related properties for the JDBC driver are set in a standalone Java app. Here is one page I found on that, I know that goolge will help you find others: http://download.oracle.com/docs/cd/B19306_01/java.102/b14355/sslthin.htm

Once you know which paranetsr to set, within the  *-ds.xml file you have two choices:

a) add all the necessary parameters to the connection URL (most JDBC drivers let you set connection properties that way, read the JDBC driver's docs for the specific syntax)

b) use the <config-property> element to define the properties (look at the docs/examples/jca/firebird-ds.xml file for an example)