Package org.biojava.bio.seq.db.biosql

Class OracleDBHelper

java.lang.Object
org.biojava.bio.seq.db.biosql.DBHelper
org.biojava.bio.seq.db.biosql.OracleDBHelper
public class OracleDBHelper extends DBHelper
Deprecated.
Use hibernate and org.biojavax.bio.db.*
This is a DBHelper that provides support for Oracle databases.
Author:
Len Trigg, Eric Haugen, Richard Holland

  • Constructor Details

  • Method Details

    • getJoinStyle

      public DBHelper.JoinStyle getJoinStyle()
      Deprecated.
      Description copied from class: DBHelper
      Returns the an object indicating the style of table joining that this database should employ.
      Overrides:
      getJoinStyle in class DBHelper
      Returns:
      the preferred joining style.

    • getInsertID

      public int getInsertID(Connection conn, String table, String columnName) throws SQLException
      Deprecated.
      Description copied from class: DBHelper
      Returns the id value created during the last insert command. This is for tables that have an auto increment column.
      Specified by:
      getInsertID in class DBHelper
      Returns:
      the last id assigned, or -1 if the id could not be found.
      Throws:
      SQLException

    • containsTable

      public boolean containsTable(DataSource ds, String tablename)
      Deprecated.
      Description copied from class: DBHelper
      Detects whether a particular table is present in the database.
      Overrides:
      containsTable in class DBHelper
      Parameters:
      ds - a DataSource that can provide a connection to a database
      tablename - the name of the table.
      Returns:
      true if the table exists in the database.

    • getBioSequenceStyle

      public DBHelper.BioSequenceStyle getBioSequenceStyle()
      Deprecated.
      Description copied from class: DBHelper
      Returns the an object indicating the style of biosequence storage that this database should employ. Generally, leave it at the default unless you are using the Oracle schema, in which case you need to override it to return BIOSEQUENCE_ORACLECLOB. This is because, in the Oracle schema we need to use CLOBs (except when using Len Trigg's version which uses LONGs instead.)
      Overrides:
      getBioSequenceStyle in class DBHelper
      Returns:
      the preferred joining style.

    • clobToString

      public String clobToString(Connection conn, ResultSet rs, int column)
      Deprecated.

    • stringToClob

      public void stringToClob(Connection conn, ResultSet rs, int column, String value)
      Deprecated.