jet.bean

Class JRCatalog

java.lang.Object

jet.bean.JRCatalog

public class JRCatalog
extends Object

This catalog bean provides methods to manipulate and access the catalog object.

Version:

1.01 04/05/99

Author:

Owen Chang

Field Summary

Fields

Modifier and Type	Field and Description
static int	TYPE_TABLE Indicates that the type of table is a table (not a view).
static int	TYPE_VIEW Indicates that the type of table is a view (not a table).
static int	vDebug Indicates to open the debug log.
static int	vError Indicates to open the error log.
static int	vOff Indicates to close the debug and error log.

Constructor Summary

Constructors

Constructor and Description
JRCatalog() The default construct.

Method Summary

Modifier and Type	Method and Description
void	addConnection(ConnectionDesc connection) Adds the specified connection to the catalog.
void	addFileQuery(String strName, File flPath) Adds the file query specified by the name and file to a catalog.
Vector	addTableViews(String strCatalogName, String schemaPattern, String tablePattern, int iType) Adds the file query specified by the name and file to a catalog.
void	addWherePortion(String strName, String strQueryName, String strSQL) Adds the specified where portion to catalog.
void	addWherePortion(String strName, String strQueryName, Vector vecGroups) Adds the specified where portion to catalog and save catalog.
void	closeCatalog() Closes the catalog and release all resources.
void	deleteConnection() Deletes the connection from the catalog.
void	deleteFileQuery(String strName) Deletes the specified file query in the catalog.
void	deleteWherePortion(String strName) Removes the where portion by the specified name.
String	getCatName() Gets the name of the catalog.
ConnectionDesc	getConnectionDesc() Gets the connection description.
String	getFileQuerySQL(String strName) Gets the file query SQL string.
String	getReportHome() Gets the report home path where the report.ini and other Logi Report system files exist.
String	getWherePortionsSQL(String strName) Gets the where portion by the specified name.
void	loadCatalog() Loads the catalog by the specified catalog name.
void	modifyConnection(ConnectionDesc connection) Modifies the connection according to the specified connection description.
void	modifyConnection(ConnectionDesc connection, boolean reconnect) Modifies the connection according to the specified connection description.
void	modifyUserInfo(String strUserName, String strPassword) Modifies the User and Password information according to the specified connection description.
void	modifyWherePortion(String strName, String strQueryName, String strSQL) Modifies the specified where portion.
void	modifyWherePortion(String strName, String strQueryName, Vector vecGroups) Modifies the specified where portion.
void	newCatalog() Creates a new catalog with the catalog name and save the catalog to file.
boolean	removeSFDataSource(String strName) Removes a user data source for IBM Sanfrancisco.
void	saveCatalog() Saves the catalog to a file.
void	saveCatalogAs(String strCatName) Saves the catalog to specified file.
void	setCatName(String catName) Sets the name of the catalog.
void	setCurrentDataSource(String dataSourceName) Sets the current DataSource.
boolean	setLogFile(String fileName) Sets the log file.
void	setReportHome(String reportHome) Sets the report home path where the report.ini and other Logi Report system files exist.
void	setShowInfoLevel(int level) Enables/disables output error and debug message.

Methods inherited from class java.lang.Object

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

Field Detail

vOff

public static final int vOff

Indicates to close the debug and error log.

See Also:

Constant Field Values

vDebug

public static final int vDebug

Indicates to open the debug log.

See Also:

Constant Field Values

vError

public static final int vError

Indicates to open the error log.

See Also:

Constant Field Values

TYPE_TABLE

public static final int TYPE_TABLE

Indicates that the type of table is a table (not a view).

See Also:

Constant Field Values

TYPE_VIEW

public static final int TYPE_VIEW

Indicates that the type of table is a view (not a table).

See Also:

Constant Field Values

Constructor Detail

JRCatalog

public JRCatalog()

The default construct.

Method Detail

getReportHome

public String getReportHome()

Gets the report home path where the report.ini and other Logi Report system files exist.

Returns:

the report home path where the report.ini and other Logi Report system files exist.

setReportHome

public void setReportHome(String reportHome)

Sets the report home path where the report.ini and other Logi Report system files exist.

Parameters:

reportHome - the home path where the report.ini and other Logi Report system files exist.

setCatName

public void setCatName(String catName)

Sets the name of the catalog.

Parameters:

catName - the name of the catalog.

getCatName

public String getCatName()

Gets the name of the catalog.

Returns:

the name of the catalog.

newCatalog

public void newCatalog()
                throws JRCatalogException

Creates a new catalog with the catalog name and save the catalog to file.

Throws:

JRCatalogException - if an error occurs

See Also:

JRCatalogException.SYSTEM_INITIALIZE_ERROR, JRCatalogException.CAT_NAME_ERROR, JRCatalogException.CREATE_CAT_ERROR, JRCatalogException.SAVE_CAT_ERROR

loadCatalog

public void loadCatalog()
                 throws JRCatalogException

Loads the catalog by the specified catalog name.

Throws:

JRCatalogException - if an error occurs

