Examples of org.jitterbit.integration.server.db.PreparedStatementCache

Package org.jitterbit.integration.server.db

Examples of org.jitterbit.integration.server.db.PreparedStatementCache

org.jitterbit.integration.server.db.PreparedStatementCache
Contains reusable PreparedStatements for each table in the database sources and targets. @author Torgil Zethson @since 3.0.0

        }
  }


  private String getCount(CROM table, String sql, List<CROM> params) throws SQLException {
        storeSqlForErrorReporting(sql, params);
      PreparedStatementCache cache=getStatementCacheForTable(table);
      PreparedStatement statement=cache.getPreparedStatement(sql);
      boolean statementMustBeClosedByMe=cache.mustLastReturnedStatementBeClosedByCaller();
        ResultSet result=null;
        writeSqlToLog(sql, params);
      try {
            int index = 1;
            for(CROM param: params){

View Full Code Here

          if(statementMustBeClosedByMe)KongaDbUtils.close(statement);
      }
  }


  private void doWriteRecord(CROM table, String sql, List<CROM> params) throws SQLException {
    PreparedStatementCache statementCache = getStatementCacheForTable(table);
    PreparedStatement statement ;
    boolean statementMustBeClosedByMe=true;
    if (sqlBuilder.hasColumnNonBind()) {
      statement = statementCache.createNewStatement(sql);
    } else {
      storeSqlForErrorReporting(sql, params);
      statement = statementCache.getPreparedStatement(sql);
      statementMustBeClosedByMe = statementCache.mustLastReturnedStatementBeClosedByCaller();
    }
    try {
      int index=1;
      for(CROM param: params){
        String value=param.getValue();

View Full Code Here

        m_sql=sql;
        m_params = params;
  }


  private PreparedStatementCache getStatementCacheForTable(CROM table) {
      PreparedStatementCache cache = statementCache.get(table);
      if (cache == null) {
          cache = new PreparedStatementCache(targetConnection);
          statementCache.put(table, cache);
      }
      return cache;
  }

View Full Code Here

          if(debug_log!=null)writeLog("SQL for table \"" + table.getName() + "\": " + sql);
          PreparedStatement stmt = null;
          boolean statementMustBeClosedByMe = true;
          ResultSet rs = null;
          try {
              PreparedStatementCache statementCache = getStatementCacheForTable(table);
              stmt = statementCache.getPreparedStatement(sql);
              statementMustBeClosedByMe = statementCache.mustLastReturnedStatementBeClosedByCaller();
            if(debug_log!=null)writeLog("About to execute query.");
              rs = stmt.executeQuery();
            if(debug_log!=null)writeLog("Done executing query.");
              int numRecordOfParent=0;
              while(rs.next()){

View Full Code Here

        try {
                    List<Record>records = Lists.newArrayList();
                    sql = buildSqlForTable(table);
                    if(debug_log!=null)writeLog("nField= " + nField);
                    if(debug_log!=null)writeLog("SQL for table \"" + table.getName() + "\": " + sql);
                    PreparedStatementCache statementCache = getStatementCacheForTable(table);
                    stmt = statementCache.getPreparedStatement(sql);
                    statementMustBeClosedByMe = statementCache.mustLastReturnedStatementBeClosedByCaller();
                    List<Pair<Integer, CROM>> linkKeyIndices = collectLinkKeyIndices(table);
                    if (linkKeyIndices.isEmpty()) {
                        handleMissingLinkKeys(parentTable, table);
                    }
                    Record[] parent_array=parents.toArray(new Record[parents.size()]);

View Full Code Here

    attributeLists.put(table, list);
    return list;
  }


    private PreparedStatementCache getStatementCacheForTable(CROM table) {
        PreparedStatementCache cache = statementCache.get(table);
        if (cache == null) {
            cache = new PreparedStatementCache(sourceConnection);
            statementCache.put(table, cache);
            cache.setFetchSize(fetchSize);
        }
        return cache;
    }

View Full Code Here

TOP

Related Classes of org.jitterbit.integration.server.db.PreparedStatementCache

org.jitterbit.integration.server.db.source.DatabaseSource

org.jitterbit.integration.server.db.target.DatabaseTarget

java.sql.PreparedStatement

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.