Package simpleorm.drivers

Class SDriverOracle

java.lang.Object
simpleorm.sessionjdbc.SDriver
simpleorm.drivers.SDriverOracle
public class SDriverOracle extends SDriver
This contains Oracle specific code.

In oracle VARCHAR2 '' == null. Ie. min string length is 2. VARCHAR == VARCHAR2? but not recommended? VARCHARs max size 2000 or 4000 Oracle 8. CHARS max size 2000 all versions. LONG for larger strings.

Dates DATE, TIMESTAMP [WITH TIMEZONE].

It is reported that CHARs need to be trimed for comparison?

  • Constructor Details

    • SDriverOracle

      public SDriverOracle()

  • Method Details

    • driverName

      protected String driverName()
      Description copied from class: SDriver
      The driver name to be compared to getMetaData().getDriverName()
      Overrides:
      driverName in class SDriver

    • maxIdentNameLength

      public int maxIdentNameLength()
      Description copied from class: SDriver
      The maximum size for table names and foreign key constraint names.
      Overrides:
      maxIdentNameLength in class SDriver

    • generateKeySequence

      protected long generateKeySequence(SRecordMeta<?> rec, SFieldScalar keyFld)
      Specializes SDriver.generateKeySequence using Oracle SEQUENCEs.
      Overrides:
      generateKeySequence in class SDriver

    • supportsKeySequences

      public boolean supportsKeySequences()
      Overrides:
      supportsKeySequences in class SDriver

    • createSequenceDDL

      protected String createSequenceDDL(String name)
      Overrides:
      createSequenceDDL in class SDriver

    • dropSequenceDDL

      protected String dropSequenceDDL(String name)
      Overrides:
      dropSequenceDDL in class SDriver

    • columnTypeSQL

      protected String columnTypeSQL(SFieldScalar field, String defalt)
      Description copied from class: SDriver
      Used to override the default. ONLY called if no fld.defaultSqlDataType has been specified, ie. only used to override the SFieldScalar.defaultSqlDataType.
      Overrides:
      columnTypeSQL in class SDriver

    • getOffsetStrategy

      protected SDriver.OffsetStrategy getOffsetStrategy()
      Description copied from class: SDriver
      JDBC prefered, if jdbc driver has a sensible scrollable resultset implemntation QUERY if database would handle it better via some proprietary sql extension (eg. LIMIT) BULK Simpleorm will get the whole resultset and skip de first row. Worst case scenario :(

      Defaults to BULK

      Overrides:
      getOffsetStrategy in class SDriver