try {
    //test
      
       byte  result[] =  null ;
      conn.setAutoCommit(false);
      LargeObjectManager lobj = ((org.postgresql.PGConnection)conn).getLargeObjectAPI();
      PreparedStatement stmt =
 	 conn.prepareStatement("SELECT rep_object FROM reports WHERE name = ?");
         
      stmt.setString( 1 , "test");
  
      
      ResultSet rs = stmt.executeQuery();
      
      LargeObject obj =  null ;
       if  (rs.next()){
         int  oid =  0 ;        
        oid = rs.getInt( 1 );
        obj = lobj.open(oid, LargeObjectManager.READ);
        
      }      
     //--test
     if  (obj !=  null ){  
      System.out.println("test proverka");
      JasperReport jasperReport =  JasperCompileManager.compileReport(obj.getInputStream());
      Map parameters =  new  HashMap();
      
      parameters.put("ReportTitle", "The Horizontal Report");
      parameters.put("MaxOrderID",  new  Integer( 10500 ));
      parameters.put("SummaryImage",  null );
      parameters.put("QUERY_FILTER", "select * from official_position where id =    '1110#0#0'");
      JasperPrint jasperPrint = JasperFillManager.fillReport(jasperReport, parameters,conn);
      JRViewer jv =  new  JRViewer(jasperPrint);
      jv.setSize( 600 , 400 );
      jv.setVisible(true);
      ReportFrame rf =  new  ReportFrame();
      rf.add(jv);
      rf.setVisible(true);
      jv.show();
      rf.moveToFront();
      dp.add(rf);
    }
  } catch (JRException f){
    System.out.println(f);
  } catch (SQLException e){
      System.out.println(e);
  }