I’m run insert jdbc request from csv file in Jmeter.sql is:
INSERT INTO SZ_1E_MYSQL1 (TS_15M,MSISDN,IMEI,IMSI, MCC, MNC, LAC, CELL) VALUES (?, ?, ?, ?, ?, ?, ?, ?);
I set Parameter values is:
${TS_15M},${MSISDN},${IMEI},${IMSI},${MCC},${MNC},${LAC},${CELL}.
Parameter types:
varchar,bigint,bigint,bigint,int,int,int,bigint. Table Structure：
mysql> desc SZ_1E_MYSQL1;
+--------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+--------+-------------+------+-----+---------+-------+
| TS_15M | varchar(17) | YES | | NULL | |
| MSISDN | bigint | YES | | NULL | |
| IMEI | bigint | YES | | NULL | |
| IMSI | bigint | YES | | NULL | |
| MCC | int | YES | | NULL | |
| MNC | int | YES | | NULL | |
| LAC | int | YES | | NULL | |
| CELL | bigint | YES | | NULL | |
+--------+-------------+------+-----+---------+-------+
8 rows in set (0.00 sec)
but test resultis：
Invalid data type: int
How to fix problem?
>Solution :
I don’t think there is int data type in MySQL, most probably it’s INTEGER
Take a look at Java, JDBC, and MySQL Types
More information: