|
|
|
|
|
Type of feature
Java Database Connectivity (JDBC) is a base feature.
About the JDBC database interface feature
JDBC provides database connectivity and activity on the Avaya IR server and to remote servers. The JDBC interface process executes basic SQL commands. It also creates and populates call data into local database tables or Solaris flat files.
The JDBC database interface process (DIP) can be accessed from a TAS application through the dbase instruction. The name of the database DIP to use is specified as the first parameter to the dbase instruction. Based on the DIP that has been configured on the platform, this value could be DBDIP1, DBDIP2, DBDIP3, etc. Using the JDBC DIP, applications can perform the following operations on a database: SELECT, NEXT, INSERT, DELETE, UPDATE. Applications can also execute stored procedures created on a database and retrieve the resultset/values returned by the procedure. For a detailed explanation on how to write TAS applications that use these features, see Avaya IVR Designer Help for TAS Applications.
The JDBC DIP can also be accessed from VoiceXML applications through a servlet interface. VXML applications can post a request to the servlet - "JDBCServlet" provided by the AVjdbcint package. Through this interface, applications can perform the following operations on a database: SELECT, NEXT, INSERT, DELETE, UPDATE. Applications can also execute stored procedures created on a database and retrieve the resultset/values returned by the procedure. For a detailed explanation on how to write VXML applications that use these features, see Avaya IVR Designer Help for VXML Applications.
The JDBC interface supports connectivity to the following remote databases:
Note:
Oracle 8i, 9i, and 10g are the only databases that have been certified to run locally on the Avaya IR.
Avaya IR does not support stored procedures on Informix or MS SQL Server 7.0.
Software requirements
The JDBC database interface feature requires the following software:
Setup considerations
The JDBC type4 drivers must be installed.
Using this feature
Administer this feature using Web Administration (Configuration Management > JDBC Administration) or the dbconfig command.
