DB Audit Expert API Reference

Softtree Technologies, Perspection Inc.

Informations

• Publié par: Ubba
• Nombre de lectures: 31
• Langue: English

Extrait

™ DB Audit Expert 3.1

Application Programming
Interface Reference

Version 1.0
Copyright © 2006-2007 SoftTree Technologies, Inc.
All rights reserved
Contents

About This Guide........................................................................................................................... 7
Intended Audience................................................................................................................... 7
Conventions used in this document......................................................................................... 7
Abbreviations and Product Reference Terms.......................................................................... 8
Trademarks.............................................................................................................................. 8
CHAPTER 1, DB Audit API Architecture, Classes and Methods ............................................. 9
Architecture Overview.............................................................................................................. 9
Database Profiles and Connections Setup............................................................................ 10
Manually Configuring Database Connections .................................................................. 10
Programmatically Configuring Database Connections..................................................... 11
Testing Database Connections ........................................................................................ 11
Audit Setup API...................................................................................................................... 11
Overview of System Audit Classes .................................................................................. 11 Data-Change Audit Classes ......................................................................... 12
Audit Reporting API ............................................................................................................... 12
RMI Interface API .................................................................................................................. 12
CHAPTER 2, Installation ............................................................................................................ 14
Client-Side API Installation ....................................................................................................14
Database Server-Side Installation ......................................................................................... 14
DB2 for Linux, Unix and Windows.................................................................................... 14
DB2 for zSeries and iSeries Platforms ............................................................................. 15
Oracle for Windows .......................................................................................................... 15
Oracle for non-Windows Platforms................................................................................... 15
Microsoft SQL Server 15
Sybase ASE and ASA ...................................................................................................... 16
CHAPTER 3, Database Connectivity ........................................................................................ 17
Profile Manager Class and Related Classes......................................................................... 17
Overview........................................................................................................................... 17
Instantiating Profile Manager Class.................................................................................. 18
getInstance .............................................................................................................................18
initInstance..............................................................................................................................18
Database Driver Class...................................................................................................... 19
Constructor.........19
getName ........................................................................................................................
setName..........20
getJdbcDriverPath...................................................................................................................20
setJdbcDriv.....21
getJdbcDriverClass.................................................................................................................21
setJdbcDriverClass....22
getJdbcDriverType....22
setJdbcDriverType....23
Managing Database Drivers............................................................................................. 23
getDbDriverList .......................................................................................................................24
-2- getDbDriverNames..................................................................................................................24
getDbDriver.............................................................................................................................25
addDbDriver........25
deleteDbDriver ........................................................................................................................26
Database Connection Profile Class.................................................................................. 26
Constructor.........26
getName .................................................................................................................................27
setName..........27
getDriverName........................................................................................................................28
setDriverName
getJdbcURL ............................................................................................................................29
setJdbcURL
getUsername...........................................................................................................................30
setUsername...........................................................................................................................31
getPassword
setPassword.......32
getRepositoryDatabase...........................................................................................................33
setRepositoryDatabase.33
getConnectionParameter ........................................................................................................34
setConnectionter5
isLoggedOnAsSYSDBA ..........................................................................................................35
getDbPath ...............................................................................................................................36
setDbPath.........37
getMailSender.........................................................................................................................37
setMailSender.......38
getMailServer........38
setMailServer........39
getMailPassword.....................................................................................................................39
setMailPassword.....40
Managing and Using Database Profiles ........................................................................... 41
getDbProfileList.......................................................................................................................41
getDbProfileNames.................................................................................................................41
getDbProfile ............................................................................................................................42
addDbProfile........42
deleteDbProfile........................................................................................................................43
createDbConnect....43
Default Configuration Generator Class.................................................................................. 44
Overview........................................................................................................................... 44
Database Connectivity Class................................................................................................. 44
Overview.... 44
Connecting/Disconnecting to/from Database................................................................... 44
connect ...................................................................................................................................44
disconnect...............................................................................................................................45
Testing Connection .................................................................................................................45
Using Connection....................................................................................................................46
Getting Connection Information........................................................................................ 47
isConnected ............................................................................................................................47
checkConnected .....................................................................................................................47
getDbVersion .....................