Add state/region(s) for Mexico in Magento

If you need to add the states or regions of Mexico to you magento store use the following SQL script.



INSERT INTO `directory_country_region` VALUES (NULL , "MX", "AGS","Aguascalientes"),(NULL , "MX", "BCN","Baja California Norte"),(NULL , "MX", "BCS","Baja California Sur"),(NULL , "MX", "CAM","Campeche"),(NULL , "MX", "CHIS","Chiapas"),(NULL , "MX", "CHIH","Chihuahua"),(NULL , "MX", "COAH","Coahuila"),(NULL , "MX", "COL","Colima"),(NULL , "MX", "DF","Distrito Federal"),(NULL , "MX", "DGO","Durango"),(NULL , "MX", "GTO","Guanajuato"),(NULL , "MX", "GRO","Guerrero"),(NULL , "MX", "HGO","Hidalgo"),(NULL , "MX", "JAL","Jalisco"),(NULL , "MX", "MICH","Michoacan"),(NULL , "MX", "MOR","Morelos"),(NULL , "MX", "MEX","Mexico (Estado de)"),(NULL , "MX", "NAY","Nayarit"),(NULL , "MX", "NL","Nuevo Leon"),(NULL , "MX", "OAX","Oaxaca"),(NULL , "MX", "PUE","Puebla"),(NULL , "MX", "QRO","Queretaro"),(NULL , "MX", "QROO","Quintana Roo"),(NULL , "MX", "SLP","San Luis Potosi"),(NULL , "MX", "SIN","Sinaloa"),(NULL , "MX", "SON","Sonora"),(NULL , "MX", "TAB","Tabasco"),(NULL , "MX", "TAMPS","Tamaulipas"),(NULL , "MX", "TLAX","Tlaxcala"),(NULL , "MX", "VER","Veracruz"),(NULL , "MX", "YUC","Yucatan"),(NULL , "MX", "ZAC","Zacatecas");

Remote debugging Applet with Eclipse

Assignment:

Configure Eclipse for remote debugging an applet. The applet will be running on an internet browser. When a breakpoint is reached, Eclipse should suspend allowing the code to be debugged.

 

Solutions:

Java provides a protocol to achieve this. You can look for JDWP in Java documentation for more information. This protocol allows debugging even a simple class. It works with a server-client mechanism. Either eclipse or the browser can be set as server.

Steps:

1.        First, I need to configure the server. I will use eclipse as server, and the applet will be the client.

From the eclipse menu choose the option: Remote Java Application.

I used the following values:

Connection Type: Socket Listen

       Port: 9100  - You can use any value, just make sure the port is not busy.

 

 

2.        Now, I need to configure the client. Since I am using the browser, I will set the values to the JRE the browser uses.

Go to: Control Panel -> Java -> (Go to Java Tab) -> Java Runtime Environment.

And add the following line to the Runtime Parameters:

-agentlib:jdwp=transport=dt_socket,server=n,suspend=y,address=9100

The port must match the one you configured in eclipse and the option server must be set to 'n'.  You also need to make sure to add the parameters to the correct JRE.

 

* Like I said, you can debug even a single class. To debug a standalone class or jar use the line like this:

java –jar -agentlib:jdwp=transport=dt_socket,server=n,suspend=y,address=9100 <class or jar>

 3.        Add some breakpoint to your code. Run the applet from your browser and the breakpoint should be hit.

Tips:

This is a very simple task. However, it does not always work as expected (what software does?) I hope this tips can help you to save some time.

1.      If it does not work try again with a different version of Java. The newest versions seem to have some security features that block the remote debugging. I was able to make it work with JRE. 1.7.0_17.

2.      Verify that your JRE is receiving the values. You can see them in the console.   

3.     For some weird reason, sometimes the values seem no to be passed. Try setting them using JRE_Instalation/bin/javacpl.exe window.

4.      Signing the JAR does not seem to be necessary.

5.      You can specify the JRE to use in the applet tag to be sure that you are using the correct JRE. Add the following line to your applet tag.

      <param name="java_version" value="1.7.0_17"/>

6.   The jar does not need to be deployed on a server in order to debug it. For this test I created an applet and put it in a jar. Then I created a simple html file with the applet tag. I open my html in a browser, and it worked fine.

 

 

 

 

References:

JDWP: http://docs.oracle.com/javase/1.5.0/docs/guide/jpda/jdwp-spec.html

About this...

I am a computer system engineer with several years of experience working in software development. I work as java developer for a company and as part-time independent consultant.

A few days ago, a client asked me to configure eclipse for remote debugging an applet. I accepted the job thinking that it would be a trivial task. After all, I have done this before some years ago. To my surprise, the task was not easy at all. I spent like seven hours (three nights) to finally be able to make it work.

This is not the first time I waste hours trying to solve something I have already solved in the past. Very often, I have to do something, I find the way to complete it, and I am happy with the result. But sometime later the same task appears, and I don’t remember how I solved it. Then I waste time googling for information that somehow is in my head.

This blog has the purpose of helping me to remember how I solved some problems I have faced with different technologies like: Java, PHP, Oracle, etc. And I hope this will also help others to find answers.

I don’t consider myself a tech “guru”, so probably my solutions are not the perfect ones. If you want to comment on a solution feel free to do it. If you have questions, please ask them. If there is something I can help, I will.

Welcome!