Can the same instance (I one single jRDC server) connect to 2 (or more) databases?
If so, can a sample code/ config be provided?
Or do I really need to run 1 server per database?
JRDC and specifically C3Po and the class SQL actually connects to an instance of mysql (in your case) and that instance can contain one or more databases.
If by databases you mean instances, then as far as I known i t would be better to create 2 connection pools. But both can be served by one jrdc .jar server.
JRDC and specifically C3Po and the class SQL actually connects to an instance of mysql (in your case) and that instance can contain one or more databases.
So in my case, I can have 2 or more databases, conecting to them with one single connection pool?
can you please, help me once again, just providing a sort of "proof of concept" kind of snippet...
I'm guessing the real work is made by the config.properties file, right? and of course, doubling the handlers...(?)
My config file above where harris is the database (config.properties)
So, you are saying I can connect to another DB (as long as I prefix it) without qualifying it in the config (as your example) - providing it has the same user rights ?
Now I can include other (db's) into the fray that are distinct from the original project - but may be useful (and used) from time to time without embedding.
Thanks!
(everyday, I learn, I learn...)
and I am not even up to jRDC yet, still stuck on original version 1 that has worked well to date... Must find time to update...
Perhaps Erel might chime in here with a vote of confidence, further instruction and guidance.
However, a simple like would mean so much.
The master knows so much yet has little time to impart his wisdom UNLESS confronted a specific tidbit that may be useful to us - that we may have not already known... (specific to B4X).
Does it get any better (or simpler) than this - anywhere outside of B4X?
Everything else MUST shine their light against B4X. It then becomes obvious where the shadows fall.
It often looks like a government redacted document - mostly blacked out... with little content.