Package com.esri.gpt.framework.sql

Examples of com.esri.gpt.framework.sql.ManagedConnection


* @throws SQLException if accessing database fails
*/
public void execute() throws SQLException {

  // establish the connection
  ManagedConnection mc = returnConnection();
  Connection con = mc.getJdbcConnection();

  // intitalize
  HjRecords records = getQueryResult().getRecords();

  // intitalize
View Full Code Here


      sbHistoryDeleteSql.append("delete from " +
        getHarvestingHistoryTableName() + " ");
      sbHistoryDeleteSql.append("where HARVEST_ID = ?");

      // establish the connection
      ManagedConnection mc = returnConnection();
      con = mc.getJdbcConnection();
      autoCommit = con.getAutoCommit();
      con.setAutoCommit(false);

      stJobsDelete = con.prepareStatement(sbJobsDeleteSql.toString());
      stCompletedJobsDelete = con.prepareStatement(sbCompletedJobsDeleteSql.
View Full Code Here

 
  // intitalize
  PreparedStatement st = null;

  // establish the connection
  ManagedConnection mc = returnConnection();
  Connection con = mc.getJdbcConnection();

  // prepare statement
  st = con.prepareStatement(
      "DELETE FROM " + getHarvestingJobsPendingTableName()+ " " +
      "WHERE HARVEST_ID IN ("+this.getActionCriteria().getResourceUuidsForSql()+")");
View Full Code Here

    if (sbWhere.length() > 0) {
      sbRecoverSql.append(" WHERE ").append(sbWhere.toString());
    }

    // establish the connection
    ManagedConnection mc = returnConnection();
    Connection con = mc.getJdbcConnection();

    stRecover = con.prepareStatement(sbRecoverSql.toString());

    int n = 1;
    // repository uuid
View Full Code Here

   * @return <code>true</code> if record with identical host URL exists
   * @throws SQLException if accessing database fails
   */
  public boolean execute() throws SQLException {
    // establish the connection
    ManagedConnection mc = returnConnection();
    Connection con = mc.getJdbcConnection();

    PreparedStatement st = null;
    ResultSet rs = null;

    try {
View Full Code Here

  // intitalize
  PreparedStatement st = null;

  try {
    // establish the connection
    ManagedConnection mc = returnConnection();
    Connection con = mc.getJdbcConnection();

    int updated = 0;

    // prepare statement
    st = con.prepareStatement(
View Full Code Here

TOP

Related Classes of com.esri.gpt.framework.sql.ManagedConnection

Copyright © 2018 www.massapicom. All rights reserved.
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.