Package sk.ipesoft.d2000.db

Class DBTrans

java.lang.Object

sk.ipesoft.d2000.db.DBTrans

public class DBTrans
extends java.lang.Object

Field Summary

Fields

Modifier and Type	Field	Description
static int	_COMMIT
static int	_ROLLBACK

Constructor Summary

Constructors

Constructor	Description
DBTrans(int eventId)
DBTrans(int eventId, int transHandle)

Method Summary

Modifier and Type	Method	Description
DBTable	dbConnect(SODBTable dbTable, int accessIdent)	Corresponds to ESL action DB_CONNECT
void	dbsDelete(SODBTable dbTable, java.lang.String whereStr)	Corresponds to ESL action DBS_DELETE
void	dbsDelete(SODBTable dbTable, D2SD structIdent)	Corresponds to ESL action DBS_DELETE
void	dbsDelete(SODBTable dbTable, D2SRow row)	Corresponds to ESL action DBS_DELETE
void	dbsInsert(SODBTable dbTable, D2SD structIdent)	Corresponds to ESL action DBS_INSERT
void	dbsInsert(SODBTable dbTable, D2SRow row)	Corresponds to ESL action DBS_INSERT
void	dbsInsertOrUpdate(SODBTable dbTable, D2SD structIdent)	Corresponds to ESL action DBS_INSUPD
void	dbsInsertOrUpdate(SODBTable dbTable, D2SRow row)	Corresponds to ESL action DBS_INSUPD
DBReadResult	dbsRead(SODBTable dbTable, D2SD localStructIdent, int maxRows_Int)	Corresponds to ESL action DBS_READ
DBReadResult	dbsRead(SODBTable dbTable, D2SD localStructIdent, int maxRows_Int, java.lang.String whereStr)	Corresponds to ESL action DBS_READ
DBReadResult	dbsRead(SODBTable dbTable, D2SRow row)	Corresponds to ESL action DBS_READ
DBReadResult	dbsRead(SODBTable dbTable, D2SRow row, java.lang.String whereStr)	Corresponds to ESL action DBS_READ
void	dbsReadBlob(SODBTable dbTable, java.lang.String blobColNameIdent_Str, java.io.OutputStream blobOutputStream, java.lang.String whereStr)	Corresponds to ESL action DBS_READ_BLOB
void	dbsReadBlob(SODBTable dbTable, java.lang.String blobColNameIdent_Str, java.io.OutputStream blobOutputStream, D2SRow row)	Corresponds to ESL action DBS_READ_BLOB
void	dbsUpdate(SODBTable dbTable, D2SD struct)
void	dbsUpdate(SODBTable dbTable, D2SRow row)	Corresponds to ESL action DBS_UPDATE
void	dbsUpdate(SODBTable dbTable, D2SRow row, java.lang.String whereStr)	Corresponds to ESL action DBS_UPDATE
void	dbsUpdateBlob(SODBTable dbTable, java.lang.String blobColNameIdent_Str, java.io.InputStream blobInputStream, java.lang.String whereStr)	Corresponds to ESL action DBS_UPDATE_BLOB
void	dbsUpdateBlob(SODBTable dbTable, java.lang.String blobColNameIdent_Str, java.io.InputStream blobInputStream, D2SRow row)	Corresponds to ESL action DBS_UPDATE_BLOB
void	dbTransClose()	Corresponds to ESL action DB_TRANS_CLOSE
void	dbTransCommit()	Corresponds to ESL action DB_TRANS_COMMIT`
void	dbTransRollback()	Corresponds to ESL action DB_TRANS_ROLLBACK
int	getEventId()	Internal function
int	getTransHandle()	Internal function
int	getTransId()	Internal function
DBSqlConn	sqlConnect(int dbObjIdent)	Deprecated.
DBSqlConn	sqlConnect(java.lang.String connString, SOProcess dbManIdent)	Corresponds to ESL action SQL_CONNECT
DBSqlConn	sqlConnect(SODatabase dbobj)
DBSqlConn	sqlConnect(SODBTable dbobj)
void	sqlSelect(SODatabase dbobj, int maxRows, java.lang.String statement, D2Base... bindVars)
void	sqlSelect(SODatabase dbobj, java.lang.String statement, D2Base... bindVars)
void	sqlSelect(SODBTable dbobj, int maxRows, java.lang.String statement, D2Base... bindVars)
void	sqlSelect(SODBTable dbobj, java.lang.String statement, D2Base... bindVars)
void	sqlSelect(SOProcess dbm, java.lang.String connectStr, int maxRows, java.lang.String statement, D2Base... bindVars)
void	sqlSelect(SOProcess dbm, java.lang.String connectStr, java.lang.String statement, D2Base... bindVars)

Methods inherited from class java.lang.Object

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

Field Detail

_COMMIT

public static final int _COMMIT

See Also:

Constant Field Values

_ROLLBACK

public static final int _ROLLBACK

See Also:

Constant Field Values

Constructor Detail

DBTrans

public DBTrans(int eventId,
               int transHandle)

DBTrans

public DBTrans(int eventId)

Method Detail

getEventId

public int getEventId()

Internal function

Returns:

getTransHandle

public int getTransHandle()

Internal function

Returns:

getTransId

public int getTransId()

Internal function

Returns:

dbTransCommit

public void dbTransCommit()

Corresponds to ESL action DB_TRANS_COMMIT`

