B4J Question Custom JRDC2 needed - consultancy?

[Bernaert Dominique]

Hi,

I have the following situation:

The client application connects to a central database (database 1).
The result from the query is the name of the database and the location of the database on the server (full path + name of the database).
All next queries should be send to the same server but with the full path + name of the database.
The queries should be executed to the database passed as a parameter.

We have more than 100 databases running on the server (each account has his own database).
That way we only need one JRDC2 server running.

Erel posted some sample code in this post of me a while ago: https://www.b4x.com/android/forum/threads/jrdc2-multiple-database.112013/

I'm looking for somebody who is willing to take a look at this and create a working and tested sample.
This is the first step.
In a second phase it would be great if it would be possible to send and receive files from the server using the same server.

I'm more than willing to pay for this.
I'm asking this because I haven't found the time to play with it and it's becoming urgent for our customers.

Thanks,

Bernaert Dominique

 

[OliverA]

The client application connects to a central database (database 1).

We have more than 100 databases running on the server (each account has his own database).

Do all these use the same database engine and therefore only one JDBC driver is required?

We have more than 100 databases running on the server (each account has his own database).

Where would the username/password for each account database come from?

 

[Erel]

@OliverA check jRDCMulti. It should be quite simple to make it read all the information needed from a configuration file.

 

[Bernaert Dominique]

Hi Oliver,

yes, it's one database engine (Firebird).
The username, password is the same for all the databases.

Dominique