SQLImporter (ATG Java API)

java.lang.Object
- atg.nucleus.logging.VariableArgumentApplicationLoggingImpl
- - atg.nucleus.GenericService
  - - atg.adapter.gsa.sqlimport.SQLImporter

All Implemented Interfaces:

atg.adapter.gsa.sqlimport.ImportLogger, atg.core.logging.Logging, atg.core.logging.TraceLogging, atg.naming.AbsoluteNameable, NameContextBindingListener, NameContextElement, atg.naming.NameContextParentable, NameResolver, AdminableService, atg.nucleus.Configured, ApplicationLogging, atg.nucleus.logging.ApplicationLoggingSender, atg.nucleus.logging.TraceApplicationLogging, VariableArgumentApplicationLogging, ComponentNameResolver, Service, ServiceListener, java.util.EventListener
```
public final class SQLImporter
extends GenericService
implements atg.adapter.gsa.sqlimport.ImportLogger
```
Tool for import of repository data. The repository SQL importer is similar to the startSQLRepository import in functionality, only it uses direct SQL calls to do the import and is much faster and scales much better for large imports.

Field Summary

Fields
Modifier and Type Field and Description

static java.lang.String CLASS_VERSION
Class version string
- Fields inherited from class atg.nucleus.GenericService
  SERVICE_INFO_KEY
- Fields inherited from interface atg.nucleus.logging.TraceApplicationLogging
  DEFAULT_LOG_TRACE_STATUS
- Fields inherited from interface atg.nucleus.logging.ApplicationLogging
  DEFAULT_LOG_DEBUG_STATUS, DEFAULT_LOG_ERROR_STATUS, DEFAULT_LOG_INFO_STATUS, DEFAULT_LOG_WARNING_STATUS

Fields
Modifier and Type	Field and Description
`static java.lang.String`	`CLASS_VERSION` Class version string

Constructor Summary

Constructors
Constructor and Description

SQLImporter()
Empty constructor

Constructors
Constructor and Description
`SQLImporter()` Empty constructor

Method Summary