dbTransRollback

public void dbTransRollback()

Corresponds to ESL action DB_TRANS_ROLLBACK

dbTransClose

public void dbTransClose()

Corresponds to ESL action DB_TRANS_CLOSE

dbConnect

public DBTable dbConnect(SODBTable dbTable,
                         int accessIdent)

Corresponds to ESL action DB_CONNECT

Parameters:

dbTable -

accessIdent -

Returns:

sqlConnect

@Deprecated
public DBSqlConn sqlConnect(int dbObjIdent)

Deprecated.

Corresponds to ESL action SQL_CONNECT

Parameters:

dbObjIdent -

Returns:

sqlConnect

public DBSqlConn sqlConnect(SODatabase dbobj)

sqlConnect

public DBSqlConn sqlConnect(SODBTable dbobj)

sqlConnect

public DBSqlConn sqlConnect(java.lang.String connString,
                            SOProcess dbManIdent)

Corresponds to ESL action SQL_CONNECT

Parameters:

connString -

dbManIdent -

Returns:

dbsDelete

public void dbsDelete(SODBTable dbTable,
                      D2SRow row)

Corresponds to ESL action DBS_DELETE

Parameters:

dbTable -

row -

dbsDelete

public void dbsDelete(SODBTable dbTable,
                      D2SD structIdent)

Corresponds to ESL action DBS_DELETE

Parameters:

dbTable -

structIdent -

dbsDelete

public void dbsDelete(SODBTable dbTable,
                      java.lang.String whereStr)

Corresponds to ESL action DBS_DELETE

Parameters:

dbTable -

whereStr -

dbsInsert

public void dbsInsert(SODBTable dbTable,
                      D2SRow row)

Corresponds to ESL action DBS_INSERT

Parameters:

dbTable -

row -

dbsInsert

public void dbsInsert(SODBTable dbTable,
                      D2SD structIdent)

Corresponds to ESL action DBS_INSERT

Parameters:

dbTable -

structIdent -

dbsInsertOrUpdate

public void dbsInsertOrUpdate(SODBTable dbTable,
                              D2SD structIdent)

Corresponds to ESL action DBS_INSUPD

Parameters:

dbTable -

structIdent -

dbsInsertOrUpdate

public void dbsInsertOrUpdate(SODBTable dbTable,
                              D2SRow row)

Corresponds to ESL action DBS_INSUPD

Parameters:

dbTable -

row -

dbsRead

