I have a problem with my database, I cannot access to it via public IP (remote).
I have developed a java stocks program, which uses JDBC to connect to DB.
My database is Oracle Database Express Edition (XE), mounted in Windows 10 to serve a stocks control program. The program works perfect while running on the same PC (localhost), but recently I wanted to access to it via remote connection.
The steps I followed are these:
1. Tell my ISP company to fix me an static public IP.
2. Configure a forwarding port in my router.
3. Create an SSH tunnel on server to route the traffic from forwarded port to database port (1521).
Comprobations I have done:
-Reaching the opened port via external access: **OK**
-Testing the SSH tunnel on server to be working. IP and port put on a browser, and the command line where the tunnel is debugging shows connection attempts. **OK**
-Testing SQLplus to connect to the remote server with public IP. **ERROR (BUT DEBUG CONSOLE ON SSH TUNNEL SHOWS A CONNECTION ATTEMPT)**. ORA-12537: TNS: closed connection.
-Testing JDBC to connect from my application to the remote server with public IP. **ERROR**. Network adapter cannot establish the connection. (NO CONNECTION ATTEMPT).
I also have configured a DDNS in the router with noIP, but the behavior is the same.
Anyone has an idea about this? I have tried several times.
**UPDATE:**
After downloading Orace Call Interface, SQLplus connects, but my Java application does not show any sign of connection.
Error:
java.sql.SQLRecoverableException: Error de E/S: The Network Adapter could not establish the connection
Error en la conexión de la base de datos
Asked by Fran Casas
(1 rep)
Sep 19, 2024, 06:34 AM
Last activity: Sep 22, 2024, 01:59 PM
Last activity: Sep 22, 2024, 01:59 PM