Android Question JTDS No suitable driver found for

Tamer El-Shimy · Mar 28, 2022

What I'm doing wrong to get the following exception ?
java.sql.SQLException: No suitable driver found for http://jdbc:jtds:SQLServer://10.29.1.82:1433;DatabaseName=KPI;IntegratedSecurity=False;Username=MySQLUsername;Password=MySQLPassword

B4A part:

Public Sub ConnectDB
    Driver="net.sourceforge.jtds.jdbc.Driver"
    Dim SIP ,SPort As String
    SIP="10.29.1.82"
    SPort="1433"
    Username=MyUsername
    Password=MyPassword
    URL="http://jdbc:jtds:SQLServer://" & SIP &":" & SPort & ";DatabaseName=KPI;IntegratedSecurity=False;Username="& Username & ";Password=" & Password
    Log (Driver)
    MySQL.Initialize2(Driver, URL,Username,Password)
    Log ("Initialization : " & MySQL.IsInitialized)
    End Sub

Additional Jar:

#AdditionalJar :JdbcSQL.jar
#AdditionalJar :jtds-1.3.1.jar

Keeping in mind the code worked for another test application

MicroDrie · Mar 28, 2022

Keeping in mind the code worked for another test application

Does that other test application still work now because the jar is from 2013 and Microsoft sql server (6.5, 7, 2000, 2005, 2008 and 2012) are all old versions and as far as I can seen, not longer supported version.

How to Connect to MS SQL Server via JDBC is stated:

Newer versions of MS SQL Server, especially those that use SSL encryption to communicate to and from the database server, may not work correctly with the jTDS driver. There are some issues with the jTDS driver, the Jave runtime environment, and the handling of SSL/TLS communications with certain SQL Server configurations. If the jTDS driver is not able to connect, generally the MS SQL Server driver from Microsoft will work. The only major difference between the two drivers is that when connecting to SQL Server from non-Windows systems, the MS SQL Server driver does not support Windows authentication. It requires SQL Server authentication. The jTDS driver does support Windows authentication from non-Windows systems.

Tamer El-Shimy · Mar 28, 2022

MicroDrie said:
Does that other test application still work now because the jar is from 2013 and Microsoft sql server (6.5, 7, 2000, 2005, 2008 and 2012) are all old versions and as far as I can seen, not longer supported version.

How to Connect to MS SQL Server via JDBC is stated:

Really I'm having a test application with a button which uses initialize2 and another button uses initializeasync ( both work with proper queries or error messages of Success : False) , The only difference is that I added the username , password ,url , and port manually for the test application not including variables.

Anyway , I've these references commented out :
''#AdditionalJar :mssql-jdbc-10.2.0.jre8
''#AdditionalJar :mssql-jdbc-10.2.0.jre11
''#AdditionalJar :mssql-jdbc-10.2.0.jre17

MicroDrie · Mar 28, 2022

I would say take the test application as a starting point and run to see if the original test application with your current IDE environment still works. If so and it doesn't work with password and username then it is the authentication problem. The RazorSQL link I gave earlier addresses login issues.

MicroDrie · Mar 28, 2022

Tamer El-Shimy said:
Anyway , I've these references commented out :
''#AdditionalJar :mssql-jdbc-10.2.0.jre8
''#AdditionalJar :mssql-jdbc-10.2.0.jre11
''#AdditionalJar :mssql-jdbc-10.2.0.jre17

Is this a finger point to Java version dependency?

Tamer El-Shimy · Mar 28, 2022

The test Application is still working , I just tried to add the variables of IP address of the DB server , Port , Username , Password and merge them with my original application.

Tamer El-Shimy · Mar 28, 2022

MicroDrie said:
Is this a finger point to Java version dependency?

When I add a line of the commented Additional Jar , I get a message "MinSDK>=26.

aeric · Mar 28, 2022

Tamer El-Shimy said:
URL="http://jdbc:jtds:SQLServer://" & SIP &":" & SPort & ";DatabaseName=KPI;IntegratedSecurity=False;Username="& Username & ";Password=" & Password

Try:

B4X:

URL="jdbc:jtds:sqlserver://" & SIP & ":" & SPort & ";DatabaseName=KPI;IntegratedSecurity=False"

Tamer El-Shimy · Mar 28, 2022

aeric said:

Try:

B4X:

URL="jdbc:jtds:sqlserver://" & SIP & ":" & SPort & ";DatabaseName=KPI;IntegratedSecurity=False"

I'm still getting the error message "No suitable driver for"

aeric · Mar 28, 2022

Tamer El-Shimy said:
When I add a line of the commented Additional Jar , I get a message "MinSDK>=26

Please post the full error message.

Tamer El-Shimy · Mar 28, 2022

