ca.sqlpower.architect.etl
Class PLUtils

java.lang.Object
  ca.sqlpower.architect.etl.PLUtils

public class PLUtils
extends java.lang.Object

PLUtils is a collection of utility methods for interfacing with the Power*Loader.

Field Summary

static java.lang.String	CONNECTION_TYPE_ACCESS
static java.lang.String	CONNECTION_TYPE_DB2
static java.lang.String	CONNECTION_TYPE_ORACLE
static java.lang.String	CONNECTION_TYPE_POSTGRES
static java.lang.String	CONNECTION_TYPE_SQLSERVER
static int	MAX_PLID_LENGTH Maximum length (in characters) of a PL identifier (transaction name, job name, etc).

Method Summary

static java.lang.String	getEngineConnectString(ca.sqlpower.sql.SPDataSource dataSource) Returns the correct argument for USER= when running the PL engine.
static java.lang.String	getEngineExecutableName(ca.sqlpower.sql.SPDataSource dataSource)
static boolean	plDotIniHasChanged(java.lang.String plDotIniPath)
static java.lang.String	toPLIdentifier(java.lang.String text) Mangles the given string into a valid PL identifier (no spaces, at most 80 characters long, all uppercase).

Methods inherited from class java.lang.Object

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

Field Detail

CONNECTION_TYPE_ORACLE

public static final java.lang.String CONNECTION_TYPE_ORACLE

See Also:

Constant Field Values

CONNECTION_TYPE_SQLSERVER

public static final java.lang.String CONNECTION_TYPE_SQLSERVER

See Also:

Constant Field Values

CONNECTION_TYPE_POSTGRES

public static final java.lang.String CONNECTION_TYPE_POSTGRES

See Also:

Constant Field Values

CONNECTION_TYPE_ACCESS

public static final java.lang.String CONNECTION_TYPE_ACCESS

See Also:

Constant Field Values

CONNECTION_TYPE_DB2

public static final java.lang.String CONNECTION_TYPE_DB2

See Also:

Constant Field Values

MAX_PLID_LENGTH

public static final int MAX_PLID_LENGTH

Maximum length (in characters) of a PL identifier (transaction name, job name, etc).

See Also:

Constant Field Values

Method Detail

toPLIdentifier

public static java.lang.String toPLIdentifier(java.lang.String text)

Mangles the given string into a valid PL identifier (no spaces, at most 80 characters long, all uppercase).

plDotIniHasChanged

public static boolean plDotIniHasChanged(java.lang.String plDotIniPath)

getEngineExecutableName

public static java.lang.String getEngineExecutableName(ca.sqlpower.sql.SPDataSource dataSource)
                                                throws UnknownDatabaseTypeException

Throws:

UnknownDatabaseTypeException

getEngineConnectString

public static java.lang.String getEngineConnectString(ca.sqlpower.sql.SPDataSource dataSource)
                                               throws UnknownDatabaseTypeException

Returns the correct argument for USER= when running the PL engine. Use the same rules as engine executable name to decide what kind of connection string to return.

Throws:

UnknownDatabaseTypeException