voice file getting overwritting

[preethi Ayyappan]

Hi,

My task is to do recording and making it to playback to the answering machine.
Let us consider an agent 1000 calls 101.It plays a message enter the customer's firstname ,lastname and reference number.the agent 1000 records the voice file and transfer it to the particular customer's answering machine.101 will playback the recorded message of the agent to the machine.It works fine when one agent calls.If multiple agent calls at a time.It is playing the voice file of the second agent when the first agent is playing back to his customer.my code is

  
 
public class Record2 extends BaseAgiScript implements AgiScript
 
{

Connection conn=null;
Statement st;
ResultSet rs=null;
int timeout=5000;
int maxDigits=10;
int maxDigits2=1;
public void service(AgiRequest request, AgiChannel channel)
    throws AgiException
{
 String callerid;
 String exten;
callerid=request.getCallerIdNumber();
System.out.print(callerid);
exten=request.getExtension();
System.out.print(exten);
SimpleDateFormat formatter = new SimpleDateFormat ("yyyy-MM-dd") ; 
String s = formatter.format (new Date()) ;
System.out.print(s);
String path="/var/lib/asterisk/sounds/";
String filename=callerid;
String filename1=callerid+"1";
String format="gsm";
int timeout=5000;
int maxDigits=1;
int maxduration=10;
answer();
String choice=channel.getData("1-yes-2-no", timeout, maxDigits);
System.out.print(choice);
if(choice.equals("1"))
{
streamFile("please-enter-the");
streamFile("firstname,lastname");
this.exec("Record", path + ' ' + filename +'.' + format + '|' + maxduration);
streamFile("please-enter-the");
streamFile("referencenumber");
this.exec("Record", path + ' ' + filename1 +'.' + format + '|' + maxduration);

try
{
Class.forName("com.mysql.jdbc.Driver").newInstance();
conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/voice","power","1234");
st=conn.createStatement();
st.executeUpdate("INSERT INTO recorddetails(`callerid` ,`date_time`,`extension`)VALUES('"+callerid+"' , sysdate(),'"+ exten +"')");

}
catch(Exception e)
{
e.printStackTrace();
}
}
else 
{
streamFile("thank-you-for-calling");
hangup();
}

try
{
 
Class.forName("com.mysql.jdbc.Driver").newInstance();
conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/voice","power","1234");
st=conn.createStatement();
//rs=st.executeQuery("select * from ivr where agentid='"+caller+"'");
rs=st.executeQuery("select * from ivr where filename='"+filename+"' && filename1='"+filename1+"'");
if(rs.next())
{
int agentflag=rs.getInt("agentflag");
//String voicefile=rs.getString("voicefile");
String file=rs.getString("filename");
String file2=" "+file;
System.out.print(file2);
String file1=rs.getString("filename1");
String file3=" "+file1;
System.out.print(file3);
String agentid=rs.getString("agentid");
System.out.print(agentflag);

if(agentflag==0)
{
System.out.print("unknown");
String agentscript=rs.getString("agentscript");
String agentscript1=rs.getString("agentscript1");
String agentscript2=rs.getString("agentscript2");
streamFile(agentscript);
streamFile(file2);
streamFile(agentscript1);
streamFile(file3);
streamFile(agentscript2);

}
else if(agentflag==1)
{
System.out.print("verified");
String agentscript3=rs.getString("agentscript3");
String agentscript4=rs.getString("agentscript4");
String agentscript5=rs.getString("agentscript5");
String agentscript6=rs.getString("agentscript6");
String agentscript7=rs.getString("agentscript7");
streamFile(agentscript3);
streamFile(file2);
streamFile(agentscript4);
streamFile(file2);
streamFile(agentscript5);
streamFile(file2);
streamFile(agentscript6);
streamFile(file3);
streamFile(agentscript7);
}
else if(agentflag==2)
{
System.out.print("metavante");
String agentscript8=rs.getString("agentscript8");
streamFile(agentscript8);
streamFile(file2);
String agentscript9=rs.getString("agentscript9");
streamFile(agentscript9);
streamFile(file3);

String agentscript10=rs.getString("agentscript10");
streamFile(agentscript10);
}
else if(agentflag==3)
{
System.out.print("wachovia");
String agentscript11=rs.getString("agentscript11");
streamFile(agentscript11);
streamFile(file2);
String agentscript12=rs.getString("agentscript12");

streamFile(agentscript12);
streamFile(file3);
String agentscript13=rs.getString("agentscript13");
streamFile(agentscript13);
}
}
}
catch(Exception e)
{
e.printStackTrace();
}
}
}
  

please help me to solve this.Thanks

[Martijn Verburg]

So what are you actually stuck on?