unsupported class file version 61.0
...while parsing com/microsoft/sqlserver/jdbc/AASAttestationParameters.class
Uncaught translation error: com.android.dx.cf.code.SimException: invalid opcode ba (invokedynamic requires --min-sdk-version >= 26)
Uncaught translation error: com.android.dx.cf.code.SimException: invalid opcode ba (invokedynamic requires --min-sdk-version >= 26)
Uncaught translation error: com.android.dx.cf.code.SimException: invalid opcode ba (invokedynamic requires --min-sdk-version >= 26)
Uncaught translation error: com.android.dx.cf.code.SimException: invalid opcode ba (invokedynamic requires --min-sdk-version >= 26)
Uncaught translation error: com.android.dx.cf.code.SimException: invalid opcode ba (invokedynamic requires --min-sdk-version >= 26)
Uncaught translation error: com.android.dx.cf.code.SimException: invalid opcode ba (invokedynamic requires --min-sdk-version >= 26)
Uncaught translation error: com.android.dx.cf.code.SimException: invalid opcode ba (invokedynamic requires --min-sdk-version >= 26)
UNEXPECTED TOP-LEVEL EXCEPTION:
java.lang.RuntimeException: Translation has been interrupted
at com.android.dx.command.dexer.Main.processAllFiles(Main.java:692)
at com.android.dx.command.dexer.Main.runMonoDex(Main.java:315)
at com.android.dx.command.dexer.Main.runDx(Main.java:293)
at com.android.dx.command.dexer.Main.main(Main.java:249)
at com.android.dx.command.Main.main(Main.java:94)
Caused by: java.lang.InterruptedException: Too many errors
at com.android.dx.command.dexer.Main.processAllFiles(Main.java:684)
... 4

aeric · Mar 28, 2022

Tamer El-Shimy said:
#AdditionalJar :JdbcSQL.jar

What if you remove this line?

Tamer El-Shimy · Mar 28, 2022

This is why I tried to use another SDK version.

unsupported class file version 61.0
...while parsing com/microsoft/sqlserver/jdbc/AASAttestationParameters.class
Uncaught translation error: com.android.dx.cf.code.SimException: invalid opcode ba (invokedynamic requires --min-sdk-version >= 26)
Uncaught translation error: com.android.dx.cf.code.SimException: invalid opcode ba (invokedynamic requires --min-sdk-version >= 26)
Uncaught translation error: com.android.dx.cf.code.SimException: invalid opcode ba (invokedynamic requires --min-sdk-version >= 26)
Uncaught translation error: com.android.dx.cf.code.SimException: invalid opcode ba (invokedynamic requires --min-sdk-version >= 26)
Uncaught translation error: com.android.dx.cf.code.SimException: invalid opcode ba (invokedynamic requires --min-sdk-version >= 26)
Uncaught translation error: com.android.dx.cf.code.SimException: invalid opcode ba (invokedynamic requires --min-sdk-version >= 26)
Uncaught translation error: com.android.dx.cf.code.SimException: invalid opcode ba (invokedynamic requires --min-sdk-version >= 26)
UNEXPECTED TOP-LEVEL EXCEPTION:
java.lang.RuntimeException: Translation has been interrupted
at com.android.dx.command.dexer.Main.processAllFiles(Main.java:692)
at com.android.dx.command.dexer.Main.runMonoDex(Main.java:315)
at com.android.dx.command.dexer.Main.runDx(Main.java:293)
at com.android.dx.command.dexer.Main.main(Main.java:249)
at com.android.dx.command.Main.main(Main.java:94)
Caused by: java.lang.InterruptedException: Too many errors
at com.android.dx.command.dexer.Main.processAllFiles(Main.java:684)

Tamer El-Shimy · Mar 28, 2022

aeric said:
What if you remove this line?

Really I wanted to try the "com.microsoft.SQLServer.SQLServerDriver" after the "net.sourceforge.jtds.jdbc.Driver" succeeded in Test application but failed to merge it in my application. Where Can I put "sqljdbc_10.2" folder?

Tamer El-Shimy · Mar 28, 2022

MicroDrie said:
Does that other test application still work now because the jar is from 2013 and Microsoft sql server (6.5, 7, 2000, 2005, 2008 and 2012) are all old versions and as far as I can seen, not longer supported version.

How to Connect to MS SQL Server via JDBC is stated:

Ok , Where to put the folder "sqljdbc_10.2" for "com.microsoft.SQLServer.jdbc.SQLServerDriver" and URL of "jdbc:SQLServer://"?

aeric · Mar 28, 2022

Tamer El-Shimy said:
the code worked for another test application

If the code works in another application then you must be making mistake in the current project.

aeric · Mar 28, 2022

Tamer El-Shimy said:
I'm still getting the error message "No suitable driver for"

I suspect you still not making the right amendment. Since no project uploaded, it is difficult to guess where you made mistakes. I 'll give up.

Tamer El-Shimy · Mar 29, 2022

aeric said:

Try:

B4X:

URL="jdbc:jtds:sqlserver://" & SIP & ":" & SPort & ";DatabaseName=KPI;IntegratedSecurity=False"

Yes , Sure .. This is what solved it . JDBCURL doesn't contain "http://".

Android Question JTDS No suitable driver found for

Tamer El-Shimy

Member

MicroDrie

Well-Known Member

Tamer El-Shimy

Member

MicroDrie

Well-Known Member

MicroDrie

Well-Known Member

Tamer El-Shimy

Member

Tamer El-Shimy

Member

aeric

Expert

Tamer El-Shimy

Member

aeric

Expert

Tamer El-Shimy

Member

aeric

Expert

Tamer El-Shimy

Member

Tamer El-Shimy

Member

Tamer El-Shimy

Member

aeric

Expert

aeric

Expert

Tamer El-Shimy

Member

Similar Threads

Android Question JTDS No suitable driver found for

Member

Well-Known Member

Member

Well-Known Member

Well-Known Member

Member

Member

Expert

Member

Expert

Member

Expert

Member

Member

Member

Expert

Expert

Member

Similar Threads

Privacy & Transparency

Privacy & Transparency