All Methods Static Methods Instance Methods Concrete Methods
Modifier and Type	Method and Description
`void`	`addImportListener(ImportListener pListener)` Allows for a component which implements the ImportListener interface to be notified as various events occur.
`void`	`dbg(java.lang.Object pMsg, int pLevel)`
`boolean`	`execute()` Perform the data export or import.
`void`	`flushRepositoryCaches()` Flush the caches of all the affected repositories.
`java.lang.String`	`getActivityId()` Get property `activityId`.
`java.lang.String`	`getBranchName()` Get property `branchName`.
`boolean`	`getBuildDBStats()` Get property `BuildDBStats`.
`java.lang.String`	`getCheckinComment()` Get property `checkinComment`.
`boolean`	`getCheckinFlag()` Get property `checkinFlag`.
`ClientLockManager`	`getClientLockManager()` Get property `clientLockManager`.
`java.lang.String`	`getClientLockManagerName()` Get property `clientLockManagerName`.
`java.lang.String`	`getConfigPath()` Get property `configPath`.
`DataFeeder`	`getDataFeeder()`
`java.io.File`	`getDataFile()` Get property `dataFile`.
`java.lang.String`	`getDataFileName()` Get property `dataFileName`.
`int`	`getDebugLevel()` Get property `debugLevel`.
`boolean`	`getDeleteAllFlag()` Get property `deleteAllFlag`.
`boolean`	`getFlushRepositoryCachesFlag()` Get property `flushRepositoryCachesFlag`.
`java.lang.String`	`getImportListenerNamesString()` Set property `username`.
`ImportListener[]`	`getImportListeners()`
`int`	`getImportSQLQueueSize()` Get property `ImportSQLQueueSize`.
`int`	`getInfoLevel()` Get property `infoLevel`.
`java.lang.String`	`getInitialServiceName()` Get property `InitialServiceName`.
`protected java.io.InputStream`	`getInputStream()`
`int`	`getMaxAddUpdateThreadCount()` the maximum number of threads to use for add/update/remove operations.
`int`	`getMaxBidirectionalPropertyUpdateThreadCount()` the maximum number of threads to use for add/update/remove operations.
`int`	`getMaxCheckoutThreadCount()` the maximum number of threads to use for batch checkout operations.
`atg.adapter.gsa.sqlimport.ParserFactory`	`getParserFactory()` Get property `ParserFactory`.
`java.lang.String`	`getProcessName()` Get property `processName`.
`Repository`	`getRepository()` Get property `repositories`.
`java.lang.String`	`getRepositoryName()` get property `repositoryName`.
`atg.repository.nucleus.RepositoryRegistryService`	`getRepositoryRegistry()` Get property `repositoryRegistry`.
`java.lang.String`	`getRepositoryRegistryName()` Get property `repositoryRegistryName`.
`boolean`	`getReserveIdsFlag()` Get property `reserveIdsFlag`.
`boolean`	`getShowTimeFlag()` Get property `showTimeFlag`.
`boolean`	`getStandalone()` Get property `standalone`.
`int`	`getTransactionBatchSize()` Get property `transactionBatchSize`.
`javax.transaction.TransactionManager`	`getTransactionManager()` Get property `transactionManager`.
`java.lang.String`	`getTransactionManagerName()` Get property `transactionManagerName`.
`java.lang.String`	`getUsername()` Get property `username`.
`VersionManager`	`getVersionManager()` Get property `versionManager`.
`java.lang.String`	`getVersionManagerName()` Get property `versionManagerName`.
`java.lang.String`	`getWorkflowName()` Get property `workflowName`.
`java.lang.String`	`getWorkingDirectoryName()` Get property `workingDirectoryName`.
`java.lang.String`	`getWorkspaceName()` Get property `workspaceName`.
`void`	`info(java.lang.Object pMsg, int pLevel)`
`void`	`initialize()` Prepare for export or import.
`static void`	`main(java.lang.String[] argv)` Main entry point for use as command line tool.
`void`	`parseArguments(java.lang.String[] pArgs)` Parse the specified command line arguments.
`void`	`removeImportListener(ImportListener pListener)` Removes a ImportListener from the deployment listener notification collection
`void`	`reportPercentComplete()`
`void`	`setActivityId(java.lang.String pActivityId)` Set property `activityId`.
`void`	`setBranchName(java.lang.String pBranchName)` Set property `branchName`.
`void`	`setBuildDBStats(boolean pBuildDBStats)` Set property `BuildDBStats`.
`void`	`setCheckinComment(java.lang.String pCheckinComment)` Set property `checkinComment`.
`void`	`setCheckinFlag(boolean pCheckinFlag)` Set property `checkinFlag`.
`void`	`setClientLockManager(ClientLockManager pClientLockManager)` Set property `clientLockManager`.
`void`	`setClientLockManagerName(java.lang.String pClientLockManagerName)` Set property `clientLockManagerName`.
`void`	`setConfigPath(java.lang.String pConfigPath)` Set property `configPath`.
`void`	`setDataFeeder(DataFeeder pDataFeeder)`
`void`	`setDataFile(java.io.File pDataFile)` Set property `dataFile`.
`void`	`setDataFileName(java.lang.String pDataFileName)` Set property `dataFileName`.
`void`	`setDebugLevel(int pDebugLevel)` Set property `debugLevel`.
`void`	`setDeleteAllFlag(boolean pDeleteAllFlag)` Set property `deleteAllFlag`.
`void`	`setFlushRepositoryCachesFlag(boolean pFlushRepositoryCachesFlag)` Set property `flushRepositoryCachesFlag`.
`void`	`setImportListenerNamesString(java.lang.String pImportListenerNamesString)` Set property `username`.
`void`	`setImportListeners(ImportListener[] pImportListeners)`
`void`	`setImportSQLQueueSize(int pImportSQLQueueSize)` Set property `ImportSQLQueueSize`.
`void`	`setInfoLevel(int pInfoLevel)` Set property `infoLevel`.
`void`	`setInitialServiceName(java.lang.String pInitialServiceName)` Set property `InitialServiceName`.
`void`	`setMaxAddUpdateThreadCount(int pMaxAddUpdateThreadCount)` the maximum number of threads to use for add/update/remove operations.
`void`	`setMaxBidirectionalPropertyUpdateThreadCount(int pMaxBidirectionalPropertyUpdateThreadCount)` the maximum number of threads to use for add/update/remove operations.
`void`	`setMaxCheckoutThreadCount(int pMaxCheckoutThreadCount)` the maximum number of threads to use for batch checkout operations.
`void`	`setParserFactory(atg.adapter.gsa.sqlimport.ParserFactory pParserFactory)` Set property `ParserFactory`.
`void`	`setProcessName(java.lang.String pProcessName)` Set property `processName`.
`void`	`setRepository(Repository pRepository)` Set property `repositories`.
`void`	`setRepositoryName(java.lang.String pRepositoryName)` Set property `repositoryName`.
`void`	`setRepositoryRegistry(atg.repository.nucleus.RepositoryRegistryService pRepositoryRegistry)` Set property `repositoryRegistry`.
`void`	`setRepositoryRegistryName(java.lang.String pRepositoryRegistryName)` Set property `repositoryRegistryName`.
`void`	`setReserveIdsFlag(boolean pReserveIdsFlag)` Set property `reserveIdsFlag`.
`void`	`setShowTimeFlag(boolean pShowTimeFlag)` Set property `showTimeFlag`.
`void`	`setTransactionBatchSize(int pTransactionBatchSize)` Set property `transactionBatchSize`.
`void`	`setTransactionManager(javax.transaction.TransactionManager pTransactionManager)` Set property `transactionManager`.
`void`	`setTransactionManagerName(java.lang.String pTransactionManagerName)` Set property `transactionManagerName`.
`void`	`setUsername(java.lang.String pUsername)` Set property `username`.
`void`	`setVersionManager(VersionManager pVersionManager)` Set property `versionManager`.
`void`	`setVersionManagerName(java.lang.String pVersionManagerName)` Set property `versionManagerName`.
`void`	`setWorkflowName(java.lang.String pWorkflowName)` Set property `workflowName`.
`void`	`setWorkingDirectoryName(java.lang.String pWorkingDirectoryName)` Set property `workingDirectoryName`.
`void`	`setWorkspaceName(java.lang.String pWorkspaceName)` Set property `workspaceName`.
`void`	`startNucleus()` Start a Nucleus, for use in standalone operation.
`java.lang.String`	`toString()` Get a string representation of this object.
`void`	`warn(java.lang.Object pMsg)`

