Integrate with a Relational Database
Lesson 8 shows a generic Java action, which can be used to do almost anything from an IVR application. This lesson shows a special Java action that is used to access and modify a relational database. There is nothing special about database Java actions. To IVR Studio, they are the same type of Java actions. However, since IVR applications and relational databases are so closely tied, and most customers use them in their environment, we dedicate this chapter to this topic.
The first part of this lesson uses a Java program for database access.
The second part uses the built-in Database action. By using Database action, accessing and updating a relational database from your IVR application is much simplified. You no longer need to write a single line of code in order to access and update a relational database.
This lesson shows:
- Learn more about relational database
- The Java Class to check password in a relational database
- Create a Java action to check password entered
- Use the result to determine which transition to take
- Get more information from the database
- Update the Java Class for more return values
- Use the return from database as a prompt
The first step of this sample:
Integration is included in IVR Studio. You can access it from
the Library program menu. A typical interaction is listed below:
- The sample IVR application answers a
- Plays a welcome message, asking the
caller to enter his/her account number
- Caller enter account number
- System asks caller to enter password
- System checks account number and
password against data saved in a relational database. If the password is incorrect, go back
to step 2. If the caller has tried more than 3 times, hang up the call
- Plays a protected information using