All Packages  Class Hierarchy  This Package  Previous  Next  Index

Class twz1.jdbc.mysql.jdbcMysqlStmt

java.lang.Object
   |
   +----twz1.jdbc.mysql.jdbcMysqlStmt

public class jdbcMysqlStmt

extends Object

implements Statement

apis

C_CANCEL

C_CLEARPARAMETERS

C_CLEARWARNINGS

C_CLOSE

C_GETMAXFIELDSIZE

C_GETMAXROWS

C_GETMORERESULTS

C_GETQUERYTIMEOUT

C_GETUPDATECOUNT

C_GETWARNINGS

C_SETASCIISTREAM

C_SETBIGDECIMAL

C_SETBINARYSTREAM

C_SETBOOLEAN

C_SETBYTE

C_SETBYTES

C_SETCURSORNAME

C_SETDATE

C_SETDOUBLE

C_SETESCAPEPROCESSING

C_SETFLOAT

C_SETINT

C_SETLONG

C_SETMAXFIELDSIZE

C_SETMAXROWS

C_SETNULL

C_SETOBJECT

C_SETQUERYTIMEOUT

C_SETSHORT

C_SETSTRING

C_SETTIME

C_SETTIMESTAMP

C_SETUNICODESTREAM

commandValue

Command value

commandWord

Command word

cx

Point back to connection.

errs

guard

Practice safe threading.

inBag

Input bag from connex

lastExecuted

executed string.

lastInsertID

last insert id on an insert

lTimeout

timeout on mutex

maxFieldSize

Maximum field size

maxRows

Maximum number of rows in result

myOID

My object

open

Statement is available

outBag

Output bag from connex

qResult

Query result

QTYPE_EQ

QTYPE_EU

QTYPE_EX

rsLock

Do we lock for ResultSet retrievals ?

rsmdXcept

should rsmd queries throw type exceptions ?

status

Statement status

jdbcMysqlStmt(jdbcMysqlConnex)

cancel()

See API.

clearWarnings()

Does nothing now, in the future it will clear the warning chain.

close()

The API is a little vague about this.

errHandlerE(int, Exception)

errHandlerE2(int, String, Exception)

errHandlerM(int, String)

execute(String)

executeQuery(String)

executeUpdate(String)

getCommandValue(String)

getMaxFieldSize()

See the API.

getMaxRows()

See API.

getMoreResults()

See the API.

getQueryTimeout()

Varies somewhat from the API as the timeout value in this implementation refers to the time the mutex lock on the referent statement times out, rather than total duration of execution.

getResultSet()

See API.

getUpdateCount()

See the API.

getWarnings()

Returns null.

iGetMaxFieldSize()

lock(boolean, int, int)

Invoke a mutex to protect access to the statement.

mExecQuery(byte[])

mExecUpdate(byte[])

mxEQ(byte[])

mxEU(byte[])

pseudoResult(Vector, RSMd)

sAction(int, int, String)

setCursorName(String)

See API: this throws an exception as cursors are not supported in MySQL.

setEscapeProcessing(boolean)

See API.

setMaxFieldSize(int)

See the API.

setMaxRows(int)

See API

setQueryTimeout(int)

Varies somewhat from the API as the timeout value in this implementation refers to the time the mutex lock on the referent statement times out, rather than total duration of execution.

 jdbcMysqlConnex cx

Point back to connection.

 int myOID

My object

 byte lastExecuted[]

executed string.

 String commandWord

Command word

 int commandValue

Command value

 int maxRows

Maximum number of rows in result

 int maxFieldSize

Maximum field size

 jdbcMysqlBag inBag

Input bag from connex

 jdbcMysqlBag outBag

Output bag from connex

 boolean open

Statement is available

 int status

Statement status

 jdbcMysqlMutex guard

Practice safe threading.

 int lTimeout

timeout on mutex

 long lastInsertID

last insert id on an insert

 jdbcMysqlResult qResult

Query result

 boolean rsmdXcept

should rsmd queries throw type exceptions ?

 boolean rsLock

