length « Field « JPA Q&A

1. Joining fixed-length CHAR field with VARCHAR field forum.hibernate.org

Newbie Joined: Thu Jul 01, 2010 4:36 am Posts: 4 I join 2 tables on join condition: table1.col1=table2.col2 col1 is NOT table1's PK, col2 is table1's PK col1's type is CHAR(20), col2's type is VARCHAR(40) I use Hibernate's Criteria API and it doesn't recognise the join condition and gives me 0 row. I've trimmed the padding spaces by extending UserType but ...

2. Trimming fixed length char fields forum.hibernate.org

Hi, I am using hibernate 2.1 against DB2/400 and all of the char fields are using the char() data type, which pads out the string with whitespace. The issue here is that when I trim the string on the object setter, it obviously triggers a database update because the getter now returns a different value than the one that was set. ...

3. How to get the "length" field programmatically? forum.hibernate.org

4. Easy way to determine field length? forum.hibernate.org

I'd like my Swing GUI application to be able to query a Hibernate persisted object and get length information (if set in the hbm.xml) to use for validation. I can't find anything in the docs that indicates there's a way, but it seems a logical thing to provide. Is there a way to do this that I'm overlooking? Thanks for the ...

5. Truncating strings to maximum field length forum.hibernate.org

Hi, I was wondering if anybody knows how to get around the following error: [JDBCExceptionReporter] ERROR: value too long for type character varying(50) I am using Postgres 8.1 and Hibernate 3.0.5 with JBoss AS 4.0.2. This happens as a result of trying to insert 51 characters (or more) into a varchar(50) field. MySQL and other databases truncate the data for you ...

6. Dynamic changes field length problem forum.hibernate.org

Hi I intially created class Emp withString type attribute(address) with length 20; Using Velocity i cretaed tables in MSSQL DB; After that i inserted 20 char string for address field. Then i changed to address field length 20 to 15;Then again i updated tables using Velocity. But my MSSQL DB Emp table address field pointing varchar 20,which i was intially created. ...