I have an SQL table with records of all company employees. Employee's ID number is a primary key in the EMPLOYEE table.
This primary key is a binary value.
For each employee there is a field called "Reports To" indicating who the employee's manager is. "Reports To" field has the manager's primary key. I need to identify the employee by his phone number and present to an agent his phone,name AND his manager's name. In theory i should fiend the employee in the table and record his name and the primary key of his manager, then with another DB READ go to the table and using the primary key i got in the first case, i should find his manager's name.
The problem is that with the first DB GET in the script the value of the Report To field is identified with data type java.lang.Timestamp. I tried creating a variable with this data type, but when i place a call, there is an exception on the first DB GET
133221: Jun 02 14:40:21.724 GMT+200 %MIVR-APP_MGR-6-ABORTING_CONTACT:Aborting contact: Application=Test,Task id=16000000009,Contact id=7,Contact implementation id=724604/2,Contact Class=com.cisco.call.CallContact,Contact Type=Cisco JTAPI Call,Exception=com.cisco.wfapi.WFExecutionException: unable set the variable with the value returned from the database [[email protected]; nested exception is:
java.lang.IllegalArgumentException: Type mismatch: context variable type=java.sql.Timestamp value type=com.cisco.doc.util.CachedDocument
Any help will be appreciated!