When you post code (such as the XML and the Perl code above), please wrap it in <code> tags to make it readable.

use strict ; 
use warnings ; 
use XML::Simple ;

my $xml = <<'EOD' ;
<database name="somedb">
  <table name="table1">
    <column name="column11" javaname="jn11" type="CHAR" />
    <column name="column12" javaname="jn12" type="CHAR" />
  </table>
  <table name="table2">
    <column name="column21" javaname="jn21" type="CHAR" />
    <column name="column22" javaname="jn22" type="CHAR" />
  </table>
</database>
EOD

my $data = XMLin( $xml, forcearray => 1 ) ;
 
foreach my $table_name ( keys(%{$data->{'table'}}) )
{
   my $table = $data->{'table'}{$table_name};

   foreach my $column_name ( keys(%{$table->{'column'}}) )
   {
      my $column      = $table->{'column'}{$column_name};
      my $column_type = $column->{'type'}; 
      my $column_java = $column->{'javaname'}; 

      print("Type      of column $column_name in table $table_name is 
+$column_type.\n");
      print("Java name of column $column_name in table $table_name is 
+$column_java.\n");
   }
}
[download]