java - Hibernate HQL strange behavior with IS NULL -


I want to get the problem with a HQL query I all PID do that 'M' or an administrative Sex There is an administrative sex set for Java (the value in Java is set to zero).

PID.class 

  @ Antiti @ Table (name = "Patient Identification") public class PID {@OneToOne (cascade = CascadeType.ALL) @JoinColumn (name = "Administrative SX", referenced columnname = "is_id") personal IS administrative SX; ...}   GenerationType.AUTO) @column (name = "is_id") private integer ID; Private string value; ...}

HQL query 

  PID where administrativeSex empty or administrative Sakskvlu = 'M'

produced SQL 

  pid0_.pid_id the pid1_84_, pid0_.administrativeSex as adminis11_84_, pid0_.birthOrder birthOrder84_, pid0_.birth Place as birthPlace84_, pid0_ citizen as citizenship 12_84_, pid0_.countyCode, as pid0_.datTimeOfBirth, driverL22_84_ as pid0_.driverLicenseNumber, maritalS8_84_, multiple4_84_pid0_.multipleBirthIndicator, nationa17_84_ as pid0_.nationality as pid0_.maritalStatus, pid0_.patientAccountNumber patientA6_84_, patient16_84_ form, as pid0_.countyCode countyCode84_, dateTim19_84_ Pid0_.patientDea ThDateAndTime form owner9_84_pid0_.owner_id, Pid0_.patientDeathIndicator as patient18_84_, pid0_.patientId as patientId84_, pid0_.primary as primary language_7_84_, pid0_.race race84_, pid0_.religion as religion_84_, pid0_.setId setId84_, pid0_.ssnNumber As ssnNumber84_, pi D0_.veteransMilitaryStatus as Veterans2_84_ as the brain identification pid0_, CodedValueForUserDefinedTables is1_ where pid0_.administrativeSex = is1_.is_id and (pid0_.sministrativeSex is zero or is1_.value = 'M')

The query is only return PID, which is set on the administrative sex 'M', it is missing in it which is not administrative gender. If you look at SQL queries, then this is normal. How can I fix my HQL query?

Hibernate reference guide:

Two join Ackyuel Association Supports forms: Built-in and clear.

All use the clear form in the questions shown in the previous section, i.e., where the included keyword is clearly used in the clause. This is a recommended form.

Does not use keywords included in the underlying form. Instead, the associations have been "dereferenced" using dot-notation. Inherent included in any HQL sections may appear. The resulting SQL statement gives inherent results in interlinking.

Since these attachments do not match, one of those internal lines contains the intern, you do not remember the people of the unknown gender. If you want a left external insertion, which do you request: PID PID contains 

  left external pin. Leave the administrative sex as sex where pid.administrativeSex is zero or gender. Value = 'm'

-

Comments

Post a Comment

Popular posts from this blog

Eclipse CDT variable colors in editor -

I hope this is a good question to ask here. This programming is related, so I thought it would be better than the superuser, so I am using the CDT C ++ Eclipse plugin. I know how the editor changes colors for some things But is there a way to do that all the variables are different colors? For example in KDEValue, it sets the local variables and square variables in different colors and bold square squares. Can I copy it to CDT? Eclips provides some level of color customization for text editor syntax You can see it on the following: There are many elements, including the Window> Preferences> C / C ++> Editor> Syntax color code that can be changed, assembly, Comments, Preprocessor and Doxian Under the code, it is possible to change the color of some variable types, such as global variables, local variable announcements, local variable references, and parameter variables. But I do not think the code is capable of changing the color of each variable declared....
Read more

AJAX doesn't send POST query -

$ (दस्तावेज़) .ready (function () {function ajaxselectrss (rssurlvar) {var ajaxRequest; // वेरिएबल जो अजाक्स को संभव बनाता है! कोशिश करें कि {// ओपेरा 8.0+, फ़ायरफ़ॉक्स, सफारी अजाक्स अनुरोध} = नया एक्सएमएलएचटीपीआरइवेस्ट ();} कैच (ई) {// इंटरनेट एक्सप्लोरर ब्राउज़र्स {ajaxRequest = new ActiveXObject ("Msxml2.XMLHTTP");} पकड़ो (ई) {try {ajaxRequest = new ActiveXObject ("Microsoft.XMLHTTP");} कैच (ई) {// कुछ गलत चेतावनी ("आपका ब्राउज़र तोड़ दिया!"); वापसी झूठी;}}} // एक बनाएं फ़ंक्शन जो सर्वर से भेजे गए डेटा प्राप्त करेंगे ajaxRequest.onreadystatechange = function () {if (ajaxRequest.readyState == 4) {var ajaxDisplay = document.getElementById ('news'); ajaxDisplay.innerHTML = ajaxRequest.responseText;}} / / Var rssurlvar = $ (this) .attr ("title"); var queryString = "rurl =" + rssurlvar; var urltofile = "rssget.php"; ajaxRequest.open ("पोस्ट", urltofile, सच); ajaxRequ Est.setRequestHeader ("सामग्री-प्र...
Read more

wpf - Custom Message Box Advice -

Well, I'm using a custom window box that comes with some custom control boxes that accompany the text The producers who are displayed are called. I have a defined event, which has been subscribed through the original class, it gets burnt when clicking on the button. However, I can not see how to use it effectively, I would like to return one yes, whether yes or not, but obviously my code will continue to execute, so this Below is some example code to clarify the problem that the method has subscibed by clicking on the button. Message box window Public partial class custom message box: window {public representative message messagebox object sender, event events e); Public event messagebox handler messagebox document; Public Customs Box () {Initial group (); } Public Customsbox (String Message) {InitializeComponent (); This.txtdescription.Text = Message; } Public Customsbox (String Message, String Title, String First BTNtext) {Initialization (); This.lbltitle.Content =...
Read more