B4J Question Problem connecting MySQL database

[tanush62]

I have MySql version 5.1.30 Installed on my PC. I copied one database to a webpage like "www.somepage.com"
With local database i have no problem connecting, but I cannot connect to web database.
I can connect both of them try "Navicat". That way i copied database from local PC.

Im Using code:

#Region Project Attributes
    #AdditionalJar: mysql-connector-java-5.1.30.jar
    #AdditionalJar: sqlite-jdbc-3.7.2
#End Region

.........


SQL1.Initialize2("com.mysql.jdbc.Driver", "jdbc:mysql://" & srv & "/information_schema", user, password)
' comment    if srv = "localhost" or IP adress working fine but if I put srv = "www.somepage.com" does not work.

What I'm doing wrong? I tried connector 8.0.17 again i cannot connect.

 

[Erel]

Please post the error message.

 

[tanush62]

Please post the error message.

java.sql.SQLException: The server time zone value 'CEST' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more specifc time zone value if you want to utilize time zone support.

 

[Erel]

https://www.b4x.com/android/forum/threads/mysql-connection-problem.104485/#content

 

[tanush62]

https://www.b4x.com/android/forum/threads/mysql-connection-problem.104485/#content

Thank You Mr. Erel, You are the Great.

While I'm here... Can I use more than one connector?
Like:

#Region Project Attributes
    #AdditionalJar: mysql-connector-java-5.1.30.jar
    #AdditionalJar: mysql-connector-java-8.0.17.jar
.......

And how to choose which one i use for connection?

 

[Erel]

No. You can only use a single MySQL connector.