Hi All,
Can someone help me understand why my call would disconnect when answered? I say hello, so it should be a live voice. This is basically copied from the example, but getting the number to dial from a database call through JSP?
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE ccxml PUBLIC "-//W3C//DTD CCXML 1.0//EN" "http://www.w3.org/TR/ccxml/ccxml.dtd">
<ccxml version="1.0" xmlns="http://www.w3.org/2002/09/ccxml">
<%@ page import="java.util.*"%>
<%@ page import="java.net.*"%>
<%@ page import="java.sql.*"%>
<%@ page contentType="application/ccxml+xml"%>
<%
/* do not want jsp content cached */
response.setHeader("Cache-Control", "no-store");
response.setHeader("Pragma", "no-cache");
response.setHeader("Expires", "1");
/*
* grab the host and save the app server host port for use later
* this makes the application urls "relative" to request so when
* we deploy this application we do not have to change the urls.
*/
//URL url = new URL (request.getRequestURL().toString());
//String host = url.getHost();
//String port = Integer.toString(url.getPort());
//String locationExt = "http://" + host + ":" + port;
//String locationLocal = "http://" + host + ":" + port + "/RouteToPhoneNumber";
//Setting Up JDBC Connection for MS Sql
String callerId = "8001234567";
String toUri = "";
String url = "jdbc:sqlserver://sqldbserver01:1433;databaseName=Database";
String userName = "user";
String passWord = "pass";
String sql = "SELECT OnCallNumber FROM dev.CompanyOnCall WHERE exits=?";
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
Connection con = DriverManager.getConnection(url,userName,passWord);
if(con!=null){
System.out.println("Database Connected");
}
PreparedStatement statement = con.prepareStatement(sql);
statement.setString(1, "OnCall");
ResultSet resultSet = statement.executeQuery();
if(resultSet.next()){
toUri=resultSet.getString("OnCallNumber");
}
System.out.println("To URI = " + toUri);
resultSet.close();
statement.close();
con.close();
%>
<!-- convert an object to a string by iterating through it structure -->
<script>
function objectToString( obj ) {
var result = " [\n";
result += extractprops( "", obj);
result += " ]";
return result;
}
function extractprops ( parent, obj ) {
var prop, name, result = "";
var count = 1;
if ( typeof ( obj ) == "object" ) {
for ( prop in obj ) {
name = parent + prop;
if ( typeof ( obj [ prop ] ) == "object" ) {
result += extractprops( name+".", obj [ prop ] );
} else {
result += " " + name + ":" + obj [ prop ] + "\n";
}
count = count + 1;
}
} else {
if (obj == undefined ) {
result += "undefined";
} else {
result += obj;
}
}
return result;
}
</script>
<var name="in_connectionid"/> <!-- The connectionid of the incoming call. -->
<var name="out_connectionid"/> <!-- The connectionid of the outgoing call. -->
<var name="dialogid"/> <!-- The id of the dialog we will run. -->
<var name="to_Uri" expr="'<%=toUri%>'+'@Company.com'"/>
<var name="caller_Id" expr="'<%=callerId%>'"/>
<!-- Initialize the state for this page -->
<var name="state" expr="'init'"/>
<!-- Possible states:
init - The initialized state, accept the call.
calling - Placing an outbound call
-->
<!-- Event processor -->
<eventprocessor statevariable="state">
<!-- STATE: init -->
<!-- New call is coming in, accept it blindly -->
<transition event="connection.alerting" state="init" >
<log expr="'-- ' + event$.name +' -- [' + state +']'"/>
<log expr="' eventdata... \n' + objectToString(event$)"/>
<assign name="in_connectionid" expr="event$.connectionid"/>
<accept/>
</transition>
<!-- Create a new call dialing a hardcoded # -->
<transition event="connection.connected" state="init" >
<log expr="'-- ' + event$.name +' -- [' + state +']'"/>
<log expr="' eventdata... \n' + objectToString(event$)"/>
<assign name="state" expr="'calling'"/>
<!--
enable call classification the call classification
will arrive in a connection.signal event.
-->
<var name="hints" expr="new Object();"/>
<assign name="hints.enable_call_classification" expr= "true"/>
<assign name="hints.call_classification_timeout" expr= "20000"/>
<createcall dest="'sip:'+to_Uri"
connectionid="out_connectionid"
timeout="30000"
callerid="caller_Id"
hints="hints" />
</transition>
<transition event="connection.connected" state="calling" >
<log expr="'-- ' + event$.name +' -- [' + state +']'"/>
<log expr="' eventdata... \n' + objectToString(event$)"/>
<log expr="'connected to caller, join the call!'"/>
<assign name="state" expr="'connected'"/>
<join id1="in_connectionid" id2="out_connectionid" duplex="'full'"/>
</transition>
<transition event="connection.signal" >
<log expr="'-- ' + event$.name +' -- [' + state +']'"/>
<log expr="' eventdata... \n' + objectToString(event$)"/>
<if cond="event$.connectionid == out_connectionid">
<if cond="event$.info.callprogress != undefined">
<if cond="event$.info.callprogress != 'live_voice'">
<log expr="' *** Oops no one there\n'"/>
<exit/>
<else/>
<log expr="' *** Got a live one\n'"/>
</if>
<else/>
<log expr="' *** No call progress in this connection.signal\n'"/>
</if>
<else/>
<log expr="' *** Not the out connection\n'"/>
</if>
</transition>
<transition event="connection.failed" state="calling" >
<log expr="'-- ' + event$.name +' -- [' + state +']'"/>
<log expr="' eventdata... \n' + objectToString(event$)"/>
<log expr="'failed to connect to caller'"/>
<exit expr="'Call Failed'"/>
</transition>
<transition event="connection.disconnected" state="">
<log expr="'-- ' + event$.name +' -- [' + state +']'"/>
<log expr="' eventdata... \n' + objectToString(event$)"/>
<if cond="event$.connectionid == in_connectionid">
<exit expr="'Caller Hungup'"/>
<else/>
<exit expr="'Called Number Hungup'"/>
</if>
</transition>
<!-- STATE: ANYSTATE. Catch all, aids in debugging and to see the missed events -->
<transition event="ccxml.exit" >
<log expr="'-- ' + event$.name +' -- [' + state +']'"/>
<log expr="' eventdata... \n' + objectToString(event$)"/>
</transition>
<transition event="ccxml.kill" >
<log expr="'-- ' + event$.name +' -- [' + state +']'"/>
<log expr="' eventdata... \n' + objectToString(event$)"/>
</transition>
<transition event="" >
<log expr="'-- missed ' + event$.name +' -- [' + state +']'"/>
<log expr="' eventdata... \n' + objectToString(event$)"/>
</transition>
</eventprocessor>
</ccxml>
