http://jmeter.apache.org/usermanual/component_reference.html#JDBC_Request
The list must be enclosed in double-quotes if any of the values contain a comma or double-quote, and any embedded double-quotes must be doubled-up, for example: "Dbl-Quote: "" and Comma: ," On Tue, Feb 12, 2013 at 2:40 PM, Raihan Jamal <[email protected]> wrote: > I am working on the project in which I need to make a connection to > database and insert lot of rows in that Database. I have two columns > currently in that database- > > * ID String PrimaryKey* > * ACCOUNT String* > > So I need to insert lot of rows in these two columns with the help of > JMeter. I am able to generate random Unique ID for ID column by using this- > > *`${__BeanShell(UUID.randomUUID().toString())}`* > > I am trying to insert `JSON String` into ACCOUNT columns using `JMeter`. > Below is the JSON string that I am trying to insert. > > *`{"lv":[{"v":{"regId":null,"user":null,"Id":996},"cn":1}],"lmd":1360185}`* > > In the parameter values section in JMeter, I am passing something like > this- > > * ${__BeanShell(UUID.randomUUID().toString())} > ,{"lv":[{"v":{"regId":null,"user":null,"Id":996},"cn":1}],"lmd":1360185}* > > > This is my SQL- > > *`INSERT INTO TEST2 (id, account) values (?, ?)`* > > > But after trying to insert, I am getting this exception- > > Response message: java.io.IOException: Cannot have quote-char in plain > field:[{"] > > How can I fix this thing? I just need to insert JSON string in the `ACCOUNT > column` > > Any thoughts how to achieve this? > > > > > > *Raihan Jamal* >
