File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Object Relational Mapping and the fly likes DB2 CHARACTER datatype issue in JPA Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Java Interview Guide this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "DB2 CHARACTER datatype issue in JPA" Watch "DB2 CHARACTER datatype issue in JPA" New topic

DB2 CHARACTER datatype issue in JPA

anyz mick

Joined: Aug 09, 2004
Posts: 15
I am working with DB2 Universal database having lots of tables with columns of datatype CHARACTER. Length of these columns is variable (greater than 1 e.g. 18). As i execute a Native query using JPA it selects only first character of the column. Seems CHARACTER datatype is mapped to Java Character.

How can i get full contents in DB column. I can not change the database bening on Vendor side. Also there are two sides of problem:

- When using JPQL
- Using native DB query (no pojo is used in this case)

i am using Hibernate implementation of JPA provided by spring.

I agree. Here's the link:
subject: DB2 CHARACTER datatype issue in JPA
jQuery in Action, 3rd edition