[Solved] java.sql.SQLException - Zero date value prohibited

-
Recently while working on a Java + Spring + Hibernate + MySQL project I encountered a weird exception "java.sql.SQLException: Zero date value prohibited"!


As usual I did a quick search on Google but to my surprise Google did not return any result!

First I was scared, thought troubleshooting would be difficult. Upon closed analysis of the issue, this came out to be a silly data issue!


org.springframework.dao.TransientDataAccessResourceException: Hibernate operation: could not execute query; SQL [select field1, field2, field3 from table1]; Zero date value prohibited; nested exception is java.sql.SQLException: Zero date value prohibited.

I had a date column where the entries were '0000-00-00', just nullified the entries and the error went away!

Comments

Post a comment

Did you enjoy this post? Why not leave a comment below and continue the conversation, or subscribe to our feed and get articles like this delivered automatically to your feed reader? Like our Facebook Page.

Popular posts from this blog

Induction Cooker Showing an Error Code? Induction Cooker Error Codes Explained

-
Image
Are you searching for Induction Cook-top error codes? Here you can find the error codes of all popular induction cooktops and how to troubleshoot it.

These are for your reference only, do not try to open your cooktop without proper safety measures, we advise you to call the service person if any servicing is needed.

If you want to know how Induction Cook-top works, read our previous article titled What is Induction Cooker? How Induction Cooker Works?.

Whirlpool Induction Cooker Error CodesError CodeErrorSolutionF0An internal error was detected.Disconnect power. Wait 5 seconds before reconnecting power. If the symbol appears again, call for service.F2The surface cooking area is too hot and has turned off.Remove the pans from the surface cooking area. "F2" will disappear when the surface cooking area has cooled. If you turn the surface cooking area back on and "F2" reappears, the cooktop is still too hot. Turn off the surface cooking area and allow it to cool.F4The po…
Read more

How to Child Lock Channels on Airtel Digital TV

-
Image
Do you want to lock some of the TV channels you have subscribed on your Airtel Digital TV so that your kids cannot watch it when you are not at home?Its easy, first press the MENU button on your universal remote and go to Settings->Child Lock/Parental Control/Security.You might have to enter a PIN code to unlock this screen. Enter the PIN/CODE set by you or 0000(also try 1234) if you have not yet changed the default PIN.All the channels subscribed by you will be listed on successful PIN entry. Now select the channels you want to lock. Finally click the Apply button once you are done with the channel selection. Also there is an option to lock the channels by rating, makes your channel selection easier.Do not forget to change the default PIN, each time you need to enter this PIN to watch the locked channels.Follow the same steps to remove channels from the block list.The steps and even the default passwords are same for other DTH providers like Tata Sky, Dish TV, Videocon D2H, Sun Dir…
Read more

LICHFL - Generating Home Loan Statements Online

-
Image
Generating an online statement from LIC Housing Finance Ltd is very easy, simply follow the below steps to create an online account with LICHFL and generate statements online! You may use the online generated statement as a proof for principal paid for a housing loan(under section 80C) and interest paid(under section 24) while filing income tax returns.* Want to know how to save maximum income tax? Read our most read article how to save maximum income tax (opens in new tab).* Paying high interest to LICHFL? Learn how to reduce interest on your existing home loan (opens in new tab).
Before reading further, make sure you have the following information with you: Your Loan Account NumberSanctioned AmountStep 1 - Open LICHFL websiteVisit LICHFL website and click on the 'New Customers? Click Here' link(refer the below screenshot). Step 2 - Enter your loan account detailsFill in the following details: New Loan NumberSanctioned AmountDate of BirthSecurity Codeand click on the Submit b…
Read more