Methods inherited from class atg.nucleus.GenericService
addLogListener, createAdminServlet, doStartService, doStopService, getAbsoluteName, getAdminServlet, getAdminServletOutputStreamEncoding, getLoggingForVlogging, getLogListenerCount, getLogListeners, getName, getNameContext, getNucleus, getRoot, getServiceConfiguration, getServiceInfo, isAdminServletUseServletOutputStream, isLoggingDebug, isLoggingError, isLoggingInfo, isLoggingTrace, isLoggingWarning, isRunning, logDebug, logDebug, logDebug, logError, logError, logError, logInfo, logInfo, logInfo, logTrace, logTrace, logTrace, logWarning, logWarning, logWarning, nameContextElementBound, nameContextElementUnbound, removeLogListener, reResolveThis, resolveName, resolveName, resolveName, resolveName, sendLogEvent, setAdminServletOutputStreamEncoding, setAdminServletUseServletOutputStream, setLoggingDebug, setLoggingError, setLoggingInfo, setLoggingTrace, setLoggingWarning, setNucleus, setServiceInfo, startService, stopService

Methods inherited from class atg.nucleus.logging.VariableArgumentApplicationLoggingImpl
vlogDebug, vlogDebug, vlogDebug, vlogDebug, vlogDebugTrace, vlogError, vlogError, vlogError, vlogError, vlogInfo, vlogInfo, vlogInfo, vlogInfo, vlogTrace, vlogTrace, vlogTrace, vlogTrace, vlogWarning, vlogWarning, vlogWarning, vlogWarning

Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

- Field Detail
  - CLASS_VERSION
```
public static java.lang.String CLASS_VERSION
```
    Class version string
- Constructor Detail
  - SQLImporter
```
public SQLImporter()
```
    Empty constructor
- Method Detail
  - getStandalone
```
public boolean getStandalone()
```
    Get property standalone. This is a flag which, if true indicates that the data loader is running standalone.
    
    Returns:
    
    standalone
  - setDebugLevel
```
public void setDebugLevel(int pDebugLevel)
```
    Set property debugLevel. This is the level of detail to provide when printing debug messages.
    
    Parameters:
    
    pDebugLevel - new value to set
  - getDebugLevel
```
public int getDebugLevel()
```
    Get property debugLevel. This is the level of detail to provide when printing debug messages.
    
    Returns:
    
    debugLevel
  - setShowTimeFlag
```
public void setShowTimeFlag(boolean pShowTimeFlag)
```
    Set property showTimeFlag. This is a flag which, if true, means that the current time in millis should be included in each info and dbg message. The default is false.
    
    Parameters:
    
    pShowTimeFlag - new value to set
  - getShowTimeFlag
```
public boolean getShowTimeFlag()
```
    Get property showTimeFlag. This is a flag which, if true, means that the current time in millis should be included in each info and dbg message. The default is false.
    
    Returns:
    
    showTimeFlag
  - setInfoLevel
```
public void setInfoLevel(int pInfoLevel)
```
    Set property infoLevel. This is the level of detail to use for info messages. The default is 1.
    
    Parameters:
    
    pInfoLevel - new value to set
  - getInfoLevel
```
public int getInfoLevel()
```
    Get property infoLevel. This is the level of detail to use for info messages. The default is 1.
    
    Returns:
    
    infoLevel
  - setDataFileName
