| java.lang.Object
 org.griphyn.vdl.dbdriver.DatabaseDriver
org.griphyn.vdl.dbdriver.SQLServer2000
| SQLServer2000 | | public class SQLServer2000 extends DatabaseDriver (Code) | | This class implements the driver API for the Microsoft SQL Server
2000 database. Please note that due to the limited capabilities of
the Microsoft-provided free JDBC driver for SQL-Server, it will
not work as a database driver. However, if you have access to
the commercial JDBC3-compatible driver, you are encouraged to
implement the missing functionality.
author:
Jens-S. Vöckler
author:
Yong Zhao
version:
$Revision: 50 $
See Also: DatabaseDriver
See Also: org.griphyn.vdl.dbschema |
| Method Summary | |
| public boolean | cachingMakesSense()
Determines, if the backend is expensive, and results should be cached. | | public boolean | connect(String url, Properties info, Set tables)
Establish a connection to your database. | | public boolean | preferString()
Predicate to tell the schema, if using a string instead of number
will result in the speedier index scans instead of sequential scans.
PostGreSQL has this problem, but using strings in the place of
integers may not be universally portable.
true, if using strings instead of integers and bigintswill yield better performance. | | public String | quote(String s)
Quotes a string that may contain special SQL characters.
Parameters:
s - is the raw string. | | public long | sequence1(String name)
Obtains the next value from a sequence. | | public long | sequence2(Statement s, String name, int pos)
Obtains the sequence value for the current statement. |
| cachingMakesSense | | public boolean cachingMakesSense()(Code) | | Determines, if the backend is expensive, and results should be cached.
Ideally, this will move transparently into the backend itself.
true if caching is advisable, false for no caching. |
| connect | | public boolean connect(String url, Properties info, Set tables) throws SQLException, ClassNotFoundException(Code) | | Establish a connection to your database. The parameters will often
be ignored or abused for different purposes on different backends.
It is assumed that the connection is not in auto-commit mode, and
explicit commits must be issued.
Parameters:
url - the contact string to database, or schema location
Parameters:
info - additional parameters, usually username and password
Parameters:
tables - is a set of all table names in the schema. Theexistence of all tables will be checked to verifythat the schema is active in the database. true if the connection succeeded, false otherwise. Usually,false is returned, if the any of the tables or sequences is missing. if the driver is incapable of establishing a connection. |
| preferString | | public boolean preferString()(Code) | | Predicate to tell the schema, if using a string instead of number
will result in the speedier index scans instead of sequential scans.
PostGreSQL has this problem, but using strings in the place of
integers may not be universally portable.
true, if using strings instead of integers and bigintswill yield better performance. |
| quote | | public String quote(String s)(Code) | | Quotes a string that may contain special SQL characters.
Parameters:
s - is the raw string. the quoted string, which may be just the input string. |
| sequence1 | | public long sequence1(String name) throws SQLException(Code) | | Obtains the next value from a sequence. JDBC drivers which allow
explicit access to sequence generator will return a valid value
in this function. All other JDBC drivers should return -1.
Parameters:
name - is the name of the sequence. the next sequence number. if something goes wrong while fetching the new value. |
| sequence2 | | public long sequence2(Statement s, String name, int pos) throws SQLException(Code) | | Obtains the sequence value for the current statement. JDBC driver
that permit insertion of NULL into auto-increment value should use
this method to return the inserted ID value via the statements
getGeneratedKeys(). Other JDBC drivers should treat return the
parametric id.
Parameters:
s - is a statment or prepared statement
Parameters:
name - is the name of the sequence.
Parameters:
pos - is the column number of the auto-increment column. the next sequence number. if something goes wrong while fetching the new value. |
| Methods inherited from org.griphyn.vdl.dbdriver.DatabaseDriver | public boolean addPreparedStatement(String id, String statement) throws SQLException(Code)(Java Doc)
protected boolean addPreparedStatement(String id, String statement, boolean autoGeneratedKeys) throws SQLException(Code)(Java Doc)
public ResultSet backdoor(String query) throws SQLException(Code)(Java Doc)
abstract public boolean cachingMakesSense()(Code)(Java Doc)
public void cancelPreparedStatement(String id) throws SQLException, ArrayIndexOutOfBoundsException(Code)(Java Doc)
public void clearWarnings() throws SQLException(Code)(Java Doc)
public void commit() throws SQLException(Code)(Java Doc)
protected boolean connect(String driver, String url, Properties info, Set tables) throws SQLException, ClassNotFoundException(Code)(Java Doc)
abstract public boolean connect(String url, Properties info, Set tables) throws SQLException, ClassNotFoundException(Code)(Java Doc)
public int delete(String table, Map columns) throws SQLException(Code)(Java Doc)
public void disconnect() throws SQLException(Code)(Java Doc)
public void driverMatch() throws SQLException(Code)(Java Doc)
protected void finalize() throws Throwable(Code)(Java Doc)
public PreparedStatement getPreparedStatement(String id) throws SQLException(Code)(Java Doc)
public SQLWarning getWarnings() throws SQLException(Code)(Java Doc)
public long insert(String table, Map keycolumns, Map columns) throws SQLException(Code)(Java Doc)
public boolean insertPreparedStatement(String id, String statement) throws SQLException(Code)(Java Doc)
public static DatabaseDriver loadDriver(String dbDriverName, String propertyPrefix, Object[] arguments) throws ClassNotFoundException, IOException, NoSuchMethodException, InstantiationException, IllegalAccessException, InvocationTargetException, SQLException(Code)(Java Doc)
public static DatabaseDriver loadDriver(String propertyPrefix) throws ClassNotFoundException, IOException, NoSuchMethodException, InstantiationException, IllegalAccessException, InvocationTargetException, SQLException(Code)(Java Doc)
abstract public boolean preferString()(Code)(Java Doc)
public String quote(String s)(Code)(Java Doc)
public void removePreparedStatement(String id) throws SQLException(Code)(Java Doc)
public void rollback() throws SQLException(Code)(Java Doc)
public ResultSet select(List select, String table, Map where, String order) throws SQLException(Code)(Java Doc)
public ResultSet select(List select, String table, Map where, Map operator, String order) throws SQLException(Code)(Java Doc)
abstract public long sequence1(String name) throws SQLException(Code)(Java Doc)
abstract public long sequence2(Statement s, String name, int pos) throws SQLException(Code)(Java Doc)
public int update(String table, Map keycolumns, Map columns) throws SQLException(Code)(Java Doc)
|
|
|