apache / apache/jmeter

how to use JDBC request when parameters have "

Open
#6,387 0 comments 0 reactions 0 assignees View on GitHub
documentation to-triage
Dominant language
Java
Stars
9.5k
Forks
2.3k
Avg merge
1d 22h
Merged PRs (30d)
5

Description

### The documentation URL

https://jmeter.apache.org/usermanual/component_reference.html#JDBC_Request

### Feedback

I try to make a JDBC request
`update user set nickname = ? where id = ?`

Parameters is
`${nickName},${id}`

Beanshell is
`String nickname = vars.get("nickname");`
`log.info("before ===>" + nickname);`
`nickname = nickname.replaceall("\"","\"\"\"");`
`log.info("after ===> "+ nickname);`
`vars.put("nickname",nickname);`

but I get a error

> before ===> nick"name
> after ===> nick\"\"\"name
> cannot have quote-char in plain filed:[nick\"]

the document say

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: ,"`

how to make it work?

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.