HowTo call stored procedures in a database server from VoiceObjects
Tuesday, August 10th, 2010Did you ever wonder what’s the best way to call a stored procedure in a relational database server from your VoiceObjects call flow implementation? As you might know, the new Database object was added with VoiceObjects 9.1, and it greatly facilitates the task of executing SELECT, INSERT and UPDATE statements in a database server. However, it just doesn’t deal with stored procedures. In many projects, however, database content must be accessed through stored procedures, while direct use of DML (Data Manipulation Language) commands (such as SELECT or INSERT) is a no-no.
So, we went ahead and created a generic VoiceObjects Connector implementation that should be useable in most if not all instances where database integration via stored procedures is required. It was implemented as a CGI connector – that is, the connector code will be deployed as a web application in a web application server (such as Tomcat), and communicate with the VoiceObjects Server via XML/http. It supports calling stored procedures with any number of IN and OUT parameters of all kinds of data types, and deals with result sets that may be returned by the stored procedure. Plus, it leverages database connection pools that are configured and maintained on the web application server.
If you’re interested, find all you need to know about this generic “database stored procedure connector” in this new Knowledge Base article. There, you’ll find background information, installation and configuration instructions, as well as the actual download of the connector including the associated Java sources.
PS: Note that the implementation of this new CGI connector actually builds on the Java Servlet framework for CGI connectors that was presented in this recent blog post on VoiceObjects back-end integration.
































