com.webmethods.portal.service.sql

Interface IDataManager

public interface IDataManager

Interface to adapt the DataManager for usage as an OSGi service

Field Summary

Fields

Modifier and Type	Field and Description
static String	DATA_SERVICE
static String	DATA_SERVICE_ALIAS_PREFIX
static String	DATA_SERVICE_FOLDER

Method Summary

Modifier and Type	Method and Description
void	beginTran() Starts sql transaction for default database connection on the current thread.
void	commitTran() Commits any outstanding transaction on the current thread.
ISqlWorker	createSafeWorker(String datasourceName) Get worker object to perform some database work.
ISqlWorker	createWorker() Get worker object to perform some database work for the default portal datasource.
ISqlWorker	createWorker(String datasourceName) Get worker object to perform some database work
void	executeSqlScriptFile(String fileName)
void	executeSqlScriptFile(String fileName, PrintStream terminalWriter, PrintStream spoolWriter, boolean ignoreErrors, Map<String,String> args)
void	executeSqlScriptString(String script, String datasource) Execute Sql script file against default DSN
void	executeSqlScriptString(String script, String datasource, boolean ignoreErrors, Map<String,String> args) Execute Sql script file against default DSN
Connection	getConnection() Returns connection to a default database
Connection	getConnection(String datasource) Returns connection to a specific datasource
IDatabaseRuntime	getDatabaseRuntime() Returns current database runtime which is setup for active portal database connection
int	getDefaultServerType() Returns name of the default database server type: mssql, oracle, mysql
void	release() Release all connection resources
void	releaseConnection(Connection conn) Releases connection back to the pool
void	rollbackTran() Rollsback any outstanding transaction on the current thread.

Field Detail

DATA_SERVICE

static final String DATA_SERVICE

See Also:

Constant Field Values

DATA_SERVICE_FOLDER

static final String DATA_SERVICE_FOLDER

See Also:

Constant Field Values

DATA_SERVICE_ALIAS_PREFIX

static final String DATA_SERVICE_ALIAS_PREFIX

See Also:

Constant Field Values

Method Detail

getDefaultServerType

int getDefaultServerType()

Returns name of the default database server type: mssql, oracle, mysql

Returns:

ISqlWorker.SERVERTYPE_ORACLE for oracle or ISqlWorker.SERVERTYPE_MSSQL otherwise

createWorker

ISqlWorker createWorker()
                 throws SQLException

Get worker object to perform some database work for the default portal datasource.

Throws:

SQLException

createWorker

ISqlWorker createWorker(String datasourceName)
                 throws SQLException

Get worker object to perform some database work

Parameters:

datasourceName - name of the datasource to create a worker for

Throws:

SQLException

createSafeWorker

ISqlWorker createSafeWorker(String datasourceName)
                     throws SQLException

Get worker object to perform some database work. If configuration doesn't have a datasource with the given name, then the default datasource is used

Parameters:

datasourceName - name of the datasource to use

Throws:

SQLException

beginTran

void beginTran()
        throws SQLException

Starts sql transaction for default database connection on the current thread. See corresponding ISqlWorker.beginTran() method.

Throws:

SQLException

commitTran

void commitTran()
         throws SQLException

Commits any outstanding transaction on the current thread. See corresponding ISqlWorker.commitTran() method

Throws:

SQLException

rollbackTran

void rollbackTran()
           throws SQLException

Rollsback any outstanding transaction on the current thread. See corresponding ISqlWorker.rollbackTran() method

Throws:

SQLException

getDatabaseRuntime

IDatabaseRuntime getDatabaseRuntime()

Returns current database runtime which is setup for active portal database connection

getConnection

Connection getConnection()

Returns connection to a default database

getConnection

Connection getConnection(String datasource)

Returns connection to a specific datasource

Parameters:

datasource - name of the datasource

release

void release()

Release all connection resources

releaseConnection

void releaseConnection(Connection conn)

Releases connection back to the pool

executeSqlScriptFile

void executeSqlScriptFile(String fileName)
                   throws SQLException,
                          ServerBusyException,
                          DeadlockException

Throws:

SQLException

ServerBusyException

DeadlockException

executeSqlScriptFile

void executeSqlScriptFile(String fileName,
                          PrintStream terminalWriter,
                          PrintStream spoolWriter,
                          boolean ignoreErrors,
                          Map<String,String> args)
                   throws SQLException,
                          ServerBusyException,
                          DeadlockException

Throws:

SQLException

ServerBusyException

DeadlockException

executeSqlScriptString

void executeSqlScriptString(String script,
                            String datasource)
                     throws SQLException,
                            ServerBusyException,
                            DeadlockException

Execute Sql script file against default DSN

Throws:

SQLException

ServerBusyException

DeadlockException

executeSqlScriptString

void executeSqlScriptString(String script,
                            String datasource,
                            boolean ignoreErrors,
                            Map<String,String> args)
                     throws SQLException,
                            ServerBusyException,
                            DeadlockException

Execute Sql script file against default DSN

Throws:

SQLException

ServerBusyException

DeadlockException