See Also:

JRCatalogException.SYSTEM_INITIALIZE_ERROR, JRCatalogException.CAT_NAME_ERROR, JRCatalogException.LOAD_CAT_ERROR

saveCatalog

public void saveCatalog()
                 throws JRCatalogException

Saves the catalog to a file. When the catalog is saved successfully, all changes on the catalog have been saved.

Throws:

JRCatalogException - if an error occurs

See Also:

JRCatalogException.NO_CAT_ERROR, JRCatalogException.SAVE_CAT_ERROR

saveCatalogAs

public void saveCatalogAs(String strCatName)
                   throws JRCatalogException

Saves the catalog to specified file.

Throws:

JRCatalogException - if an error occurs

See Also:

JRCatalogException.NO_CAT_ERROR, JRCatalogException.SAVE_CAT_ERROR

closeCatalog

public void closeCatalog()

Closes the catalog and release all resources. When the catalog is closed, the operation on catalog will be rejected.

addWherePortion

public void addWherePortion(String strName,
                            String strQueryName,
                            String strSQL)
                     throws JRCatalogException

Adds the specified where portion to catalog.

Parameters:

strName, - the name of where portion.

strQueryName, - the query name of where portion.

strSQL, - the where portion string

Throws:

JRCatalogException - if an error occurs

See Also:

JRCatalogException.NO_CAT_ERROR, JRCatalogException.WHEREPORTION_NAME_ERROR

addWherePortion

public void addWherePortion(String strName,
                            String strQueryName,
                            Vector vecGroups)
                     throws JRCatalogException

Adds the specified where portion to catalog and save catalog.

Parameters:

strName, - the name of where portion.

strQueryName, - the query name of where portion.

vecGroups, - the where portion structure.

Throws:

JRCatalogException - if an error occurs

See Also:

JRCatalogException.NO_CAT_ERROR, JRCatalogException.WHEREPORTION_NAME_ERROR

modifyWherePortion

public void modifyWherePortion(String strName,
                               String strQueryName,
                               String strSQL)
                        throws JRCatalogException

Modifies the specified where portion.

Parameters:

strName, - the name of where portion.

strQueryName, - the query name of where portion.

strSQL, - the where portion string

Throws:

JRCatalogException - if an error occurs

See Also:

JRCatalogException.NO_CAT_ERROR, JRCatalogException.WHERE_PORTION_NOT_EXISTS

modifyWherePortion

public void modifyWherePortion(String strName,
                               String strQueryName,
                               Vector vecGroups)
                        throws JRCatalogException

Modifies the specified where portion.

Parameters:

strName, - the name of where portion.

strQueryName, - the query name of where portion.

vecGroups, - the where portion structure.

Throws:

JRCatalogException - if an error occurs

See Also:

JRCatalogException.NO_CAT_ERROR, JRCatalogException.WHERE_PORTION_NOT_EXISTS

deleteWherePortion

public void deleteWherePortion(String strName)
                        throws JRCatalogException

Removes the where portion by the specified name.

Parameters:

strName, - the name of where portion.

Throws:

JRCatalogException - if an error occurs

See Also:

JRCatalogException.NO_CAT_ERROR, JRCatalogException.WHERE_PORTION_NOT_EXISTS

getWherePortionsSQL

public String getWherePortionsSQL(String strName)
                           throws JRCatalogException

Gets the where portion by the specified name.

Parameters:

nameOfWherePortion, - the name of where portion.

Returns:

the string of where portion if successfully, else null.

Throws:

JRCatalogException - if an error occurs

See Also:

JRCatalogException.NO_CAT_ERROR, JRCatalogException.WHERE_PORTION_NOT_EXISTS

addFileQuery

public void addFileQuery(String strName,
                         File flPath)
                  throws JRCatalogException

Adds the file query specified by the name and file to a catalog.

Parameters:

strName, - the name of file query.

flPath, - the sql file.

Throws:

JRCatalogException - if an error occurs

See Also:

JRCatalogException.NO_CAT_ERROR, JRCatalogException.NO_CONNECTION_ERROR, JRCatalogException.CREATE_FILEQUERY_FAILED

addTableViews

public Vector addTableViews(String strCatalogName,
                            String schemaPattern,
                            String tablePattern,
                            int iType)
                     throws JRCatalogException

Adds the file query specified by the name and file to a catalog. In pattern string, wildcard character "%" and "_" are supported.

Parameters:

strCatalogName, - the name of catalog.

schemaPattern, - the pattern of schema.

tablePattern, - the pattern of table.

Throws:

JRCatalogException - if an error occurs

See Also:

JRCatalogException.NO_CAT_ERROR, JRCatalogException.NO_CONNECTION_ERROR, JRCatalogException.INVALID_TABLETYPE, JRCatalogException.UNKNOWN_ERROR, JRCatalogException.CONNECTION_FAILURE_ERROR, JRCatalogException.CLOSE_CONNECTION_ERROR

deleteFileQuery

public void deleteFileQuery(String strName)
                     throws JRCatalogException

