CODEWITHSUNDEEP
netbeans-8mysql-5.7
Mohita Shrivastava
Mohita Shrivastava

Reputation: 11

I am begginer with mysql connection with netbeans

When I click on start on Database, it shows error like ZeroDataTimeBehaviour. I tried everything but I did not get the solution since I am new to mysql and its connectivity. Mysql works properly in command line but I don't know how to connect with netbeans properly ?

Error on click on start on netbeans

Upvotes: 0

Views: 33

Answers (1)

Gaming.ingrs
Gaming.ingrs

Reputation: 281

First of all I would try with this setting:

enter image description here

If that doesn't help to You try to lower version of mySql to 5.5

You might find this link helpful: NetBeans, MySQL

zeroDateTimeBehavior

What should happen when the driver encounters DATETIME values that are composed entirely of zeros (used by MySQL to represent invalid dates)? Valid values are "exception", "round" and "convertToNull".

Default: exception

Since version: 3.1.4

Upvotes: 1

Related Questions