db2 « Database « JPA Q&A





1. Hibernate NullPointerException In Loader Class    stackoverflow.com

I'm having a bit of an odd problem. This is Hibernate 3.3.2-GA with DB2400Dialect. I'm seeing the following exception --

java.lang.NullPointerException
at org.hibernate.loader.Loader.doQuery(Loader.java:720)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:259)
at org.hibernate.loader.Loader.doList(Loader.java:2232)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2129)
at org.hibernate.loader.Loader.list(Loader.java:2124)
at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:312)
at org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1723)
at org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:165)
at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:175)
at ...

3. Hibernate DB2    coderanch.com

Hi! all i was using COM.ibm.db2.jdbc.app.DB2Driver and was getting following exception : 10:57:18,124 WARN BasicResourcePool:1222 - com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@966905 -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (30). 10:57:18,124 WARN BasicResourcePool:1222 - com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@c8ccb1 -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to ...

4. Hibernate on the iSeries w DB2    forum.hibernate.org

New topic for Q&A or discussion of the quirks of using Hibernate on the IBM iSeries midrange (aka AS/400). Generally Hibernate works well as long as the profile has update authority granted on all the appropriate tables. One issue we're seeing is that simple queries are creating jobs that remain on the system as *JOBLOG *PENDING. An iSeries expert advises to ...

5. DB2/400 and getGeneratedKeys()    forum.hibernate.org

Hi All, I have a weird issue related to indentity columns in a DB2/400 table. In the topic below, the user was having basically the same issue, which seemed to point to a driver issue. https://forum.hibernate.org/viewtopic.php?f=1&t=950850 My problem is that this happens occasionally, and only after a new deployment if our app. I have been able to resolve this by just ...

6. hibernate with pureXML in DB2    forum.hibernate.org

7. Problem with DB2    forum.hibernate.org

