Oracle® Data Integrator Java API Reference
11g Release 1 (11.1.1.3.0)

E17060-01

oracle.odi.setup.support
Class WorkRepositorySetupImpl

java.lang.Object
  extended by oracle.odi.setup.support.WorkRepositorySetupImpl
All Implemented Interfaces:
IWorkRepositorySetup

public final class WorkRepositorySetupImpl
extends java.lang.Object
implements IWorkRepositorySetup

Default IWorkRepositorySetup implementation.


Field Summary
 
Fields inherited from interface oracle.odi.setup.IWorkRepositorySetup
WORK_REPOSITORY_MAX_ID, WORK_REPOSITORY_PASSWORD_MAX_LENGTH
 
Constructor Summary
WorkRepositorySetupImpl(OdiInstance pOdiInstance)
          Creates a new WorkRepositorySetupImpl for the given @link OdiInstance.
 
Method Summary
 void configureWorkDevRepository(java.lang.String pWorkUrl, java.lang.String pWorkDriver, java.lang.String pWorkUsername, java.lang.String pWorkPassword, int pWorkDevRepositoryId, java.lang.String pWorkRepositoryName, TechnologyName pWorkTechnology)
          Configure default content of a given ODI work runtime repository.
 void configureWorkRuntimeRepository(java.lang.String pWorkUrl, java.lang.String pWorkDriver, java.lang.String pWorkUsername, java.lang.String pWorkPassword, int pWorkRuntimeRepositoryId, java.lang.String pWorkRepositoryName, TechnologyName pWorkTechnology)
          Configure default content of a given ODI work runtime repository.
 boolean createWorkDevRepository(java.lang.String pWorkUrl, java.lang.String pWorkDriver, java.lang.String pWorkUsername, java.lang.String pWorkPassword, int pWorkDevRepositoryId, java.lang.String pWorkRepositoryName, java.lang.String pWorkRepositoryPassword, TechnologyName pWorkTechnology, boolean pOverwrite)
          Create an ODI Work development repository into the database specified by the given parameters.
 boolean createWorkDevRepository(java.lang.String pWorkUrl, java.lang.String pWorkDriver, java.lang.String pWorkUsername, java.lang.String pWorkPassword, int pWorkDevRepositoryId, java.lang.String pWorkRepositoryName, TechnologyName pWorkTechnology, boolean pOverwrite)
          Create an ODI Work development repository into the database specified by the given parameters.
 boolean createWorkRuntimeRepository(java.lang.String pWorkUrl, java.lang.String pWorkDriver, java.lang.String pWorkUsername, java.lang.String pWorkPassword, int pWorkRuntimeRepositoryId, java.lang.String pWorkRepositoryName, java.lang.String pWorkRepositoryPassword, TechnologyName pWorkTechnology, boolean pOverwrite)
          Create an ODI Work runtime repository into the database specified by the given parameters.
 boolean createWorkRuntimeRepository(java.lang.String pWorkUrl, java.lang.String pWorkDriver, java.lang.String pWorkUsername, java.lang.String pWorkPassword, int pWorkRuntimeRepositoryId, java.lang.String pWorkRepositoryName, TechnologyName pWorkTechnology, boolean pOverwrite)
          Create an ODI Work runtime repository into the database specified by the given parameters.
 boolean isRepIdAndRepNameAvailable(int pWorkDevRepositoryId, java.lang.String pWorkRepositoryName)
          This method checks that the repository id and name are available.
 void upgradeWorkRepository(java.lang.String pWorkRepositoryName)
          Upgrade the work repository schema for the database specified by the given parameters.
 void upgradeWorkRepository(java.lang.String pWorkRepositoryName, JdbcProperties pWorkRepositoryNewJdbcProperties)
          Upgrade the work repository schema for the database specified by the given parameters.
 
Methods inherited from class java.lang.Object
equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Constructor Detail

WorkRepositorySetupImpl

public WorkRepositorySetupImpl(OdiInstance pOdiInstance)
Creates a new WorkRepositorySetupImpl for the given @link OdiInstance.

Parameters:
pOdiInstance - the OdiInstance connected to a master repository.
Method Detail

configureWorkDevRepository

public void configureWorkDevRepository(java.lang.String pWorkUrl,
                                       java.lang.String pWorkDriver,
                                       java.lang.String pWorkUsername,
                                       java.lang.String pWorkPassword,
                                       int pWorkDevRepositoryId,
                                       java.lang.String pWorkRepositoryName,
                                       TechnologyName pWorkTechnology)
                                throws RepositorySetupException
Description copied from interface: IWorkRepositorySetup
Configure default content of a given ODI work runtime repository.

That method will also add work repository information into parent master repository.

Specified by:
configureWorkDevRepository in interface IWorkRepositorySetup
Parameters:
pWorkUrl - the url of the database where the work repository will be created
pWorkDriver - the JDBC driver name of the database
pWorkUsername - the username to connect to the database
pWorkPassword - the password to connect to the database
pWorkDevRepositoryId - the ID of the repository that will be created
pWorkRepositoryName - the logical name of the work repository
pWorkTechnology - the technology of the database
Throws:
RepositorySetupException - if failed to create that work repository
RepositoryScriptsNotFoundException - if failed to find the script files

configureWorkRuntimeRepository

public void configureWorkRuntimeRepository(java.lang.String pWorkUrl,
                                           java.lang.String pWorkDriver,
                                           java.lang.String pWorkUsername,
                                           java.lang.String pWorkPassword,
                                           int pWorkRuntimeRepositoryId,
                                           java.lang.String pWorkRepositoryName,
                                           TechnologyName pWorkTechnology)
                                    throws RepositorySetupException
Description copied from interface: IWorkRepositorySetup
Configure default content of a given ODI work runtime repository.

That method will also add work repository information into parent master repository.

Specified by:
configureWorkRuntimeRepository in interface IWorkRepositorySetup
Parameters:
pWorkUrl - the url of the database where the work repository will be created
pWorkDriver - the JDBC driver name of the database
pWorkUsername - the username to connect to the database
pWorkPassword - the password to connect to the database
pWorkRuntimeRepositoryId - the ID of the repository that will be created
pWorkRepositoryName - the logical name of the work repository
pWorkTechnology - the technology of the database
Throws:
RepositorySetupException - if failed to create that work repository
RepositoryScriptsNotFoundException - if failed to find the script files

createWorkDevRepository

public boolean createWorkDevRepository(java.lang.String pWorkUrl,
                                       java.lang.String pWorkDriver,
                                       java.lang.String pWorkUsername,
                                       java.lang.String pWorkPassword,
                                       int pWorkDevRepositoryId,
                                       java.lang.String pWorkRepositoryName,
                                       java.lang.String pWorkRepositoryPassword,
                                       TechnologyName pWorkTechnology,
                                       boolean pOverwrite)
                                throws RepositorySetupException,
                                       PermissionDeniedException
Description copied from interface: IWorkRepositorySetup
Create an ODI Work development repository into the database specified by the given parameters.

This method will create work repository schema for development with the specified ODI work repository name and password.

Specified by:
createWorkDevRepository in interface IWorkRepositorySetup
Parameters:
pWorkUrl - the url of the database where the work repository will be created
pWorkDriver - the JDBC driver name of the database
pWorkUsername - the username to connect to the database
pWorkPassword - the password to connect to the database
pWorkDevRepositoryId - the ID of the repository that will be created
pWorkRepositoryName - the logical name of the work repository
pWorkRepositoryPassword - the password of the work repository
pWorkTechnology - the technology of the database
pOverwrite - true to override an existing repository, false otherwise. Note that overwrite of a repository having a different version might fail. In this case please cleanup your database schema manually.
Returns:
true if the repository has been created, and false in case a previous repository was found but invoker had asked to not overwrite any existing repository.

Throws:
RepositorySetupException - if failed to create that work repository
RepositoryScriptsNotFoundException - if failed to find the script files
PermissionDeniedException

createWorkDevRepository

public boolean createWorkDevRepository(java.lang.String pWorkUrl,
                                       java.lang.String pWorkDriver,
                                       java.lang.String pWorkUsername,
                                       java.lang.String pWorkPassword,
                                       int pWorkDevRepositoryId,
                                       java.lang.String pWorkRepositoryName,
                                       TechnologyName pWorkTechnology,
                                       boolean pOverwrite)
                                throws RepositorySetupException
Description copied from interface: IWorkRepositorySetup
Create an ODI Work development repository into the database specified by the given parameters.

This method will create work repository schema for development with the specified ODI work repository name and without any password.

Specified by:
createWorkDevRepository in interface IWorkRepositorySetup
Parameters:
pWorkUrl - the url of the database where the work repository will be created
pWorkDriver - the JDBC driver name of the database
pWorkUsername - the username to connect to the database
pWorkPassword - the password to connect to the database
pWorkDevRepositoryId - the ID of the repository that will be created
pWorkRepositoryName - the logical name of the work repository
pWorkTechnology - the technology of the database
pOverwrite - true to override an existing repository, false otherwise. Note that overwrite of a repository having a different version might fail. In this case please cleanup your database schema manually.
Returns:
true if the repository has been created, and false in case a previous repository was found but invoker had asked to not overwrite any existing repository.

Throws:
RepositorySetupException - if failed to create that work repository
RepositoryScriptsNotFoundException - if failed to find the script files

createWorkRuntimeRepository

public boolean createWorkRuntimeRepository(java.lang.String pWorkUrl,
                                           java.lang.String pWorkDriver,
                                           java.lang.String pWorkUsername,
                                           java.lang.String pWorkPassword,
                                           int pWorkRuntimeRepositoryId,
                                           java.lang.String pWorkRepositoryName,
                                           java.lang.String pWorkRepositoryPassword,
                                           TechnologyName pWorkTechnology,
                                           boolean pOverwrite)
                                    throws RepositorySetupException,
                                           PermissionDeniedException
Description copied from interface: IWorkRepositorySetup
Create an ODI Work runtime repository into the database specified by the given parameters.

This method will create work repository schema for runtime with the specified ODI work repository name and password.

Specified by:
createWorkRuntimeRepository in interface IWorkRepositorySetup
Parameters:
pWorkUrl - the url of the database where the work repository will be created
pWorkDriver - the JDBC driver name of the database
pWorkUsername - the username to connect to the database
pWorkPassword - the password to connect to the database
pWorkRuntimeRepositoryId - the ID of the repository that will be created
pWorkRepositoryName - the logical name of the work repository
pWorkRepositoryPassword - the password of the work repository
pWorkTechnology - the technology of the database
pOverwrite - true to override an existing repository, false otherwise. Note that overwrite of a repository having a different version might fail. In this case please cleanup your database schema manually.
Returns:
true if the repository has been created, and false in case a previous repository was found but invoker had asked to not overwrite any existing repository.

Throws:
RepositorySetupException - if failed to create that work repository
RepositoryScriptsNotFoundException - if failed to find the script files
PermissionDeniedException

createWorkRuntimeRepository

public boolean createWorkRuntimeRepository(java.lang.String pWorkUrl,
                                           java.lang.String pWorkDriver,
                                           java.lang.String pWorkUsername,
                                           java.lang.String pWorkPassword,
                                           int pWorkRuntimeRepositoryId,
                                           java.lang.String pWorkRepositoryName,
                                           TechnologyName pWorkTechnology,
                                           boolean pOverwrite)
                                    throws RepositorySetupException
Description copied from interface: IWorkRepositorySetup
Create an ODI Work runtime repository into the database specified by the given parameters.

This method will create work repository schema for runtime with the specified ODI work repository name and without any password.

Specified by:
createWorkRuntimeRepository in interface IWorkRepositorySetup
Parameters:
pWorkUrl - the url of the database where the work repository will be created
pWorkDriver - the JDBC driver name of the database
pWorkUsername - the username to connect to the database
pWorkPassword - the password to connect to the database
pWorkRuntimeRepositoryId - the ID of the repository that will be created
pWorkRepositoryName - the logical name of the work repository
pWorkTechnology - the technology of the database
pOverwrite - true to override an existing repository, false otherwise. Note that overwrite of a repository having a different version might fail. In this case please cleanup your database schema manually.
Returns:
true if the repository has been created, and false in case a previous repository was found but invoker had asked to not overwrite any existing repository.

Throws:
RepositorySetupException - if failed to create that work repository
RepositoryScriptsNotFoundException - if failed to find the script files

isRepIdAndRepNameAvailable

public boolean isRepIdAndRepNameAvailable(int pWorkDevRepositoryId,
                                          java.lang.String pWorkRepositoryName)
                                   throws RepositorySetupException
Description copied from interface: IWorkRepositorySetup
This method checks that the repository id and name are available.

Specified by:
isRepIdAndRepNameAvailable in interface IWorkRepositorySetup
Parameters:
pWorkDevRepositoryId - the ID of the repository
pWorkRepositoryName - the logical name of the work repository
Returns:
true if the specified work repository id and name are available, false if they are already used.
Throws:
RepositorySetupException

upgradeWorkRepository

public void upgradeWorkRepository(java.lang.String pWorkRepositoryName)
                           throws RepositorySetupException
Description copied from interface: IWorkRepositorySetup
Upgrade the work repository schema for the database specified by the given parameters.

In order to upgrade a work repository, caller of this method have to passe in an instance of ODI running only against an ODI Master repository.

Following the work repository type (development or runtime) that method will upgrade the repository schema accordingly.

Specified by:
upgradeWorkRepository in interface IWorkRepositorySetup
Parameters:
pWorkRepositoryName - the name of the work repository to upgrade
Throws:
RepositorySetupException - if failed to upgrade the work repository
RepositoryScriptsNotFoundException - if failed to find the script files

upgradeWorkRepository

public void upgradeWorkRepository(java.lang.String pWorkRepositoryName,
                                  JdbcProperties pWorkRepositoryNewJdbcProperties)
                           throws RepositorySetupException,
                                  PermissionDeniedException
Description copied from interface: IWorkRepositorySetup
Upgrade the work repository schema for the database specified by the given parameters.

In order to upgrade a work repository, caller of this method have to passe in an instance of ODI running only against an ODI Master repository.

Following the work repository type (development or runtime) that method will upgrade the repository schema accordingly.

Specified by:
upgradeWorkRepository in interface IWorkRepositorySetup
Parameters:
pWorkRepositoryName - the name of the work repository to upgrade
pWorkRepositoryNewJdbcProperties - The new location of the work repository (this can be usefull if it's different from the location defined in the master repository). If null the location currently in the master repostiory will be kept.
Throws:
RepositorySetupException - if failed to upgrade the work repository
RepositoryScriptsNotFoundException - if failed to find the script files
PermissionDeniedException

Oracle® Data Integrator Java API Reference
11g Release 1 (11.1.1.3.0)

E17060-01

Copyright © 2010, Oracle and/or its affiliates. All rights reserved.