Package org.biojava.bio.seq.db.biosql
Class DBHelper
java.lang.Object
org.biojava.bio.seq.db.biosql.DBHelper
- Direct Known Subclasses:
HypersonicDBHelper
,MySQLDBHelper
,OracleDBHelper
,PostgreSQLDBHelper
,UnknownDBHelper
Deprecated.
Use hibernate and org.biojavax.bio.db.*
Isolates all code that is specific to a particular RDBMS. To add
support for a new RDBMS, write a new
DBHelper
subclass
and ensure that it can be found by editing the
getDBHelperForURL
method in this class.- Author:
- Thomas Down, Matthew Pocock, Len Trigg, Eric Haugen, Richard Holland
-
Nested Class Summary
Nested ClassesModifier and TypeClassDescriptionstatic final class
Deprecated.static final class
Deprecated.static final class
Deprecated. -
Field Summary
FieldsModifier and TypeFieldDescriptionstatic final DBHelper.BioSequenceStyle
Deprecated.static final DBHelper.BioSequenceStyle
Deprecated.static final DBHelper.DeleteStyle
Deprecated.static final DBHelper.DeleteStyle
Deprecated.static final DBHelper.DeleteStyle
Deprecated.static final DBHelper.JoinStyle
Deprecated.static final DBHelper.JoinStyle
Deprecated. -
Constructor Summary
Constructors -
Method Summary
Modifier and TypeMethodDescriptionboolean
containsTable
(DataSource ds, String tablename) Deprecated.Detects whether a particular table is present in the database.Deprecated.Returns the an object indicating the style of biosequence storage that this database should employ.static DBHelper
getDBHelper
(Connection conn) Deprecated.Returns a DBHelper implementation suitable for a particular database.Deprecated.Returns the an object indicating the style of deletion that this database should employ.abstract int
getInsertID
(Connection conn, String table, String columnName) Deprecated.Returns the id value created during the last insert command.Deprecated.Returns the an object indicating the style of table joining that this database should employ.
-
Field Details
-
DELETE_POSTGRESQL
Deprecated. -
DELETE_MYSQL4
Deprecated. -
DELETE_GENERIC
Deprecated. -
JOIN_ORACLE8
Deprecated. -
JOIN_GENERIC
Deprecated. -
BIOSEQUENCE_GENERIC
Deprecated. -
BIOSEQUENCE_ORACLECLOB
Deprecated.
-
-
Constructor Details
-
DBHelper
public DBHelper()Deprecated.
-
-
Method Details
-
getDBHelper
Deprecated.Returns a DBHelper implementation suitable for a particular database.- Parameters:
conn
- a connection to the database.- Returns:
- a
DBHelper
.
-
getInsertID
public abstract int getInsertID(Connection conn, String table, String columnName) throws SQLException Deprecated.Returns the id value created during the last insert command. This is for tables that have an auto increment column.- Returns:
- the last id assigned, or -1 if the id could not be found.
- Throws:
SQLException
-
getDeleteStyle
Deprecated.Returns the an object indicating the style of deletion that this database should employ. Unless overridden, this is DELETE_GENERIC.- Returns:
- the preferred deletion style.
-
getJoinStyle
Deprecated.Returns the an object indicating the style of table joining that this database should employ.- Returns:
- the preferred joining style.
-
getBioSequenceStyle
Deprecated.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.)- Returns:
- the preferred joining style.
-
containsTable
Deprecated.Detects whether a particular table is present in the database.- Parameters:
ds
- aDataSource
that can provide a connection to a databasetablename
- the name of the table.- Returns:
- true if the table exists in the database.
- Throws:
NullPointerException
- if pool is null.IllegalArgumentException
- if tablename is null or empty.
-