Package io.odysz.semantic.DA.drvmnger

Class OracleDriver

java.lang.Object

io.odysz.semantic.DA.AbsConnect<OracleDriver>

io.odysz.semantic.DA.drvmnger.OracleDriver

public class OracleDriver
extends AbsConnect<OracleDriver>

Author:

odys-z@github.com

Field Summary

Fields inherited from class io.odysz.semantic.DA.AbsConnect

drvName, flag_disableSql, flag_nothing, flag_printSql, id, locks, log

Constructor Summary

Constructors

Constructor	Description
OracleDriver(String id, boolean log)

Method Summary

Modifier and Type	Method	Description
int[]	commit(io.odysz.semantics.IUser log, ArrayList<String> sqls, ArrayList<Clob> lobs, int i)
int[]	commit(ArrayList<String> sqls, int flags)
static void	excecuteBatch(Connection conn, ArrayList<String> sqls, String userid, String username, String operTime, String funcName, String sysID)	Deprecated.
static void	excecuteBatch(ArrayList<String> sqls)
static void	executeBatch(ArrayList<String> sqls, String userid, String username, String operTime, String funcName, String sysID)	Deprecated.
static Connection	getConnection()	MUST CLOSE CONNECTION!
static OracleDriver	initConnection(String id, String conn, String user, String psword, boolean log, int flag)
static void	insert_updateBlob(String insertSql, String blobTable, String idField, String blobField, String recID, InputStream inStream)
static AnResultset	select(String sql)
AnResultset	select(String sql, int flags)
static AnResultset	selectBlob(String sql)
static void	setClobs(ArrayList<OracleLob> lobs)

Methods inherited from class io.odysz.semantic.DA.AbsConnect

close, commit, driverType, getAutoseqLock, initDmConnect, initPooledConnect, printSql, printSql, prop, prop

Methods inherited from class java.lang.Object

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

Constructor Details

OracleDriver

public OracleDriver(String id,
 boolean log)

Method Details

getConnection

public static Connection getConnection()
                                throws SQLException

MUST CLOSE CONNECTION!

Returns:

Connection

Throws:

SQLException

initConnection

public static OracleDriver initConnection(String id,
 String conn,
 String user,
 String psword,
 boolean log,
 int flag)
                                   throws SQLException

Throws:

SQLException

select

public static AnResultset select(String sql)
                          throws SQLException

Throws:

SQLException

executeBatch

public static void executeBatch(ArrayList<String> sqls,
 String userid,
 String username,
 String operTime,
 String funcName,
 String sysID)
                         throws SQLException

Deprecated.

Parameters:

sqls -

userid -

username -

operTime -

funcName -

sysID -

Throws:

SQLException

excecuteBatch

public static void excecuteBatch(Connection conn,
 ArrayList<String> sqls,
 String userid,
 String username,
 String operTime,
 String funcName,
 String sysID)
                          throws SQLException

Deprecated.

Parameters:

conn -

sqls -

userid -

username -

operTime -

funcName -

sysID -

Throws:

SQLException

excecuteBatch

public static void excecuteBatch(ArrayList<String> sqls)
                          throws SQLException

Throws:

SQLException

insert_updateBlob

public static void insert_updateBlob(String insertSql,
 String blobTable,
 String idField,
 String blobField,
 String recID,
 InputStream inStream)
                              throws Exception

Throws:

Exception

selectBlob

public static AnResultset selectBlob(String sql)
                              throws SQLException

Parameters:

sql -

Returns:

result set

Throws:

SQLException

setClobs

public static void setClobs(ArrayList<OracleLob> lobs)

select

public AnResultset select(String sql,
 int flags)
                   throws SQLException

Specified by:

select in class AbsConnect<OracleDriver>

Throws:

SQLException

commit

public int[] commit(ArrayList<String> sqls,
 int flags)
             throws SQLException

Specified by:

commit in class AbsConnect<OracleDriver>

Throws:

SQLException

commit

public int[] commit(io.odysz.semantics.IUser log,
 ArrayList<String> sqls,
 ArrayList<Clob> lobs,
 int i)
             throws SQLException

Specified by:

commit in class AbsConnect<OracleDriver>

Throws:

SQLException