Eager to Code, Enjoy to Debug ~ Embark into Each Stage with Your Heart

Change Table Column Size in MySQL

Posted by: Chyne on: February 9, 2010

Last few weeks, when I was trying to deploy a backup data consists of around 100 MB in size, the deployment ends up in failure with some of the following errors:


2010-02-09 14:20:48,199 main WARN     [core.entity.jdbc.DatabaseUtil] WARNING: Column "<column_name>" of table "<table_name>" has a column size of "600" in the database, but is defined to have a column size of "255" in the entity definition.

After a few days, the customer came back with a reply and telling me that I need to change the column size from 600 to 255. 255 is the default value for the column size of the table.

Although the command to change the column size is not that hard but this is really the first time I encountered this. I strongly dislike users that violating the database or disrespect the default database settings.

In order to change the column size in mysql, the command is:

ALTER TABLE tablename MODIFY columnname varchar(600);

Since some of the data for that particular column in the backup contains more than 255 characters and the customer’s database has already setup (the failure just occurs when the data does not fits into the required size), I changed the column size into 600 instead of 255.

How to Generate Hardware Information on Ubuntu

Posted by: Chyne on: February 6, 2010

You can generate a nice report (HTML or XML format) of your laptop/desktop hardware information by executing this command:

lshw -html > sysinfo.html

You can find the detailed information about lshw from the following page:


Other alternative method is to install hardinfo in Ubuntu:

Tags:

Top 10 in codingexplorer for 2009

Posted by: Chyne on: January 1, 2010

Top 10 Posts and Pages from WordPress Statistics

Title Views
The BASEDIR environment variable is not defined correctly. This environment variable is needed to run this program 2,792
The Reason behind Oracle 11g: SEVERE: Error while registering Oracle JDBC Diagnosability MBean 1,583
Tomcat Startup Error: Error in dependencyCheck 827
Why Windows Subsystem Process Terminated Unexpectedly? 809
Installation of Bugzilla in Ubuntu Environment 544
java.io.FileNotFoundException with (Permission Denied) 539
SSL Certificate is not imported properly – ‘unable to find valid certification path to requested target’ 481
java.net.BindException: Address already in use: JVM_Bind:8090 465
Installation of Subversion 1.6.5 on Ubuntu 8.10 463
How to Install Mantis in Ubuntu? 404



Top 10 Clicks from WordPress Statistics

URL Clicks
The BASEDIR environment variable is not defined correctly This environment variable is needed to run this program 450
Oracle’s malicious OracleDataSource implementation and why it fails in Tomcat 360
How to troubleshoot a “STOP 0xC000021A” error 294
Tomcat 6 web app is not started because of “java.io.IOException: invalid header” 179
Thread: SEVERE: Error while registering Oracle JDBC Diagnosability MBean 158
No more ‘unable to find valid certification path to requested target’ 119
Blogs about: Java How To Program 7th Edition It Practice Books 99
20.3.4.1. Driver/Datasource Class Names, URL Syntax and Configuration Properties for Connector/J 66
java.io Class FileNotFoundException 58
Extension Validator 49



Top 10 Search Terms from WordPress Statistics

Search Views
the basedir environment variable is not 841
error while registering oracle jdbc diag 320
error while registering oracle jdbc diag 255
the basedir environment variable is not 224
the windows subsystem system process ter 134
windows subsystem system process termina 110
severe: error while registering oracle j 78
severe: error in dependencycheck 75
basedir environment variable is not defi 69
the windows subsystem system process ter 59

Statistics for Year 2009

Posted by: Chyne on: January 1, 2010

Yearly Statistics from StatCounter

StatCounter Year 2009

Monthly Statistics from WordPress

Months and Years from WordPress

Rating Reports from WordPress

What’s for 2009?

Posted by: Chyne on: December 31, 2009

As usual, 31st December of every year, I will blog about what I had done for the entire year , incomplete tasks that need to carry forward to the next year and also the annual report to show the progress of the blog.


<<< Last Year 2008
Can’t recall much but remember that it’s not a good year comparing with this year.


This Year >>> 2009
This year is stuffed with knowledge and quite busy most of the time comparing with previous years. Besides of spending more time for personal reading and research, most of the time was spent in planning and thinking and all these were not that much during previous year.

Last year, I was given the opportunity to travel to Indonesia for on-site support. As for this year, without my expectation, I was given the opportunity to travel to Sydney for training. I’m looking forward for the next surprise in 2010.


Next Year >>> 2010
A lot of personal planning needs to be done in year 2010 and I can foresee that 2010 will be even busier than 2009.

Still carry forward the same tasks from the previous years. Embarrassed to say that.

  • Internship Notes (almost there)
  • Java How to Program book (still a lot more to do)

New tasks

  • Ajax Bible book
  • SCJP book

SCJP will be the highest priority at the moment due to the reason that it causes a lot of preventions for me to complete other personal tasks. Besides that, this has been postponed since last year when I was on the job transition. The second postponement was due to the reason of the training in Sydney. I hope that there is no more postpones again as this is the biggest blocker for me at the current moment.

Well, sometimes, I will think if there is really another postponement, I don’t think I’m going to proceed to sit for the exam but it doesn’t mean I already given up. I already gained all the required knowledge from what I had studied so far. Most important is the knowledge that I had gained during the learning path :)

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

 

February 2010
M T W T F S S
« Jan    
1234567
891011121314
15161718192021
22232425262728

Archives


StatCounter

free hit counters