Android Question Adding Library and referencing to it.

[Backalife]

Gents, sorry if I am getting confused about such an elementary thing,
I am trying to reproduce the JDBC project Here with SQL Server instead of MySQL so I proceeded by:
1- Setting the Additional Libraries folder see Attachment "AdditionalLibs"
2 - Dropped the JDBC Library downloaded from Here onto the Additional Libraries Folder: Attachment "JDBC_Jar_Added"
3 - Importing the library using #AdditionalJar "mssql-jdbc-8.2.2.jre11"

But I am still getting an error about missing library to the jdbcSQL variable declared in the code.

Thank you.

 

[Erel]

Can you post the #AdditionalJar line and the compilation error message?

 

[Backalife]

Thank you Erel for your help,
These are the Globals and Attribs statments, I hope I am not missing something up:
in fact I tried to make it work with both mssql-jdbc-8.2.2.jre11 and mssql-jdbc-7.2.2.jre11 but in vain.

#Region  Project Attributes
    #ApplicationLabel: SQL Example
    #VersionCode: 1
    #VersionName:
    'SupportedOrientations possible values: unspecified, landscape or portrait.
    #SupportedOrientations: unspecified
    #CanInstallToExternalStorage: False
'    #AdditionalJar: mssql-jdbc-8.2.2.jre11
    #AdditionalJar: mssql-jdbc-7.2.2.jre11
  
#End Region

#Region  Activity Attributes
    #FullScreen: False
    #IncludeTitle: True
    #BridgeLogger: True
    DriverClass="com.microsoft.sqlserver.jdbc.SQLServerDriver"
#End Region

Sub Globals
    'These global variables will be redeclared each time the activity is created.
    'These variables can only be accessed from this module.

  
End Sub

Sub Process_Globals
   Public sqlserver As JdbcSQL
   Private driver As String = "com.microsoft.sqlserver.jdbc.SQLServerDriver"
   Private jdbcUrl As String = "jdbc:sqlserver://172.23.26.81:1433"
   Private Username As String = "user"
   Private Password As String = "password"
End Sub

and this is the Log:

Main - 78: Undeclared variable 'crsr' is used before it was assigned any value.
Main - 74: Undeclared variable 'sqlserver' is used before it was assigned any value.
Main - 66: Undeclared variable 'sqlserver' is used before it was assigned any value.
Main - 57: Undeclared variable 'sqlserver' is used before it was assigned any value.
Main - 75: Unknown type
Main - 28: Unknown type: jdbcsql<br />Are you missing a library reference?
Main - 29: Unused variable 'driver'. (warning #9)
Main - 30: Unused variable 'jdbcUrl'. (warning #9)
Main - 31: Unused variable 'Username'. (warning #9)
Main - 32: Unused variable 'Password'. (warning #9)
Main - 69: Sub 'ListAnimals' is not used. (warning #12)
Layout file 'main.bal' is not used. Are you missing a call to Activity.LoadLayout? (warning #16)
Library 'PreferenceActivity' is not used. (warning #32)

Thanks again.

 

[Erel]

Have you checked the JdbcSQL library in the libraries tab?

 

[Backalife]

Negative Erel, my Libraries Manager shows no JdbcSQL item.
Here is a snapshot of it.

 

[Erel]

This is an "additional" library. You need to download it: https://www.b4x.com/android/forum/t...ly-connect-to-remote-databases.84016/#content
And copy to the additional libraries folder.

 

[DonManfred]

And copy to the additional libraries folder.

he did, but only the JAR, no xml. See #1

 

[Backalife]

Yes DonManfred, I did copy that Jar in the AdditionalLib folder, and there was no xml file in the package provided by Microsoft in here

 

[Erel]

Carefully read post #6. The answer is there.

 

[DonManfred]

and there was no xml file in the package provided by Microsoft in here

Where does the file JdbcSQL.jar comes from (it is part of one of the screenshots in #1)?

 

[MicroDrie]

Erel point to link at post 6 and follow the link we can read:

The SQL type was renamed to JdbcSQL and ResultSet was renamed to JdbcResultSet, this allows using it together with the SQL library.

Contracts has always imported things in small letters. This post has a picture very small overview of all used and unused libraries. So what do we see if we blow up the small picture at post 5:

No SQL library selected. So perhaps it helps to select also the SQL library?

 

[Erel]

The SQL library is not needed. OP didn't copy the XML file to the libraries folder.