nyla.solutions.dao.executable.BatchSqlExecutable Maven / Gradle / Ivy

Go to download
package nyla.solutions.dao.executable;

import nyla.solutions.dao.AbstractDaoOperation;
import nyla.solutions.dao.SQL;
import nyla.solutions.global.exception.RequiredException;
import nyla.solutions.global.exception.SystemException;

import java.sql.*;
import nyla.solutions.global.patterns.command.Environment;
import nyla.solutions.global.util.Debugger;

/**
 * @author Gregory Green
 * @version 1.0
 * @deprecated use commands
 *
 * * SqlExecutable  represents an executed SQL statement
 * 
 * Sample Spring Configuration
 * 
 *     <bean id="cleanUpMonitoringExecutable" class="nyla.solutions.dao.executable.BatchSqlExecutable"
		singleton="false">
		
		<property name="sqls">
		     <list>
		         <value><![CDATA[DELETE FROM JVM_MEMORY_USAGES WHERE CAPTURE_DATE < trunc(add_months(sysdate,-12),'DAY')]]></value>
		         <value><![CDATA[DELETE FROM JVM_THREAD_COUNTS WHERE CAPTURE_DATE < trunc(add_months(sysdate,-12),'DAY')]]></value>
		         <value><![CDATA[DELETE FROM MONITORING_SIZES WHERE CAPTURE_DATE < trunc(add_months(sysdate,-12),'DAY')]]></value>
		      </list>
		</property>
	</bean>
 * 
 */
@Deprecated
public class  BatchSqlExecutable extends AbstractDaoOperation
//implements Executable, Command
{
	/**
	 * Execute an Batch Sqls statement
	 */
	public void execute(Environment env, String[] args)
	{		
	   String sqlQuery = this.getSql();
	   
	   if(sqlQuery ==null || sqlQuery.length() == 0 && this.sqls == null)
	   {
		throw new RequiredException("sql or sqls" );
	   }
		
	      
	   SQL sql = null;
	    Statement stmt = null;
	    try
	    {
		 //connect
	       sql = this.connect();  
	         
	       //create statement  
	       stmt = sql.createStatement();
	         
	         
	         if(sqlQuery != null && sqlQuery.length() > 0)
	         {
	      	Debugger.println(this,"executing="+sqlQuery);
	      	stmt.addBatch(sqlQuery);
	         }
	      	
	         
	         for(int i =0; i < sqls.length; i++)
	         {
	      	Debugger.println(this,"executing sql["+i+"]="+sqls[i]);
	      	
	      	//add batch for SQL
	      	stmt.addBatch(sqls[i]);
	         }
	         
	         //execute batch
	         stmt.executeBatch();
	         
	         sql.commit();
	      }
	      catch(SQLException e)
	      {
	         sql.rollback();
	         
	         throw new SystemException(e+" sqls="+Debugger.toString(sqls)+ " i="+0);
	      }
	      finally
	      {
	         if(stmt != null)
	      	try{ stmt.close();} catch(Exception e){}
	      	
	         if(sql != null)
	            sql.dispose();
	      }      
	}//---------------------------------------------
	/**
	 * Wrapper execution for a command
	 * @source
	 * @see solutions.global.patterns.command.Command#execute(java.lang.Object)
	 */
	public Object execute(Environment source)
	{
		execute(null,null);
		
		return null;
	}
	
	/**
	 * @return the SQL(s)
	 */
	public String[] getSqls()
	{
	   return sqls;
	}

	/**
	 * @param sqls the SQL(s) to set
	 */
	public void setSqls(String[] sqls)
	{
	   this.sqls = sqls;
	}

	private String[] sqls = null;
}