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 wonder if such kind of information can be retrieved from any DB.

sure, use the java.sql.DatabaseMetaData reference obtained from the underlying connection to query various aspect regarding the database...

specifically, check out its getColumns() method