org.chur.ant.db.profiles.impl
Class OracleProfile

java.lang.Object
  org.chur.ant.db.profiles.AbstractDBProfile
      org.chur.ant.db.profiles.impl.OracleProfile

All Implemented Interfaces:

DBProfile

public class OracleProfile
extends AbstractDBProfile

Oracle DB profile

Date: Oct 10, 2006 Time: 5:36:32 PM Author: Sergey Churikov

Constructor Summary

OracleProfile()

Method Summary

SQLCommandProducer<Record>	createDeleteSQLProducer()
SQLCommandProducer<Record>	createInsertSQLProducer()
SQLCommandProducer<UpdateRecord>	createUpdateSQLProducer()
boolean	isExceptionCanBeIgnored(java.sql.SQLException ex) The error ORA-00942 ("table or view does not exist") is ignored.
java.lang.String	toString()
java.lang.String	typeName(int sqlType, int len, java.lang.Integer precision) Convert field description into ANSI SQL.
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.

Methods inherited from class org.chur.ant.db.profiles.AbstractDBProfile

convert

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

Constructor Detail

OracleProfile

public OracleProfile()

Method Detail

typeName

public java.lang.String typeName(int sqlType,
                                 int len,
                                 java.lang.Integer precision)

Convert field description into ANSI SQL. The following types supported:

• java.sql.Types.DATE and java.sql.Types.TIMESTAMP -> DATE
• java.sql.Types.CHAR and java.sql.Types.VARCHAR -> VARCHAR2( len )
• java.sql.Types.INTEGER, java.sql.Types.SMALLINT and java.sql.Types.TINYINT -> INTEGER( len )
• java.sql.Types.DECIMAL, java.sql.Types.DOUBLE, java.sql.Types.FLOAT and java.sql.Types.REAL -> NUMERIC( len[,precision] )
• in others cases IllegalArgumentException will be thrown

Parameters:

sqlType - java.sql.Type value

len - field length according to metadata

precision - precision value if exist

Returns:

The SQL type description to include this string in SQL script

Throws:

java.lang.IllegalArgumentException - if sqlType is not supported (the support type see above)

viewsCatalog

public java.lang.String viewsCatalog()

Description copied from interface: DBProfile

This method is used only in ViewStructTask to retrieve information about a view.

Returns:

ALL_VIEWS value

viewSqlColumn

public java.lang.String viewSqlColumn()

Description copied from interface: DBProfile

This method is used only in ViewStructTask to retrieve information about a view.

Returns:

TEXT value

viewNameColumn

public java.lang.String viewNameColumn()

Description copied from interface: DBProfile

This method is used only in ViewStructTask to retrieve information about a view.

Returns:

VIEW_NAME value

viewOwnerColumn

public java.lang.String viewOwnerColumn()

Description copied from interface: DBProfile

This method is used only in ViewStructTask to retrieve information about a view.

Returns:

OWNER value

isExceptionCanBeIgnored

public boolean isExceptionCanBeIgnored(java.sql.SQLException ex)

The error ORA-00942 ("table or view does not exist") is ignored.

Parameters:

ex -

Returns:

true if error code is 942 false else

createUpdateSQLProducer

public SQLCommandProducer<UpdateRecord> createUpdateSQLProducer()

createInsertSQLProducer

public SQLCommandProducer<Record> createInsertSQLProducer()

createDeleteSQLProducer

public SQLCommandProducer<Record> createDeleteSQLProducer()

toString

public java.lang.String toString()

Overrides:

toString in class java.lang.Object