Пример #1
0
  public static JasperPrint generateRecapAdressesClients(Date dateDebut, Date dateFin) {

    JasperPrint printImprCheques = new JasperPrint();

    Connection conn = null;
    long start = System.currentTimeMillis();
    try {

      Map<String, Object> paramFacture = new HashMap<String, Object>();
      paramFacture.put("debut", dateDebut);
      paramFacture.put("fin", dateFin);

      org.hibernate.Session session = CEFXUtil.getSessionFactory().getCurrentSession();

      SessionFactoryImplementor sfi = (SessionFactoryImplementor) session.getSessionFactory();
      ConnectionProvider cp = sfi.getConnectionProvider();
      conn = cp.getConnection();

      printImprCheques =
          JasperFillManager.fillReport("src/cefx/report/AdresseAnnee.jasper", paramFacture, conn);

    } catch (Exception e) {
      throw new RuntimeException("Impossible de générer le recap", e);
    } finally {
      //                     it's your responsibility to close the connection, don't forget it!
      if (conn != null) {
        try {
          conn.close();
        } catch (Exception e) {
        }
      }
    }

    return printImprCheques;
  }
 private void closeConnection() {
   try {
     if (statement != null) statement.close();
     if (connection != null) {
       JDBCExceptionReporter.logWarnings(connection.getWarnings());
       connection.clearWarnings();
       connectionProvider.closeConnection(connection);
       connectionProvider.close();
     }
   } catch (Exception e) {
     System.err.println("Could not close connection");
     e.printStackTrace();
   }
 }
 private void createConnection() throws SQLException {
   connectionProvider = ConnectionProviderFactory.newConnectionProvider(properties);
   connection = connectionProvider.getConnection();
   if (!connection.getAutoCommit()) {
     connection.commit();
     connection.setAutoCommit(true);
   }
 }
Пример #4
0
  public static JasperPrint generateFacture(Integer numFacture) {

    Connection conn = null;
    JasperPrint printFacture = new JasperPrint();

    long start = System.currentTimeMillis();

    try {

      Map<String, Object> paramFacture = new HashMap<String, Object>();
      paramFacture.put("num_commande", numFacture);

      org.hibernate.Session session = CEFXUtil.getSessionFactory().getCurrentSession();

      SessionFactoryImplementor sfi = (SessionFactoryImplementor) session.getSessionFactory();
      ConnectionProvider cp = sfi.getConnectionProvider();
      conn = cp.getConnection();

      printFacture =
          JasperFillManager.fillReport("src/cefx/report/FactureCE.jasper", paramFacture, conn);
      //    JasperPrint printBDC =
      // JasperFillManager.fillReport("src/cefx/report/BonDeCommande.jasper", paramFacture, conn);

    } catch (Exception e) {
      throw new RuntimeException("Impossible de générer la Facture", e);
      //  COMMANDE ENREGISTREE MAIS NON IMPRIMEE
    } finally {
      //                     it's your responsibility to close the connection, don't forget it!
      if (conn != null) {
        try {
          conn.close();
        } catch (Exception e) {
        }
      }
    }

    return printFacture;
  }
Пример #5
0
  public void readFromDatabase(String catalog, String schema, Mapping mapping) {

    this.connectionProvider = settings.getConnectionProvider();

    try {

      DatabaseCollector collector = readDatabaseSchema(catalog, schema);
      createPersistentClasses(collector, mapping); // move this to a different step!
    } catch (SQLException e) {
      throw settings.getSQLExceptionConverter().convert(e, "Reading from database", null);
    } finally {
      if (connectionProvider != null) connectionProvider.close();
    }
  }
  /**
   * Execute the schema updates
   *
   * @param script print all DDL to the console
   */
  public void execute(boolean script, boolean doUpdate, File out) {

    log.info("Running hbm2ddl schema update");

    Connection connection = null;
    Statement stmt = null;
    boolean autoCommitWasEnabled = true;
    FileWriter writer = null;

    if (script && out != null) {
      try {
        log.info("Creating filewriter to file : " + out.getAbsolutePath());
        writer = new FileWriter(out);
      } catch (IOException e) {
        log.debug("IOException while creating filewriter");
        log.debug(e);
      }
    }

    exceptions.clear();

    try {

      DatabaseMetadata meta;
      try {
        log.info("fetching database metadata");
        connection = connectionProvider.getConnection();
        if (!connection.getAutoCommit()) {
          connection.commit();
          connection.setAutoCommit(true);
          autoCommitWasEnabled = false;
        }
        meta = new DatabaseMetadata(connection, dialect);
        stmt = connection.createStatement();
      } catch (SQLException sqle) {
        exceptions.add(sqle);
        log.error("could not get database metadata", sqle);
        throw sqle;
      }

      log.info("updating schema");

      String[] createSQL = configuration.generateSchemaUpdateScript(dialect, meta);
      for (int j = 0; j < createSQL.length; j++) {

        final String sql = createSQL[j];
        try {
          if (script) {
            System.out.println(sql);
            if (writer != null) {
              writer.write(sql + ";\n");
            }
          }
          if (doUpdate) {
            log.debug(sql);
            stmt.executeUpdate(sql);
          }
        } catch (SQLException e) {
          exceptions.add(e);
          log.error("Unsuccessful: " + sql);
          log.error(e.getMessage());
        }
      }

      if (writer != null) {
        writer.close();
      }

      log.info("schema update complete");

    } catch (Exception e) {
      exceptions.add(e);
      log.error("could not complete schema update", e);
    } finally {

      try {
        if (stmt != null) stmt.close();
        if (!autoCommitWasEnabled) connection.setAutoCommit(false);
        if (connection != null) connection.close();
        if (connectionProvider != null) connectionProvider.close();
      } catch (Exception e) {
        exceptions.add(e);
        log.error("Error closing connection", e);
      }
    }
  }