How to connect java using eclipse with MySQL database

Question

I got the error

Error:java.sql.SQLException: The server time zone value 'Malay Peninsula Standard Time' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the server timezone configuration property) to use a more specific time zone value if you want to utilize time zone support. java.lang.NullPointerException

I tried changing my computer's time with our local timezone but still the same error.

I tried adding my connection:

"jdbc:mysql://localhost/db?useUnicode=true&amp;useJDBCCompliatnTimezoneShift=true&amp;useLegacyDatetimeCode=false","root",""

still no work and i got the error:

Error:java.sql.SQLNonTransientConnectionException: Cannot load connection class because of underlying exception: com.mysql.cj.exceptions.WrongArgumentException: Malformed database URL, failed to parse the connection string near ';useJDBCCompliatnTimezoneShift=true&useLegacyDatetimeCode=false'. java.lang.NullPointerException

My connection string is:

Class.forName("com.mysql.cj.jdbc.Driver");
con = DriverManager.getConnection("jdbc:mysql://localhost:3306/raqs","root","");

Is an instance of MySQL actually running when you try this? Did you configure it to listen on local host and on port 3306? Can you show us how you configured MySQL networking so we can verify that it's running correctly? — markspace
– markspace, Commented Sep 13, 2018 at 3:06
I have tried connecting MySQL database with a php code and I can access the database in my local host — Raqz
– Raqz, Commented Sep 13, 2018 at 3:17

rzwitserloot · Accepted Answer · 2018-09-13 03:13:12Z

1

Fix your typo. It's 'compliant', not 'compliatn'. Just like the error says.

answered Sep 13, 2018 at 3:13

rzwitserloot

107k6 gold badges74 silver badges104 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Raqz Over a year ago

Fixed it but still an error: Error:java.sql.SQLException: The server time zone value 'Malay Peninsula Standard Time' 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. java.lang.NullPointerException

Raqz · Accepted Answer · 2018-09-13 15:57:05Z

0

To solve my problem:

I have only added serverTimezone=UTC to my URL. And to be very careful in declaring a query which is case sensitive. And make sure in declaring variables in String or in Int and etc.

My codes worked well already and successfully connected my database to the eclipse ^_^

answered Sep 13, 2018 at 15:57

Raqz

35 bronze badges

Collectives™ on Stack Overflow

How to connect java using eclipse with MySQL database

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related