```
public void setDataFileName(java.lang.String pDataFileName)
```
    Set property dataFileName. This is the name of the data file to use.
    
    Parameters:
    
    pDataFileName - new value to set, must not be null
  - getDataFileName
```
public java.lang.String getDataFileName()
```
    Get property dataFileName. This is the name of the data file to use.
    
    Returns:
    
    dataFileName
  - setDataFile
```
public void setDataFile(java.io.File pDataFile)
```
    Set property dataFile. This is the data file to use. If not explicitly set the dataFileName and workingDirectoryName properties are used to get the data file.
    
    Parameters:
    
    pDataFile - new value to set
  - getDataFile
```
public java.io.File getDataFile()
```
    Get property dataFile. This is the data file to use. If not explicitly set the dataFileName and workingDirectoryName properties are used to get the data file.
    
    Returns:
    
    dataFile, never null
  - setWorkingDirectoryName
```
public void setWorkingDirectoryName(java.lang.String pWorkingDirectoryName)
```
    Set property workingDirectoryName. This is the name of the working directory to use. The data file name is resolved relative to the working directory. The default is null.
    
    Parameters:
    
    pWorkingDirectoryName - new value to set
  - getWorkingDirectoryName
```
public java.lang.String getWorkingDirectoryName()
```
    Get property workingDirectoryName. This is the name of the working directory to use. The data file name is resolved relative to the working directory. The default is null.
    
    Returns:
    
    workingDirectoryName
  - setConfigPath
```
public void setConfigPath(java.lang.String pConfigPath)
```
    Set property configPath. This is the configpath to pass to Nucleus.
    
    Parameters:
    
    pConfigPath - new value to set
  - getConfigPath
```
public java.lang.String getConfigPath()
```
    Get property configPath. This is the configpath to pass to Nucleus.
    
    Returns:
    
    configPath
  - setInitialServiceName
```
public void setInitialServiceName(java.lang.String pInitialServiceName)
```
    Set property InitialServiceName. This is the name of the initial service to use. The default is "/atg/epub/InitialService".
    
    Parameters:
    
    pInitialServiceName - new value to set
  - getInitialServiceName
```
public java.lang.String getInitialServiceName()
```
    Get property InitialServiceName. This is the name of the initial service to use. The default is "/atg/epub/InitialService".
    
    Returns:
    
    InitialServiceName
  - setTransactionManagerName
```
public void setTransactionManagerName(java.lang.String pTransactionManagerName)
```
    Set property transactionManagerName. This is the name of the transaction manager to use for import. The default is "/atg/dynamo/transaction/TransactionManager".
    
    Parameters:
    
    pTransactionManagerName - new value to set
  - getTransactionManagerName
```
public java.lang.String getTransactionManagerName()
```
    Get property transactionManagerName. This is the name of the transaction manager to use for import. The default is "/atg/dynamo/transaction/TransactionManager".
    
    Returns:
    
    transactionManagerName
  - setTransactionManager
```
public void setTransactionManager(javax.transaction.TransactionManager pTransactionManager)
```
    Set property transactionManager. This is the transaction manager to use for import.
    
    Parameters:
    
    pTransactionManager - new value to set
  - getTransactionManager
```
public javax.transaction.TransactionManager getTransactionManager()
```
    Get property transactionManager. This is the transaction manager to use for import.
    
    Returns:
    
    transactionManager
  - setClientLockManagerName
```
public void setClientLockManagerName(java.lang.String pClientLockManagerName)
```
    Set property clientLockManagerName. This is the name of the lock manager. The default is "/atg/dynamo/service/ClientLockManager".
    
    Parameters:
    
    pClientLockManagerName - new value to set
  - getClientLockManagerName
```
public java.lang.String getClientLockManagerName()
```
    Get property clientLockManagerName. This is the name of the transaction manager to use. The default is "/atg/dynamo/service/ClientLockManager".
    
    Returns:
    
    clientLockManagerName
  - setClientLockManager
```
public void setClientLockManager(ClientLockManager pClientLockManager)
```
    Set property clientLockManager. This is the transaction manager to use for import.
    
    Parameters:
    
    pClientLockManager - new value to set
  - getClientLockManager
```
public ClientLockManager getClientLockManager()
```
    Get property clientLockManager. This is the transaction manager to use for import.
    
    Returns:
    
    clientLockManager
  - getImportListeners
```
public ImportListener[] getImportListeners()
```
    Returns:
    
    Returns the value of the ImportListeners property.
  - setImportListeners
