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

DonManfred

Expert

Licensed User

Longtime User

• Nov 3, 2020

• #2

Yes, sure. Just use two different ServerPort

 

Upvote 0

M

medifor

Member

Licensed User

• Nov 3, 2020

• #3

Ok thanks

 

Upvote 0

josejad

Expert

Licensed User

Longtime User

• Nov 3, 2020

• #4

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

 

Upvote 0

M

medifor

Member

Licensed User

• Nov 3, 2020

• #5

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

 

Upvote 0

josejad

Expert

Licensed User

Longtime User

• Nov 3, 2020

• #6

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:

B4X:

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:

B4X:

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

 

Upvote 0

M

medifor

Member

Licensed User

• Nov 3, 2020

• #7

Very well,
Thanks

 

Upvote 0