|
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Object butler.sql.util.SQLHelper
public class SQLHelper
Helper class for providing misc database vendor specific information. This class has subclasses for every database vendor that has specific information.
Constructor Summary | |
---|---|
SQLHelper()
|
Method Summary | |
---|---|
boolean |
checkDuplicateBeforeInsert()
|
java.lang.Exception |
createException(java.sql.SQLException e)
|
java.lang.Object |
db2obj(java.lang.Object obj,
Column col)
|
java.lang.String |
getColumnTypeSQL(Column col)
|
static SQLHelper |
getHelper(java.sql.DatabaseMetaData meta)
Returns the helper for given database. |
java.lang.Class |
getJavaClass(int type)
Deprecated. Use Datatype.getJavaClass instead. |
java.lang.String |
getJoinAliasKeyword()
|
java.lang.String |
getQuote()
Returns the character that is used as a quote. |
java.lang.String |
getTypeName(int type)
Returns the column type name that is used in create table statements. |
void |
populateStatement(JPreparedStatement stmt,
int index,
Record rec,
Column col,
java.lang.Object value)
|
boolean |
supportsForeignKeys()
|
boolean |
supportsIndexes()
|
boolean |
useCatalog()
Tells if catalog should be used in qualified names for tables. |
boolean |
useColumnAliasInOrderBy()
|
boolean |
useSchema()
Tells if schema should be used in qualified names for tables. |
Methods inherited from class java.lang.Object |
---|
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Constructor Detail |
---|
public SQLHelper()
Method Detail |
---|
public static SQLHelper getHelper(java.sql.DatabaseMetaData meta) throws java.lang.Exception
java.lang.Exception
public java.lang.String getTypeName(int type) throws java.lang.Exception
java.lang.Exception
public java.lang.String getColumnTypeSQL(Column col) throws java.lang.Exception
java.lang.Exception
public java.lang.Class getJavaClass(int type) throws java.lang.Exception
java.lang.Exception
public java.lang.String getQuote()
public boolean useCatalog()
public boolean useSchema()
public void populateStatement(JPreparedStatement stmt, int index, Record rec, Column col, java.lang.Object value) throws java.lang.Exception
java.lang.Exception
public java.lang.String getJoinAliasKeyword()
public java.lang.Object db2obj(java.lang.Object obj, Column col) throws java.lang.Exception
java.lang.Exception
public java.lang.Exception createException(java.sql.SQLException e)
public boolean useColumnAliasInOrderBy()
public boolean checkDuplicateBeforeInsert()
public boolean supportsIndexes()
public boolean supportsForeignKeys()
|
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |