oracle « Query « JPA Q&A





1. ORA-00942: table or view does not exist : How do I find which table or view it is talking about    stackoverflow.com

We'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 exist
Is there a way to ...

2. Hibernate Computed Criteria Order    stackoverflow.com

I 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.com

Please 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.com

I have an existing working query that selects a column from an entity mapped to an Oracle View using the following JPQL

    SELECT COUNT(o.id) FROM MyEntityView o
I refactored ...

5. Oracle CLOB and JPA/Hibernate ORDER BY?    stackoverflow.com

I 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.com

I 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.com

I'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.com

I have the following code


Criteria criteria = this.getCriteriaForClass(DeviceListItem.class);
Projection rowCountProjection = Projections.countDistinct("color");
criteria.setProjection(rowCountProjection);
int rowCount = ((Long) criteria.uniqueResult()).intValue();
return rowCount;
, 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.com

When I run this in sqldeveloper:

SELECT   CASE
WHEN TABLE1.COL1 IS NOT NULL
THEN (
CASE
WHEN TABLE1.COL2 IS NOT NULL
THEN TABLE1.COL3
ELSE TABLE1.COL4
END) 
WHEN TABLE1.COL5 IS NOT NULL
THEN TABLE1.COL6
ELSE TABLE1.COL7 END "C" FROM TABLE1
it ...





10. Oracle Flashback Query with Hibernate    stackoverflow.com

I'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.com

I have a query in one of my projects as below which uses oracle specific stuff. How to rewrite this in HQL?

from HotAddressHibId a  where a.expirationTsp >= trunc(SYSDATE)

12. JPA Error compiling query when using Oracle objects within a query    stackoverflow.com

The following JPA query doesn't compile -

SELECT a FROM CUSTOMER a WHERE a.activeCustomer = 'N' AND a.customerInfo.city IN :cityName ORDER BY a.customerId
where the table CUSTOMER in Oracle database has a ...

13. Hibernate + Oracle IN clause limitation, how to solve it?    stackoverflow.com

I 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.com

Is it possible to perform a JPA Criteria Query using Oracle Text's contains statement, and if so how?

15. hibernate repeat query    stackoverflow.com

I 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.com

Dear 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 ...





19. Hibernate with Oracle 11g not working with "select" generato    forum.hibernate.org

Hello 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.org

I 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 FROM PARTITION (); By applying the "PARTITION" keyword after the clause, a user can select from a given partition. What would be the best/cleanest way to implement this extension?

22. How to write HQL query using exists keyword of Oracle    forum.hibernate.org

Right 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.org

Ummmm 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.org

I 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.org

I 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.org

Hi, 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 ...

29. Order by Join and Oracle 7.3 problem    forum.hibernate.org

I 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.org

Hi 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 ...

32. select distinct, oracle barfs on clob    forum.hibernate.org

Need 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

35. Using named sql-query, Invalid Column Name, Oracle    forum.hibernate.org

Hey! 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.org

I 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.org

Hi, 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.org

Newbie 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.org

Newbie 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.org

By 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 and name I check the generated SQL ...

43. Order BY not working inside Subqueries in Oracle    forum.hibernate.org

44. Pagination problem with Oracle    forum.hibernate.org

Newbie 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.org

Hi 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**************** org.hibernate.dialect.Oracle9Dialect oracle.jdbc.driver.OracleDriver jdbc:oracle:thin:@172.16.31.25:1521:BOMBAY poonam poonam true //**********contact.hbm.xml********** ...

47. Problem in group by and order by with oracle10g    forum.hibernate.org

I 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 ...

50. Hibernate+Oracle and Native Sql with where clause    forum.hibernate.org

Hi, 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.org

Newbie 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 executarPesquisaSenhasCanceladas(){ String sql = "" + ...

53. CONNECT BY PRIOR Oracle Clause with Hibernate    forum.hibernate.org

54. After select with Oracle 10G (XE and PE) database empty?    forum.hibernate.org

Author 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.org

Author 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.org

Newbie 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 ...