No enum constant mysql.cj.conf.PropertyDefinitions.ZerodatetimeBehaviour.CONV ERTTONULL using MySQL Community Server 8.0.11 and NetBeans 8.0.2
Posted by: Martin OShea
Date: April 20, 2018 07:08PM

I have just upgraded my installation of MySQL to the Community Edition 8.0.11.0 and all of the relavant database schemas have been restored correctly with appropriate authorities.

However, when trying to run a Java application in NetBeans 8.0.2 which connects to the database, I receive messages in NetBeans saying that:

"No enum constant MySql.cj.conf.PropertyDefinitions.ZerodatetimeBehaviour.CONVERTTONULL"

Furthermore, the following messages also appear:

"2018-04-21T00:59:31.427055Z 0 [System] [MY-010116] [Server] C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe (mysqld 8.0.11) starting as process 25496
mysqld: Table 'mysql.plugin' doesn't exist
2018-04-21T00:59:33.444111Z 0 [ERROR] [MY-010735] [Server] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
2018-04-21T00:59:33.907490Z 0 [Warning] [MY-010015] [Repl] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2018-04-21T00:59:35.066791Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2018-04-21T00:59:35.071764Z 0 [ERROR] [MY-010262] [Server] Can't start server: Bind on TCP/IP port: Unknown error
2018-04-21T00:59:35.071936Z 0 [ERROR] [MY-010257] [Server] Do you already have another mysqld server running on port: 3306 ?
2018-04-21T00:59:35.072186Z 0 [ERROR] [MY-010119] [Server] Aborting
2018-04-21T00:59:36.466971Z 0 [System] [MY-010910] [Server] C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe: Shutdown complete (mysqld 8.0.11) MySQL Community Server - GPL."

My application has the mysql-connector-java-8.0.11.jar and this file has also been added to NetBeans.

I believe that my MySQL settings in NetBeans are correct: for file mysqld.exe I have options --console --datadir=C:\\ProgramData\\MySQL\\MySQL Server 8.0\\Data\\. And for mysqladmin.exe I have -u root shutdown.

So can anyone advise why I have these messages?

Options: ReplyQuote


Subject
Written By
Posted
No enum constant mysql.cj.conf.PropertyDefinitions.ZerodatetimeBehaviour.CONV ERTTONULL using MySQL Community Server 8.0.11 and NetBeans 8.0.2
April 20, 2018 07:08PM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.