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

juanM1 · Jan 28, 2016

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.

B4X:

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 · Jan 28, 2016

Maybe the server firewall blocks the connection.

juanM1 · Jan 28, 2016

Erel said:
Maybe the server firewall blocks the connection.

Hi Erel:

firewall and antivirus deactivated.

Erel · Jan 28, 2016

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

juanM1 · Jan 28, 2016

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

the ip address, is on local computer.

moster67 · Jan 28, 2016

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

Erel · Jan 28, 2016

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 · Jan 29, 2016

Erel said:
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.

B4X:

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 · Jan 30, 2016

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 · Jan 31, 2016

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

juanM1 · Feb 1, 2016

incendio said:
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 · Feb 1, 2016

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).

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

juanM1

Member

Erel

B4X founder

juanM1

Member

Erel

B4X founder

juanM1

Member

moster67

Expert

Erel

B4X founder

juanM1

Member

incendio

Well-Known Member

Erel

B4X founder

juanM1

Member

Erel

B4X founder

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

Member

B4X founder

Member

B4X founder

Member

Expert

B4X founder

Member

Well-Known Member

B4X founder

Member

B4X founder

Privacy & Transparency

Privacy & Transparency