```
public void setImportListeners(ImportListener[] pImportListeners)
```
    Parameters:
    
    pImportListeners - Sets the value of the ImportListeners property.
  - addImportListener
```
public void addImportListener(ImportListener pListener)
```
    Allows for a component which implements the ImportListener interface to be notified as various events occur.
    
    Parameters:
    
    pListener - a ImportListener to notify
  - removeImportListener
```
public void removeImportListener(ImportListener pListener)
```
    Removes a ImportListener from the deployment listener notification collection
    
    Parameters:
    
    pListener - the ImportListener to remove
  - setMaxCheckoutThreadCount
```
public void setMaxCheckoutThreadCount(int pMaxCheckoutThreadCount)
```
    the maximum number of threads to use for batch checkout operations. A value of 1 means perform all operations in a single thread. The default is 10.
    
    Parameters:
    
    pMaxCheckoutThreadCount - new value to set
  - getMaxCheckoutThreadCount
```
public int getMaxCheckoutThreadCount()
```
    the maximum number of threads to use for batch checkout operations. A value of 1 means perform all operations in a single thread. The default is 10.
    
    Returns:
    
    MaxCheckoutThreadCount
  - setMaxAddUpdateThreadCount
```
public void setMaxAddUpdateThreadCount(int pMaxAddUpdateThreadCount)
```
    the maximum number of threads to use for add/update/remove operations. A value of 1 means perform all operations in a single thread. The default is 10.
    
    Parameters:
    
    pMaxAddUpdateThreadCount - new value to set
  - getMaxAddUpdateThreadCount
```
public int getMaxAddUpdateThreadCount()
```
    the maximum number of threads to use for add/update/remove operations. A value of 1 means perform all operations in a single thread. The default is 10.
    
    Returns:
    
    mMaxAddUpdateThreadCount
  - setMaxBidirectionalPropertyUpdateThreadCount
```
public void setMaxBidirectionalPropertyUpdateThreadCount(int pMaxBidirectionalPropertyUpdateThreadCount)
```
    the maximum number of threads to use for add/update/remove operations. A value of 1 means perform all operations in a single thread. The default is 10.
    
    Parameters:
    
    pMaxBidirectionalPropertyUpdateThreadCount - new value to set
  - getMaxBidirectionalPropertyUpdateThreadCount
```
public int getMaxBidirectionalPropertyUpdateThreadCount()
```
    the maximum number of threads to use for add/update/remove operations. A value of 1 means perform all operations in a single thread. The default is 1.
    
    Returns:
    
    mMaxBidirectionalPropertyUpdateThreadCount
  - setTransactionBatchSize
```
public void setTransactionBatchSize(int pTransactionBatchSize)
```
    Set property transactionBatchSize. This is the maximum number of repository items to import in a single transaction. A value of 0 means perform all operations in a single transaction. The default is 1000.
    
    Parameters:
    
    pTransactionBatchSize - new value to set
  - getTransactionBatchSize
```
public int getTransactionBatchSize()
```
    Get property transactionBatchSize. This is the maximum number of repository items to export or import in a single transaction. A value of 0 means perform all operations in a single transaction. The default is 1000.
    
    Returns:
    
    transactionBatchSize
  - setImportSQLQueueSize
```
public void setImportSQLQueueSize(int pImportSQLQueueSize)
```
    Set property ImportSQLQueueSize. This class creates multiple threads to do import related work like checkouts, inserts, updates etc. These threads read their "work units" from a queue of these "work units". importSQLQueueSize determines the maximum number of "import units" this queue will have. If the queue is small it will slow down imports due to threads waiting to read from the queue and if it's too large it will require more memory.
    
    Parameters:
    
    pImportSQLQueueSize - new value to set
  - getImportSQLQueueSize
```
public int getImportSQLQueueSize()
```
    Get property ImportSQLQueueSize. This class creates multiple threads to do import related work like checkouts, inserts, updates etc. These threads read their "work units" from a queue of these "work units". importSQLQueueSize determines the maximum number of "import units" this queue will have. If the queue is small it will slow down imports due to threads waiting to read from the queue and if it's too large it will require more memory. read from the queue and if it's too large it will require more memory.
    
    Returns:
    
    ImportSQLQueueSize
  - setDeleteAllFlag
```
public void setDeleteAllFlag(boolean pDeleteAllFlag)
```
    Set property deleteAllFlag. This is a flag which, if true means that all items should be deleted in each affected repository before importing data. The items are only deleted for GSARepositories. The default is true.
    
    Parameters:
    
    pDeleteAllFlag - new value to set
  - getDeleteAllFlag
