org.ovirt.engine.core.dal.dbbroker

Class SqlServerDbEngineDialect

java.lang.Object

org.ovirt.engine.core.dal.dbbroker.SqlServerDbEngineDialect

All Implemented Interfaces:

DbEngineDialect

public class SqlServerDbEngineDialect
extends Object
implements DbEngineDialect

SQL Server db engine dialect.

Constructor Summary

Constructors

Constructor and Description
SqlServerDbEngineDialect()

Method Summary

Methods

Modifier and Type	Method and Description
org.springframework.jdbc.core.simple.SimpleJdbcCallOperations	createJdbcCallForQuery(org.springframework.jdbc.core.JdbcTemplate jdbcTemplate) Create the object used for performing function calls for querying data and returning a result/list of results.
org.springframework.jdbc.core.JdbcTemplate	createJdbcTemplate(DataSource dataSource) Create the JdbcTemplate to use in the DbFacade class.
String	getFunctionReturnKey() TODO: Remove this method once we don't use SqlServer anymore, since it's a needed only for SqlServer Compatibility.
String	getParamNamePrefix() Gets the engine prefix to be used for sp parameters.
String	getPreSearchQueryCommand() TODO: Remove this method once we don't use SqlServer anymore, since it's a needed only for SqlServer Compatibility.

Methods inherited from class java.lang.Object

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

Constructor Detail

SqlServerDbEngineDialect

public SqlServerDbEngineDialect()

Method Detail

createJdbcTemplate

public org.springframework.jdbc.core.JdbcTemplate createJdbcTemplate(DataSource dataSource)

Description copied from interface: DbEngineDialect

Create the JdbcTemplate to use in the DbFacade class. TODO: Remove this method once we don't use SqlServer anymore, since it's a needed only for SqlServer Compatibility.

Specified by:

createJdbcTemplate in interface DbEngineDialect

Parameters:

dataSource - The Data Source to use for the template.

Returns:

A JdbcTemplate that can be used to DB operations.

createJdbcCallForQuery

public org.springframework.jdbc.core.simple.SimpleJdbcCallOperations createJdbcCallForQuery(org.springframework.jdbc.core.JdbcTemplate jdbcTemplate)

Description copied from interface: DbEngineDialect

Create the object used for performing function calls for querying data and returning a result/list of results. This object can't be used safely to execute other commands, since it doesn't necessarily support features such as out parameters. However, it must be used in order to query the DB correctly using a function call.

Specified by:

createJdbcCallForQuery in interface DbEngineDialect

Parameters:

jdbcTemplate - The JDBC template is needed for actually performing the calls.

Returns:

A SimpleJdbcCallOperations instance that can be used to call a query function in the DB.

getParamNamePrefix

public String getParamNamePrefix()

Description copied from interface: DbEngineDialect

Gets the engine prefix to be used for sp parameters.

Specified by:

getParamNamePrefix in interface DbEngineDialect

Returns:

getPreSearchQueryCommand

public String getPreSearchQueryCommand()

Description copied from interface: DbEngineDialect

TODO: Remove this method once we don't use SqlServer anymore, since it's a needed only for SqlServer Compatibility.

Specified by:

getPreSearchQueryCommand in interface DbEngineDialect

Returns:

The command to run before executing the search query (can be empty).

getFunctionReturnKey

public String getFunctionReturnKey()

Description copied from interface: DbEngineDialect

TODO: Remove this method once we don't use SqlServer anymore, since it's a needed only for SqlServer Compatibility.

Specified by:

getFunctionReturnKey in interface DbEngineDialect

Returns:

The default key of the returned value by a function when called using SimpleJdbcCallOperations#execute().