Android Question connexion to mysql server online

[NomeUn]

Hello,

I have a problem when trying to connect to a mysql server online using jdbc.
I have copy the jdbcSQLExemple from here : link
I've only changed the url, the id and the password and i have this error :

(SQLException) java.sql.SQLException: No suitable driver found for "SERVERNAME"

I've also add this jar file :

#AdditionalJar: mysql-connector-java-8.0.28

What could be the problem ?

 

[Erel]

1. Post the jdbc url.
2. If I remember correctly the latest versions of mysql driver aren't compatible with Android. You need to use an older version.

 

[NomeUn]

1. Here is my jdbc url.

Private jdbcUrl As String = "[I]NAME[/I].webapps.net"

How do I know if my mysql server is compatible with jdbc ?
2. I've tried with this driver :

#AdditionalJar: mysql-connector-java-5.1.34-bin

and I have the same error

 

[Erel]

It is wrong.
Example: https://www.b4x.com/android/forum/threads/jar-crash-on-jdbc-timeout-mysql.88214/#content

 

[NomeUn]

It is wrong.
Example: https://www.b4x.com/android/forum/threads/jar-crash-on-jdbc-timeout-mysql.88214/#content

Thanks, I changed it by :

Private jdbcUrl As String = "jdbc:mysql://NAME.webapps.net:3306/c25database?characterEncoding=utf8"

but now the error is with the encoding :

(WrongArgumentException) com.mysql.cj.exceptions.WrongArgumentException: Unsupported character encoding 'utf8'

 

[Erel]

Remove this: ?characterEncoding=utf8

 

[NomeUn]

Remove this: ?characterEncoding=utf8

I found my mistake.
I did'nt call the right database
Thank you for this quick support.