All Packages Class Hierarchy This Package Previous Next Index
Class twz1.jdbc.mysql.DbMd
java.lang.Object
|
+----twz1.jdbc.mysql.DbMd
- public final class DbMd
- extends Object
- implements DatabaseMetaData
-
bbestRowNotPseudo
-
-
bbestRowSession
-
-
btable
-
-
bTableIndexOther
-
-
cin
-
-
cnn
-
-
ctL
-
-
ctN
-
-
cx
- Parent connection
-
dbmdXcept
- Do we throw exceptions on unsupported methods or just reurn
empty tables?
-
defref
-
-
errs
-
-
getBRId_rsmd
-
-
getCats_rsmd
-
-
getCols_rsmd
-
-
getII_rsmd
-
-
getKM_rsmd
-
-
getPCols_rsmd
-
-
getPK_rsmd
-
-
getPr_rsmd
-
-
getProc_rsmd
-
-
getSchm_rsmd
-
-
getTab_rsmd
-
-
getTI_rsmd
-
-
getTTyp_rsmd
-
-
getXK_rsmd
-
-
maxRows
- Max rows
-
myCx
- Our connection
-
no
-
-
T_INTEGER
-
-
T_SHORT
-
-
T_STRING
-
-
ten
-
-
typemap
- Type mapping hashtable
-
yes
-
-
DbMd(jdbcMysqlConnex)
-
-
allProceduresAreCallable()
-
-
allTablesAreSelectable()
- Without actually looking we return true.
-
dataDefinitionCausesTransactionCommit()
-
-
dataDefinitionIgnoredInTransactions()
-
-
doesMaxRowSizeIncludeBlobs()
-
-
errHandlerE(int, Exception)
-
-
errHandlerE2(int, String, Exception)
-
-
errHandlerM(int, String)
-
-
getBestRowIdentifier(String, String, String, int, boolean)
- Maybe later, and maybe peace will break out all over,
, return empty RS
-
getCatalogs()
-
-
getCatalogSeparator()
-
-
getCatalogTerm()
-
-
getColumnPrivileges(String, String, String, String)
- Priveliges work a little different in MySQL, return empty RS
-
getColumns(String, String, String, String)
-
-
getCrossReference(String, String, String, String, String, String)
- Return empty RS
-
getDatabaseProductName()
-
-
getDatabaseProductVersion()
-
-
getDefaultTransactionIsolation()
-
-
getDriverMajorVersion()
-
-
getDriverMinorVersion()
-
-
getDriverName()
-
-
getDriverVersion()
-
-
getExportedKeys(String, String, String)
- Return empty RS
-
getExtraNameCharacters()
-
-
getIdentifierQuoteString()
-
-
getImportedKeys(String, String, String)
- Return empty RS
-
getIndexInfo(String, String, String, boolean, boolean)
- Return empty RS
-
getMaxBinaryLiteralLength()
-
-
getMaxCatalogNameLength()
-
-
getMaxCharLiteralLength()
-
-
getMaxColumnNameLength()
- settable at gen; is there a way to check?
-
getMaxColumnsInGroupBy()
- need to look this up
-
getMaxColumnsInIndex()
-
-
getMaxColumnsInOrderBy()
-
-
getMaxColumnsInSelect()
- Is there a limit?
-
getMaxColumnsInTable()
-
-
getMaxConnections()
-
-
getMaxCursorNameLength()
-
-
getMaxIndexLength()
-
-
getMaxProcedureNameLength()
-
-
getMaxRowSize()
-
-
getMaxSchemaNameLength()
-
-
getMaxStatementLength()
-
-
getMaxStatements()
-
-
getMaxTableNameLength()
-
-
getMaxTablesInSelect()
- Is there a limit?
-
getMaxUserNameLength()
-
-
getNumericFunctions()
- Right from the manual
-
getPrimaryKeys(String, String, String)
- May do this later, return empty RS
-
getProcedureColumns(String, String, String, String)
- No procedures in MySQL, return empty RS
-
getProcedures(String, String, String)
- No procedures in MySQL, return empty RS
-
getProcedureTerm()
-
-
getResult1(String)
- A simple method to return a vector of the first column of a query
-
getSchemas()
- No schemas in MySQL, return empty RS
-
getSchemaTerm()
-
-
getSearchStringEscape()
-
-
getSQLKeywords()
- Most of this is a guess from the MySQL documentation since I don't
know a lot about the formal ANSI 92 SQL.
-
getStringFunctions()
- Right from the manual
-
getSystemFunctions()
- Right from the manual
-
getTablePrivileges(String, String, String)
- Priveliges work a little different in MySQL, return empty RS
-
getTables(String, String, String, String[])
- See the API
-
getTableTypes()
-
-
getTimeDateFunctions()
- Right from the manual
-
getTypeInfo()
- Someday, Return empty RS
-
getURL()
-
-
getUserName()
-
-
getVersionColumns(String, String, String)
- AFAIK no version columns in MySQL, return empty RS
-
isCatalogAtStart()
-
-
isReadOnly()
-
-
makePrivs()
-
-
makeXkey()
-
-
nullPlusNonNullIsNull()
-
-
nullsAreSortedAtEnd()
-
-
nullsAreSortedAtStart()
-
-
nullsAreSortedHigh()
-
-
nullsAreSortedLow()
-
-
rsCol(RSMd, String, int, int)
-
-
rsMake(int)
-
-
sillySort(String[], Object[])
-
-
storesLowerCaseIdentifiers()
-
-
storesLowerCaseQuotedIdentifiers()
-
-
storesMixedCaseIdentifiers()
-
-
storesMixedCaseQuotedIdentifiers()
-
-
storesUpperCaseIdentifiers()
-
-
storesUpperCaseQuotedIdentifiers()
-
-
supportsAlterTableWithAddColumn()
-
-
supportsAlterTableWithDropColumn()
-
-
supportsANSI92EntryLevelSQL()
-
-
supportsANSI92FullSQL()
-
-
supportsANSI92IntermediateSQL()
-
-
supportsCatalogsInDataManipulation()
-
-
supportsCatalogsInIndexDefinitions()
-
-
supportsCatalogsInPrivilegeDefinitions()
-
-
supportsCatalogsInProcedureCalls()
-
-
supportsCatalogsInTableDefinitions()
-
-
supportsColumnAliasing()
-
-
supportsConvert()
- Didn't see any explicit mention of CONVERT though implicit conversion
is all over the place.
-
supportsConvert(int, int)
-
-
supportsCoreSQLGrammar()
-
-
supportsCorrelatedSubqueries()
- Damfino.
-
supportsDataDefinitionAndDataManipulationTransactions()
-
-
supportsDataManipulationTransactionsOnly()
-
-
supportsDifferentTableCorrelationNames()
-
-
supportsExpressionsInOrderBy()
-
-
supportsExtendedSQLGrammar()
- A guess
-
supportsFullOuterJoins()
- ng reports problems with left outer join
-
supportsGroupBy()
-
-
supportsGroupByBeyondSelect()
-
-
supportsGroupByUnrelated()
-
-
supportsIntegrityEnhancementFacility()
-
-
supportsLikeEscapeClause()
-
-
supportsLimitedOuterJoins()
-
-
supportsMinimumSQLGrammar()
-
-
supportsMixedCaseIdentifiers()
-
-
supportsMixedCaseQuotedIdentifiers()
-
-
supportsMultipleResultSets()
-
-
supportsMultipleTransactions()
- Odd one, no transactions but diff queries on diff connex
-
supportsNonNullableColumns()
-
-
supportsOpenCursorsAcrossCommit()
-
-
supportsOpenCursorsAcrossRollback()
-
-
supportsOpenStatementsAcrossCommit()
-
-
supportsOpenStatementsAcrossRollback()
-
-
supportsOrderByUnrelated()
-
-
supportsOuterJoins()
-
-
supportsPositionedDelete()
-
-
supportsPositionedUpdate()
-
-
supportsSchemasInDataManipulation()
-
-
supportsSchemasInIndexDefinitions()
-
-
supportsSchemasInPrivilegeDefinitions()
-
-
supportsSchemasInProcedureCalls()
-
-
supportsSchemasInTableDefinitions()
-
-
supportsSelectForUpdate()
-
-
supportsStoredProcedures()
-
-
supportsSubqueriesInComparisons()
-
-
supportsSubqueriesInExists()
-
-
supportsSubqueriesInIns()
- clueless here
-
supportsSubqueriesInQuantifieds()
- Wazza quantified?
-
supportsTableCorrelationNames()
- Not quite sure what they mean here; have to dig someday
-
supportsTransactionIsolationLevel(int)
-
-
supportsTransactions()
-
-
supportsUnion()
- Union?? I may be Pennsylvanian but my heart belongs to Dixie
-
supportsUnionAll()
-
-
usesLocalFilePerTable()
- Presumed true given API wording
-
usesLocalFiles()
- Given wording of API I presume "local" means to the database
cx
jdbcMysqlConnex cx
- Parent connection
myCx
jdbcMysqlConnex myCx
- Our connection
typemap
private static Hashtable typemap
- Type mapping hashtable
maxRows
int maxRows
- Max rows
dbmdXcept
boolean dbmdXcept
- Do we throw exceptions on unsupported methods or just reurn
empty tables?
T_STRING
private static int T_STRING
T_INTEGER
private static int T_INTEGER
T_SHORT
private static int T_SHORT
errs
private static String errs[]
yes
private static byte yes[]
no
private static byte no[]
ten
private static byte ten[]
cin
private static byte cin[]
cnn
private static byte cnn[]
btable
private static byte btable[]
bbestRowSession
private static byte bbestRowSession[]
bbestRowNotPseudo
private static byte bbestRowNotPseudo[]
bTableIndexOther
private static byte bTableIndexOther[]
getProc_rsmd
private static RSMd getProc_rsmd
getCols_rsmd
private static RSMd getCols_rsmd
getPCols_rsmd
private static RSMd getPCols_rsmd
getBRId_rsmd
private static RSMd getBRId_rsmd
getTab_rsmd
private static RSMd getTab_rsmd
getSchm_rsmd
private static RSMd getSchm_rsmd
getCats_rsmd
private static RSMd getCats_rsmd
getTTyp_rsmd
private static RSMd getTTyp_rsmd
getPK_rsmd
private static RSMd getPK_rsmd
getTI_rsmd
private static RSMd getTI_rsmd
getII_rsmd
private static RSMd getII_rsmd
getXK_rsmd
private static RSMd getXK_rsmd
getKM_rsmd
private static RSMd getKM_rsmd
getPr_rsmd
private static RSMd getPr_rsmd
ctN
private static final String ctN[]
ctL
private static short ctL[]
defref
private static int defref[][]
DbMd
DbMd(jdbcMysqlConnex connection) throws SQLException
allProceduresAreCallable
public boolean allProceduresAreCallable() throws SQLException
allTablesAreSelectable
public boolean allTablesAreSelectable() throws SQLException
- Without actually looking we return true.
getURL
public String getURL() throws SQLException
getUserName
public String getUserName() throws SQLException
isReadOnly
public boolean isReadOnly() throws SQLException
nullsAreSortedHigh
public boolean nullsAreSortedHigh() throws SQLException
nullsAreSortedLow
public boolean nullsAreSortedLow() throws SQLException
nullsAreSortedAtStart
public boolean nullsAreSortedAtStart() throws SQLException
nullsAreSortedAtEnd
public boolean nullsAreSortedAtEnd() throws SQLException
getDatabaseProductName
public String getDatabaseProductName() throws SQLException
getDatabaseProductVersion
public String getDatabaseProductVersion() throws SQLException
getDriverName
public String getDriverName() throws SQLException
getDriverVersion
public String getDriverVersion() throws SQLException
getDriverMajorVersion
public int getDriverMajorVersion()
getDriverMinorVersion
public int getDriverMinorVersion()
usesLocalFiles
public boolean usesLocalFiles() throws SQLException
- Given wording of API I presume "local" means to the database
usesLocalFilePerTable
public boolean usesLocalFilePerTable() throws SQLException
- Presumed true given API wording
supportsMixedCaseIdentifiers
public boolean supportsMixedCaseIdentifiers() throws SQLException
storesUpperCaseIdentifiers
public boolean storesUpperCaseIdentifiers() throws SQLException
storesLowerCaseIdentifiers
public boolean storesLowerCaseIdentifiers() throws SQLException
storesMixedCaseIdentifiers
public boolean storesMixedCaseIdentifiers() throws SQLException
supportsMixedCaseQuotedIdentifiers
public boolean supportsMixedCaseQuotedIdentifiers() throws SQLException
storesUpperCaseQuotedIdentifiers
public boolean storesUpperCaseQuotedIdentifiers() throws SQLException
storesLowerCaseQuotedIdentifiers
public boolean storesLowerCaseQuotedIdentifiers() throws SQLException
storesMixedCaseQuotedIdentifiers
public boolean storesMixedCaseQuotedIdentifiers() throws SQLException
getIdentifierQuoteString
public String getIdentifierQuoteString() throws SQLException
getSQLKeywords
public String getSQLKeywords() throws SQLException
- Most of this is a guess from the MySQL documentation since I don't
know a lot about the formal ANSI 92 SQL. Will look it up someday.
getNumericFunctions
public String getNumericFunctions() throws SQLException
- Right from the manual
getStringFunctions
public String getStringFunctions() throws SQLException
- Right from the manual
getSystemFunctions
public String getSystemFunctions() throws SQLException
- Right from the manual
getTimeDateFunctions
public String getTimeDateFunctions() throws SQLException
- Right from the manual
getSearchStringEscape
public String getSearchStringEscape() throws SQLException
getExtraNameCharacters
public String getExtraNameCharacters() throws SQLException
supportsAlterTableWithAddColumn
public boolean supportsAlterTableWithAddColumn() throws SQLException
supportsAlterTableWithDropColumn
public boolean supportsAlterTableWithDropColumn() throws SQLException
supportsColumnAliasing
public boolean supportsColumnAliasing() throws SQLException
nullPlusNonNullIsNull
public boolean nullPlusNonNullIsNull() throws SQLException
supportsConvert
public boolean supportsConvert() throws SQLException
- Didn't see any explicit mention of CONVERT though implicit conversion
is all over the place.
supportsConvert
public boolean supportsConvert(int x,
int y) throws SQLException
supportsTableCorrelationNames
public boolean supportsTableCorrelationNames() throws SQLException
- Not quite sure what they mean here; have to dig someday
supportsDifferentTableCorrelationNames
public boolean supportsDifferentTableCorrelationNames() throws SQLException
supportsExpressionsInOrderBy
public boolean supportsExpressionsInOrderBy() throws SQLException
supportsOrderByUnrelated
public boolean supportsOrderByUnrelated() throws SQLException
supportsGroupBy
public boolean supportsGroupBy() throws SQLException
supportsGroupByUnrelated
public boolean supportsGroupByUnrelated() throws SQLException
supportsGroupByBeyondSelect
public boolean supportsGroupByBeyondSelect() throws SQLException
supportsLikeEscapeClause
public boolean supportsLikeEscapeClause() throws SQLException
supportsMultipleResultSets
public boolean supportsMultipleResultSets() throws SQLException
supportsMultipleTransactions
public boolean supportsMultipleTransactions() throws SQLException
- Odd one, no transactions but diff queries on diff connex
supportsNonNullableColumns
public boolean supportsNonNullableColumns() throws SQLException
supportsMinimumSQLGrammar
public boolean supportsMinimumSQLGrammar() throws SQLException
supportsCoreSQLGrammar
public boolean supportsCoreSQLGrammar() throws SQLException
supportsExtendedSQLGrammar
public boolean supportsExtendedSQLGrammar() throws SQLException
- A guess
supportsANSI92EntryLevelSQL
public boolean supportsANSI92EntryLevelSQL() throws SQLException
supportsANSI92IntermediateSQL
public boolean supportsANSI92IntermediateSQL() throws SQLException
supportsANSI92FullSQL
public boolean supportsANSI92FullSQL() throws SQLException
supportsIntegrityEnhancementFacility
public boolean supportsIntegrityEnhancementFacility() throws SQLException
supportsOuterJoins
public boolean supportsOuterJoins() throws SQLException
supportsFullOuterJoins
public boolean supportsFullOuterJoins() throws SQLException
- ng reports problems with left outer join
supportsLimitedOuterJoins
public boolean supportsLimitedOuterJoins() throws SQLException
getSchemaTerm
public String getSchemaTerm() throws SQLException
getProcedureTerm
public String getProcedureTerm() throws SQLException
getCatalogTerm
public String getCatalogTerm() throws SQLException
isCatalogAtStart
public boolean isCatalogAtStart() throws SQLException
getCatalogSeparator
public String getCatalogSeparator() throws SQLException
supportsSchemasInDataManipulation
public boolean supportsSchemasInDataManipulation() throws SQLException
supportsSchemasInProcedureCalls
public boolean supportsSchemasInProcedureCalls() throws SQLException
supportsSchemasInTableDefinitions
public boolean supportsSchemasInTableDefinitions() throws SQLException
supportsSchemasInIndexDefinitions
public boolean supportsSchemasInIndexDefinitions() throws SQLException
supportsSchemasInPrivilegeDefinitions
public boolean supportsSchemasInPrivilegeDefinitions() throws SQLException
supportsCatalogsInDataManipulation
public boolean supportsCatalogsInDataManipulation() throws SQLException
supportsCatalogsInProcedureCalls
public boolean supportsCatalogsInProcedureCalls() throws SQLException
supportsCatalogsInTableDefinitions
public boolean supportsCatalogsInTableDefinitions() throws SQLException
supportsCatalogsInIndexDefinitions
public boolean supportsCatalogsInIndexDefinitions() throws SQLException
supportsCatalogsInPrivilegeDefinitions
public boolean supportsCatalogsInPrivilegeDefinitions() throws SQLException
supportsPositionedDelete
public boolean supportsPositionedDelete() throws SQLException
supportsPositionedUpdate
public boolean supportsPositionedUpdate() throws SQLException
supportsSelectForUpdate
public boolean supportsSelectForUpdate() throws SQLException
supportsStoredProcedures
public boolean supportsStoredProcedures() throws SQLException
supportsSubqueriesInComparisons
public boolean supportsSubqueriesInComparisons() throws SQLException
supportsSubqueriesInExists
public boolean supportsSubqueriesInExists() throws SQLException
supportsSubqueriesInIns
public boolean supportsSubqueriesInIns() throws SQLException
- clueless here
supportsSubqueriesInQuantifieds
public boolean supportsSubqueriesInQuantifieds() throws SQLException
- Wazza quantified?
supportsCorrelatedSubqueries
public boolean supportsCorrelatedSubqueries() throws SQLException
- Damfino. Lookee all the purty colors ...
supportsUnion
public boolean supportsUnion() throws SQLException
- Union?? I may be Pennsylvanian but my heart belongs to Dixie
supportsUnionAll
public boolean supportsUnionAll() throws SQLException
supportsOpenCursorsAcrossCommit
public boolean supportsOpenCursorsAcrossCommit() throws SQLException
supportsOpenCursorsAcrossRollback
public boolean supportsOpenCursorsAcrossRollback() throws SQLException
supportsOpenStatementsAcrossCommit
public boolean supportsOpenStatementsAcrossCommit() throws SQLException
supportsOpenStatementsAcrossRollback
public boolean supportsOpenStatementsAcrossRollback() throws SQLException
getMaxBinaryLiteralLength
public int getMaxBinaryLiteralLength() throws SQLException
getMaxCharLiteralLength
public int getMaxCharLiteralLength() throws SQLException
getMaxColumnNameLength
public int getMaxColumnNameLength() throws SQLException
- settable at gen; is there a way to check?
getMaxColumnsInGroupBy
public int getMaxColumnsInGroupBy() throws SQLException
- need to look this up
getMaxColumnsInIndex
public int getMaxColumnsInIndex() throws SQLException
getMaxColumnsInOrderBy
public int getMaxColumnsInOrderBy() throws SQLException
getMaxColumnsInSelect
public int getMaxColumnsInSelect() throws SQLException
- Is there a limit?
getMaxColumnsInTable
public int getMaxColumnsInTable() throws SQLException
getMaxConnections
public int getMaxConnections() throws SQLException
getMaxCursorNameLength
public int getMaxCursorNameLength() throws SQLException
getMaxIndexLength
public int getMaxIndexLength() throws SQLException
getMaxSchemaNameLength
public int getMaxSchemaNameLength() throws SQLException
getMaxProcedureNameLength
public int getMaxProcedureNameLength() throws SQLException
getMaxCatalogNameLength
public int getMaxCatalogNameLength() throws SQLException
getMaxRowSize
public int getMaxRowSize() throws SQLException
doesMaxRowSizeIncludeBlobs
public boolean doesMaxRowSizeIncludeBlobs() throws SQLException
getMaxStatementLength
public int getMaxStatementLength() throws SQLException
getMaxStatements
public int getMaxStatements() throws SQLException
getMaxTableNameLength
public int getMaxTableNameLength() throws SQLException
getMaxTablesInSelect
public int getMaxTablesInSelect() throws SQLException
- Is there a limit?
getMaxUserNameLength
public int getMaxUserNameLength() throws SQLException
getDefaultTransactionIsolation
public int getDefaultTransactionIsolation() throws SQLException
supportsTransactions
public boolean supportsTransactions() throws SQLException
supportsTransactionIsolationLevel
public boolean supportsTransactionIsolationLevel(int l) throws SQLException
supportsDataDefinitionAndDataManipulationTransactions
public boolean supportsDataDefinitionAndDataManipulationTransactions() throws SQLException
supportsDataManipulationTransactionsOnly
public boolean supportsDataManipulationTransactionsOnly() throws SQLException
dataDefinitionCausesTransactionCommit
public boolean dataDefinitionCausesTransactionCommit() throws SQLException
dataDefinitionIgnoredInTransactions
public boolean dataDefinitionIgnoredInTransactions() throws SQLException
getProcedures
public ResultSet getProcedures(String c,
String s,
String p) throws SQLException
- No procedures in MySQL, return empty RS
getProcedureColumns
public ResultSet getProcedureColumns(String c,
String s,
String p,
String l) throws SQLException
- No procedures in MySQL, return empty RS
getTables
public ResultSet getTables(String c,
String s,
String p,
String t[]) throws SQLException
- See the API
getSchemas
public ResultSet getSchemas() throws SQLException
- No schemas in MySQL, return empty RS
getCatalogs
public ResultSet getCatalogs() throws SQLException
getTableTypes
public ResultSet getTableTypes() throws SQLException
getTablePrivileges
public ResultSet getTablePrivileges(String c,
String s,
String p) throws SQLException
- Priveliges work a little different in MySQL, return empty RS
getColumnPrivileges
public ResultSet getColumnPrivileges(String c,
String s,
String p,
String l) throws SQLException
- Priveliges work a little different in MySQL, return empty RS
getColumns
public ResultSet getColumns(String c,
String s,
String p,
String l) throws SQLException
getBestRowIdentifier
public ResultSet getBestRowIdentifier(String c,
String s,
String t,
int r,
boolean n) throws SQLException
- Maybe later, and maybe peace will break out all over,
, return empty RS
getVersionColumns
public ResultSet getVersionColumns(String c,
String s,
String t) throws SQLException
- AFAIK no version columns in MySQL, return empty RS
getPrimaryKeys
public ResultSet getPrimaryKeys(String c,
String s,
String t) throws SQLException
- May do this later, return empty RS
sillySort
void sillySort(String s[],
Object o[])
getImportedKeys
public ResultSet getImportedKeys(String c,
String s,
String t) throws SQLException
- Return empty RS
getExportedKeys
public ResultSet getExportedKeys(String c,
String s,
String t) throws SQLException
- Return empty RS
getCrossReference
public ResultSet getCrossReference(String pc,
String ps,
String pt,
String fc,
String fs,
String ft) throws SQLException
- Return empty RS
getTypeInfo
public ResultSet getTypeInfo() throws SQLException
- Someday, Return empty RS
getIndexInfo
public ResultSet getIndexInfo(String c,
String s,
String t,
boolean u,
boolean a) throws SQLException
- Return empty RS
makeXkey
private ResultSet makeXkey() throws SQLException
makePrivs
private ResultSet makePrivs() throws SQLException
getResult1
private Vector getResult1(String query) throws SQLException
- A simple method to return a vector of the first column of a query
rsCol
private jdbcMysqlField rsCol(RSMd rd,
String name,
int ty,
int len) throws SQLException
rsMake
private RSMd rsMake(int m) throws SQLException
errHandlerM
void errHandlerM(int n,
String m) throws SQLException
errHandlerE
void errHandlerE(int n,
Exception e) throws SQLException
errHandlerE2
void errHandlerE2(int n,
String s,
Exception e) throws SQLException
All Packages Class Hierarchy This Package Previous Next Index