|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Objectto.etc.dbutil.BaseDB
to.etc.dbutil.MysqlDB
public class MysqlDB
Constructor Summary | |
---|---|
MysqlDB()
|
Method Summary | |
---|---|
protected java.lang.String |
getCheckString()
Returns a SQL statement that is the cheapest way to check the validity of a connection. |
protected int |
getFullSequenceID(java.sql.Connection dbc,
java.lang.String tablename)
Returns a sequence number that can be used to create a new PK for a record in the given table. |
protected java.io.Reader |
getLobReader(java.sql.Connection dbc,
java.sql.ResultSet rs,
int col)
Returns a Reader from the blob (clob) column specified. |
protected java.io.Reader |
getLobReader(java.sql.Connection dbc,
java.sql.ResultSet rs,
java.lang.String col)
Returns a Reader from the blob (clob) column specified. |
protected java.io.InputStream |
getLobStream(java.sql.Connection dbc,
java.sql.ResultSet rs,
int col)
Returns an InputStream from the blob (clob) column specified. |
protected java.io.InputStream |
getLobStream(java.sql.Connection dbc,
java.sql.ResultSet rs,
java.lang.String col)
Returns an InputStream from the blob (clob) column specified. |
protected int |
getSequenceID(java.sql.Connection dbc,
java.lang.String tablename)
Uses mysql specific code to create a sequence number from a sequence table. |
protected void |
setBlob(java.sql.Connection dbc,
java.lang.String table,
java.lang.String column,
java.lang.String[] pkfields,
java.lang.Object[] key,
java.io.InputStream is)
|
protected void |
setBlob(java.sql.Connection dbc,
java.lang.String table,
java.lang.String column,
java.lang.String where,
java.io.InputStream is)
Writes a blob to the requested record using the normal setBinaryStream call. |
protected void |
setClob(java.sql.Connection dbc,
java.lang.String table,
java.lang.String column,
java.lang.String where,
java.io.Reader r)
Writes a blob to the requested record using the normal setBinaryStream call. |
Methods inherited from class to.etc.dbutil.BaseDB |
---|
oracleOuterJoin, setBlob, streamCopy |
Methods inherited from class java.lang.Object |
---|
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Constructor Detail |
---|
public MysqlDB()
Method Detail |
---|
protected java.lang.String getCheckString()
getCheckString
in class BaseDB
protected int getSequenceID(java.sql.Connection dbc, java.lang.String tablename) throws java.sql.SQLException
getSequenceID
in class BaseDB
dbc
- the connection
java.sql.SQLException
- if the sequence could not be obtainedprotected int getFullSequenceID(java.sql.Connection dbc, java.lang.String tablename) throws java.sql.SQLException
getFullSequenceID
in class BaseDB
dbc
- tablename
-
java.sql.SQLException
protected void setBlob(java.sql.Connection dbc, java.lang.String table, java.lang.String column, java.lang.String[] pkfields, java.lang.Object[] key, java.io.InputStream is) throws java.sql.SQLException
setBlob
in class BaseDB
java.sql.SQLException
protected void setBlob(java.sql.Connection dbc, java.lang.String table, java.lang.String column, java.lang.String where, java.io.InputStream is) throws java.sql.SQLException
setBlob
in class BaseDB
java.sql.SQLException
protected void setClob(java.sql.Connection dbc, java.lang.String table, java.lang.String column, java.lang.String where, java.io.Reader r) throws java.lang.Exception
setClob
in class BaseDB
java.lang.Exception
protected java.io.Reader getLobReader(java.sql.Connection dbc, java.sql.ResultSet rs, int col) throws java.lang.Exception
getLobReader
in class BaseDB
rs
- col
-
java.lang.Exception
protected java.io.Reader getLobReader(java.sql.Connection dbc, java.sql.ResultSet rs, java.lang.String col) throws java.lang.Exception
getLobReader
in class BaseDB
rs
- col
-
java.lang.Exception
protected java.io.InputStream getLobStream(java.sql.Connection dbc, java.sql.ResultSet rs, int col) throws java.lang.Exception
getLobStream
in class BaseDB
rs
- col
-
java.lang.Exception
protected java.io.InputStream getLobStream(java.sql.Connection dbc, java.sql.ResultSet rs, java.lang.String col) throws java.lang.Exception
getLobStream
in class BaseDB
rs
- col
-
java.lang.Exception
|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |