Change Table Column Size in MySQL
Posted by: Chyne on: February 9, 2010
- In: MySQL
- Leave a Comment
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
- In: Linux
- 2 Comments
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:
Top 10 in codingexplorer for 2009
Posted by: Chyne on: January 1, 2010
Top 10 Posts and Pages from WordPress Statistics
Top 10 Clicks from WordPress Statistics
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
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 
- The BASEDIR environment variable is not defined correctly. This environment variable is needed to run this program
- Installation of Bugzilla-3.4.4 on Ubuntu 9.0.4
- Installation of Subversion 1.6.5 on Ubuntu 8.10
- The Reason behind Oracle 11g: SEVERE: Error while registering Oracle JDBC Diagnosability MBean
- Why Windows Subsystem Process Terminated Unexpectedly?
- How to Change the Location of stdout.log?
- java.io.FileNotFoundException with (Permission Denied)
- 'Interface was expected' for JPEGImageEncoder
- How to Reset Postgres Forgotten Password?
- Installation of Bugzilla in Ubuntu Environment
- How to Generate Hardware Information on Ubuntu « Eager to Code … | Just linux！: [...] Read more: How to Generate Hardware Information on Ubuntu « Eager to Code … [...]
- How to Generate Hardware Information on Ubuntu « Eager to Code …: [...] more here: How to Generate Hardware Information on Ubuntu « Eager to Code … Рубрика: Разные рубрики | Метк
- gJans: This post is a life saviour Thanks
