Package com.eka.middleware.adapter

Class SQL

java.lang.Object

com.eka.middleware.adapter.SQL

public class SQL
extends Object

Constructor Summary

Constructors

Constructor	Description
SQL()

Method Summary

Modifier and Type	Method	Description
static void	commitTransaction(Connection myCon)
static Savepoint	createSavepoint(Connection myCon, String savePointName)
static Boolean	DDL(String sqlCode, List<Map<String,Object>> sqlParameters, Connection myCon, DataPipeline dp, boolean logQuery)
static int	DML(String sqlCode, List<Map<String,Object>> sqlParameters, Connection myCon, DataPipeline dp, boolean logQuery)
static String[]	DML_RGKs(String sqlCode, List<Map<String,Object>> sqlParameters, Connection myCon, DataPipeline dp, boolean logQuery)
static List<Map<String,Object>>	DQL(String sqlCode, List<Map<String,Object>> sqlParameters, Connection myCon, DataPipeline dp, boolean logQuery)
static Connection	getConnection(String jdbcConnection, DataPipeline dp)
static Connection	getProfileConnection(boolean isTransactional)
static String	getTableNameFromQuery(String sqlQuery)
static void	rollbackTransaction(Connection myCon)
static void	rollbackTransaction(Connection myCon, Savepoint savepoint)
static Connection	setTransactionIsolationLevel(Connection connection, int isolationLevel)
static Connection	startTransaction(String jdbcConnection, DataPipeline dp)

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Details

SQL

public SQL()

Method Details

DQL

public static List<Map<String,Object>> DQL(String sqlCode,
 List<Map<String,Object>> sqlParameters,
 Connection myCon,
 DataPipeline dp,
 boolean logQuery)
                                    throws Exception

Throws:

Exception

DML

public static int DML(String sqlCode,
 List<Map<String,Object>> sqlParameters,
 Connection myCon,
 DataPipeline dp,
 boolean logQuery)
               throws Exception

Throws:

Exception

getTableNameFromQuery

public static String getTableNameFromQuery(String sqlQuery)

DML_RGKs

public static String[] DML_RGKs(String sqlCode,
 List<Map<String,Object>> sqlParameters,
 Connection myCon,
 DataPipeline dp,
 boolean logQuery)
                         throws Exception

Throws:

Exception

DDL

public static Boolean DDL(String sqlCode,
 List<Map<String,Object>> sqlParameters,
 Connection myCon,
 DataPipeline dp,
 boolean logQuery)
                   throws Exception

Throws:

Exception

startTransaction

public static Connection startTransaction(String jdbcConnection,
 DataPipeline dp)
                                   throws Exception

Throws:

Exception

setTransactionIsolationLevel

public static Connection setTransactionIsolationLevel(Connection connection,
 int isolationLevel)
                                               throws Exception

Parameters:

connection -

isolationLevel -

Returns:

Throws:

Exception

commitTransaction

public static void commitTransaction(Connection myCon)
                              throws SQLException

Throws:

SQLException

rollbackTransaction

public static void rollbackTransaction(Connection myCon)
                                throws SQLException

Throws:

SQLException

rollbackTransaction

public static void rollbackTransaction(Connection myCon,
 Savepoint savepoint)
                                throws SQLException

Throws:

SQLException

createSavepoint

public static Savepoint createSavepoint(Connection myCon,
 String savePointName)
                                 throws SQLException

Throws:

SQLException

getProfileConnection

public static Connection getProfileConnection(boolean isTransactional)

getConnection

public static Connection getConnection(String jdbcConnection,
 DataPipeline dp)
                                throws Exception

Throws:

Exception