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

medifor

Member
Licensed User
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)?
 
Yes, sure. Just use two different ServerPort
 
Upvote 0
Note than you can use just one jRDC2 server to access several databases in a mysql server.

 
Upvote 0
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:

Code: Copy
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:

Code: Copy
sql.selectTest = select * from test.table1
sql.selectDB2 = select * from db2.table1
 
Upvote 0
Back
Top