1. ORA-00942: table or view does not exist : How do I find which table or view it is talking about stackoverflow.comWe're running a java/hibernate app going against ORACLE 10g in TESTING. Once in a while, we're seeing this error: ORA-00942: table or view does not existIs there a way to ... |
2. Hibernate Computed Criteria Order stackoverflow.comI have an Oracle XMLType column that stores the various language specific strings. I need to construct a Hibernate criteria that orders on this column. In order to do this, I ... |
3. Paging With a Cartesian Product stackoverflow.comPlease do add a comment if more information is needed to answer this question. We have a query that returns a cartesian product. Since there are a lot of results, there ... |
4. Unable to select a column from an Oracle View using JPA 2 Criteria API stackoverflow.comI have an existing working query that selects a column from an entity mapped to an Oracle View using the following JPQL
I refactored ... |
5. Oracle CLOB and JPA/Hibernate ORDER BY? stackoverflow.comI have a JPQL query that works fine with MySQL and SQL Server. But with Oracle it fails with ORA-00932: inconsistent datatypes: expected - got CLOB. The reason seems to be ... |
6. Problem using JPA with Oracle and grouping by hour stackoverflow.comI have a problem using JPA with Oracle and grouping by hour. Here's the scenario: I have an entiry named EventData. This entity has a java.util.Date field named startOfPeriod. This field maps in ... |
7. HQL to SQL: Querying an Oracle database in Netbeans stackoverflow.comI'm new to Hibernate and I'm having difficulty generating a very basic SQL statement from HQL. I followed this tutorial pretty much to the letter with the exception that the ... |
8. Projections.countDistinct with Hibernate produces unexpected result stackoverflow.comI have the following code
, whose purpose is to find out the number of rows with different values for the ... |
9. query runs fine in sql developer, but crashes in hibernate stackoverflow.comWhen I run this in sqldeveloper:
it ... |
10. Oracle Flashback Query with Hibernate stackoverflow.comI've to use Oracle Flashback Queries in my Java application. We're using Hibernate for data persistence so I'd like to know if there is a way of enable this feature in ... |
11. What is the HQL equivalent of this Oracle specific query? stackoverflow.comI have a query in one of my projects as below which uses oracle specific stuff. How to rewrite this in HQL?
|
12. JPA Error compiling query when using Oracle objects within a query stackoverflow.comThe following JPA query doesn't compile -
where the table CUSTOMER in Oracle database has a ... |
13. Hibernate + Oracle IN clause limitation, how to solve it? stackoverflow.comI know this question is posted many times, but I want to ask about details, Using Oracle, you can't pass to IN clause more than 1000 parameters, so using hibernate with oracle ... |
14. Oracle Text Criteria Query in JPA stackoverflow.comIs it possible to perform a JPA Criteria Query using Oracle Text's contains statement, and if so how? |
15. hibernate repeat query stackoverflow.comI have Web app(as ORM I use Hibernate) that populates data from Orcale 11 DB. For short period of time some Oracle packages becomes invalid and then becomes valid back (it's legacy ... |
16. Firing Native Oracle Queries through hibernate coderanch.comDear All, I wish to fire the native oracle query through hibernate. SELECT * FROM ASSET START WITH ASSET_ID=66 CONNECT BY ASSET_ID = PRIOR PARENT_ASSET_ID Assuming you have a heirarchical structure of records in the ASSET table, the above query will get uppermost root of asset_id 66. How do I run this query using hibernate. I tried to do so and ... |
17. CONNECT BY PRIOR clause (Oracle) with Hibernate coderanch.com |
18. how to write hibernate query for complicated oracle query coderanch.com |
19. Hibernate with Oracle 11g not working with "select" generato forum.hibernate.orgHello there. I am using Hibernate 3.2.5 and Hibernate Annotations 3.3.1.GA as the JPA provider in a data loading application. I have configured Hibernate to use C3P0 for connection pooling. My database is: Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production As there is no built in hibernate dialect for 11g, so I have configured it to use Code: ... |
20. Oracle pagination: rownum vs rank() forum.hibernate.org |
21. Oracle Partition Select forum.hibernate.orgI would like use an Oracle specific select statement. With Oracle you have the ability to select from a named partition, using the following format: SELECT |
22. How to write HQL query using exists keyword of Oracle forum.hibernate.orgRight now I have delete statements and for that I am using HQL Query. The problem is I have more than 1000 Ids so I cant use 'in' clause in HQL as it is throwing error. I want to use exists keyword. Could you please guide me how to use it ? my Query is like this delete from Employee where ... |
23. Pagination on an Oracle Database forum.hibernate.org |
24. How can I limit a query (use of Oracle rownum) forum.hibernate.orgUmmmm we actually use this kind of query when you use setFirstResult() > 0 .... I've never been certain if we should use it in the case of ONLY a setMaxResults(). I'm not sure if its better. Add a request to JIRA if you like ..... but I will need some solid advice on this before changing anything. |
25. oracle limit and order by queries forum.hibernate.orgI don't believe this gives you the same results. The second query you presentet is - give me the first 10 results and then order them, while the original one is order the results then give me the first 10. I think oracle would be seriously messed up if this works the same. You could change the dialect to use a ... |
26. paging problem on oracle forum.hibernate.orgI am not very sure if it's a problem, it seems oracle's problem, I have fired an issue on tracker, but I think it maybe not a prolem now. data base : oracle 8.1.7 dialect: net.sf.hibernate.dialect.Oracle9Dialect when I use the query with paging like this: Query query = session.createQuery(hql); query.setFirstResult(firstResultPosition); query.setMaxResults(maxResultSize); query.list(); //...blahblah the dialect generate the following SQL(formatted for short): ... |
27. Using Oracle HINT in HQL queries forum.hibernate.orgHi, I'm using Hibernate 2.1.4 with Oracle 9i. I need to embed an Oracle hint after the SELECT statement in my HQL queries. I have searched this forum and I know this is possible by using a SQL query, but this is not suitable for me, since my application is written to use HQL queries and depends on the mapping that ... |
28. can't get connect by oracle native query to work?? forum.hibernate.org |
29. Order by Join and Oracle 7.3 problem forum.hibernate.orgI have the problem bellow. In short a have a Join entity and I am trying to do a order by and pagination. The error is in the position of the order by in the sql query (I am using Oracle 7.3). What can I do? (just as a note everything works fine without the order by) Hibernate version: 3.03 Also ... |
30. Pagination Oracle rownum Cached RowSet forum.hibernate.orgHi I am doing a HTML search screen which needs to paginate results 10 records per page. I have it working, but am currently executing 2 queries, one for the page, and one for the count of total num results. I have read around the pagination articles and read that it is possible to get a page of results, + the ... |
31. when i use the procedure of oracle,i find the strange circs. forum.hibernate.org |
32. select distinct, oracle barfs on clob forum.hibernate.orgNeed help with Hibernate? Read this first: http://www.hibernate.org/ForumMailingli ... AskForHelp Hibernate version: 2.1, Oracle 9 I essentially have the Item and Bid relationship described in Hibernate in Action. I'm trying to return a [b]paged[b] set of Items ordered by the highest bid. Because I'm paging, using a HashSet to remove non-distinct items after the query isn't an option. I need the ... |
33. SchemaValidator can't find views on oracle9i forum.hibernate.org |
34. HibernateTemplate.find() doesn't work with Oracle fixedStrin forum.hibernate.org |
35. Using named sql-query, Invalid Column Name, Oracle forum.hibernate.orgHey! I've never used sql-queries in Hibernate before, and have come up with the following problem. I am using Oracle 9i RDBMS and Hibernate 3.1 and really need Oracle's CONNECT BY structure. I really hope that you can help. Thank you very much in advance. Hibernate version: 3.1 Mapping documents: |
36. select-before-update problem with Oracle forum.hibernate.orgI have an application which runs on: - Oracle 10g XE - Tomcat 5.0.28 - Hibernate 3.1.3 - MyFaces 1.1.3 I have a simple POJO value object, which is mapped to the database using Hibernate with dynamic-update="true" and select-before-update="true" setting. The same value object is binded to a JSF form, so the data is easily transferred between the UI and the ... |
37. Query.setReadOnly() seems not work on Oracle RDB forum.hibernate.orgHi, I built a hibernate query to search records from Oracle RDB and we observed that while executing this query, the status in Oracle RDB is W(Write) mode whereas it should have been in R(Read) mode. I managed to set Query.setReadOnly(true) but the situation does not change. This problem can affect a lot the performance. If I try with SQL without ... |
38. Hibernate Order By Problem with Oracle and large Datasets forum.hibernate.orgNewbie Joined: Thu Dec 21, 2006 6:13 am Posts: 3 Hi There! I have got a problem with Hibernate when selecting a small data set out of a large amount of ordered data. Please see the following scenario: Java 5 Spring 2 Hibernate Version: 3.1.2 Oracle 10g Database Table: Customer (with 1.000.000 records) I want to select records 990.000 to 991.000 ... |
39. Oracle Pagination problem forum.hibernate.org |
40. Oracle Pagination problem (testCase won't pass) forum.hibernate.orgNewbie Joined: Mon Aug 15, 2005 10:02 am Posts: 7 Hi, Sory for another topic about this but I've been througth this issue for three days by now and can't find a answer in google, hibernate forum or gira. This simple testCase won't pass using Oracle database and Hibernate 3.2.2. Is there any wrong assumptions made here? Code: ... |
41. Hibernate support for Oracle Text Query forum.hibernate.org |
42. Problem finding database objects in Oracle .. forum.hibernate.orgBy default oracle names the schema same like the user that is connected. Well, when i use a different user to connect to BD, and existing objects in different schema's, objects like sequences or views, hibernate can not find them. I try to set all possible configuration in the mappings |
43. Order BY not working inside Subqueries in Oracle forum.hibernate.org |
44. Pagination problem with Oracle forum.hibernate.orgNewbie Joined: Fri Dec 14, 2007 10:09 pm Posts: 4 Location: Sydney, Australia Hi Gang I am using Hibernate 3.2.0 with an Oracle 10g DB. I have had fairly extensive experience with Hibernate (also using it as a JPA implementation) over the last couple of years and read "Hibernate in Action" cover to cover several times, so I don't post this ... |
45. support for flashback query from oracle 10g ? forum.hibernate.orgHi Guru, Flashback query is introduced in the oracle 10g, which handles the historical and temporal dimension of data out of box, each flashback query comes with "as of timestamp" clause, which returns version of data made to the database over the time at row level. I can use the native sql query with "as of" in the hibernate, but it ... |
46. Facing problem in runing a select query using oracle forum.hibernate.org//*****Hibernate.cfg.xml**************** |
47. Problem in group by and order by with oracle10g forum.hibernate.orgI am using query given below in hibernate with oracle10g, "SELECT OcspTransactionLogs.relyingPartyIp,OcspTransactionLogs.relyingPartyId,count(OcspTransactionLogs.id) FROM OcspTransactionLog OcspTransactionLogs WHERE OcspTransactionLogs.responseStatus = 'successful' GROUP BY OcspTransactionLogs.relyingPartyIp,OcspTransactionLogs.relyingPartyId ORDER BY count(OcspTransactionLogs.id) desc" It properly grouping records without "order by clause",as I order it by count(...), It fill first record data in "OcspTransactionLogs.relyingPartyIp and OcspTransactionLogs.relyingPartyId" for the subsequent records, e.g, True grouping records are as, 192.123.12.13 N/A 10 ... |
48. Blowing Oracle's Temporary Tablespace with a simple group by forum.hibernate.org |
49. Blowing Oracle's Temporary Tablespace with a simple group by forum.hibernate.org |
50. Hibernate+Oracle and Native Sql with where clause forum.hibernate.orgHi, I need to query oracle 10g and get order number using Hibernate. for this i though of using native sql. kept related HB jars in path along with ojdbc14.jar. I tried using the following queries but could not get the order number through Hibernate. But when i execute the below queries am getting the order number from SQL prompt. Am ... |
51. How Can I Query View In Oracle Via HIBERNATE? forum.hibernate.org |
52. Problems with Oracle native query result forum.hibernate.orgNewbie Joined: Thu Feb 05, 2009 6:48 am Posts: 1 I'm using Oracle 10g express with Hibernate 3.2.6GA as implementation of JPA. I'm having some serious problems with hibernate result of the following native query : Code: @SuppressWarnings("unchecked") public List |
53. CONNECT BY PRIOR Oracle Clause with Hibernate forum.hibernate.org |
54. After select with Oracle 10G (XE and PE) database empty? forum.hibernate.orgAuthor Message JeroenM Post subject: After select with Oracle 10G (XE and PE) database empty? Posted: Tue Mar 24, 2009 3:38 pm Newbie Joined: Tue Mar 24, 2009 3:14 pm Posts: 6 Location: Leeuwarden, Netherlands Hey, I'm trying to setup a simple Hibernate project with Hibernate, I'm used on working with NHibernate. However now I run into strange things.. ... |
55. After select with Oracle 10G (XE and PE) database empty? forum.hibernate.orgAuthor Message JeroenM Post subject: After select with Oracle 10G (XE and PE) database empty? Posted: Tue Mar 24, 2009 3:39 pm Newbie Joined: Tue Mar 24, 2009 3:14 pm Posts: 6 Location: Leeuwarden, Netherlands Hey, I'm trying to setup a simple Hibernate project with Hibernate, I'm used on working with NHibernate. However now I run into strange things.. ... |
56. Problem with Named Queries on Oracle Weblogic 10gr3 forum.hibernate.orgNewbie Joined: Thu Apr 16, 2009 4:33 am Posts: 1 Hi I am trying to deploy a web application which uses Hibernate 3 in Oracle weblogic 10gr3.But I am getting following exception.The same application gets deployed in Tomcat 5.0.28 without any problem. urce [/WEB-INF/servicesContext.xml]: Cannot resolve reference to bean 'genericDao' while setting bean property 'genericDao'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating ... |