Do we lock for ResultSet retrievals ?

 static final int QTYPE_EU

 static final int QTYPE_EQ

 static final int QTYPE_EX

 static final int C_CLOSE

 static final int C_GETMAXFIELDSIZE

 static final int C_SETMAXFIELDSIZE

 static final int C_GETMAXROWS

 static final int C_SETMAXROWS

 static final int C_SETESCAPEPROCESSING

 static final int C_GETQUERYTIMEOUT

 static final int C_SETQUERYTIMEOUT

 static final int C_CANCEL

 static final int C_GETWARNINGS

 static final int C_CLEARWARNINGS

 static final int C_SETCURSORNAME

 static final int C_GETUPDATECOUNT

 static final int C_GETMORERESULTS

 static final int C_SETNULL

 static final int C_SETBOOLEAN

 static final int C_SETBYTE

 static final int C_SETSHORT

 static final int C_SETINT

 static final int C_SETLONG

 static final int C_SETFLOAT

 static final int C_SETDOUBLE

 static final int C_SETSTRING

 static final int C_SETBYTES

 static final int C_SETDATE

 static final int C_SETTIME

 static final int C_SETTIMESTAMP

 static final int C_SETASCIISTREAM

 static final int C_SETBINARYSTREAM

 static final int C_SETUNICODESTREAM

 static final int C_SETBIGDECIMAL

 static final int C_SETOBJECT

 static final int C_CLEARPARAMETERS

 static final String apis[]

 static final String errs[]

 jdbcMysqlStmt(jdbcMysqlConnex connection) throws SQLException

 public int executeUpdate(String sql) throws SQLException

 void mExecUpdate(byte sql[]) throws SQLException

 private void mxEU(byte sql[]) throws SQLException

 public ResultSet executeQuery(String sql) throws SQLException

 ResultSet mExecQuery(byte sql[]) throws SQLException

 private jdbcMysqlRSet mxEQ(byte sql[]) throws SQLException

 public boolean execute(String sql) throws SQLException

 ResultSet pseudoResult(Vector data,
                        RSMd rsmd) throws SQLException

 public void close() throws SQLException

The API is a little vague about this. As implemented in invalidates results from any previous inquiries and renders the statement unusable for future inquiries. From a technical standpoint there is no reason why the statement should not be reusable, but I'll let it stand as is unless shown to be wrong.

 public int getMaxFieldSize() throws SQLException

See the API. While showing maximum field size returnable to the caller, there are dependencies on the communication protocol and its packages for an upper bound which may not be reflected here.

 public void setMaxFieldSize(int s) throws SQLException

See the API. While setting the maximum field size returnable to the caller, there are dependencies on the communication protocol and its packages for an upper bound which may not be reflected here.

 public int getMaxRows() throws SQLException

See API.

 public void setMaxRows(int s) throws SQLException

See API

 public void setEscapeProcessing(boolean t) throws SQLException

See API. Throws an exception as MySQL's escape processing is implicit and invariant. At some future time (if there is demand) this driver may be modified to do some escpae processing, but as of now it does not.

 public int getQueryTimeout() throws SQLException

Varies somewhat from the API as the timeout value in this implementation refers to the time the mutex lock on the referent statement times out, rather than total duration of execution. IE the time before a "waiting" request times out: the reqirement that a query to the connection be completed mandates this variation.

 public void setQueryTimeout(int t) throws SQLException

Varies somewhat from the API as the timeout value in this implementation refers to the time the mutex lock on the referent statement times out, rather than total duration of execution. IE the time before a "waiting" request times out: the reqirement that a query to the connection be completed mandates this variation.

 public void cancel() throws SQLException

See API. In actuality this varies from the API because MySQL does not support multiple queries on a single connection. If another thread is executing this statement, cancel() will be blocked until that request clears, at which time the statement will be effectively closed.

 public SQLWarning getWarnings() throws SQLException

Returns null. In the near future it will return the top of the error stack.

 public void clearWarnings() throws SQLException

Does nothing now, in the future it will clear the warning chain.

 public void setCursorName(String s) throws SQLException

See API: this throws an exception as cursors are not supported in MySQL.

 public int getUpdateCount() throws SQLException

See the API. There may be exceptions to the API use of this method following the execution of private SQL methods.

 public boolean getMoreResults() throws SQLException

See the API. This will return true only if a query has been executed by an execute() and the RS not yet retrieved.

 public ResultSet getResultSet() throws SQLException

See API. For MySQL there should be only one RS generated per query.

 private int sAction(int option,
                     int vi,
                     String vs) throws SQLException

 void getCommandValue(String sql) throws SQLException

 boolean lock(boolean lockOnOff,
              int oid,
              int timeout) throws SQLException

Invoke a mutex to protect access to the statement.

Parameters:

lockOnOff - set or clear the mutex.

oid - Object setting the lock.

timeout - time (seconds) to wait before tossing cookies.

 void errHandlerM(int n,
                  String m) throws SQLException

 void errHandlerE(int n,
                  Exception e) throws SQLException

 void errHandlerE2(int n,
                   String s,
                   Exception e) throws SQLException

 int iGetMaxFieldSize()

All Packages  Class Hierarchy  This Package  Previous  Next  Index