also if your json string uses " you can probably inline to use an update
statement with something like
insert into table(col1,col2) values ('${var1}','${var2}');
then you wont have to escape anything (unless your json also uses ')On Tue, Feb 12, 2013 at 7:01 PM, Deepak Shetty <[email protected]> wrote: > 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* >> > >
