Handling white spaces in Request Parameter in springboot

up vote
1
down vote

favorite

In my HQL i'm using

  queryListBuilder.append(" and f.nom like '%"+ nomFil +"%' ");

nomFil is a string that may contain white spaces between words.
when i send

 http://localhost:8080/list?nom=First Last

I got empty result.
Ps: in my DB the value exists in my target table.
is there any way to handel white spaces in request parameters?

edited Nov 19 at 15:36

asked Nov 19 at 15:20

Java.net

479

add a comment |

up vote
1
down vote

favorite

In my HQL i'm using

  queryListBuilder.append(" and f.nom like '%"+ nomFil +"%' ");

nomFil is a string that may contain white spaces between words.
when i send

 http://localhost:8080/list?nom=First Last

I got empty result.
Ps: in my DB the value exists in my target table.
is there any way to handel white spaces in request parameters?

edited Nov 19 at 15:36

asked Nov 19 at 15:20

Java.net

479

add a comment |

up vote
1
down vote

favorite

In my HQL i'm using

  queryListBuilder.append(" and f.nom like '%"+ nomFil +"%' ");

nomFil is a string that may contain white spaces between words.
when i send

 http://localhost:8080/list?nom=First Last

I got empty result.
Ps: in my DB the value exists in my target table.
is there any way to handel white spaces in request parameters?

edited Nov 19 at 15:36

asked Nov 19 at 15:20

Java.net

479

In my HQL i'm using

  queryListBuilder.append(" and f.nom like '%"+ nomFil +"%' ");

nomFil is a string that may contain white spaces between words.
when i send

 http://localhost:8080/list?nom=First Last

I got empty result.
Ps: in my DB the value exists in my target table.
is there any way to handel white spaces in request parameters?

java rest spring-boot hql

edited Nov 19 at 15:36

asked Nov 19 at 15:20

Java.net

479

edited Nov 19 at 15:36

asked Nov 19 at 15:20

Java.net

479

edited Nov 19 at 15:36

asked Nov 19 at 15:20

Java.net

479

asked Nov 19 at 15:20

Java.net

479

asked Nov 19 at 15:20

Java.net

479

add a comment |

2 Answers
2

active

oldest

votes

up vote
2
down vote

accepted

You need to encode and decode the query params.

Ref : https://www.baeldung.com/java-url-encoding-decoding

answered Nov 19 at 15:37

Sheetal Mohan Sharma

2,30811522

1

best solution founded Thanks.
– Java.net
Nov 22 at 8:39

add a comment |

up vote
2
down vote

You should encode nomFil if using inside URL,as:

 URLEncoder.encode(nomFil, "UTF-8");

See Percent encoding

Percent-encoding, also known as URL encoding, is a mechanism for encoding information in a Uniform Resource Identifier (URI) under certain circumstances. Although it is known as URL encoding it is, in fact, used more generally within the main Uniform Resource Identifier (URI) set, which includes both Uniform Resource Locator (URL) and Uniform Resource Name (URN). As such, it is also used in the preparation of data of the application/x-www-form-urlencoded media type, as is often used in the submission of HTML form data in HTTP requests.

edited Nov 20 at 6:50

answered Nov 19 at 15:36

user7294900

19.4k93157

add a comment |

Your Answer

StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});

}
});

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53377692%2fhandling-white-spaces-in-request-parameter-in-springboot%23new-answer', 'question_page');
}
);

Post as a guest

Name

Required, but never shown

2 Answers
2

active

oldest

votes

2 Answers
2

active

oldest

votes

up vote
2
down vote

accepted

You need to encode and decode the query params.

Ref : https://www.baeldung.com/java-url-encoding-decoding

answered Nov 19 at 15:37

Sheetal Mohan Sharma

2,30811522

1

best solution founded Thanks.
– Java.net
Nov 22 at 8:39

add a comment |

up vote
2
down vote

accepted

You need to encode and decode the query params.

Ref : https://www.baeldung.com/java-url-encoding-decoding

answered Nov 19 at 15:37

Sheetal Mohan Sharma

2,30811522

1

best solution founded Thanks.
– Java.net
Nov 22 at 8:39

add a comment |

up vote
2
down vote

accepted

You need to encode and decode the query params.

Ref : https://www.baeldung.com/java-url-encoding-decoding

answered Nov 19 at 15:37

Sheetal Mohan Sharma

2,30811522

You need to encode and decode the query params.

Ref : https://www.baeldung.com/java-url-encoding-decoding