```
public boolean getDeleteAllFlag()
```
    Get property deleteAllFlag. This is a flag which, if true means that all items should be deleted in each affected repository before importing data. The items are only deleted for GSARepositories. The default is false.
    
    Returns:
    
    deleteAllFlag
  - setFlushRepositoryCachesFlag
```
public void setFlushRepositoryCachesFlag(boolean pFlushRepositoryCachesFlag)
```
    Set property flushRepositoryCachesFlag. This is a flag which, if true indicates that repository caches should be flushed when batches are committed. The default is false
    
    Parameters:
    
    pFlushRepositoryCachesFlag - new value to set
  - getFlushRepositoryCachesFlag
```
public boolean getFlushRepositoryCachesFlag()
```
    Get property flushRepositoryCachesFlag. This is a flag which, if true indicates that repository caches should be flushed when batches are committed. The default is false
    
    Returns:
    
    flushRepositoryCachesFlag
  - setWorkspaceName
```
public void setWorkspaceName(java.lang.String pWorkspaceName)
```
    Set property workspaceName. This is the name of the workspace to use for import. The workspace will be created if it does not already exist. A value of null means do the import without the version manager. The default is "import".
    
    Parameters:
    
    pWorkspaceName - new value to set
  - getWorkspaceName
```
public java.lang.String getWorkspaceName()
```
    Get property workspaceName. This is the name of the workspace to use for import. The workspace will be created if it does not already exist. A value of null means do the import without the version manager. The default is "import".
    
    Returns:
    
    workspaceName
  - setProcessName
```
public void setProcessName(java.lang.String pProcessName)
```
    Set property processName. This is the name of a process to use for import. A value of null means do the import without creating a process. The default is null.
    
    Parameters:
    
    pProcessName - new value to set
  - getProcessName
```
public java.lang.String getProcessName()
```
    Get property processName. This is the name of a process to use for import. A value of null means do the import without creating a process. The default is null.
    
    Returns:
    
    processName
  - setWorkflowName
```
public void setWorkflowName(java.lang.String pWorkflowName)
```
    Set property workflowName. This is the name of a workflow to use for import. A value of null means do the import with the default project type. The default is "/Common/commonWorkflow.wdl".
    
    Parameters:
    
    pWorkflowName - new value to set
  - getWorkflowName
```
public java.lang.String getWorkflowName()
```
    Get property workflowName. This is the name of a workflow to use for import. A value of null means do the import with the default workflow. The default is "/Common/commonWorkflow.wdl".
    
    Returns:
    
    workflowName
  - setActivityId
```
public void setActivityId(java.lang.String pActivityId)
```
    Set property activityId. This is the ID of an activity to associate with a project created by the loader for import. The default value is null.
    
    Parameters:
    
    pActivityId - The activity ID.
  - getActivityId
```
public java.lang.String getActivityId()
```
    Get property activityId. This is the ID of an activity to associate with a project created by the loader for import. The default value is null.
    
    Returns:
    
    The activity ID.
  - setBranchName
```
public void setBranchName(java.lang.String pBranchName)
```
    Set property branchName. This is the name of branch to use if creating a new workspace. The default is "main".
    
    Parameters:
    
    pBranchName - new value to set
  - getBranchName
```
public java.lang.String getBranchName()
```
    Get property branchName. This is the name of branch to use if creating a new workspace. The default is "main".
    
    Returns:
    
    branchName
  - setBuildDBStats
```
public void setBuildDBStats(boolean pBuildDBStats)
```
    Set property BuildDBStats. This is a flag which, if true, indicates that database statistics should be build before and after imports. The default is true.
    
    Parameters:
    
    pBuildDBStats - new value to set
  - getBuildDBStats
```
public boolean getBuildDBStats()
```
    Get property BuildDBStats. This is a flag which, if true, indicates that database statistics should be build before and after imports. The default is true.
    
    Returns:
    
    BuildDBStats
  - setCheckinFlag
```
public void setCheckinFlag(boolean pCheckinFlag)
```
    Set property checkinFlag. This is a flag which, if true, indicates that a version manager checkin should be performed for imports. The default is true.
    
    Parameters:
    
    pCheckinFlag - new value to set
  - getCheckinFlag
```
public boolean getCheckinFlag()
```
    Get property checkinFlag. This is a flag which, if true, indicates that a version manager checkin should be performed for imports. The default is true.
    
    Returns:
    
    checkinFlag
  - setCheckinComment
```
public void setCheckinComment(java.lang.String pCheckinComment)
```
    Set property checkinComment. This is the checkin comment to use when importing data. The default is "import".
    
    Parameters:
    
    pCheckinComment - new value to set
  - getCheckinComment
