jpa - Alternative namedquery for nativequery -

-

i need change query native-query (named-query or create-query) in jpa.

em = getentitymanager();      string query = "select kcu.table_name information_schema.key_column_usage kcu,information_schema.tables kt " +             "where kcu.referenced_table_name = 'sampletable1' " +             "and kcu.table_schema='sampledatabase' " +             "and kcu.referenced_column_name = 'samplerollnoid' " +             "and kt.table_name = kcu.table_name " +             "and kt.table_rows > 0 " +             "and kt.table_schema = kcu.table_schema";      list tablenamelist = (list) em.createnativequery(query).getresultlist();

this query returns tablenames (the tables names foreign key refer table (sampletable1)).

i got error when change createquery or namedquery.

like

list tablenamelist = (list) em.createquery(query).getresultlist();  or  list tablenamelist = (list) em.createnamedquery(query).getresultlist();

how change query namedquery or createquery. possible?

the following error, when use createquery

------------- standard error ----------------- log4j:warn no appenders found logger     (org.springframework.test.context.junit4.springjunit4classrunner). log4j:warn please initialize log4j system properly.  testcase: testentryinusenamedquery(com.jpasampledaotest):        caused error org.hibernate.hql.ast.querysyntaxexception: information_schema.key_column_usage not mapped  [select kcu.table_name information_schema.key_column_usage kcu,information_schema.tables kt kcu.referenced_table_name = 'sampletable1' , kcu.table_schema='sampledatabase' , kcu.referenced_column_name = 'samplerollnoid' , kt.table_name = kcu.table_name , kt.table_rows > 0 , kt.table_schema = kcu.table_schema]  java.lang.illegalargumentexception: org.hibernate.hql.ast.querysyntaxexception: information_schema.key_column_usage not mapped [select kcu.table_name information_schema.key_column_usage kcu,information_schema.tables kt kcu.referenced_table_name = 'sampletable1' , kcu.table_schema='sampledatabase' , kcu.referenced_column_name = 'samplerollnoid' , kt.table_name = kcu.table_name , kt.table_rows > 0 , kt.table_schema = kcu.table_schema]     @ org.hibernate.ejb.abstractentitymanagerimpl.throwpersistenceexception(abstractentitymanagerimpl.java:624)     @ org.hibernate.ejb.abstractentitymanagerimpl.createquery(abstractentitymanagerimpl.java:96)     @ org.springframework.orm.jpa.sharedentitymanagercreator$sharedentitymanagerinvocationhandler.invoke(sharedentitymanagercreator.java:193)     @ $proxy27.createquery(unknown source)  @ org.springframework.test.context.junit4.springtestmethod.invoke(springtestmethod.java:198)     @ org.springframework.test.context.junit4.springmethodroadie.runtestmethod(springmethodroadie.java:274)     @ org.springframework.test.context.junit4.springmethodroadie$2.run(springmethodroadie.java:207)     @ org.springframework.test.context.junit4.springmethodroadie.runbeforesthentestthenafters(springmethodroadie.java:254)     @ org.springframework.test.context.junit4.springmethodroadie.runwithrepetitions(springmethodroadie.java:234)     @ org.springframework.test.context.junit4.springmethodroadie.runtest(springmethodroadie.java:204)     @ org.springframework.test.context.junit4.springmethodroadie.run(springmethodroadie.java:146)     @ org.springframework.test.context.junit4.springjunit4classrunner.invoketestmethod(springjunit4classrunner.java:151)  caused by: org.hibernate.hql.ast.querysyntaxexception: information_schema.key_column_usage not mapped [select kcu.table_name information_schema.key_column_usage kcu,information_schema.tables kt kcu.referenced_table_name = 'sampletable1' , kcu.table_schema='sampledatabase' , kcu.referenced_column_name = 'samplerollnoid' , kt.table_name = kcu.table_name , kt.table_rows > 0 , kt.table_schema = kcu.table_schema]     @ org.hibernate.hql.ast.util.sessionfactoryhelper.requireclasspersister(sessionfactoryhelper.java:158)     @ org.hibernate.hql.ast.tree.fromelementfactory.addfromelement(fromelementfactory.java:87)     @ org.hibernate.hql.ast.tree.fromclause.addfromelement(fromclause.java:70)     @ org.hibernate.hql.ast.hqlsqlwalker.createfromelement(hqlsqlwalker.java:255)     @ org.hibernate.hql.antlr.hqlsqlbasewalker.fromelement(hqlsqlbasewalker.java:3056)     @ org.hibernate.hql.antlr.hqlsqlbasewalker.fromelementlist(hqlsqlbasewalker.java:2945)     @ org.hibernate.hql.antlr.hqlsqlbasewalker.fromclause(hqlsqlbasewalker.java:688)     @ org.hibernate.hql.antlr.hqlsqlbasewalker.query(hqlsqlbasewalker.java:544)     @ org.hibernate.hql.antlr.hqlsqlbasewalker.selectstatement(hqlsqlbasewalker.java:281)     @ org.hibernate.hql.antlr.hqlsqlbasewalker.statement(hqlsqlbasewalker.java:229)     @ org.hibernate.hql.ast.querytranslatorimpl.analyze(querytranslatorimpl.java:228)     @ org.hibernate.hql.ast.querytranslatorimpl.docompile(querytranslatorimpl.java:160)     @ org.hibernate.hql.ast.querytranslatorimpl.compile(querytranslatorimpl.java:111)     @ org.hibernate.engine.query.hqlqueryplan.<init>(hqlqueryplan.java:77)     @ org.hibernate.engine.query.hqlqueryplan.<init>(hqlqueryplan.java:56)     @ org.hibernate.engine.query.queryplancache.gethqlqueryplan(queryplancache.java:72)     @ org.hibernate.impl.abstractsessionimpl.gethqlqueryplan(abstractsessionimpl.java:133)     @ org.hibernate.impl.abstractsessionimpl.createquery(abstractsessionimpl.java:112)     @ org.hibernate.impl.sessionimpl.createquery(sessionimpl.java:1623)     @ org.hibernate.ejb.abstractentitymanagerimpl.createquery(abstractentitymanagerimpl.java:93)

