In some settings MySQL / MariaDB treats empty or null ‘datetime’ and ‘timestamp’ fields/columns as simply null, in others it writes out zeros (0s) like 0000-00-00 00:00:00. If you designed your own database, you probably know what you’re dealing with, already. But if you are working on someone else’s database, like migrating data to or from, or just doing development for it, for example, you may encounter the error “Incorrect datetime value: ‘0000-00-00 00:00:00’ for …
In version 5.6 of MySQL, you might get errors regarding InnoDB tables mysql/slave_master_info,mysql/slave_worker_info, and mysql/slave_relay_log_info like the following when the server was not gracefully shut down, and the InnoDB tables in question become eventually corrupt. This article will present detailed instructions to fix the problem.
MySQL Management and Administration with Navicat I was pleased to announce my book’s give-away campaign with Packt Publishing back on November 30th, 2012. All we asked the website visitors to do was just comment about the book below this post, and win a free e-copy of MySQL Management and Administration with Navicat. Three lucky winners got the chance to win free copies of the e-book. You could have been one of the Lucky Ones if you visited this …
In this part (4) of the tutorial we will correct the bugs inherent in version 2.2 of Seam-gen and we will add some code to spice up our blog CMS. First of all, our PostEdit.seam page is not working at all as it is. We shall fix this: Open PostEdit.xhtml from the WebContent folder and find the <rich:tabPanel switchType=”ajax”> block. This is what’s causing the problem, because it has more than one tab – one …
In part I of the tutorial, I provided the instructions about the development environment and how to create the blog’s database. In this part II, using Eclipse’s JBoss tools plugin, we’ll create and configure the JBoss Seam web project and prepare it for full Tomcat-compatibilty and for the creation the basic CRUD (create, read, update and delete) functionality of entities which will be reverse engineered from the database using hbm2java embedded in Seam-gen whose GUI version comes built-in …