1. DB2 Query to Hibernate Criteria stackoverflow.comI have a specific DB2 query, and I would like to execute this query using criteria. The query: |
2. Performing static SQL queries against DB2 without PureQuery stackoverflow.comI'd like to use JPA over JDBC for a new application. I'm strictly using Named queries and basic CRUD methods of JPA Entity manager, which allows me (with the help of ... |
3. Hibernate, DB2 - Slow running queries stackoverflow.comI'm doing a search on one of my tables (legacy database) and recieving a horrible time here. The query is build by criteria api of hibernate, e.g.: |
4. Exception when trying to query DB2 through Hibernate JPA stackoverflow.comI am trying to create a web application with ICEFaces 2.0 as front end on GlassFish v3 with Hibernate 3.6 as JPA 2 provider talking to DB2 v9 on the Mainframe. ... |
5. Error while Querying : The value of a host variable in the EXECUTE or OPEN statement is too large for its corresponding use stackoverflow.comOn trying to use a select query statement. The input variable has 8 characters just as expected. I dont know why this error comes for select query because for a select query ... |
6. Exception on DB2 query with Hibernate JPA2 coderanch.com0 down vote favorite I am trying to create a web application with ICEFaces 2.0 as front end on GlassFish v3 with Hibernate 3.6 as JPA 2 provider talking to DB2 v9 on the Mainframe. I am using NetBeans 6.9.1 IDE for this. I was able to successfully test and configure JDBC connection pool on GlassFish using the DB2 jdbc drivers ... |
7. Getting exception when trying to run JPA query through DB2 java.netI am trying to create a web application with ICEFaces 2.0 as front end on GlassFish v3 (with Hibernate 3.6 as JPA 2 provider talking to DB2 v9 on the Mainframe). I am using NetBeans 6.9.1 IDE for this. I was able to successfully test and configure JDBC connection pool on GlassFish using the DB2 jdbc drivers (db2jcc4.jar and db2jcc_license_cu.jar). I ... |
8. SELECT CURRENT_SERVER FROM sysibm.sysdummy1 - DB2 forum.hibernate.org |
9. DB2 Order By Problem forum.hibernate.orgHi, i have this query : "from Aplicacion as a order by a.nombre" when i try this query, i recive the following error (in Ibm DB2 7.1 UDB): [IBM][CLI Driver][DB2/NT] SQL0104N An unexpected token "order" was found following "ICACION aplicacion0_". Expected tokens may include: "GROUP". SQLSTATE=42601 Sql : select * from ( select rownumber() over(order by aplicacion0_.APLNOMBRE) as row_, aplicacion0_.APL_ID as ... |
10. DB2 "with ur" query forum.hibernate.orgDirty reads are just evil. This recommendation seems to be common among DB2 DBAs who are used to working with batch-processing systems that use long-running transactions. It is advice that is simply inappropriate for the kind of online, record-oriented systems that Hibernate is usually used for, where transactions are always extremely short. |
11. appending "with UR" onto DB2 queries forum.hibernate.orgMy DBA came to me just before integration testing and said that I should put "with UR" to the end of my queries. Almost all of the queries I am doing are done using Criteria object. I am using the DB2 Dialect. Where would I have to go to extend Hibernate to put "with UR" at the end of the SELECT ... |
12. Problem with UPPER in Query in DB2 forum.hibernate.orgAuthor Message dalelepine Post subject: Problem with UPPER in Query in DB2 Posted: Fri Aug 20, 2004 10:02 am Newbie Joined: Fri Aug 20, 2004 9:13 am Posts: 2 I'm trying to do a lookup and I'm using the upper method to upper case the name and DB2 is throwing Caused by: COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2/NT] SQL0418N A statement contains ... |
13. DB2/400 V4R5 ORDER BY workaround? forum.hibernate.orgI am using Hibernate 2.1 with DB2 for iSeries (AS400). I have read the other posts in the forum concerning the problems with older versions of AS400 and the ORDER BY clause although I am not sure if the problem has ever been accurately described (and thus a truly good workaround ever suggested). The problem is that the column name specified ... |
14. High # of compilations for certain prepared queries (DB2) forum.hibernate.orgHi, The simple queries mentioned below are showing up in the DB2 catalog cache as being executed ~800 times, but the number of compilations is showing up as 4294967295. Is there anything in the way that hibernate prepares queries that might cause them to be compiled instead of pulled from an already-compiled cache on the db2 server? In looking at the ... |
15. Invalid ORDER BY clause in SQL (DB2 OS390) forum.hibernate.orgAuthor Message tnleeuw Post subject: Invalid ORDER BY clause in SQL (DB2 OS390) Posted: Fri Oct 22, 2004 6:15 am Newbie Joined: Wed Apr 28, 2004 6:44 am Posts: 15 Location: Amsterdam, Netherlands Hi, I have to redeploy an existing application onto DB2 for OS390. The current version is running on DB2 for AIX, where it works. I changed ... |
16. Pagination and DB2 for AS/400 V4R5 forum.hibernate.orgGreetings, I am working with Hibernate (V2) against a DB2 database running on an AS/400. The DB2 version is V4R5. In the interests of optimizing some of the queries we are performing I recently added setFirstResult() and setMaxResult() parameters to one of our queries: Query q = mgr.createQuery("from TransactionHistory hist where hist.account = ? and hist.effectiveDate between ? and ?"); q.setParameter(0, ... |
17. selecting, deleting, updating rows by NULL value id DB2 forum.hibernate.orgHi, I have mapping (using Hibernate 2.1.8) of the child table as a set, with key and composite-element. e.g. [quote] |
18. Hibernate Queries -Not able to get it working on DB2-UDB-8.0 forum.hibernate.orgNewbie Joined: Wed Aug 31, 2005 10:10 am Posts: 2 Location: Atlanta I am using Hibernate 3.0.5 with DB2 in standalone mode. I was able to insert data into the database but HQL and Criteris queries are all failing. Even a simple query like "from MedicalHistoryClaim claim" is failing. The stack trace leads me to think that somhow the JDBC layer ... |
19. Unable to execute a query on DB2 using Hibernate forum.hibernate.orgHibernate version: 3.0.5 Mapping documents: hibernate.cfg.xml |
20. problem with pagination and order on DB2 8.2 forum.hibernate.org |
21. DB2 pagination forum.hibernate.orgView unanswered posts | View active topics Board index Hibernate & Java Persistence Hibernate Users All times are UTC - 5 hours [ DST ] DB2 pagination Page 1 of 1 [ 3 posts ] Previous topic | Next topic Author Message kirks Post subject: DB2 pagination Posted: Thu Dec ... |
22. Hibernate queries for DB2 (breaks in Mainframe) forum.hibernate.org |
23. SetMaxResults with db2 database problem forum.hibernate.orgI try to get first 10 rows of a table from db2 database, but get only exceptions... Hibernate version: 3.2.0.ga Code between sessionFactory.openSession() and session.close(): Query query = HibernateUtil.currentSession().createQuery("from Subject"); query.setMaxResults(10); List |
24. Pb method setFirstResu setMaxResults of Criteria on DB2 z/os forum.hibernate.orgHibernate: select this_.NUMINTFI as NUMINTFI2_0_, this_.NUMINTFG as this_.MOISPREL as MOISPREL2_0_, this_.CODEPAYS as CODEPAYS2_0_, this_.MOTIFREJ as MOTIFREJ2_0_, this_.IBANCORR as IBANCORR2_0_, this_.JETON as JETON2_0_ from GDFFIDET this_ where this_.NUMINTFG=? [06/02/09 17:31:18:262 CET] 00000018 WSRdbManagedC W DSRA0080E: Une exception a t reue par Data Store Adapter. Voir le message de l'exception d'origine : com.ibm.db2.jcc.b.SqlException: DB2 SQL error: SQLCODE: -471, SQLSTATE: 55023, SQLERRMC: SYSIBM.SQLCAMESSAGE;00E7900C |