Android Question JDBC SQL & SQLlite (Online & Offline Database)

[M.SALIM]

hello

I'm developing an App on Android that will connect to a database online & offline mode.
The Online Database is MSSqlServer using JdbcSQL and the local database on the device is SQLlite.

When connecting to the Online database it works perfectly, but failed to connect to localDB when offline.
The Error is : java.lang.RuntimeException: Object should first be initialized.

Below is my sample code :

If DBOnline  Then
        Dim myDBRemote As JdbcSQL
        myDBRemote.Initialize("net.sourceforge.jtds.jdbc.Driver",  myConnectionString)
        Dim myRS  As JdbcResultSet =myDBRemote.ExecQuery("SELECT * FROM CUSTOMERS")
    Else
        Dim myfolder As String = Starter.rp.GetSafeDirDefaultExternal("")
        Dim myDBlocal As JdbcSQL
        myDBlocal.InitializeSQLite(myFolder, "ABSDB.db",     True)
        Dim myRS As JdbcResultSet = myDBlocal.ExecQuery("SELECT * FROM CUSTOMERS")
    End If

Can anyone advise how to achieve this using JdbcSQL with different database connection?

 

[Erel]

Best to use File.DirInternal.

You will need to use the SQL library to access the local database.

 

[Erel]

You cannot declare the same variable with different types.

 

[M.SALIM]

You cannot declare the same variable with different types.

Noted.
I thought we could do same as in VB6

 

[M.SALIM]

Dear Erel,
Kindly delete the POST #3.
I've inserted my full connection string to my test database by mistake .
I've already disabled access to same just in case.

Thank you in advance.

 

[M.SALIM]

Which library is latest JSQL or JDBCSQL???
Or which one you would recommend to use in B4A?

 

[Erel]

You should never post new questions in existing threads.