1 Reply Latest reply on Nov 22, 2017 1:12 AM by Anup Dey

    How to resolve database connection through firewall

    Azizur Rahaman Newbie

      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,

        • 1. Re: How to resolve database connection through firewall
          Anup Dey Apprentice

          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