Abhisar's Blog

I was looking on the net for the query that "What will happen in an InnoDB MySQL table with column of type AUTO INCREMENT if the max value has reached?" There is so much of information on the net regarding this but does not lead anywhere. I could not find any official word in this query. Most of the links say that it would throw an error. Some had other views that the behavior is not predictable http://www.dbforums.com/mysql/1207954-auto-increment-field-hit-maximum-integer-value.html So i tried a small test myself through mysqlcc by inserting the largest value in int(11) - AUTO INCREMENT type column (name "id"). Th maximum value i could insert manually was "2147483647" (the next number gives "Out of range value" error) The moment I inserted a new row, the new number assigned to the column "id" was "1000000000" Behavior was strange, might help someone that it did not give an error

We had a requirement to provide some CRUD based screens to perform administrative task. After doing some searching I found a tool. Our requirement changed so have not used it, but thought of sharing the tool with all those extreme programmers to save their time. http://sourceforge.net/projects/struts2builder/ I builds a base project on for CRUD operations on selected tables. Also provide maven based structure.

In case you have the need to crawl the web to get information. I would suggest few: Smart and Simple Web Crawler - https://crawler.dev.java.net/ Websphnix - http://www.cs.cmu.edu/~rcm/websphinx/ Archive-Crawler - http://archive-crawler.sourceforge.net Of these i would recommend https://crawler.dev.java.net/ Why? because I have used it. This is a quite simple crawler which serves the purpose. It loads the page and parses the page. Throws appropriate events while crawling. (i.e supports event model to serve the requirement). It has HTML and HTTP parsing capabilities.