VoiceXML database operations and use

This section describes the various database operations that can be used in VoiceXML applications to access remote databases like MSSQL, DB2, and Sybase.

Avaya IVR Designer Release 5.1 or later has a sample VoiceXML application called JDBC_SP. This application plays a welcome announcement and then presents the user with a menu for selecting the type of database operation to perform. The topics in this section describe database operations (menu options) that are used in the JDBC_SP sample application.

For a VoiceXML application that uses JDBC database operations, if the same database query is run multiple times and the <subdialog> tag is set to method="get", only the first database query will be sent to the database. The rest of the query results will be fetched from the Avaya Voice Browser cache. To prevent this, do one of the following:

• Use method="post"
• Use <subdialog ... method="get" maxage="0s" ... >

For more information about and practice using VoiceXML database operations, see Using database operations in VoiceXML applications and Using stored procedures in VoiceXML applications in the Avaya IVR Designer Help for VoiceXML Applications.

© 2006 Avaya Inc. All Rights Reserved.