|
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES All Classes | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
public interface DBProfile
Date: Oct 9, 2006 Time: 6:28:59 PM Author: Sergey Churikov
Method Summary | |
---|---|
java.lang.String |
convert(java.sql.ResultSet rs,
int fieldIndex,
int sqlType)
Export method (i.e. |
SQLCommandProducer<Record> |
createDeleteSQLProducer()
|
SQLCommandProducer<Record> |
createInsertSQLProducer()
|
SQLCommandProducer<UpdateRecord> |
createUpdateSQLProducer()
|
boolean |
isExceptionCanBeIgnored(java.sql.SQLException ex)
This this method it is possible to handle some cases when SQL operation can be continue even database error occured (say in case of Oracle we ignore ORA-00942 error: table or view does not exist). |
java.lang.String |
typeName(int sqlType,
int len,
java.lang.Integer precision)
Comparison method, i.e. |
java.lang.String |
viewNameColumn()
This method is used only in ViewStructTask to retrieve information about a view. |
java.lang.String |
viewOwnerColumn()
This method is used only in ViewStructTask to retrieve information about a view. |
java.lang.String |
viewsCatalog()
This method is used only in ViewStructTask to retrieve information about a view. |
java.lang.String |
viewSqlColumn()
This method is used only in ViewStructTask to retrieve information about a view. |
Method Detail |
---|
java.lang.String convert(java.sql.ResultSet rs, int fieldIndex, int sqlType) throws java.sql.SQLException
This method is used to convert SQL data from ResultSet to String (i.e. java.sql.ResultSet.getXXX( fieldIndex ) to java.sql.String). The result of convertation will be saved into XML. Because JAXB is used it is not necessary to think about conversation of 'special' illegal for XML symbols (say like <).
rs
- java.sql.ResultSet with current rowfieldIndex
- the field which should be retrived from rs by rs.getXXX( fieldIndex ) methodsqlType
- java.sql.Type according to metadata information.
java.sql.SQLException
java.lang.String typeName(int sqlType, int len, java.lang.Integer precision)
Converts field description into ANSI SQL. If sqlType is not supported by DBProfile implementation IllegalArgumentException exception is thrown.
sqlType
- java.sql.Types valuelen
- field len valueprecision
-
java.lang.String viewsCatalog()
java.lang.String viewSqlColumn()
java.lang.String viewNameColumn()
java.lang.String viewOwnerColumn()
boolean isExceptionCanBeIgnored(java.sql.SQLException ex)
ex
- database error
SQLCommandProducer<UpdateRecord> createUpdateSQLProducer()
SQLCommandProducer<Record> createInsertSQLProducer()
SQLCommandProducer<Record> createDeleteSQLProducer()
|
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES All Classes | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |