B4J Question JDRC serving different databases

[Peekay]

I have two different apps, each addressing different SQL Server databases on the same server machine.
The config.properties file only allows me to address one JdbcUrl, I think, or how does it know which database to address, and where do I specify it?
With regard to the SQL commands, how would I handle that for two different databases?

Thanks
PK

 

[EnriqueGonzalez]

hi Peekay

you can manually modify the config properties to have both databases addressed or modify the sql sentences with the database and the jdbcurl point to master. There isnt much science around it.

 

[Erel]

A modified version of jRDC2 that supports multiple databases is available here: https://www.b4x.com/android/forum/threads/mysql-connector-for-b4i.116617/post-729095

You are expected to post the "database name" as a GET parameter with the DBName key. See the code in Main and RDCHandler to better understand how it works.