Hi I am using Hibernate 3.4 togehter with Eclipse EMF Teneo. While I have no problems with PostgreSQL and MSSQL, I have the following issue using DB2 with the DB2Dialect: select count(this_."id") as y0_ from ( select id, icon, description, name, active, sorthint, basiccode_parent_id, 1 as clazz_ from "code" union all select id, icon, description, name, nullif(0,0) as active, sorthint, basiccode_parent_id, ...

8. Unexplained db2 warning    forum.hibernate.org

Page 1 of 1 [ 3 posts ] Previous topic | Next topic Author Message devu Post subject: Unexplained db2 warning Posted: Fri Jun 25, 2010 8:54 am Newbie Joined: Thu Jun 09, 2005 7:12 am Posts: 7 In my seemingly innocuous test example, I do a single insert into a ...

9. Hibernate no longer working after DB2 reinstall.    forum.hibernate.org

Hi, I've got a project that uses a hibernate based webapp running on at tomcat server to access a db2 database. Everything worked fine until I had to reinstall the database and now hibernate doesn't seem to be working anymore. I've checked the connection settings, and everything seems to be in order, and Hibernate does seem to be able to make ...





10. Any compatibility issues between Hibernate 3.3.1 and DB2 9.7    forum.hibernate.org

We in the planning stages of DB2 database upgrades from DB2 8.1 and DB2 9.1 to DB2 9.7. We currently use Hibernate 3.3.1. I'm a DBA and I must admit I don't know what Hibernate does, but I've been asked to investigate any potential compatibility issues between version 3.3.1 and DB2 9.7. Thanks for any help you can provide. :)

11. Hibernate & DB2    forum.hibernate.org

Hi, I am new to Hibernate. But I am very familiar with DB2. Looking at performance of an application that uses Hibernate & D2. Is it possible to configure Hibernate to generate static SQL? I have looked in Hibernate books and so far have not found such a configuration/set-up parm. Any help/direction appreciated. Thanks Learner

12. How do you get to your database using DB2 z/OS?    forum.hibernate.org

13. Hibernate - DB2/400 ???    forum.hibernate.org

Hi As you may guess I am new to Hibernate. I have downloaded struts-hibernate example by Ted Husted and have got it working fine with IBM DB2UDB7 on Windows XP. The problem is that I have tried the same app trying to access a DB2/400 on iseries. I get the following error SELECT user.user_uid as user_uid, user.version as version, user.name as ...

14. DB2 UDB 8.1?    forum.hibernate.org

15. Hibernate 1.2 & DB2 8.1 problem    forum.hibernate.org

Newbie Joined: Wed Oct 15, 2003 11:18 am Posts: 1 I'm using Hibernate 1.2, DB2 UDB 8.1; JDBC driver is IBM's UDB driver (type 4). I'm running into a problem when persisting an one-to-many mapping which works fine with Oracle. Attached are the log messages for both DB2 and Oracle. Does anyone have similar issue? This issue seems to do an ...

16. DB2 / WebLogic AbstractMethodError    forum.hibernate.org

I am using Hibernate with DB2 and WebLogic. Hibernate works fine when I run the application standalone but when I run it under weblogic using a datasource I get this error java.lang.AbstractMethodError at weblogic.jdbc.pool.DatabaseMetaData.supportsResultSetType(DatabaseMetaData.java:1199) Any ideas? Thanks in advance. Here is the full stack trace 593 [ExecuteThread: '12' for queue: 'default'] INFO net.sf.hibernate.dialect.Dialect - Using dialect: net.sf.hibernate.dialect.DB2Dialect 608 [ExecuteThread: '12' for ...





17. Problem with DB2    forum.hibernate.org

I working on a demo with Hibernate. Everything worked fine with MySQL-4.0.16 with the driver com.mysql.jdbc.Driver. The same demo failed on DB2 UDB 7.2 on Linux with the driver COM.ibm.db2.jdbc.app.DB2Driver. Below is the exception thrown (on the line sessionFactory = cfg.buildSessionFactory();): java.lang.AbstractMethodError: COM.ibm.db2.jdbc.app.DB2DatabaseMetaData.supportsResultSetType(I)Z at net.sf.hibernate.impl.SessionFactoryImpl.(SessionFactoryImpl.java:170) at net.sf.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:627) at com.westfieldgrp.wescom.hibernate.HibernateSession.currentSession(HibernateSession.java:51) Thank you. mota

18. Hibernate works fine with DB2 8.1, but not 7.2    forum.hibernate.org

I have an application that I recently ported from MySQL to DB2 - and it was extremely easy thanks to Hibernate. I got everything working using JDK 1.4 and DB2 8.1. At my client, they're using DB2 7.2 in production - so this is the target platform. I've been trying for a couple of days to get everything to work, but ...

19. Hibernate over DB2/MVS    forum.hibernate.org

21. Db2 with hibernate    forum.hibernate.org

22. hibernate and db2 6.1?    forum.hibernate.org

23. Problem with DB2 database    forum.hibernate.org

24. Help on DB2 needed    forum.hibernate.org

Author Message gigsvoo Post subject: Help on DB2 needed Posted: Fri May 21, 2004 5:31 am Beginner Joined: Fri May 21, 2004 5:22 am Posts: 24 Hello there, I am using Hibernate 2.1 rc1 (I think so), my mapping documents consists of a few files (reply me if need). This is the DB DDL: Code: CREATE TABLE SEC.SEC_MENU ( ...

25. DB2 8, Websphere 5 Communication link failure?    forum.hibernate.org

Curious if anyone is having an issue like this... Its pretty basic stuff... Struts app, Spring for IoC / DAO support and Hibernate for persistence. Getting "Communication link failures?" Any advice would be appreciated.. Versions: Database product name : DB2/LINUX Database product version : 08.01.0000 JDBC driver name : IBM DB2 JDBC 2.0 Type 2 JDBC driver version : 08.01.0000 Websphere ...

26. DB2 on mainframe    forum.hibernate.org

Hi, We are working on Re-Engineering of the existing web application, currently running on SQL Server 2000. So during the process or re-engineering we thought of using Hibernate.. In near future the database needs to be changed to DB2 on mainframe. Does Hibernate supports DB2 on maiframe database? I have no idea on this. Pls throw some light on this.. and ...

27. DB2 driver not found    forum.hibernate.org

Just begin to try to use hibernate with DB2 8.1. Copied the db2java.zip to the place of classpath, but still get the error message, saying driver class not found (it is inside the zip file), what's wrong? 13:46:09,723 INFO Environment:462 - Hibernate 2.1.3 13:46:09,743 INFO Environment:496 - loaded properties from resource hibernate.properties: {hibernate.connection.username=db2admin , hibernate.connection.password=db2admin , hibernate.cglib.use_reflection_optimizer=true, hibernate.dialect=cirrus.hibernate.sql.DB2Dialect, hibernate.connection.url=jdbc:db2:empl , hibernate.connection.driver_class=COM.ibm.db2.jdbc.app.DB2Driver ...

28. using Hibernate 2 with WebSphere 5.1 and IBM Universal DB2    forum.hibernate.org

Hello all, and thank you in advance for your assistance. I am researching alternate persistence technologies for use in our web applications. One branch of research led me to Hibernate. It sounded very promising, so I downloaded the most recent version and I am in the process of trying to integrate it into a WSAD 5.1 project. I found a few ...

29. use hibernate with DB2 6.1?    forum.hibernate.org

We intend to use hibernate_2 with DB2 6.1 on mainframe s390. I read in documentation that DB2 7.1 was tested for hibernate2, but I am not sure, if it is true for version 6.1. Can you passible have same advise for me, please? Can we use hibernate on version DB2 6.1 ? I have not any bugs is testenvironment, but in ...

30. Hibernate-DB2 7.2 - Websphere Studio 5.1.1    forum.hibernate.org

31. DB2 bug check issue    forum.hibernate.org

Hi We have the following exception when trying to select non-ascii character data from a varchar column. I wrote a small java test program using the jdbc driver and it works fine. But while using hibernate I get this exception. Anyone had seen this before? Thanks for your help [11:53:15.834 ERROR net.sf.hibernate.util.JDBCExceptionReporter [ImportCRIFilter 0] (JDBCException.java:38) - SQLException occurred com.ibm.db2.jcc.a.SqlException: bug check ...

32. DB2 400    forum.hibernate.org

33. how to config hibernate for accessing db2    forum.hibernate.org

34. Help, newbie db2/400    forum.hibernate.org

Sorry, we have download the hibernate 3 beta4, i have some question to post. Here there's my hibernate.cfg: Code: [list] java:comp/env/jdbc/as400 true org.hibernate.dialect.DB2400Dialect here my hbm:

35. DB2 and hibernate    forum.hibernate.org

36. Cant generate seqence when using DB2    forum.hibernate.org

Hi I'm using DB2 and Hibernate2.1 and I'm having trouble generating a sequence value for an id. The code worked fine with Oracle but is failing with DB2. Here is the hbm.xml file : Hibernate version: Hibernate 2.1 Mapping documents: FORM_ID_SEQ ...

37. DB2 Problem    forum.hibernate.org

I have a DB2 database which works as follows: INSERT INTO T1 VALUES ('04.01.1998','WERT227','WERT327'); ---------+---------+---------+---------+---------+---------+----- DSNE615I NUMBER OF ROWS AFFECTED IS 1 DSNE616I STATEMENT EXECUTION WAS SUCCESSFUL, SQLCODE IS 0 ---------+---------+---------+---------+---------+---------+----- COMMIT; ---------+---------+---------+---------+---------+---------+----- DSNE616I STATEMENT EXECUTION WAS SUCCESSFUL, SQLCODE IS 0 ---------+---------+---------+---------+---------+---------+----- UPDATE T1 SET T1DAT2 = 'QQ'; ---------+---------+---------+---------+---------+---------+----- DSNE615I NUMBER OF ROWS AFFECTED IS 1 DSNE616I STATEMENT EXECUTION WAS SUCCESSFUL, ...

38. Hibernate with DB2    forum.hibernate.org

Need help with Hibernate? Read this first: http://www.hibernate.org/ForumMailingli ... AskForHelp Hibernate version: hibernate-3.0.5 I used the example at http://www.hibernate.org/hib_docs/v3/re ... orial.html However the table I used was different. Also, instead of HSQLDB I used IBM DB2 Mapping documents: Code between sessionFactory.openSession() and session.close(): Full stack trace of any exception that occurs: D:\Dhanya\Projects\FastForward\Test>C:\apache-ant-1.6.5\bin\ant.bat run -Daction =list Buildfile: build.xml clean: [delete] Deleting directory ...

39. Moving from H3 RC2 to H3 RC3 - Changed Behavior w/ DB2/400    forum.hibernate.org

Newbie Joined: Wed Mar 02, 2005 12:11 pm Posts: 2 Finished the migration from H2 to H3 with few/no problems....great work, by the way. As we're still in development mode, I decided to go ahead and use H3.1 since you'll probably go 'live' before we do. Our system uses DB2/400 V5R3 in conjunction with v4.9 of the JTOpen JDBC drivers. Our ...

40. Timstamp subtraction doesn't work in Hibernate 3.0.5 DB2    forum.hibernate.org

We have an annoying problem. The timestamp subtraction doesn't seem to work properly. The hibernate query: select cat.name, avg(current_timestamp() - ai.creationDate), avg(ai.closeDate - ai.creationDate) from xxx.beans.Category as cat, xxx.ActionItem as ai where ai.abstractTaskType = some elements(cat.taskTypes) and cat.parent.id=109 group by cat.name Hibernate version: 3.0.5 Full stack trace of any exception that occurs: Caused by: org.hibernate.exception.SQLGrammarException: could not execute query at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:59) ...

41. DB2 and hibernate    forum.hibernate.org

42. Hibernate with DB2/OS390 an DB2 Qualifier    forum.hibernate.org

Hello, i have the following question concerning Hibernate. We would like to use Hibernate within our company-wide Enterprise Application. We use DB2 on OS390 as our databasesystem. As I am not sure if everybody knows DB2 on OS390, I add a short info: We have more than 200 clients (finance institutes) which all should use this application. The tables are equal ...

43. DB2 for z/OS    forum.hibernate.org

Hi guys, Has anyone tried Hibernate with DB2 for z/OS. I tried both drivers for DB2 that come with Hibernate and they didnt seem to work. What bothers me is that the version that we have (and I read in the Internet that this is so in all version of DB2 for z/OS), I need to perform commit after every operation ...

45. Does Hibernate support DB2 on zOS 390?    forum.hibernate.org

46. Hibernate 3.1 with DB2 UDB 8.2    forum.hibernate.org

...

47. DB2 to hibernate    forum.hibernate.org

48. Websphere 6, DB2 and JNDI    forum.hibernate.org

49. Websphere 6, DB2 and JNDI    forum.hibernate.org

############ ### JNDI ### ############ ## specify a JNDI name for the SessionFactory #hibernate.session_factory_name hibernate/session_factory ## Hibernate uses JNDI to bind a name to a SessionFactory and to look up the JTA UserTransaction; ## if hibernate.jndi.* are not specified, Hibernate will use the default InitialContext() which ## is the best approach in an application server #file system #hibernate.jndi.class com.sun.jndi.fscontext.RefFSContextFactory #hibernate.jndi.url file:/ ...

50. DB2 SQLCODE: -911, SQLSTATE: 40001    forum.hibernate.org

Newbie Joined: Fri Aug 04, 2006 9:27 am Posts: 2 Our system, running on WepSphere 5.1 is getting a lot of DB2 deadlock errors: DB2 SQLCODE: -911, SQLSTATE: 40001 I have posted more information at the end of this message about our environment as well as a full description from IBM of the error message. There are two meanings for this ...

51. Optimize pagging for DB2    forum.hibernate.org

did you see the "Hibernate Team" tag under my name ? :) If the dialect does not have enough information to control it then it is not possible today. You can try and see where those dialect methods are being used and see if you can patch hibernate to work like this. But for it to be applied you should show ...

52. DB2 UDB: SYSIBM.METADATA not found.    forum.hibernate.org

I am testing hibernate with the DB2 Connect JDBC driver from IBM. I am trying to connect to DB2 UDB located on an iSeries (AS/400). Hibernate connects and fetches the data from the database allright, except that it logs a warning while connecting. The warning is: 08:13:25,663 WARN SettingsFactory:103 - Could not obtain connection metadata com.ibm.db2.jcc.a.SqlException: DB2 SQL error: SQLCODE: -204, ...

53. JNDI with IBM RAD 6.0 and DB2 8.2.2    forum.hibernate.org

Author Message jgodea Post subject: JNDI with IBM RAD 6.0 and DB2 8.2.2 Posted: Fri Aug 25, 2006 11:24 am Newbie Joined: Thu Jun 15, 2006 2:15 pm Posts: 15 I have been using a non jndi session with db2 8.2.2 and my app works fine now I am trying to use jndi. I am using the HibernateUtil.java from ...

54. Problem with german umlauts and DB2 universal driver    forum.hibernate.org

Hi hibernate gurus, this issue is not only hibernate specific but as I use hibernate in my application I thought maybe someone had the same problem... Environment DB: DB2 7.x Web-Server: Tomcat 5.x Hibernate: 3.1.x Struts+JSP I have 2 problems: 1. In my application the special german characters(umlauts...) are not shown correctly when I'm using IBM jdbc driver(type 2). When I ...

55. db2 everyplace with hibernate.    forum.hibernate.org

Hi, We decided to use hibernate with DB2 for our website. I know it is going to work fine. However, we have used same code for standalone version of application. As they are standalone and hard to maintain, we are using DB2 everyplace V. 8.1 for the back end. I wonder if someone has tried hibernate 3.2 (or any version) with ...

56. NamedQuery run against DB2 produces SQLSTATE: 42610    forum.hibernate.org

Problem Description: We are porting a hibernate application from Oracle 10g to DB2. We have found that Named Queries which worked with the Oracle 10g platform produce JDBC errors when executed against DB2. When the query is changed from a Named Query to a Dynamically-generated HQL statement, the application works as expected. When we cut and paste the generated SQL from ...

57. Hibernate breaks in Mainframe DB2    forum.hibernate.org

58. db2 8.2 on z/os    forum.hibernate.org

59. Does Hibernate Supports VSE DB2 database?    forum.hibernate.org

Hi, We would like to implement Hibernate 3.2 version in our application to interact with VSE DB2 database. I have been getting errors for simple query selection. Since VSE DB2 database does not support "AS" keyword for column alias we implemented native sql queries. The native sql query worked well for single selection table but it failed when I do join ...

60. Reverse Engineering DB2...help    forum.hibernate.org

Hello all, I developed an application with Hibernate and MySQL and now I have to migrate it to DB2, the problem is that the DB2 Server owner doesn't ALLOW foreign keys in their new tables...I can only create primary key constraints not foreign keys constraints. So using the same mapping files (mapping sets with bi-dir many-to-many relationships, etc...) Hibernate does NOT ...

61. does Hibernate not support DB2/LINUXZ64?    forum.hibernate.org

62. DB2 OS/390 indentity returns 0 always    forum.hibernate.org

Thanks in andvance for any help. We are inserting rows into DB2. We use JBoss and Spring. When we insert these rows and then ask for the identity number ont DB2/NT everything works fine. When we use DB2 OS/390 we get the error listed below. As if the identity is alway returning null or 0. This is on one of our ...

63. DB2 Reverse Engineering on MQTs    forum.hibernate.org

64. Hibernate DB2 Multi-Partitioning Support    forum.hibernate.org

Hello, Has anyone experienced issues with Hibernate generating DDL which cannot be understood by multi-partitioned DB2 instances? I'm using the vanilla DB2 dialect, and apparently multi-partitioning imposes additional constraints to facilitate distribution of rows to partitions via a "distribution key." I'm hoping there is a potential workaround outside of refactoring the schema. Thanks, Anthony

65. SET do not initialized for DB2    forum.hibernate.org

Newbie Joined: Wed Jul 15, 2009 8:18 am Posts: 1 I've migrated from a MySQL DB to a BD2 DB and some sets are not initialized for the DB2 DB. The hibernate configuration file is (including properties for connecting each DB): "-//Hibernate/Hibernate Configuration DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd"> true false thread

66. Not able to drop db2 database    forum.hibernate.org

Hi, I am trying to drop db before proceeding to Redirect restore. When i tried to drop db its saying (DB couldnt found) i am getting the below message.But when i tried to list th DB directory,i can able to see the below TEST database. Please suggest me. bash-2.05b$ db2 drop db TEST SQL1013N The database alias name or database name ...

67. DB2 code page issue on V9.5    forum.hibernate.org

Expert, We have migrated the db2 instance from v8.1 to v9.5 . After migration we are facing the issue like below SQL0332N Character conversion from the source code page "" to the target code page "" is not supported. Below is the DB code page setup Database configuration release level = 0x0c00 Database release level = 0x0c00 Database territory = GB ...

68. Webshere 7 with Hiberbnet on IBM db2 9.7    forum.hibernate.org