Android Question RDC java.sql.SQLException: An attempt by a client to checkout a Connection has timed out.

[juanM1]

Hi

I have the following connection that works well with local connection, remote connection but gives the error.

Remote Database connector: java.sql.SQLException: An attempt by a client to checkout a Connection has timed out.

DriverClass=org.firebirdsql.jdbc.FBDriver
#JdbcUrl=jdbc:firebirdsql://AsusP/d:/Gebial/data/Gebidata42.fdb - well
#JdbcUrl=jdbc:firebirdsql://192.168.1.5/d:/Gebial/data/Gebidata42.fdb -well
JdbcUrl=jdbc:firebirdsql://176.57.71.116/d:/Gebial/data/Gebidata42.fdb . Error

User=SYSDBA
Password=masterkey
ServerPort=17178
#If Debug is true then this file will be reloaded on every query.
#This is useful if you need to modify the queries.
Debug=true

#commands
sql.Confirmar_albacabe=update cabealbaclie set estado = 0 where cabealbaclie_id = ?

Thanks in advance

 

[Erel]

Maybe the server firewall blocks the connection.

 

[juanM1]

Maybe the server firewall blocks the connection.

Hi Erel:

firewall and antivirus deactivated.

 

[Erel]

What is this ip address? Is this an online server? Or a local computer?

 

[juanM1]

What is this ip address? Is this an online server? Or a local computer?

the ip address, is on local computer.

 

[moster67]

Perhaps it is a port-forwarding issue in your router ("incoming connection -> port number -> forward to your local computer" and/or TCP/UDP)?

 

[Erel]

See the steps required to connect to a remote computer (over the internet): https://www.b4x.com/android/forum/t...r-b4j-server-over-the-internet.37201/#content

 

[juanM1]

See the steps required to connect to a remote computer (over the internet): https://www.b4x.com/android/forum/t...r-b4j-server-over-the-internet.37201/#content

I installed the program and working properly,
but the RDC continues to give the same problem.

DriverClass=org.firebirdsql.jdbc.FBDriver
#JdbcUrl=jdbc:firebirdsql://AsusP/d:/Gebial/datos/Gebidata42.fdb                           ---- well
JdbcUrl=jdbc:firebirdsql://gexxxxxxr.duckdns.org/d:/Gebial/datos/Gebidata42.fdb       --- error

 

[incendio]

Is the server in windows or linux ? Path description in windows different than linux. Windows uses \ not /.

Try this jdbc.firebirdsql://ip adrress/d:\folder of your database file.

 

[Erel]

Have you configured the router to forward the relevant port to the server?

 

[juanM1]

Is the server in windows or linux ? Path description in windows different than linux. Windows uses \ not /.

Try this jdbc.firebirdsql://ip adrress/d:\folder of your database file.

Hi incendio.
The server is windows. It works well with private IP, but not with public IP.

Have you configured the router to forward the relevant port to the server?

Hi Erel.
yes therouter is configured.

 

[Erel]

This is a network issue. It is not really related to RDC.

It might be easier to solve it if you run RDC on the server and use the dynamic ip to connect to RDC (from the client).