Eastern Polish Christmas Tree Notation

public
DataPair[] getHotelInformation(String hotelId, String informationId)
                           {
                              return getHotelInfo("EN", hotelId, informationId);
                            }

public
DataPair[] getHotelInformation(String lang, String hotelId, String informationId)
                           {

                String key = "_HOINF_"+lng+"_"+hotelId+"_"+informationId;
             DataPair[] tbl = (DataPair[])csh.getObject(key);
               if(tbl!=null)  return tbl;

              Connection cn = null;
OracleCallableStatement cs = null;
                        try {
                 String qry = " begin HotelServices.getHotelInfo(?, ?, ?, ?, ?); end; ";
                    logger . debug("---"+qry+" "+hotelId+" "+informationId);
                         cn = DriverManager.getConnection("jdbc:weblogic:pool:oraclePool",null);
                         cs = (OracleCallableStatement)cn.prepareCall(qry);
                         cs . registerOutParameter(1,java.sql.Types.INTEGER);
                         cs . registerOutParameter(2,java.sql.Types.OTHER);
                         cs . setString(3,hotelId);
                         cs . setString(4,informationId);
                         cs . setString(5,lang);
                         cs . execute();
                    int sta = cs.getInt(1);
                  if(sta!=0)  throw new Exception("status not zero sta="+sta);
               ResultSet rs = cs.getResultSet(2);
                       tbl = getDataPairArray(rs);
                     logger . debug("sta="+sta+" key="+key+" cn="+cn);
                        csh . put(key,tbl);
                            }
                       catch(Exception e)
                            {
                     logger . debug("!!! "+e.toString()+" "+key);
                            }
                     finally
                            {
                        try {
            if(cs!=null) cs . close();
           if(cn!=null) cn . close();
                            }
                       catch(Exception x)
                            {
                     logger . debug("!!! "+x.toString()+" "+key);
                     logger . error("!!! "+x.toString());
                            }
                            }
                      return tbl;
                            }