java - jpql left join fetch not returning results for like -

-

Text after "itemprop =" text ">

In a app using a Spring MVC Hibernate and MySQL, I've written the following query method to return a list of names with patients To: 

  @SuppressWarnings ("uncheck") public collection & lt; Person & gt; FindPersonByLastName (string ln) throws DataAccessException {query query = this.em.createQuery ("DISTINCT person joining rimPerson person to pers.names n.m. ou nm.family choose to leave from like: LNM"); Query.setParameter ("LN", LN); Return query.getResultList (); }

This is used to produce the following hibernate SQL: 

  Select specific person0_.hppid as hibernate: hppid1_340_0_, names1_.HJID HJID1_89_1_, as as person0_2_.classCode_HJID classCod2_339_0_, administ2_341_0_ as person0_1_.administrativeGenderCode_HJID, birthTim3_341_0_, DELIMITE2_89_1_ as names1_.DELIMITER_, FAMILY3_89_1_ as names1_.FAMILY, named5_89_1_ as names1_.named_entity_hppid, SUFFIX4_89_1_ as names1_.SUFFIX, name9_340_0__ as names1_.name_entity_HJID, names1_ .HJID as HJID1_89_0__ as person0_1_.birthTime_HJID Rim_person person0_Internal rim_living_subject person0_1_ on person0_.hppid = person0_1_.hppid Ntrik include rim_entity person0_2_ person0_.hppid = person0_2_.hppid internal included rim_infrastructure_root Wykti0_3_ person0_.hppid = person0_3_.hppid left outer join N name 1_ person0_.hppid = names1_. Name_entity_HJID where like names1_.FAMILY?

When I call the above JPQL method with the following command, it returns zero results: 

  this.myappService.findPersonByLastName ("");

When I give the above generated hibernate code in the MySQL command line client and give it past, I get zero results and ? to code>.

If, however, i where names1_.FAMILY? Above the hibernate generated SQL and the small SQL place in the MySQL command line client, I have four results, each for the last name field value.

How can I change JPQL so that it generates a hibernate query that returns four results when `` the empty string parameter is passed as? I want to include the results set to give every result when the user returns empty input, but to give filtered results when the user types in any text input.

The typical reason is that like fails to do that It looks like this should be forgotten to put wildcards in the pattern string. For example, if you want to match all the usernames starting with 'Code', then you have to do something like 'code%', such as 'code%' , no name 'code' / Code>. Code> this.myappService.findPersonByLastName ("%");

This is cute for inserting the findPersionByLastName caller in the % wildcard. For a better implementation the caller has to specify which name they are looking for, and then the code is created in which the wildcard was placed in the right place. When you are looking for the last name, you can do something like this: 

  query.setParameter ("lnm", "%" + ln);

This will match anything that ends with the parameter that has passed the method.


Comments

Post a Comment

Popular posts from this blog

apache - 504 Gateway Time-out The server didn't respond in time. How to fix it? -

-
Using a form submission on an embedded iframe , the customer downloads a compressed log file Requested. The request was sent to the server, which is the compressed log files, perform some database operations and returns a compressed file. After just 2 minutes, 504 gateway time-out server did not respond timely message on browser net panel How to fix this error? The log files were taking a long time to compress, and timeout was set to 2min The error was fixed by extending the file file: # # timeout: The number of seconds before getting the time out. # # # Timeout 120 timeout 600
Read more

c# - .net WebSocket: CloseOutputAsync vs CloseAsync -

-
We have a working ASP.NET Web API REST service, which is one of the methods of our controller, HTTPTTEX. .) Socket handler code looks something like this ... Public async task socket handler (AspNetWebSocketContext context) {_webSocket = context.WebSocket; ... while (! Cts.IsCancellationRequested) {WebSocketReceiveResult Results = _webSocket.ReceiveAsync (Input Segment, cts.Token) .Result; WebSocketsStateCollusocketState = _webSocket.State; If (result.MessageType == WebSocketMessageType.Close || currentSocketState == WebSocketState.CloseReceived) {// What should I use. CloseAysnc () or. CloseOutputAsync ()? _webSocket.CloseOutputAsync (WebSocketCloseStatus.NormalClosure, "Client Requested", cts.Token). Wait (); } If (currentSocketState == WebSocketState.Open) {...}}} .What is the difference between .CooseAsync () and CloseOutputAysnc ()? I tried both of them and they both seemed to work fine but some difference should be the same they both describe very similar to...
Read more

c++ - How to properly scale qgroupbox title with stylesheet for high resolution display? -

-
I am trying to apply a stylesheet for QGroupBox (QT4.8), which works on the normal screen ( 96 dpi) high resolution screen (Yoga 2 Pro, 3200x1800, 275 dpi, windows 8.1). The following style looks good on the 275 dpi screen, but the top margins on a regular 96 dpi screen are far too big. QGroupBox {border: 1px solid red; Range radius: 7px; Margin-top: 12x; } QGroupBox :: Title {subcontrol-origin: margin; Subcontrol-position: left above; Padding-left: 10px; Padding-right: 10px; } Changing the top-margin has an effect, but I did not get a proper setting which works on both screens. If I shorten the value, the content of the group box overlaps with the title on 275 dpi screen. I was also playing with units "East", "PX", "MX", "PT". Reading the document I would have guessed, "2 X" was the correct solution, which should be scaled with different screen resolutions. Without the stylesheet, the groupbox works well on both screens. ...
Read more