com.webmethods.portal.service.sql

Class DataManager

java.lang.Object

com.webmethods.portal.service.sql.DataManager

Deprecated.

left for backward compatibility. Use the OSGi service registered for the IDataManager interface

@Deprecated
public class DataManager
extends Object

DataManager works as a factory class to create SqlWorker instances.

Here is an example of opening a connection to a sql datasource:

 String dataSource = "dataSourceName";
 ISqlWorker worker = null;
 try {
        // get the connection information for the datasource
        ConnectionInfo conninfo = ConnectionManager.getConnInfo(dataSource);

        // get a worker instance from the data manager
        worker = DataManager.createWorker(dataSource);

        // TODO use one of the execute methods from the worker to
        // perform the query or update

 } catch (SQLException e) {
        // log and report the exception
        Debug.fatal(e, m_logCategory);
        throw new PortalException(e);
 } finally {
        if (worker != null) {
                // release the worker so the sql resources can be reclaimed
                worker.release();
        }
 }
 

See Also:

ISqlWorker, ConnectionManager

Field Summary

Fields

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

Constructor Summary

Constructors

Constructor and Description
DataManager() Deprecated.

Method Summary

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

Methods inherited from class java.lang.Object

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

Field Detail

DATA_SERVICE

public static final String DATA_SERVICE

Deprecated.

See Also:

Constant Field Values

DATA_SERVICE_FOLDER

public static final String DATA_SERVICE_FOLDER

Deprecated.

See Also:

Constant Field Values

DATA_SERVICE_ALIAS_PREFIX

public static final String DATA_SERVICE_ALIAS_PREFIX

Deprecated.

See Also:

Constant Field Values

Constructor Detail

DataManager

public DataManager()

Deprecated.

Method Detail

getDefaultServerType

public static int getDefaultServerType()

Deprecated.

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

Returns:

ISqlWorker.SERVERTYPE_ORACLE for oracle or ISqlWorker.SERVERTYPE_MSSQL otherwise

createWorker

public static ISqlWorker createWorker()
                               throws SQLException

Deprecated.

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

Throws:

SQLException

beginTran

public static void beginTran()
                      throws SQLException

Deprecated.

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

Throws:

SQLException

commitTran

public static void commitTran()
                       throws SQLException

Deprecated.

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

Throws:

SQLException

rollbackTran

public static void rollbackTran()
                         throws SQLException

Deprecated.

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

Throws:

SQLException

createWorker

public static ISqlWorker createWorker(String datasourceName)
                               throws SQLException

Deprecated.

Get worker object to perform some database work

Parameters:

datasourceName - name of the datasource to create a worker for

Throws:

SQLException

createSafeWorker

public static ISqlWorker createSafeWorker(String datasourceName)
                                   throws SQLException

Deprecated.

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

getDatabaseRuntime

public static IDatabaseRuntime getDatabaseRuntime()

Deprecated.

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

getConnection

public static Connection getConnection()

Deprecated.

Returns connection to a default database

getConnection

public static Connection getConnection(String datasource)

Deprecated.

Returns connection to a specific datasource

Parameters:

datasource - name of the datasource

release

public static void release()

Deprecated.

Release all connection resources

releaseConnection

public static void releaseConnection(Connection conn)

Deprecated.

Releases connection back to the pool

executeSqlScriptFile

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

Deprecated.

Throws:

SQLException

ServerBusyException

DeadlockException

executeSqlScriptFile

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

Deprecated.

Throws:

SQLException

ServerBusyException

DeadlockException

executeSqlScriptString

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

Deprecated.

Execute Sql script file against default DSN

Throws:

SQLException

ServerBusyException

DeadlockException

executeSqlScriptString

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

Deprecated.

Execute Sql script file against default DSN

Throws:

SQLException

ServerBusyException

DeadlockException