B4J Question Problem connecting MySQL database

tanush62

Member
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:
B4X:
#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.
 

tanush62

Member
Please post the error message.
B4X:
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.
 
Top