How to resolve database connection through firewall

[akhanmca]

Hi,

I am hosting a website on Jboss 7.1. My JBoss is on public IP but my database server is not.It will be a mobile application. Client(i.e. iphone)  will call my webservice, it will come to the fire wall. From my firewall can I resolve my database(local). My jdbc connectivity should be like this.

jdbc:oracle:thin:@firewallip@localdbip:1521:DATABASE

Thanks in advance,

[andey]

You need to get the ports open through the firewall to work with the Oracle..

For oracle when database firewall is configured in proxy mode. The clients connecting to the database will use the ezconnect mechanism.

Like

CONNECT username/password@[//]host[:port][/service_name]

Now here the catch is host and port are of database firewall. Not the actual database host and port information.

You can also add firewall host and port detains in the client side tnsnames.ora for connecting using netalias of the database service.

For more information see: Features Specific to JDBC Thin