answered Nov 19 at 15:37

Sheetal Mohan Sharma

2,30811522

answered Nov 19 at 15:37

Sheetal Mohan Sharma

2,30811522

answered Nov 19 at 15:37

Sheetal Mohan Sharma

2,30811522

answered Nov 19 at 15:37

Sheetal Mohan Sharma

2,30811522

1

best solution founded Thanks.
– Java.net
Nov 22 at 8:39

add a comment |

1

best solution founded Thanks.
– Java.net
Nov 22 at 8:39

best solution founded Thanks.
– Java.net
Nov 22 at 8:39

add a comment |

up vote
2
down vote

You should encode nomFil if using inside URL,as:

 URLEncoder.encode(nomFil, "UTF-8");

See Percent encoding

Percent-encoding, also known as URL encoding, is a mechanism for encoding information in a Uniform Resource Identifier (URI) under certain circumstances. Although it is known as URL encoding it is, in fact, used more generally within the main Uniform Resource Identifier (URI) set, which includes both Uniform Resource Locator (URL) and Uniform Resource Name (URN). As such, it is also used in the preparation of data of the application/x-www-form-urlencoded media type, as is often used in the submission of HTML form data in HTTP requests.

edited Nov 20 at 6:50

answered Nov 19 at 15:36

user7294900

19.4k93157

add a comment |

up vote
2
down vote

You should encode nomFil if using inside URL,as:

 URLEncoder.encode(nomFil, "UTF-8");

See Percent encoding

Percent-encoding, also known as URL encoding, is a mechanism for encoding information in a Uniform Resource Identifier (URI) under certain circumstances. Although it is known as URL encoding it is, in fact, used more generally within the main Uniform Resource Identifier (URI) set, which includes both Uniform Resource Locator (URL) and Uniform Resource Name (URN). As such, it is also used in the preparation of data of the application/x-www-form-urlencoded media type, as is often used in the submission of HTML form data in HTTP requests.

edited Nov 20 at 6:50

answered Nov 19 at 15:36

user7294900

19.4k93157

add a comment |

up vote
2
down vote

You should encode nomFil if using inside URL,as:

 URLEncoder.encode(nomFil, "UTF-8");

See Percent encoding

Percent-encoding, also known as URL encoding, is a mechanism for encoding information in a Uniform Resource Identifier (URI) under certain circumstances. Although it is known as URL encoding it is, in fact, used more generally within the main Uniform Resource Identifier (URI) set, which includes both Uniform Resource Locator (URL) and Uniform Resource Name (URN). As such, it is also used in the preparation of data of the application/x-www-form-urlencoded media type, as is often used in the submission of HTML form data in HTTP requests.

edited Nov 20 at 6:50

answered Nov 19 at 15:36

user7294900

19.4k93157

You should encode nomFil if using inside URL,as:

 URLEncoder.encode(nomFil, "UTF-8");

See Percent encoding

Percent-encoding, also known as URL encoding, is a mechanism for encoding information in a Uniform Resource Identifier (URI) under certain circumstances. Although it is known as URL encoding it is, in fact, used more generally within the main Uniform Resource Identifier (URI) set, which includes both Uniform Resource Locator (URL) and Uniform Resource Name (URN). As such, it is also used in the preparation of data of the application/x-www-form-urlencoded media type, as is often used in the submission of HTML form data in HTTP requests.

edited Nov 20 at 6:50

answered Nov 19 at 15:36

user7294900

19.4k93157

edited Nov 20 at 6:50

answered Nov 19 at 15:36

user7294900

19.4k93157

answered Nov 19 at 15:36

user7294900

19.4k93157

answered Nov 19 at 15:36

user7294900

19.4k93157

add a comment |

draft saved

draft discarded

Thanks for contributing an answer to Stack Overflow!

Please be sure to answer the question. Provide details and share your research!

But avoid …

Asking for help, clarification, or responding to other answers.

Making statements based on opinion; back them up with references or personal experience.

To learn more, see our tips on writing great answers.

Some of your past answers have not been well-received, and you're in danger of being blocked from answering.

Please pay close attention to the following guidance:

Please be sure to answer the question. Provide details and share your research!

But avoid …

Asking for help, clarification, or responding to other answers.

Making statements based on opinion; back them up with references or personal experience.

To learn more, see our tips on writing great answers.

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Name

Required, but never shown

Name

Required, but never shown

This page is only for reference, If you need detailed information, please check here

搜尋此網誌

Nsryjdtyk