public DBReadResult dbsRead(SODBTable dbTable,
                            D2SRow row)

Corresponds to ESL action DBS_READ

Parameters:

dbTable -

row -

dbsRead

public DBReadResult dbsRead(SODBTable dbTable,
                            D2SRow row,
                            java.lang.String whereStr)

Corresponds to ESL action DBS_READ

Parameters:

dbTable -

row -

whereStr -

dbsRead

public DBReadResult dbsRead(SODBTable dbTable,
                            D2SD localStructIdent,
                            int maxRows_Int)

Corresponds to ESL action DBS_READ

Parameters:

dbTable -

localStructIdent -

maxRows_Int -

Returns:

dbsRead

public DBReadResult dbsRead(SODBTable dbTable,
                            D2SD localStructIdent,
                            int maxRows_Int,
                            java.lang.String whereStr)

Corresponds to ESL action DBS_READ

Parameters:

dbTable -

localStructIdent -

maxRows_Int -

whereStr -

Returns:

dbsReadBlob

public void dbsReadBlob(SODBTable dbTable,
                        java.lang.String blobColNameIdent_Str,
                        java.io.OutputStream blobOutputStream,
                        D2SRow row)

Corresponds to ESL action DBS_READ_BLOB

Parameters:

dbTable -

blobColNameIdent_Str -

blobOutputStream -

row -

dbsReadBlob

public void dbsReadBlob(SODBTable dbTable,
                        java.lang.String blobColNameIdent_Str,
                        java.io.OutputStream blobOutputStream,
                        java.lang.String whereStr)

Corresponds to ESL action DBS_READ_BLOB

Parameters:

dbTable -

blobColNameIdent_Str -

blobOutputStream -

whereStr -

dbsUpdate

public void dbsUpdate(SODBTable dbTable,
                      D2SRow row)

Corresponds to ESL action DBS_UPDATE

Parameters:

dbTable -

row -

dbsUpdate

public void dbsUpdate(SODBTable dbTable,
                      D2SD struct)

dbsUpdate

public void dbsUpdate(SODBTable dbTable,
                      D2SRow row,
                      java.lang.String whereStr)

Corresponds to ESL action DBS_UPDATE

Parameters:

dbTable -

row -

whereStr -

dbsUpdateBlob

public void dbsUpdateBlob(SODBTable dbTable,
                          java.lang.String blobColNameIdent_Str,
                          java.io.InputStream blobInputStream,
                          D2SRow row)

Corresponds to ESL action DBS_UPDATE_BLOB

Parameters:

dbTable -

blobColNameIdent_Str -

blobInputStream -

row -

dbsUpdateBlob

public void dbsUpdateBlob(SODBTable dbTable,
                          java.lang.String blobColNameIdent_Str,
                          java.io.InputStream blobInputStream,
                          java.lang.String whereStr)

Corresponds to ESL action DBS_UPDATE_BLOB

Parameters:

dbTable -

blobColNameIdent_Str -

blobInputStream -

whereStr -

sqlSelect

public void sqlSelect(SODatabase dbobj,
                      int maxRows,
                      java.lang.String statement,
                      D2Base... bindVars)

sqlSelect

public void sqlSelect(SODatabase dbobj,
                      java.lang.String statement,
                      D2Base... bindVars)

sqlSelect

public void sqlSelect(SODBTable dbobj,
                      int maxRows,
                      java.lang.String statement,
                      D2Base... bindVars)

sqlSelect

public void sqlSelect(SODBTable dbobj,
                      java.lang.String statement,
                      D2Base... bindVars)

sqlSelect

public void sqlSelect(SOProcess dbm,
                      java.lang.String connectStr,
                      int maxRows,
                      java.lang.String statement,
                      D2Base... bindVars)

sqlSelect

public void sqlSelect(SOProcess dbm,
                      java.lang.String connectStr,
                      java.lang.String statement,
                      D2Base... bindVars)