Monthly Archives: November 2006

JDBC parameter for null timestamps in MySQL

I just came to know that support for timestamps with null values in MySQL JDBC using mysql-connector-java is not default! It throws an exception. However, using zeroDateTimeBehavior parameter with a value of convertToNull in the jdbc url will do the trick.

Leave a comment

Filed under Database, JDBC, MySQL

Freeware tools to convert DVD to MP4 (iPod Video)

I wanted to convert a dvd into mp4 to be able to view it from my iPod. After a bit of research, found several shareware tools to do this. I usually look for freeware first and only if I don’t find something suitable, I explore other alternatives (like buying a shareware program or a popular commercial program). After a bit of experimentation, I was able to successfully convert a dvd into mp4 and upload it on to the ipod. Below is what I had to do (if you are going to follow what’s given below, make sure what you are doing is legal)

1. Use DVDFab Decrypter to extract VOB files from the DVD. A dvd can have several vob files but you can select the ones that you really need by previewing.
2. If you end up with multiple VOB files, then you need to first merge them before converting them to mp4. For this, you can use the VOBMerge.
3. Finally, use the MobileVideo For iPod to convert the VOB file into an mp4 file.
4. Connect your ipod to the PC and drag and drop the mp4 file into the itunes under the ipod Movies section.

That’s it, you are done!

Update: Recently I came to know of an open source software that converts DVD to MP4 and it’s called HandBrake.


Filed under DVD Tools, iPod Video, mp4

Running linux on a windows laptop

I recently got a Dell Inspiron I6400 T2300 with XP Home edition. Given that it has 2 cores, 120GB harddisk and 1GB RAM, I wanted to try running linux within XP. So, I first downloaded Microsoft’s Virtual Server software which is free but that didn’t let me create virtual servers on XP home edition. Apparently, it only works on XP Professional edition, for which I would have had to shell out another $100 or so. So, I then downloaded VMWare Server 1.0.1, which btw, is also free and it worked fine. I initially had a few issues, as this is the first time I ever ventured into the virtualization space, but things went smoothly. I downloaded Gentoo’s 2006.1 distribution for Linux and now the system is up and running. Performance is pretty decent, I don’t get the feeling I am either running a virtual server when I am in XP or that it’s a virtual server when I am in linux.

Leave a comment

Filed under Tech - Tips, Virtual Server, virtualization