Android Question Remote Database Connection to maintain or not?

[Jakes72]

Hi to all the Experts,

Just a quick question.
I am connecting to a MS SQL database on a remote Server using the JdbcSQL driver.
Now is it better to establish a connection at the start of my app and maintain the connection, or is it better to connect and disconnect everytime I do a query/non query?

Thank you for your time,
Regards Jacques.

 

[Erel]

Best option is to use jRDC2 instead of connecting to the database directly.

It is not so simple to maintain an active connection. I recommend you to connect and disconnect each time, however it also depends on your app requirements.

 

[Jakes72]

Thank you for your reply Erel I appreciate it.
What would the connection string look like using jRDC2 if I wanted to connect to an MS SQL database?

 

[josejad]

Based on:

jRDC2 MSSQL getting error fetching connection when connecting

Hi Erel and Expert guys out there, Getting error fetching connection when connecting to mssql server using b4j web server app. I can able to connect using mysql but for mssql using the jtds-1.3.1 library I cannot figured it out. B4j: #AdditionalJar: jtds-1.3.1 config.properties #example of...

www.b4x.com

It should be something like:

JdbcUrl=jdbc:jtds:sqlserver://127.0.0.1/test

supposing your jRDC2 server is on the same MS SQL server

Note that if you want to use jRDC2, you should have a VPS.