mysql - How to make a working SQL query a native query in spring data -

-

i created sql query:

select order_num, stuff2, stuff3 table1 t1 (stuff3 = 'poor') , not exists (select order_num table2 t2 t1.order_num = t2.order_num)

the query works correctly , desired result; however, trying use working query in spring data application native query, using @query annotation. 

@query(value = "select order_num, stuff2, stuff3 table1 t1 (stuff3 = ?0) , not exists (select order_num table2 t2 t1.order_num = t2.order_num)", nativequery = true) list<eorder> findbystuff3(string stuff3);

i copied exact same query , placed in repository (as shown above) value binding null , no records showing. there step missing make query work spring application?

through further research able fix problem having. native query used in repository work, there simple error in code, instead of 0, replaced 1 , worked great!

old version:

@query(value = "select order_num, stuff2, stuff3 table1 t1 (stuff3 = ?0) , not exists (select order_num table2 t2 t1.order_num = t2.order_num)", nativequery = true) list<eorder> findbystuff3(string stuff3);

modified version:

@query(value = "select order_num, stuff2, stuff3 table1 t1 (stuff3 = ?1) , not exists (select order_num table2 t2 t1.order_num = t2.order_num)", nativequery = true) list<eorder> findbystuff3(string stuff3);

i came across method works using jpql able query run in spring application:

@query(value = "select t1.order_num, t1.stuff2, t1.stuff3 table1 t1 (t1.stuff3 = ?0) , not exists (select t2.order_num table2 t2 t1.order_num = t2.order_num)", nativequery = true) list<eorder> findbystuff3(string stuff3);

Comments

Post a Comment

Popular posts from this blog

how to insert data php javascript mysql with multiple array session 2 -

-
i have method method discussed , successful data entered 1 when more 1 can not database this programs my php form : <form class="form-horizontal" id="form-produk"> <div class="control-group" > <label class="control-label" for="kelas">kategori</label> <div class="controls"> <select class='form-control' name='id_kategori'> <?php $tampil=mysql_query("select * kategori order nama_kategori"); if ($id_kat==0){ echo "<option value=0 selected>- pilih kategori -</option>"; } while($w=mysql_fetch_array($tampil)){ if ($id_kat==$w[id_kategori]){ echo "<option value=$w[id_kategori] selected>$w[nama_kategori]</option>"; } else{ echo "<option value=$w[id_kategori]>$...
Read more

multithreading - Exception in Application constructor -

-
i wanna write snake game javafx , there exception don't know , want know how fix it. ( know it's not complete yet ) and want know , class extends application ( start override ) main in other programs? see , here not static void main bc didn't need, if want add main shoud do? it's exeption... exception in application constructor exception in thread "main" java.lang.nosuchmethodexception: main_snake.main([ljava.lang.string;) @ java.lang.class.getmethod(class.java:1819) @ com.intellij.rt.execution.application.appmain.main(appmain.java:125) and code : import javafx.animation.animationtimer; import javafx.application.application; import javafx.event.eventhandler; import javafx.scene.scene; import javafx.scene.canvas.canvas; import javafx.scene.canvas.graphicscontext; import javafx.scene.input.keyevent; import javafx.scene.layout.borderpane; import javafx.scene.paint.color; import javafx.stage.stage; import java.util.arraylist; /** * creat...
Read more

windows - CertCreateCertificateContext returns CRYPT_E_ASN1_BADTAG / 8009310b -

-
i realize similar post others (e.g. this one ), there details missing posts might significant case. to start with, here's simplified program: #include "stdafx.h" #include <windows.h> #include <wincrypt.h> int _tmain(int argc, _tchar* argv[]) { // usage: certextract certpath char keyfile[] = "c:\\certificates\\public.crt"; byte lp[65536]; security_attributes sa; handle hkeyfile; dword bytes; pccert_context certcontext; sa.nlength = sizeof(sa); sa.lpsecuritydescriptor = null; sa.binherithandle = false; hkeyfile = createfile(keyfile, generic_read, file_share_read, &sa, open_existing, file_attribute_normal, null); if (hkeyfile) { if (readfile(hkeyfile, lp, getfilesize(hkeyfile, null), &bytes, null) && bytes > 0) { certcontext = certcreatecertificatecontext(x509_asn_encoding, lp, bytes); if (certcontext) { printf("yay...
Read more