net.aditsu.depeche

Class SQLServerProvider

java.lang.Object

net.aditsu.depeche.Provider

net.aditsu.depeche.SQLServerProvider

All Implemented Interfaces:

Serializable

public class SQLServerProvider
extends Provider

Provider implementation for Microsoft SQL Server

Author:

aditsu

See Also:

Serialized Form

Constructor Summary

Constructors

Constructor and Description
SQLServerProvider(ConnSource cs) Creates a SQLServerProvider using a connection source
SQLServerProvider(String host, int port, String db, String user, String password) Creates a SQLServerProvider using connection details including port number
SQLServerProvider(String host, String db, String user, String password) Creates a SQLServerProvider using connection details

Method Summary

Methods

Modifier and Type	Method and Description
static DSConnSource	createConnSource(String host, int port, String db, String user, String password) Creates a SQL Server connection source
long	getLongLastId(Conn conn) Returns the last generated auto-increment value in a given connection as a long value

Methods inherited from class net.aditsu.depeche.Provider

addColumn, addColumn, addFKey, addFKey, addUnique, addUnique, batchInsert, batchInsert, clearTable, close, createTable, createTable, createView, createView, dropColumn, dropColumn, dropFKey, dropFKey, dropTable, dropTable, dropView, dropView, execute, execute, filter, filter, filter, filterIn, getAddColumnSQL, getAddFKeySQL, getAddUniqueSQL, getAllTables, getAllViews, getColumnCommentQuery, getColumnDesc, getCreateTableSQL, getCreateViewSQL, getDropColumnSQL, getDropFKeySQL, getDropTableSQL, getDropViewSQL, getEnumValues, getGenericTableDetails, getGenericTables, getLastId, getName, getProviderRef, getRecord, getRecord, getRecord, getRecord, getRecord, getRecord, getTableInfo, getTableInfo, getTableInfo, getTableInfo, getTables, getTableTypes, getUniqueConstraints, getViewDefinition, getViews, hasFlag, joinCondition, joinCondition, joinCondition, newRecord, newRecord, newRecord, query, query, query, query, query, quote, rawQuery, rawQuery, rawQuote, resolveTable, resolveTable, run, setColumnComment, setColumnComment, setName, setProviderRef, transaction

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

SQLServerProvider

public SQLServerProvider(ConnSource cs)

Creates a SQLServerProvider using a connection source

SQLServerProvider

public SQLServerProvider(String host,
                 String db,
                 String user,
                 String password)

Creates a SQLServerProvider using connection details

SQLServerProvider

public SQLServerProvider(String host,
                 int port,
                 String db,
                 String user,
                 String password)

Creates a SQLServerProvider using connection details including port number

Method Detail

createConnSource

public static DSConnSource createConnSource(String host,
                            int port,
                            String db,
                            String user,
                            String password)

Creates a SQL Server connection source

getLongLastId

public long getLongLastId(Conn conn)

Description copied from class: Provider

Returns the last generated auto-increment value in a given connection as a long value

Overrides:

getLongLastId in class Provider