db2 « Schema « JPA Q&A

  1. JPA Q&A
  2. Schema
  3. db2




1. Default Schema in Hibernate and DB2    forum.hibernate.org

Hi, I'm trying to port my application from Oracle to DB2 (v9.7). I have set the "hibernate.default_schema" property to VRM in my hibernate.cfg.xml file. (VRM) The problem is that one of my queries (not all of them) fails with the following error: DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=DB2ADMIN.TRACK, DRIVER=3.58.82 From this error I can guess that hibernate is looking for ...

2. SchemaExport identity with DB2 customisation    forum.hibernate.org

3. How do we specify the DB2/400 schema name in HQL dynamically    forum.hibernate.org

Hi, We are using the database DB2/400 on OS/400 V5R4, IBM Iseries Our Schema stucture and application structure is ofcourse tightly coupled as it is a legacy database. Each user of the application has a specific schema/library specified. All the DB operations performed/executed by that user should only effect in the specified schema. We are planning to implement DB persistance using ...

4. How do we specify the DB2/400 schema name in HQL dynamically    forum.hibernate.org

Hi, We are using the database DB2/400 on OS/400 V5R4, IBM Iseries Our Schema stucture and application structure is ofcourse tightly coupled as it is a legacy database. Each user of the application has a specific schema/library specified. All the DB operations performed/executed by that user should only effect in the specified schema. We are planning to implement DB persistance using ...

5. Hibernate and DB2 -- Schema problems    forum.hibernate.org

Hello, Is anybody using hibernate and db2? The issue I'm having is that I have three different schema's for each of the three different environments of test, integration and production. DB2 requires the schema be defined or it defaults to the ID.tablename where ID is the username that was used to establish the original connection. I am using the ${defaultSchema} ...

6. default_schema ignored in DB2?    forum.hibernate.org

Hi All, I've been searching for a solution to the following problem but to no avail. I am using hiberate to interact with DB2 on iSeries/AS400. My configuration file uses the url: jdbc:as400:##.###.#.###/MYLIBA;prompt=false. I then declare a default schema as MYLIBB. If I execute queries session.createSQLQuery(sql).list(), I get data from MYLIBA, not MYLIBB. If I remove MYLIBA from my connection to ...