jQuery in Action, 3rd edition
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
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’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link: http://aspose.com
subject: DB2 CHARACTER datatype issue in JPA
It's not a secret anymore!