Search DaniWeb - hql

(HQL).hbm.xml vs. SQL 16 Years Ago by ceyesuma … someone help me get these xmls to produce this SQL(HQL)? This is how I represented the Instructor.class Instructor.hbm… someone help me get those xmls to produce this SQL(HQL)? HQL query in JAVA 15 Years Ago by oldSoftDev hi I am working on HQL queries and writing an application in Java it is just … database. But I am having troubles with displaying result using HQL queries. /** * Displays a report listing all companies that have no… Hql join query 14 Years Ago by _aGt_ … please help me to translate this mysql query to its hql counterpart. select TRANSACTION_RECORD.BOOK_TYPE,TRANSACTION_RECORD.ID, TRANSACTION_RECORD.RECORD_DATE, TRANSACTION_ACCOUNTS.ACCOUNT_NAME… Re: HQL query difficulties 12 Years Ago by bibiki … your reply. This is how I am filtering: String builder hql = new StringBuilder().append("SELECT business FROM ").append(Customer…; WHERE created >=:created"); Query tempQuery = getSessionFactory().getCurrentSession().createQuery(hql.toString()).setParameter("created", new Date(new Date().getTime… Re: HQL query difficulties 12 Years Ago by IIM … my system and help you to solve this. String builder hql = new StringBuilder().append("SELECT c.business FROM Customer c… c.created >=:created"); Query tempQuery = getSessionFactory().getCurrentSession().createQuery(hql.toString()).setDate("created", new Date(new Date().getTime… Re: HQL query difficulties 12 Years Ago by IIM … using i can't help. For reference for filter in HQL read http://docs.jboss.org/hibernate/orm/3.3/reference… problem with displaying data from hql query 16 Years Ago by omesanni … am having a with problem displaying the contents of the hql query from the database. Basically I created entity classes for… how I can retrieve the data from a list of hql query please help me about Are hql.exe nvmqi.exe faxshell.exe suspect? 14 Years Ago by boute After startup, the processes mstask.exe, system.exe, hql.exe, nvmqi.exe and faxshellm.exe initially take 99% CPU time, after a few minutes faxshellm.exe alone takes 99% and keeps doing so until stopped. About nvmqi.exe and faxshellm.exe there seems to be no info on the web. Is malware involved? another HQL statement question 11 Years Ago by bibiki … managed to write the query and have something returned for hql is: select max(T.merchant), count(T.merchant) from Transaction… Re: HQL query in JAVA 15 Years Ago by oldSoftDev [code] /** * Displays a report listing all companies that have no departments. */ public void displayCompaniesWithoutDepartments() { System.out.println("---- All Companies Without Departments ----"); Session session = sessions.getCurrentSession(); session.beginTransaction(); Query q = session.createQuery("… HQL query difficulties 12 Years Ago by bibiki hey there, I have two classes with a one-to-many relationship. For ilustration: public class Customer { Business business; Date created; } public class Business { } Now, when I do the following: new StringBuilder().append("SELECT business FROM ").append(Customer.class.getName())… Re: HQL query difficulties 12 Years Ago by bibiki hey IIM, thank you very much. That worked perfectly fine. I have been trying to do this two days now but I couldn't figure out why it wouldn't work. thanks again. I'm marking this thread as solved. Re: problem with displaying data from hql query 16 Years Ago by ~s.o.s~ Simply put, the list returned by the `findFlights' method seems to return a list of Object arrays rather than a list of FlightItenary. Don't mix and match type safe code with non-type safe code; either use generics all the way through or don't use it at all [not recommended]. Try to debug the `findFlights' to see what exactly is it returning. Re: Are hql.exe nvmqi.exe faxshell.exe suspect? 14 Years Ago by Rik_ I would suspect malware! Problem is you have told us absolutely nothing about your PC. What windows version are you using and what protective software have you got? Re: Are hql.exe nvmqi.exe faxshell.exe suspect? 14 Years Ago by boute Thanks for your willingness to help. PC: old Compaq; Windows: 2000. Protective software: formerly service provider's own (Telenet), recently ESET NOD32. File faxshellm.exe is a hidden protected operating systems file in C:\WINNT\System32. Scan by NOD32 yields for faxshellm.exe a message: "error - could not open file". Attempt at manual … Re: Are hql.exe nvmqi.exe faxshell.exe suspect? 14 Years Ago by Rik_ Download MBAM, update it, and run a full scan with it and see if that has any effect. Google will find it! Re: Are hql.exe nvmqi.exe faxshell.exe suspect? 14 Years Ago by boute [QUOTE=Rik from RCE;1426627]Download MBAM, update it, and run a full scan with it and see if that has any effect. Google will find it![/QUOTE] MBAM solved the malware problem and the resulting registry issues underlying a different problem (drag and drop not working) within a few minutes. Quite amazing. Thank you for your help. Re: Are hql.exe nvmqi.exe faxshell.exe suspect? 14 Years Ago by Rik_ No problem at all! Glad my idea worked! :) help me - An Hibernate error 18 Years Ago by rahul_sharma …COLOR] [COLOR=#000000] at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)[/COLOR]…COLOR] [COLOR=#000000] at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)[/COLOR]…COLOR] [COLOR=#000000] at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)[/COLOR… Implementing Entity Lifecycle via Hibernate Filters 13 Years Ago by petr.hribal …lastUpdate DESC"; Query q = getSession().createQuery(hql) .setFirstResult(page) .setMaxResults(length); @SuppressWarnings(&… = :messageid"; Query q = getSession().createQuery(hql) .setString("relationType", RelationTypeEnum.SUBMESSAGE) .setFirstResult… "org.hibernate.Session" ClassNotFoundException 15 Years Ago by talha06 ….openSession(); Transaction transaction = session.beginTransaction(); String hql = "from Kisi"; Query query = session.createQuery(hql); List<Kisi> list = query… Hibernate 15 Years Ago by Danny_501 … org.hibernate.cfg.SettingsFactory createQueryTranslatorFactory INFO: Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory 12/04/2010 9:50:26 AM org….hibernate.hql.ast.ASTQueryTranslatorFactory <init> INFO: Using ASTQueryTranslatorFactory 12/04… Problems with hibernate and mysql? 14 Years Ago by beckveg ….hibernate.cfg.SettingsFactory createQueryTranslatorFac tory INFO: Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory 9/05/2010 02:02:00 PM org….hibernate.hql.ast.ASTQueryTranslatorFactory <init> INFO: Using ASTQueryTranslatorFactory 9/05… hibernate session.save(object) is not inserting a row in the database 11 Years Ago by vijaya436 … org.hibernate.cfg.SettingsFactory createQueryTranslatorFactory INFO: Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory Nov 29, 2013 10:37:55 AM org….hibernate.hql.ast.ASTQueryTranslatorFactory <init> INFO: Using ASTQueryTranslatorFactory Nov 29… how to merge two files using python 7 Years Ago by manyatha …,name string) location 'hadfs:.../'; these two files stored under file1.hql create external table db.emp1(id int,name string) row…,name string) location 'hadfs:.../'; These two files stored under file2.hql and so on Re: Multiple Select in Left Join 15 Years Ago by masijade …;='2009-01-31' (+)[/code] Edit: Although I don't know HQL, at all, I am assuming it is one of the… should still understand basic SQL. I'll probably look into HQL, to find out what it [i]really[/i] is, but… hibernate mapping classes 16 Years Ago by ceyesuma is this true? hql use xml to create results that hibernate can use. Simialar … Hibernate query eyception 16 Years Ago by dav555 … uc.carid = y.cid where uc.userid = :inuserid] org.hibernate.hql.classic.FromParser.token(FromParser.java:106)[/CODE] Multiple Select in Left Join 15 Years Ago by onsir … null null I004 null null null [/code] how convert to HQL Thanks AST node exception 14 Years Ago by sureshksk … pcs.productSubcatName=kitchen and diet]; nested exception is org.hibernate.hql.ast.QuerySyntaxException: unexpected AST node: diet near line 1, column…