0 Replies Latest reply on Feb 10, 2003 3:28 PM by justin georgeson

    jboss 2.4.4/tomcat 2.3.3 bundle and oracle 8i

    justin georgeson Newbie

      I am trying to run the above combination. The only caveat is the oracle server is behind a NAT. There are two ways I tried to connect: with SSH tunnels and opening the oracle ports through the NAT. Both had the exact same result, so I'll stick with the SSH tunnels since that's what I want. In conf/tomcat/jboss.jcml, I configure the JDBC section with the URL "jdbc:oracle:thin@localhost:1521:qlink". I have an SSH tunnel forwarding localhost:1521 on the jboss/tomcat machine to localhost:1521 on the oracle machine. I can connect to the desired database over the ssh tunnel using sqlplus, so I know the path works and the database is running. When jboss/tomcat tries to connect, a REDIRECT response comes back from the oracle server and jboss/tomcat hangs. I'm getting really frustrated, because this jboss/tomcat app has been forcing me to change my network topology (I can't run it behind a nat because it broadcasts the 192.168 IP to clients, I can't connect it to my oracle server behind the nat so it looks like I have to put oracle on the same machine).