B4J Question 2 server jRDC2 on the same machine. Is possible?

[medifor]

I am using a remote jrdc2 server to manage a mysql db. is it possible to run 2 jrdc servers on the same machine to manage 2 different schema (mysql) or 2 different db (1 mysql and 1 sqlite)?

 

[DonManfred]

Yes, sure. Just use two different ServerPort

 

[medifor]

Ok thanks

 

[josejad]

Note than you can use just one jRDC2 server to access several databases in a mysql server.

jRDC2 connect Two or More MySQL databases

I already read .. Erel Answer from https://www.b4x.com/android/forum/threads/jrdc-how-to-connect-to-multiple-database.59930/#content But as i'm new member to b4x and not expert in java ... modification of RDCHandler is hard for me. I do Erel answer but i can't success. This is my jRDC...

www.b4x.com

 

[medifor]

how you do it? how do i declare the 2 db in config.properties?

 

[josejad]

In config.properties, instead of declaring the name of the database (ie database test: JdbcUrl=jdbc:mysql://127.0.0.1/test?characterEncoding=utf8), don't write any name:

JdbcUrl=jdbc:mysql://127.0.0.1?characterEncoding=utf8 'I've deleted /test

Then, in your sql, you have to give your database name and table, instead of just the table:
ie:

sql.selectTest = select * from test.table1
sql.selectDB2 = select * from db2.table1

 

[medifor]

Very well,
Thanks