5R3Lpq0F

1DROP TABLE IF EXISTS allbydate;
2CREATE TEMPORARY TABLE allbydate (INDEX channel (calldate,channel,src,dst)) AS (
3select ...
4);
5
6DROP TABLE IF EXISTS allsrc;
7CREATE TEMPORARY TABLE allsrc (INDEX channel (channel,disposition)) AS (
8select ...
9);
10
11DROP TABLE IF EXISTS alldst;
12CREATE TEMPORARY TABLE alldst (INDEX channel (dstchannel,calldate,disposition)) AS (
13select ...
14);
15
16DROP TABLE IF EXISTS result;
17CREATE TEMPORARY TABLE result (INDEX channel (calldate,number)) AS (
18select * from allsrc
19);
20
21INSERT INTO result 
22select * from alldst;
23
24select * from result;
25	
26Object object = jdbcTemplate.query(query, ROW_MAPPER);
27	
28java.sql.SQLException: Can not issue data manipulation statements with executeQuery()
29	
30Query OK, 54 rows affected (0.00 sec)
31Records: 54  Duplicates: 0  Warnings: 0
32	
33java.sql.SQLException: Can not issue data manipulation statements with executeQuery()