1. Ingres proble during a query... forum.hibernate.orgNewbie Joined: Tue Oct 11, 2005 10:57 am Posts: 13 Hi. I had the folowing problem during a quering in Ingres 3.0.2: "Request to retrieve BLOB column which had already been accessed. BLOB columns may only be accessed once." But I dont have any BLOB field in my table!!! This is the query constructed by Hibernate: Code: select this_.curId as curId0_, ... |
2. query construction forum.hibernate.orgYou're talking about result sets as though you're dealing with JDBC statements. There's no way to understand from your description what you really want. I suggest you study Chapter 7 "Collection Mapping" from the Hibernate reference, and then search out references to the term "parent-child". It's a fairly standard Hibernate pattern, and has nothing to do with result sets. Hope that ... |
3. Query : strange behaviour forum.hibernate.org |
4. how to stop outter query ? forum.hibernate.orgThis has got to be my most-frequently-asked question, recently :) Hibernate is aware that all rows in Resource might be ManagedResources. Any instances of ManagedResource MUST be loaded with all columns from both tables. Polymorphism requires this: a ManagedResource with only its Resource values is not a ManagedResource. Therefore, all Resources will always be loaded with that outer join, in case ... |
5. Querying on existence in a set forum.hibernate.orgHi all, I've read various old threads about how to do this in Hibernate, but I'm just making sure. I have a Group objects, which contains a member Set of User objects, named memberUsers. I want to build a Criteria-based query that returns all Group objects whose memberUsers Set contains a given User. By what I've been reading, my query function ... |
6. could not execute query forum.hibernate.orgList list = session.createSQLQuery(query.toString()) .addScalar("NAME_ID", Hibernate.INT) .addScalar("TYPE", Hibernate.INT) ... |
7. Seeking Query Assistance forum.hibernate.orgHibernate 3.0 I have been able to run simple queries using hql on single databases. Today I have my first join and I am a bit lost. I have two tables. User and Password. When a user logs into my site, I grab the username and password, and populate a bean called UserObject with the username, and password. I want to ... |
8. Queries forum.hibernate.orgHello! I have two questions about Hibernate quering. 1) Suppose I have some entity "ent" with collections "col1" of "ent1", "col2" of "ent2". Both "ent1" and "ent2" have "name" attribute. Both are mapped as "lazy". So, I need to retrive "ent" where in "col1" entities restricted by some "name". I am using something like "from ent as e left join fetch ... |
9. Hibernate Query.. forum.hibernate.orghttp://www.javalobby.org/articles/hibernate-query-101 Has some examples of what I think you are trying to do.. I found this to be an excellent article. I am new to hibernate but this article shows several methods for accessing multiple object (tables if you will). Also for a good article on different ways to map object you could look at http://www-128.ibm.com/developerworks/java/library/j-hibernate/ I hope that this give ... |
10. more info in queries forum.hibernate.orgthis is my complete log config, in our company we use this in each project during programming, testing and deployed-testing log4j.rootLogger=DEBUG, stdout, file log4j.appender.file=org.apache.log4j.RollingFileAppender log4j.appender.file.File=../logs/logfile.log log4j.appender.file.MaxFileSize=5000KB log4j.appender.file.MaxBackupIndex=1 log4j.appender.file.layout=org.apache.log4j.PatternLayout #log4j.appender.file.layout.ConversionPattern=%-4r [%t] %-5p %c %x - %m%n log4j.appender.file.layout.ConversionPattern=%d{ABSOLUTE} %5p %c{1}:%L - %m%n #debug output wat beperken log4j.logger.com.sun=ERROR log4j.logger.org=ERROR log4j.logger.httpclient.wire=ERROR ### direct log messages to stdout ### log4j.appender.stdout=org.apache.log4j.ConsoleAppender log4j.appender.stdout.Target=System.out log4j.appender.stdout.layout=org.apache.log4j.PatternLayout log4j.appender.stdout.layout.ConversionPattern=%d{ABSOLUTE} %5p %c{1}:%L - ... |
11. Eager Query-All forum.hibernate.org |
12. Hibernate query and Javabeans forum.hibernate.org |
13. Create Hibernate Query for many-to-many forum.hibernate.orgIts a simple question, I'm sure. I just not so familiar with db queries. I have the following classes: class SRLG { Long id; Collection links @ManyToMany(cascade = {CascadeType.PERSIST, CascadeType.MERGE}) Collection getLinks() } class Link { Long id; String name; } I want to create a hibernate query that return all the SRLGs that contain a certain link. (I got the ... |
14. I'm sure there is a better way to write my query forum.hibernate.orgHi all, I've got a query (that work) but that I found ugly because not the "hibernate" way. It's a mix between hql and Oracle functions .... Can somebody show me the way to write it the proper way ? (Criteria or full hql, I prefer criterias ;) ). I didn't manage to do it an other way. here's the query: ... |
15. Hierarchical Query forum.hibernate.orgThanks for the reply but that's not a hierarchical query. You get the results for each PopulationCenter but i need something like, the sum of car accidents in states. It means the sum for the cities and counties will be added to the sum of their parent state. I fetched the results with a query like, select ID from T_POPULATION_CENTER start ... |
16. Querying in the background without a View forum.hibernate.orgIm using hibernate using spring framework. I was successful in implementing it in servlet.xml using MVC. I was able to successful transact hibernate queries using a View. My question is, how do you implement hibernate without a view? How do you create the interceptor to capture the hibernate transaction without a view? My project is that I am creating a print ... |
17. Query.SetParameterList forum.hibernate.org |
18. CompositeID Query.. forum.hibernate.org |
19. What is the most effective way to do a many-to-many query? forum.hibernate.org |
20. n:m create Query forum.hibernate.orgHi! I have a (for an advanced user shurley easy) question. I have two classes User and Project. Every User has a list of Projects. They are n:m mapped. To find all Users of a specific Project is no Problem, I do this with list = session.createQuery("from User1 where projectList.id="+p.getId()).list(); where p is a given Project. But how can I get ... |
21. Best practice querying forum.hibernate.orgHi, I'm rather new to hibernate (i know how to use it, but no deeper understandings of the mechanics) and have run into a problem. I have the problem that I'm not sure what gives the best performance of either retrieving whole objects/tables from the database or only retrieving the specific columns that are required for a specific piece of functionality. ... |
22. What's wrong with this query? forum.hibernate.orgI having problem with HQL queries that require JOINS in my application. If I try and access a property of the class I have no problem ie. select ip from IntellectualProperty as ip WHERE ip.status.id = 2 ORDER BY ip.title but when I try to join classes together I get not results what so ever. ie. select ip from IntellectualProperty as ... |
23. Query woes - determined but struggling forum.hibernate.org(2) SEARCHING FOR OBJECT(s): Now imagine theres a webpage that allows you to search any of those fields. Lets say a person enters "Boston Terrier" in the breed textfield and clicks search. I want a list of all the rescue centers that have that breed with their associated vet, vet_note, pets (all of them), and pet_notes. In short, all the info ... |
24. how to write a HAVING query forum.hibernate.org |
25. EOFException when trying to do a query/deserializing an obje forum.hibernate.orgI'm getting an EOFException when trying to do a query with Hibernate. Here's the root cause in my stack trace: Caused by: java.io.EOFException at java.io.ObjectInputStream$PeekInputStream.readFully(Unknown Source) at java.io.ObjectInputStream$BlockDataInputStream.readShort(Unknown Source) at java.io.ObjectInputStream.readStreamHeader(Unknown Source) at java.io.ObjectInputStream. |
26. Are literals ok in hibernate queries? forum.hibernate.orgI am getting an error on this query, but no detail in the error. |
27. Creating 2D arrays from queries forum.hibernate.orgIs there anyway to create queries which return 2 dimensional arrays I would like to something similar to this hypothetical situation Say I have a table containing information about books, ie. author, date of publishing etc. Is there anyway I can create a query which groups books by author or date. eg. If I had only 20 books 10 of them ... |
28. How are queries constructed? forum.hibernate.orgHi, I'm using hibernate to persist data to bunch of different databases and it's working great. (My thanks). However, I've noticed a strange phenomenon when running against SQL Server and was wondering if there's anything I can do short of creating a custom type to influence it's behavior. I also want to appologize in advance for not supplying the mapping file. ... |
29. How can i write this query in Hibernate forum.hibernate.orgHi all, How can i write this query in Hibernate. Please help me out it is an urgent requirement for me. select u.user_det_id,r.reg_no,a.allotment_id,u.first_name,a.no_of_attempt,u.user_Dob,a.site_Dim_Id,a.ews_Id,a.prj_Lay_Id from User_Master u, Bda_Registration r,allotment_information a where u.user_det_id=r.user_det_id and r.reg_no=a.reg_no and a.site_Dim_Id ='04' and a.ews_Id='01' and a.prj_Lay_Id ='01' and a.category_Id ='C08' order by a.no_of_attempt,u.user_Dob desc Regards Sreenivasula Reddy A |
30. Trying to implement a "tag cloud" query? (using Cr forum.hibernate.orgNewbie Joined: Sat May 13, 2006 12:00 pm Posts: 19 I ended up solving the above problem using a nested query. It ends up looking something like this: Code: crit = getExistingCriteria(); Set< Integer > ids = new HashSet< Integer >(); ... |
31. could not execute query forum.hibernate.orgHi all, i try to execute the following statement to obtain a user from my Sybase-DB: Code: public User getUserByName(String screenName) { User user = null; Session lsession = getCurrentSession(); try{ log.info("Trying to login ... |
32. Hibernate-3.2.0.cr3 Query forum.hibernate.org |
33. Preventing multiple queries forum.hibernate.org |
34. could not execute query forum.hibernate.orglog4j:WARN No appenders could be found for logger (org.hibernate.cfg.Environment). log4j:WARN Please initialize the log4j system properly. Exception in thread "main" org.hibernate.exception.SQLGrammarException: could not execute query at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:59) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) at org.hibernate.loader.Loader.doList(Loader.java:1596) at org.hibernate.loader.Loader.list(Loader.java:1577) at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:395) at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:271) at org.hibernate.impl.SessionImpl.list(SessionImpl.java:844) at org.hibernate.impl.QueryImpl.list(QueryImpl.java:74) at service.Test.main(Test.java:23) Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: 'TB_VILLES' : nom d'objet incorrect. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(Unknown Source) at com.microsoft.sqlserver.jdbc.IOBuffer.processPackets(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerStatement.sendExecute(Unknown Source) at ... |
35. Links not being recognised in query. forum.hibernate.orgI am using Hibernate-Version: 3.2.0.cr4 with SQL Server 2000, in a Tomcat 5.5.16 app with JDK 1.5.0_06. I wish to retrieve the Orders for a given Rep, and force the immediate retrieval of the Rep records as well. I have sucessfully retrieved all Orders with their associated Reps (lazily) with the HQL Code: "from Order order" This code Code: ... |
36. Stuck on query setString forum.hibernate.orgHi, I have the following table on Oracle: test_table: something char(10) ID char(12) not null Then I tried executing the code: String result = (String)session.createQuery("SELECT test.something FROM com.blah.test AS test where test.ID = :var").setString("var","hello").uniqueResult(); There were no exceptions, but I get a null value for the string result. However, if I hardcoded the "hello" in the SELECT statement (SELECT test.something FROM ... |
37. Reserved word in hibernate query forum.hibernate.org |
38. Hibernate and Hierarchical Queries forum.hibernate.orgHi all We are facing a problem on retreiving the results on hierarchical queries We use hierarchical queries in our application . since hibernate does not support any of these queries we are firing native sql queries This is our query select pth_pty_party_id, PTH_PTY_PARENT_PARTY_ID, level from party_hierarchy where PTH_HRC_SUBTREE_ID='H10' start with pth_pty_party_id='110204' connect by pth_pty_party_id = prior pth_pty_parent_party_id Now the level ... |
39. query forum.hibernate.orgIf your posting (or a question you are referring to) was not answered by anybody, the possible reasons are: - http://www.hibernate.org/ForumMailingli ... AskForHelp - You did not submit enough information - Nobody knows the answer or has the free time to answer What you can do now: - Do the things listed in After Posting - Add missing and/or more information ... |
40. Grandparent / Parent / Grandchild structure with Adhoc Query forum.hibernate.orgHibernate version: 3.1.3 I may have missed it, but I have tried reading through the forum, and I have tried RTFM (I bought the book and read through it multiple times). If I missed my answer somewhere, apologies. We are migrating a client/server application into a new database. The database structure has a grandparent/parent/grandchild structure. There is one grandparent (master) table, ... |
41. cacheable queries forum.hibernate.orgHi, From the hibernate javadoc, I understand that setting the cacheable flag on a query controls whether or not the results are cached after the query is executed. "Hibernate in Action" views this differently - the cacheable flag is used to control both caching results after the query, and using the cache to get results during the query. However, running some ... |
42. Hibernate created humongous Query !! forum.hibernate.orgHibernate version: 3.2 Mapping documents: Annotations Name and version of the database you are using: PostgreSQL The generated SQL (show_sql=true): The actual query has 5392 fields in SELECT Statement and 227 LEFT OUTER JOIN Hi there !! Hibernate has been working great, I have 72 EntityBeans running in several persistence contexts, and they all work fine, nice and smooth for months, ... |
43. Complicated Query, dont know how to do it. forum.hibernate.org.. |
44. Query forum.hibernate.org |
45. Inline Queries forum.hibernate.orgHi all, I'm trying to use inline query in HQL, like exists in Oracle's dialect and support, for example: Code: select t.id, t.a, iq.rows_count from tab1 as t ,(select id, count(0) as rows_count from tab2 ... |
46. Hibernate reporting queries vs views forum.hibernate.org |
47. two queries -> instance was altered forum.hibernate.orgorg.hibernate.HibernateException: identifier of an instance of at.plot.profit.persist.objects.database.Users was altered from 2 to 2 at org.hibernate.event.def.DefaultFlushEntityEventListener.checkId(DefaultFlushEntityEventListener.java:58) at org.hibernate.event.def.DefaultFlushEntityEventListener.getValues(DefaultFlushEntityEventListener.java:157) at org.hibernate.event.def.DefaultFlushEntityEventListener.onFlushEntity(DefaultFlushEntityEventListener.java:113) at org.hibernate.event.def.AbstractFlushingEventListener.flushEntities(AbstractFlushingEventListener.java:196) at org.hibernate.event.def.AbstractFlushingEventListener.flushEverythingToExecutions(AbstractFlushingEventListener.java:76) at org.hibernate.event.def.DefaultAutoFlushEventListener.onAutoFlush(DefaultAutoFlushEventListener.java:35) at org.hibernate.impl.SessionImpl.autoFlushIfRequired(SessionImpl.java:969) at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1562) at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:283) ... |
48. Why is this an illegal query? forum.hibernate.orgI'm getting the following exception: org.hibernate.QueryException: query specified join fetching, but the owner of the fetched association was not present in the select list [FromElement{explicit,not a collection join,fetch join,fetch non-lazy properties,classAlias=null,role=net.iss.sp.entity.Asset.networkInterfaces,tableName=NetworkInterface,tableAlias=networkint1_,origin=Asset asset0_,colums={asset0_.AssetID ,className=net.iss.sp.entity.NetworkInterface}}] [select count( asset ) from net.iss.sp.entity.Asset asset left join fetch asset.networkInterfaces left join fetch asset.owner left join fetch asset.criticality ]; nested exception is java.lang.IllegalArgumentException: org.hibernate.QueryException: query specified join ... |
49. Parameterised queries & cost-based optimisation in SqlSe forum.hibernate.org |
50. Hibernate Query forum.hibernate.orgHi, I would like to ask for my application which is using Hibernate3.0 and the database is Oracle8i, i have a query:- queryStr.append(" and upper(supplier.coName) like ? "); paramList.add(coName.replace('*','%').toUpperCase()); typeList.add(Hibernate.STRING); The result returns back is around 2 minutes from the application. But if i run the query in oracle itself is around 6 secs. Because the input for coName is like ... |
51. why hiber nate execute each query two times ? forum.hibernate.orgIn my eclipse console i found every hibernate program execute sql statement two times why it is like that???? I have two sql statements in hibernate program,all the query executes well first time, when i tried to refresh i get the the first sql statement executes well but the second query gives error this is the error java.lang.reflect.InvocationTargetException at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ... |
52. damn query.getReturnAliases() has not been implemented forum.hibernate.orgThis is quite a problem. While I use HQL for business querying there is still the need for dynamic SQL queries, especially for reports. The fact that I cant automatically determine the fields from a query select field1, somthing as field2, ... from tables... is surprising, as surely it is just iterating through the JDBC meta data. Any ideas on how ... |
53. Custom Persiter can be used in Query? forum.hibernate.orgHello Hibernate Team, is it possible to use my own custom persiter for FOO class and use find or any other retrieval api using HQL to lookup my FOO class. For example i have modified your MasterDetailTest#testCustomPersiter Code: public void testCustomPersister() throws Exception { Session s = openSession(); ... |
54. Query based on various inputs forum.hibernate.orgHi all, I have a basically simple question, which seems to be hard to track down. I tried to search but actually I'm not even sure what I search ;) What I've done: So far I installed Hibernate, created the config and the mappings and did some first testing (inserting data). This all worked very well. Now I wanted to load ... |
55. Hibernate Query Parsing forum.hibernate.org |
56. Hibernate query forum.hibernate.orgNeed help with Hibernate? Read this first: http://www.hibernate.org/ForumMailingli ... AskForHelp Hibernate version:3.0.5 [b]Mapping documents: Code: |
57. Adding a common NamedParameter to every Query that runs? forum.hibernate.orgHi, This is a pretty big problem that I'd like to figure out a good solution for. I have a base entity class that all my entities extend, this contains a boolean column: deleted. Instead of hard deleting a row from the database, I set this flag to true, and always filter it out through queries. In findAll(), i use a ... |
58. Which query is more efficient ? forum.hibernate.orgHibernate version:3.2 I have a database with 2 tables, address and person. Address contain street_name, street_number etc. Mutliple person can share the same address. We model this by person with a FK address_id To query who is living at 'Sesame St'. We use this HQL "from person where address.street_name = 'Sesame St'" which is translate into SQL as a table join ... |
59. Extra queries with a one-to-many forum.hibernate.orgNewbie Joined: Fri Mar 30, 2007 7:15 pm Posts: 6 Versions: Hibernate 3.2.2 ga Database: Oracle 8.1.7 JDK: 1.5 I have two domain objects (one-to-many), BusinessRefence and BusinessReferenceValues that I want to load with one Criteria query (below). When I run the query, I get the correct set of BusinessReference domain objects. However, when I then attempt to load the BusinessReferenceValues ... |
60. Query with setEntity forum.hibernate.orgBeginner Joined: Thu Mar 29, 2007 11:57 am Posts: 27 Hi, I want to create a query which selects a country object with a specified id. I tried this in that way: Code: public Country getCountryByID(Long id) { Session session = HibernateUtil.getSessionFactory().getCurrentSession(); ... |
61. force hibernate to use offset query when offset is 0 forum.hibernate.org |
62. Qyery with in Query forum.hibernate.orgHi Try this. You must have a property in Table1 class which related to Table2 extract of mapping file |
63. could not execute query forum.hibernate.orgHello Frnds, Im developing one web based program using hibernate . But My problem is when the session is lost , and when I tries to relogin ... the starnge error hits Hibernate: select users0_.Id as Id0_, users0_.Active as Active0_, users0_.Username as Username0_, users0_.Password as Password0_, users0_.Firstname as Firstname0_, users0_.Lastname as Lastname0_, users0_.Email as Email0_, users0_.Projects_permission as Projects8_0_, users0_.Properties_permission as Properties9_0_, ... |
64. Hibernate Query Split () forum.hibernate.org |
65. Using dot notation in queries permitted in 3.2? forum.hibernate.orgUnder 3.1.3 I had a dao method like the following: Code: public List getPersonByNameAndOrganization(final String firstname, final String lastname, final String employer) { HibernateTemplate ht = new HibernateTemplate(this.sessionFactory); return (List) ht.execute(new HibernateCallback() { public Object doInHibernate(org.hibernate.Session session) throws HibernateException, SQLException ... |
66. Hibernate apparently repeating a single query 7+ times forum.hibernate.orgUpdate: I believe this is due to the object being recreated everytime it's referenced in the view. I thought when an object is referenced the first time it's created, and should stay alive in that session. Should I be setting a particular ScopeType or setting somewhere to stop this from happening? ---- I've been migrating a seam/hibernate app that used to ... |
67. setting priority of executed query forum.hibernate.org |
68. query forum.hibernate.org |
69. Multi query forum.hibernate.orgHi, I have a very costy query to optimize, and I found out that multi query (CreateMultiQuery method from NHibernate) would be perfect for it, however I'm using Hibernate for Java. Is there any similar method or approach under Hibernate for such queries? I searched many docs and pages, but they only refer to NHibernate. Any help is appreciated! Many thanks ... |
70. addOrder query forum.hibernate.orgi'm coding a search application. i want to order my criteria list by some property.i'm successful id the order is applied on immediate property. but it fails if i try to apply on a property for which i have created an alias--- criteria.createAlias("postMst.orgPostDetailsRlt", "postDetailsRlt"); criteria.add(Restrictions.like("postDetailsRlt.orgDesignationMst",orgDesignationMst)).addOrder(Order.asc("dsgnName")); it gives an error saying cannot resolve property.... |
71. hibernate could not execute query? forum.hibernate.orgHi, i want to develop a simple WEb Application. I use Hibernate + JSF + Firebird DB + JBOSS Server. Now i have deployed my project in the deploy directory of the application server and became the following failure message: Code: exception javax.servlet.ServletException: #{loginAction.login}: javax.faces.el.EvaluationException: org.springframework.orm.hibernate3.HibernateJdbcException: JDBC exception on Hibernate data access; nested exception is org.hibernate.exception.GenericJDBCException: could not execute query ... |
72. Can I access Query metadata? forum.hibernate.org |
73. Easy Query? forum.hibernate.org |
74. After almost 1 day hibernate says: could not execute Query forum.hibernate.orgHi everybody: I am newbie using hibernate framework. I have made a web application that uses hibernate to insert, update and delete entities in a mysql database. I generated the map xml files and the dao classes and objects entities with MyEclipse 6.0 that work very well, but I'm having a problem: When I deployed the web application to the tomcat ... |
75. Query for SUM(IFNULL) forum.hibernate.orgI am trying to execute this query using HQL and it throws a NULL pointer exception The query is this select new list(SUM(IFNULL(customer.count,0))) from Customer customer I am using MYSQL as the backend database. And this is the exception I get: Code: Caused by: java.lang.NullPointerException at org.hibernate.dialect.Dialect$3.getReturnType(Dialect.java:102) ... |
76. Faster way to Query and divide to bulks forum.hibernate.orgHibernate discourages the use of stored procedures for anything but "SELECT" operations, because whatever is inserted or deleted in the tables without Hibernate knowing, results in the objects in the session being outdated. So you can discard the stored procedure solution. Using the firstResult/maxResult alternative seems reasonable,that's what it is for. Remember that once you call ".list()" you are forcing your ... |
77. 3.2.6 breaks working query in 3.2.5... forum.hibernate.org |
78. Why does Hibernate remove whitespaces from my query? forum.hibernate.org |
79. how to write hibernate query forum.hibernate.org |
80. how to write hibernate query forum.hibernate.org |
81. Shared interest query forum.hibernate.orgHi, I'm trying to run an HQL query that should do the following : I have a User. The User has a set of Interrest. I want my query to find all the Users that share at least N Interests with the Person with id X. Here is my person class : Code: public class User { private ... |
82. Query, what's wrong? forum.hibernate.orgCode: session = HibernateUtil.getSessionFactory().openSession(); FullTextSession fullTextSession = Search.createFullTextSession(session); Transaction tx = fullTextSession.beginTransaction(); // ... |
83. CPU usage extremely high before any queries have taken place forum.hibernate.orgHi. I am running an extremely basic test application that simply creates a SessionFactory, opens a session (via getCurrentSession()), and then closes the session and the sessionFactory (nothing happens in between). The CPU percentage goes through the roof (above 100% on a unix box - I am monitoring the top command) while the session factory is being initialized. What could be ... |
84. can this query be converted in to hibernate query? forum.hibernate.org |
85. Query runs for 24 hrs when submitted by web app! forum.hibernate.orgPage 1 of 1 [ 1 post ] Previous topic | Next topic Author Message lvkazes Post subject: Query runs for 24 hrs when submitted by web app! Posted: Thu Apr 24, 2008 4:50 pm Newbie Joined: Thu Apr 24, 2008 3:52 pm Posts: 1 Location: NY I'm having a problem ... |
86. Hibernate query forum.hibernate.orgDear all, please give me help information for may problem. I have in my project this model structure D class has atributes d1, d2 A class has attributes a1, a2 D is in 0..1-0..1 association with A A is in 0..1-0..* association with CR N (with attributes n1 and n2) and M(with attributes m1 and m2) extend CR How to create ... |
87. The first query takes so long and the nothing forum.hibernate.orgThe generated SQL (show_sql=true): SELECT f.* FROM J INNER JOIN T ON t.jId = j.jId AND j.exjId = 'bbbbb'' INNER JOIN F f ON t.tenId=f.tenId WHERE f.fin = 1 AND f.status!='X' Takes 672 milis SELECT f.fin, mr.sc FROM M mr INNER JOIN FH fh ON mr.sFinHId=fh.finHId INNER JOIN F f ON fh.finId=f.finId INNER JOIN Tt t ON f.tenId=t.tenId INNER JOIN J ... |
88. Query Doesnt get executed forum.hibernate.orgHi, I am trying to execute a simple query select a from order_item a where a.status=2 I get the following exception: net.sf.hibernate.QueryException: in expected: a [select a from order_item a where a.status=2 ] at net.sf.hibernate.hql.FromParser.token(FromParser.java:102) at net.sf.hibernate.hql.ClauseParser.token(ClauseParser.java:87) at net.sf.hibernate.hql.PreprocessingParser.end(PreprocessingParser.java:142) at net.sf.hibernate.hql.ParserHelper.parse(ParserHelper.java:30) at net.sf.hibernate.hql.QueryTranslator.compile(QueryTranslator.java:149) at net.sf.hibernate.hql.QueryTranslator.compile(QueryTranslator.java:138) at net.sf.hibernate.impl.SessionFactoryImpl.getQuery(SessionFactoryImpl.java:295) at net.sf.hibernate.impl.SessionImpl.getQueries(SessionImpl.java:1572) at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1543) at net.sf.hibernate.impl.QueryImpl.list(QueryImpl.java:49) at How can I resolve the same Thanks. ... |
89. Hibernate Queries forum.hibernate.org |
90. Hibernate Queries forum.hibernate.orgYou can actually do alot of stuff with Hibernate before you need to master HQL. In fact, I've written some great applications that use Hibernate and the Hibernate Criteria API, and didn't use HQL at all! Look, if you want to learn and master Hibernate, start with the basics. http://jpa.ezhibernate.com/Javacode/lea ... hhibernate 1. Get your environment set up (database, JVM, JDBC ... |
91. Optimize queries forum.hibernate.orgselect this_.id as y0_, this_.item_date as y1_, this_.amount as y3_, company3_.firmname as y7_, company3_.id as y8_, client2_1_.firmname as y9_, client2_.id as y10_, operator1_.first_name as y11_, operator1_.last_name as y12_ from items this_ inner join companies company3_ on this_.company_id=company3_.id inner join client client2_ on this_.client_id=client2_.id left outer join firms client2_1_ on client2_.id=client2_1_.id inner join users operator1_ on this_.operator_id=operator1_.id order by this_.id desc; |
92. Why does getBatcher() work but Query does not? forum.hibernate.orgHi, When I am trying to generate an id for my object; I have a class that implements IdentifierGenerator I get a stackOverflow when calling Query.uniqueResult(); The query is obtained from SessionImplementor which is passed into generate method which I have implemented as the interface dictates. The Query is an object returned from getNamedSQLQuery(). This operation is in the context of ... |
93. Simple distrinct query forum.hibernate.org |
94. Hibernate query takes ages, while in MSSQL it takes seconds forum.hibernate.orgHi all. I have a strange situation in our system which causes us a major problem. We have a query running on a big data table, joined with few fairly small tables. The query uses a date range. Our system is Java-Hibernate based, and when the system gets to the point of running the query it just gets stuck. When looking ... |
95. Query runs lower and lower. forum.hibernate.orgAuthor Message superzz Post subject: Query runs lower and lower. Posted: Thu Aug 28, 2008 10:06 am Newbie Joined: Tue Jun 10, 2008 3:51 am Posts: 10 I am calling the same hibernate query twice, the first time, it takes around one minute, but the second time, it takes 4 minutes. Moreover, at the second time, there are much ... |
96. A small query...! forum.hibernate.orgRespected Sir/madam, am a beginner in learning Hibernate . starting with the version 3.1.2 using the distribution reference manual as my primary source of information.In the introduction chapter (pdf). page number 13 |
97. Datetime query doesn't work forum.hibernate.orgMy colleagues who are much better at Hibernate than I, have tried to help me with this question but I still haven't gotten it to work. Some background on the problem: We have a table where we declare a datetime field as a varchar in the following manner (This is a standard for our project so I cannot change it): CREATE ... |
98. Second level and query caches not helping! forum.hibernate.org |
99. How to use creteria Query using Hibernate Templete Method forum.hibernate.org |
100. Query many to many forum.hibernate.orgI have two tables: Customer and State. These two tables are linked by m:m relationship. So there is customer_state table. Customer: 8000 rows cust_num f_name l_name state_Code State: 36,000 rows state_Code state_Desc Customer_state: cust_num state_code I have the following query in hbm: |