```
public java.lang.String getCheckinComment()
```
    Get property checkinComment. This is the checkin comment to use when importing data. The default is "import".
    
    Returns:
    
    checkinComment
  - setUsername
```
public void setUsername(java.lang.String pUsername)
```
    Set property username. This is the username to use when importing data. The default is "admin".
    
    Parameters:
    
    pUsername - new value to set
  - getUsername
```
public java.lang.String getUsername()
```
    Get property username. This is the username to use when importing data. The default is "admin".
    
    Returns:
    
    username
  - setImportListenerNamesString
```
public void setImportListenerNamesString(java.lang.String pImportListenerNamesString)
```
    Set property username. Comma separated component path names for ImportListeners to call.
    
    Parameters:
    
    pImportListenerNamesString - new value to set
  - getImportListenerNamesString
```
public java.lang.String getImportListenerNamesString()
```
    Set property username. Comma separated component path names for ImportListeners to call.
    
    Returns:
    
    importListenerNamesString
  - setVersionManagerName
```
public void setVersionManagerName(java.lang.String pVersionManagerName)
```
    Set property versionManagerName. This is the name of the version manager to use for imports. The default is "/atg/epub/version/VersionManagerService".
    
    Parameters:
    
    pVersionManagerName - new value to set
  - getVersionManagerName
```
public java.lang.String getVersionManagerName()
```
    Get property versionManagerName. This is the name of the version manager to use for imports. The default is "/atg/epub/version/VersionManagerService".
    
    Returns:
    
    versionManagerName
  - setVersionManager
```
public void setVersionManager(VersionManager pVersionManager)
```
    Set property versionManager. This is the version manager to use for imports.
    
    Parameters:
    
    pVersionManager - new value to set
  - getVersionManager
```
public VersionManager getVersionManager()
```
    Get property versionManager. This is the version manager to use for imports.
    
    Returns:
    
    versionManager
  - setRepositoryName
```
public void setRepositoryName(java.lang.String pRepositoryName)
```
    Set property repositoryName. This is the name of the repository to be imported into if the XML does not have repository path specified.
    
    Parameters:
    
    pRepositoryName - new value to set
  - getRepositoryName
```
public java.lang.String getRepositoryName()
```
    get property repositoryName. This is the names of the repository to be imported into if the XML does not have repository path specified.
  - setRepository
```
public void setRepository(Repository pRepository)
```
    Set property repositories. This is the repository to be imported into.
    
    Parameters:
    
    pRepository - new value to set
  - getRepository
```
public Repository getRepository()
```
    Get property repositories. This is the repository to be imported into.
    
    Returns:
    
    the default repository
  - setRepositoryRegistryName
```
public void setRepositoryRegistryName(java.lang.String pRepositoryRegistryName)
```
    Set property repositoryRegistryName. This is the name of the registry service to use when exporting all repositories. The default is "/atg/registry/ContentRepositories".
    
    Parameters:
    
    pRepositoryRegistryName - new value to set
  - getRepositoryRegistryName
```
public java.lang.String getRepositoryRegistryName()
```
    Get property repositoryRegistryName. This is the name of the registry service to use when exporting all repositories. The default is "/atg/registry/ContentRepositories".
    
    Returns:
    
    repositoryRegistryName
  - setRepositoryRegistry
```
public void setRepositoryRegistry(atg.repository.nucleus.RepositoryRegistryService pRepositoryRegistry)
```
    Set property repositoryRegistry. This is the repository registry service to use when exporting all repositories.
    
    Parameters:
    
    pRepositoryRegistry - new value to set
  - getRepositoryRegistry
```
public atg.repository.nucleus.RepositoryRegistryService getRepositoryRegistry()
```
    Get property repositoryRegistry. This is the repository registry service to use when exporting all repositories.
    
    Returns:
    
    repositoryRegistry
  - setReserveIdsFlag
```
public void setReserveIdsFlag(boolean pReserveIdsFlag)
```
    Set property reserveIdsFlag. This is a flag which, if true indicates that the ids of imported repository items should be reserved with the appropriate id generator. The default is true.
    
    Parameters:
    
    pReserveIdsFlag - new value to set
  - getReserveIdsFlag
```
public boolean getReserveIdsFlag()
```
    Get property reserveIdsFlag. This is a flag which, if true indicates that the ids of imported repository items should be reserved with the appropriate id generator. The default is true.
    
    Returns:
    
    reserveIdsFlag
  - getDataFeeder
```
public DataFeeder getDataFeeder()
```
  - setDataFeeder
```
public void setDataFeeder(DataFeeder pDataFeeder)
```
  - setParserFactory
```
public void setParserFactory(atg.adapter.gsa.sqlimport.ParserFactory pParserFactory)
```
    Set property ParserFactory.
    
    Parameters:
    
    pParserFactory - new value to set
  - getParserFactory