help me, in advance.

use jpql on sql. in jpql refer entities rather tables , properties rather columns.

use em.createquery() execute jpql query. em.createnamedquery() different purposes.


Comments

Post a Comment

Popular posts from this blog

c# - SVN Error : "svnadmin: E205000: Too many arguments" -

-
i trying reposotries using c# code process svncommand = null; var psi = new processstartinfo("svnadmin"); psi.redirectstandardoutput = true; psi.redirectstandarderror = true; psi.useshellexecute = false; psi.arguments= @"dump c:\repositories\myrepo > c:\temp\myrepodumpfile.dump"; using (svncommand = process.start(psi)) { var myoutput = svncommand.standardoutput; var myerror = svncommand.standarderror; debug.write("output :" + environment.newline + environment.newline + myoutput.readtoend() + environment.newline + "error :" + environment.newline + environment.newline + myerror.readtoend()); svncommand.close(); } when use dump command commandline svnadmin dump c:\repositories\myrepo > c:\temp\myrepodumpfile.dump it works fine when try ...
Read more

c++ - Using OpenSSL in a multi-threaded application -

-
i have been writing soap client application in c++ on ubuntu using openssl https transport , pthreads threading. have number of threads - 1 central data acquisition thread periodically gets worker threads make soap requests via shared mutex protected queues. reading documentation openssl found is openssl thread-safe? in openssl faq describes mechanisms required ensure thread safety when using openssl. implemented , works fine. the reason question conceptual difficulty really. thinking implementing same functionality application has already, instead of using threads, create 2 seperate applications : 1 worker thread (of multiple copies running) , main data acquisition thread. use tcp sockets communicate between 2 rather mutex protected queues. may bad idea not important - confusing me would have implement same functions required ensure openssl thread safety in second approach or not? my guess not have , treated independent (indeed surely must many applications use openssl) re...
Read more

All overlapping substrings matching a java regex -

-
is there api method returns (possibly overlapping) substrings match regular expression? for example, have text string: string t = 04/31 412-555-1235; , , have pattern: pattern p = new pattern("\\d\\d+"); matches strings of 2 or more characters. the matches are: 04, 31, 412, 555, 1235. how overlapping matches? i want code return: 04, 31, 41, 412, 12, 55, 555, 55, 12, 123, 1235, 23, 235, 35. theoretically should possible -- there obvious o(n^2) algorithm enumerates , checks substrings against pattern. edit rather enumerating substrings, safer use region(int start, int end) method in matcher . checking pattern against separate, extracted substring might change result of match (e.g. if there non-capturing group or word boundary check @ start/end of pattern). edit 2 actually, it's unclear whether region() expect zero-width matches. specification vague, , experiments yield disappointing results. for example: string line = "xx90xx"; strin...
Read more