Class 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 Detail

      • OracleDBHelper

        public OracleDBHelper​(java.sql.Connection connection)
        Deprecated.
    • Method Detail

      • 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​(java.sql.Connection conn,
                               java.lang.String table,
                               java.lang.String columnName)
                        throws java.sql.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:
        java.sql.SQLException
      • containsTable

        public boolean containsTable​(javax.sql.DataSource ds,
                                     java.lang.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 java.lang.String clobToString​(java.sql.Connection conn,
                                             java.sql.ResultSet rs,
                                             int column)
        Deprecated.
      • stringToClob

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