Deletes the specified file query in the catalog.

Parameters:

strName, - the name of file query.

Throws:

JRCatalogException - if an error occurs

See Also:

JRCatalogException.NO_CAT_ERROR, JRCatalogException.NO_CONNECTION_ERROR, JRCatalogException.CREATE_FILEQUERY_FAILED

getFileQuerySQL

public String getFileQuerySQL(String strName)
                       throws JRCatalogException

Gets the file query SQL string.

Parameters:

strName, - the name of file query.

Returns:

the SQL string.

Throws:

JRCatalogException - if an error occurs

See Also:

JRCatalogException.NO_CAT_ERROR, JRCatalogException.NO_CONNECTION_ERROR, JRCatalogException.FILEQUERY_NAME_ERROR, JRCatalogException.CREATE_FILEQUERY_FAILED, JRCatalogException.FILEQUERY_NOT_EXISTS

removeSFDataSource

public boolean removeSFDataSource(String strName)
                           throws JRCatalogException

Removes a user data source for IBM Sanfrancisco.

Parameters:

strName, - the name of UDS;

Throws:

JRCatalogException - if an error occurs

See Also:

JRCatalogException.NO_CAT_ERROR

addConnection

public void addConnection(ConnectionDesc connection)
                   throws JRCatalogException

Adds the specified connection to the catalog. The program will try to make a connection to the database and fetch connection information.

Parameters:

connection, - the connection description.

Throws:

JRCatalogException - if an error occurs

See Also:

JRCatalogException.NO_CAT_ERROR, JRCatalogException.ONE_CONNECTION, JRCatalogException.CONNECTION_FAILURE_ERROR, JRCatalogException.FILEQUERY_NOT_EXISTS

modifyConnection

public void modifyConnection(ConnectionDesc connection)
                      throws JRCatalogException

Modifies the connection according to the specified connection description. Note: A connection contains the tables, views, stored procedures and file queries. The queries, formulas and summaries also depend on the connection. Please be careful when you call this method. The program will try to make a connection to the database and fetch connection information.

Parameters:

connection, - the connection description.

Throws:

JRCatalogException - if an error occurs

See Also:

JRCatalogException.NO_CAT_ERROR, JRCatalogException.NO_CONNECTION_ERROR, JRCatalogException.CONNECTION_FAILURE_ERROR

modifyConnection

public void modifyConnection(ConnectionDesc connection,
                             boolean reconnect)
                      throws JRCatalogException

Modifies the connection according to the specified connection description. Note: A connection contains the tables, views, stored procedures and file queries. The queries, formulas and summaries also depend on the connection. Please be careful when you call this method.

Parameters:

connection, - the connection description.

reconnect, - try to make a connection to the database and fetch connection information if it is true.

Throws:

JRCatalogException - if an error occurs

See Also:

JRCatalogException.NO_CAT_ERROR, JRCatalogException.NO_CONNECTION_ERROR, JRCatalogException.CONNECTION_FAILURE_ERROR

modifyUserInfo

public void modifyUserInfo(String strUserName,
                           String strPassword)
                    throws JRCatalogException

Modifies the User and Password information according to the specified connection description. Note: A connection contains the tables, views, stored procedures and file queries. The queries, formulas and summaries also depend on the connection. Please be careful when you call this method.

Parameters:

connection, - the connection description.

Throws:

JRCatalogException - if an error occurs

See Also:

JRCatalogException.NO_CAT_ERROR, JRCatalogException.NO_CONNECTION_ERROR, JRCatalogException.CONNECTION_FAILURE_ERROR

deleteConnection

public void deleteConnection()
                      throws JRCatalogException

Deletes the connection from the catalog. Note: A connection contains the tables, views, stored procedures and file queries. The queries, formulas and summaries also depend on the connection. Please be careful when you call this method.

Throws:

JRCatalogException - if an error occurs

See Also:

JRCatalogException.NO_CAT_ERROR, JRCatalogException.NO_CONNECTION_ERROR, JRCatalogException.CONNECTION_FAILURE_ERROR

getConnectionDesc

public ConnectionDesc getConnectionDesc()
                                 throws JRCatalogException

Gets the connection description.

Returns:

the ConnectionDesc object if there is a connection, otherwise, null.

Throws:

JRCatalogException - if an error occurs

See Also:

JRCatalogException.NO_CAT_ERROR

setShowInfoLevel

public void setShowInfoLevel(int level)

Enables/disables output error and debug message.

Parameters:

level - the debug level, for example: vDebug | vError

See Also:

vOff, vDebug, vError

setLogFile

public boolean setLogFile(String fileName)

Sets the log file.

Parameters:

fileName - the log file name

LogFileName specifies where the debug, error and other information will go. LogFileName contains both the path and the file name. If no path is specified, the current path is used. If no file name is specified, the file logireport.log is used

Returns:

true if successful

setCurrentDataSource

public void setCurrentDataSource(String dataSourceName)

Sets the current DataSource.

Parameters:

dataSourceName - the DataSource name user can use this method to switch among the data sources. The default data source is named as "".