java - How to use CONCAT_WS() in Hibernate HQL -

-

एकाधिक स्तंभों को एक के रूप में संयोजित करने के लिए, 

  SELECT id, CONCAT_WS (',', Field_1, field_2, field_3, field_4) `तालिका` से सूची;   
 यह क्वेरी SQL में ठीक काम करती है लेकिन यह मुझे HQL में त्रुटि देता है: 
 त्रुटि है  
 (java.lang.IllegalStateException: नोड के लिए कोई डेटा प्रकार: org.hibernate.hql.internal.ast.tree.MethodNode)  
 मेरी मदद कृपया क्या गलत पता लगाने के लिए मैं पता करने के लिए किया था, मेरी मदद करो  
 नीचे HQL में CONCAT_WS () का उपयोग करने के लिए कैसे कैसे मैं अपने HQL क्वेरी लिखा  
  का चयन करें C1._URI, C1.HEALTH_FACILITY, C1.DISTRICT , CONCAT_WS ( ',', C1.BLOCKS_OF_BHUBRI, C1.BLOCKS_OF_GOLAGHAT, C1.BLOCKS_OF_HAILAKANDI) Block_name रूप GapAnalysisWashInHealthFacilitiesCore सी 1 से   
 किसी भी मदद   
 सराहना करेंगे 
 
  CONCAT_WS  मेरे एसक्यूएल के लिए विशिष्ट फ़ंक्शन है HQL एक सामान्य भाषा है और मूल एसक्यूएल फ़ंक्शंस और सिंटैक्स से अवगत नहीं है। यदि आपको वास्तव में फ़ंक्शन की आवश्यकता है, तो आपको स्थानीय SQL के लिए हाइबरनेट के एपीआई का उपयोग करना चाहिए।  
  सत्र सत्र = ...; क्वेरी क्वेरी = session.createSQLQuery ("SELECT id, CONCAT_WS (',', field_1, field_2, field_3, फ़ील्ड_4)` तालिका` से ब्लॉक_नाम;); सूची परिणाम = query.list ();   
 फिर आप  GapAnalysisWashInHealthFacilitiesCore  ऑब्जेक्ट की सूची के रूप में परिणाम प्राप्त करना चाह सकते हैं।

Comments

Post a Comment

Popular posts from this blog

xml - Complex xPath query with getNodeSet in R -

-
I have an XML file downloaded from the uniprot protein database. Protein & lt; - XmlRoot (xmlTreeParse ("http://www.uniprot.org/uniprot/Q01974.xml")) From the many annotated features, I am interested in starting and ending the following Keynes domain stored in the xml node: & lt; Feature type = "domain" description = "protein keyrings" & gt; & Lt; Location & gt; & Lt; Starting position = "288" /> & Lt; End position = "539" /> & Lt; / Location & gt; & Lt; / Feature & gt; With GetNodeSet, I can find out this tag well: getNodeSet (Protein, "// uniprot: feature [@type = \" domain \ "and @ description = \" Unfortunately, I could not reduce the query, except for any other criteria. Example: GetNodeSet (Protein, "// Uniprot: Feature [@ type = \" domain \ "and @ description = \" protein keynes \ "] / location" , C (Uniprote =
Read more

vbscript - Delete registry folder and sub folder using VBS -

-
I want to delete the registry folder and sub-folder by using this vb script. In the reg file we can do the script as below: [- HKEY_LOCAL_MACHINE \ software \ abc \ prr] Under the script above, will delete sub folder How can one get the same using a VB script? I tried to use .RegDelete but I think it only works for the key and not for the registry folder. Thank you. [path] RegDelete [key] | [Value] The Path Path (hence Windows can find it) to download the paths Windows 98 Tips and tips on hacks pages to see Windows always find it. Do not start RegDelete with any user interface, or do not close key or values ​​in the inverted commas while typing the value to delete or delete. Key key to delete key always ends in a backslash if the key has a space then it must be attached in reverse coma. Keys and subkeys will be removed. Value Deletion value values ​​do not have a backslash at the back. If the key has a location then it should be enclosed in reverse comm
Read more

multithreading - PhantomJS-Node in a for Loop -

-
I am trying to implement a screen-scraps application that opens a URL in which a parameter changes as it is for a loop: var data = [ '100', '101', '102', '103', '104']; (Var indexA = 0; indexA & lt; data.length; indexA ++) for {Phantom Generation ({'port': freeport}, function (pH) {ph.create page (function (page) {page.open ("http: //...++ data [index B] +" ... " , Status {console.log ("open site:" + data [index B], position); / * OLD * / indexB ++; page evaluation (function () {// page scrape and an object Return}, function {console.log (result.dataRequest); // here is the problem}); / * new and fixed * / indexB ++} first console Logs it: Open Site: 100 Success Opens Site: 101 Success B Ola Site: 102 Success Opening Site: 103 Success Opened Site: 104 Success Which is good. Data is verified in scrap HTML and from index to array Matches. So in page 101 I scrap '101 and retrieve' and pu
Read more