I’ve done a little more work on the IP address locator project.  I’ve added a CountryHelper class that looks up a country name based on a two character country code in order to completely fill out the LocationPOJO object in getLocation.  I changed the query that looks up the IP address info in the database so that it performs much faster.  It’s still not as fast as it could be though.  If I leave out the “and end_ip_num > ?” clause it performs much much faster but also returns bad results if the IP number is greater than 2^32.  As I typed that I came up with the fix.  I need to check the incoming IP number to see if it is greater than 2^32 before performing the query.  If I can eliminate the check on the high end in the query it will become much faster and also correct for all values between 0 and 2^32.  That fix will have to wait for the morning however.

Here is the project EAR file as it stands now.  As usual any questions and comments are welcome.

November 11th, 2006 | Java