field « Test « JPA Q&A





2. How to efficently test if a lob field exists?    forum.hibernate.org

Newbie Joined: Wed Aug 18, 2010 6:20 am Posts: 1 I am facing this problem when migrating some legacy ibatis sql code. The sql code(oracle) is put here: Code: select id, report_id, file_name, file_type, file_size, page_size,flag, nvl2(pdf_content,1,0) as pdf_exist, ...

3. Testing if a value fits in field's size    forum.hibernate.org

Hello there, Is there any way to verify the database field's size before performing a write operation (INSERT or UPDATE) ? The only one I know is to capture the exception thrown when the value does not fit in field. I am looking for a not-so-ugly approach :-) Thanks in advance, Fred PS: I use both Oracle and HSQL, but I ...