```
public atg.adapter.gsa.sqlimport.ParserFactory getParserFactory()
```
    Get property ParserFactory.
    
    Returns:
    
    ParserFactory
  - main
```
public static void main(java.lang.String[] argv)
```
    Main entry point for use as command line tool.
  - execute
```
public boolean execute()
                throws atg.adapter.gsa.sqlimport.ImportException
```
    Perform the data export or import. export is not implemented yet but could be in the future.
    
    Returns:
    
    true if successful, else false
    
    Throws:
    
    ImportException - if there is a problem
  - initialize
```
public void initialize()
                throws atg.adapter.gsa.sqlimport.ImportException
```
    Prepare for export or import. This performs tasks such as resolving all component names. Nucleus must be running before this method is called. This method must be called before execute is called.
    
    Throws:
    
    ImportException - if there is deployment trouble
  - parseArguments
```
public void parseArguments(java.lang.String[] pArgs)
```
    Parse the specified command line arguments.
    
    Parameters:
    
    pArgs - arguments to parse
  - startNucleus
```
public void startNucleus()
```
    Start a Nucleus, for use in standalone operation.
  - getInputStream
```
protected java.io.InputStream getInputStream()
                                      throws java.io.FileNotFoundException
```
    Throws:
    
    java.io.FileNotFoundException
  - flushRepositoryCaches
```
public void flushRepositoryCaches()
```
    Flush the caches of all the affected repositories. Strictly speaking this should not be necessary, however in the current GSA implementation it has been shown to help for large tests. See PR69470.
  - reportPercentComplete
```
public void reportPercentComplete()
```
    Specified by:
    
    reportPercentComplete in interface atg.adapter.gsa.sqlimport.ImportLogger
  - info
```
public void info(java.lang.Object pMsg,
                 int pLevel)
```
    Specified by:
    
    info in interface atg.adapter.gsa.sqlimport.ImportLogger
  - warn
```
public void warn(java.lang.Object pMsg)
```
    Specified by:
    
    warn in interface atg.adapter.gsa.sqlimport.ImportLogger
  - dbg
```
public void dbg(java.lang.Object pMsg,
                int pLevel)
```
    Specified by:
    
    dbg in interface atg.adapter.gsa.sqlimport.ImportLogger
  - toString
```
public java.lang.String toString()
```
    Get a string representation of this object.
    
    Overrides:
    
    toString in class GenericService
    
    Returns:
    
    the string

Class SQLImporter

Field Summary

Fields inherited from class atg.nucleus.GenericService

Fields inherited from interface atg.nucleus.logging.TraceApplicationLogging

Fields inherited from interface atg.nucleus.logging.ApplicationLogging

Constructor Summary

Method Summary

Methods inherited from class atg.nucleus.GenericService

Methods inherited from class atg.nucleus.logging.VariableArgumentApplicationLoggingImpl

Methods inherited from class java.lang.Object

Field Detail

CLASS_VERSION

Constructor Detail

SQLImporter

Method Detail

getStandalone

setDebugLevel

getDebugLevel

setShowTimeFlag

getShowTimeFlag

setInfoLevel

getInfoLevel

setDataFileName

getDataFileName

setDataFile

getDataFile

setWorkingDirectoryName

getWorkingDirectoryName

setConfigPath

getConfigPath

setInitialServiceName

getInitialServiceName

setTransactionManagerName

getTransactionManagerName

setTransactionManager

getTransactionManager

setClientLockManagerName

getClientLockManagerName

setClientLockManager

getClientLockManager

getImportListeners

setImportListeners

addImportListener

removeImportListener

setMaxCheckoutThreadCount

getMaxCheckoutThreadCount

setMaxAddUpdateThreadCount

getMaxAddUpdateThreadCount

setMaxBidirectionalPropertyUpdateThreadCount

getMaxBidirectionalPropertyUpdateThreadCount

setTransactionBatchSize

getTransactionBatchSize

setImportSQLQueueSize

getImportSQLQueueSize

setDeleteAllFlag

getDeleteAllFlag

setFlushRepositoryCachesFlag

getFlushRepositoryCachesFlag

setWorkspaceName

getWorkspaceName

setProcessName

getProcessName

setWorkflowName

getWorkflowName

setActivityId

getActivityId

setBranchName

getBranchName

setBuildDBStats

getBuildDBStats

setCheckinFlag

getCheckinFlag

setCheckinComment

getCheckinComment

setUsername

getUsername

setImportListenerNamesString

getImportListenerNamesString

setVersionManagerName

getVersionManagerName