com.genexus.db.driver.DirectPreparedStatement Maven / Gradle / Ivy

Go to download
Show more of this group Show more artifacts with this name
Show all versions of gxclassR Show documentation
Core classes for the runtime used by Java and Android apps generated with GeneXus
There is a newer version: 4.7.3
package com.genexus.db.driver;
import java.sql.CallableStatement;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.util.Enumeration;
import java.util.Vector;

import com.genexus.DebugFlag;


public class DirectPreparedStatement implements IPreparedStatementCache
{
	private static final boolean DEBUG       = DebugFlag.DEBUG;
	private GXConnection jdbcConnection;
	private Vector activeStatements;

	DirectPreparedStatement(GXConnection jdbcConnection)
	{
		this.jdbcConnection = jdbcConnection;
		activeStatements = new Vector<>();
	}

	public CallableStatement getCallableStatement(int handle, String index, String sqlSentence) throws SQLException
	{
		return (CallableStatement) getStatement(handle, index, sqlSentence, false, true, false);
	}

	public int getUsedCursors()
	{
		return 0;
	}
	
	public int getUsedCursorsJMX()
	{
		return 0;
	}	

	public PreparedStatement getStatement(int handle, String index, String sqlSentence, boolean currentOf) throws SQLException
	{
		return getStatement(handle, index, sqlSentence, currentOf, false, false);
	}

	private GXPreparedStatement createStatement(int handle, String cursorId, String sqlSentence, boolean currentOf, boolean callable) throws SQLException
	{
		GXPreparedStatement stmt = (GXPreparedStatement) (callable?jdbcConnection.prepareCall(sqlSentence):jdbcConnection.prepareStatement(sqlSentence, handle, cursorId));

		// Cosas feas que no deberian ir aqui...
		if	(currentOf && jdbcConnection.getDBMS() instanceof GXDBMSas400)
		{
			stmt.setCursorName(cursorId);
		}

		activeStatements.addElement(stmt);
		return stmt;
	}

	public synchronized PreparedStatement getStatement(int handle, String index, String sqlSentence, boolean currentOf, boolean callable, boolean batch) throws SQLException
	{
		return createStatement(handle, index, sqlSentence, currentOf, callable);
	}

	/**
	 * Hace un drop de todos los cursores preparados del pool de cursores.
	 */
	public synchronized void dropAllCursors()
	{
		for(Enumeration enum1 = activeStatements.elements(); enum1.hasMoreElements(); )
		{
			GXPreparedStatement stmt = (GXPreparedStatement)enum1.nextElement();
			if	(DEBUG)
			{
				jdbcConnection.log(GXDBDebug.LOG_MED, "GX: Drop All/Dropping cursor - " + stmt.getSqlStatement());
			}
			try
			{
				stmt.close();
			}
			catch (SQLException e)
			{
				System.err.println("can't close cursor");
			}
		}
		activeStatements.removeAllElements();
	}

        public synchronized void freeAllCursors()
        {
        }

	/** Elimina un cursor (lo cierra y lo saca de la lista de prepared statements)
	 */	
	public synchronized void dropCursor(GXPreparedStatement stmt)
	{
		if(stmt == null)return;
		setNotInUse(stmt);
	}

	/**
	 * Marca un cursor como "Not in use", de modo que pueda ser reutilizado.
	 * En este caso cierra directamente el cursor.
	 */
	public synchronized void setNotInUse(GXPreparedStatement stmt)
	{
		// Puede venir en null si se llama desde un supplier que nunca
		// abri� el cursor.
		if	(stmt == null)
		{
			return;
		}

		if(stmt.isBatch() || stmt.getSkipSetBlobs())
		{ // Si es un statement batch, despu�s de hacer el setNotInUse se pueden setear los parametros
		  // En este caso no cerramos el statement, sino que lo dejamos para cerrar en la dropAllCursors
		  // que es ejecutada al terminar el request del wbp
			return;
		}

		activeStatements.removeElement(stmt);
		if	(DEBUG)
		{
			jdbcConnection.log(GXDBDebug.LOG_MED, "GX: Marking cursor as unused [" + activeStatements.size() + "] - " + stmt.getSqlStatement());
		}
		try
		{
			stmt.close();
		}
		catch (SQLException e)
		{
			System.err.println("can't close cursor");
		}
	}

	public void dump(java.io.PrintStream out)
	{
	}

}