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

juanM1

Member
Licensed User
Longtime User
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.

Code: Copy
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
 
Perhaps it is a port-forwarding issue in your router ("incoming connection -> port number -> forward to your local computer" and/or TCP/UDP)?
 
Upvote 0
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.

Code: Copy
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
 
Upvote 0
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.
 
Upvote 0
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.
 
Upvote 0
Back
Top