LOB data type in Oracle and typeHandler processing this type in ibatis

The LOB type in Oracle. the LOB data type provides specific data types such as BOLB, COLB, and BFILE to store unstructured big data blocks, such as text, images, images, sounds, and views.

The LOB type in Oracle. the LOB data type provides specific data types such as BOLB, COLB, and BFILE to store unstructured big data blocks, such as text, images, images, sounds, and views.

1. LOB type in Oracle

The LOB data type provides BOLB, COLB, BFILE, and other data types to store unstructured big data blocks, such as text, images, images, sounds, and videos, the maximum storage size is 4 GB, and data can be accessed in an efficient, arbitrary, and random segment manner.

BOLB: used to store large files and materials that contain images and Images

COLB: used to store large files and materials with only text

BFILE: generally used when operating system files are needed for business operations, such as sound and video.

2. Type Controller of the batis configuration file

Whether iBatis sets a parameter in a preprocessing statement or retrieves a value from the result set, the type processor is used to convert the obtained value to the Java type in an appropriate way, the type converter in spring is used here.

BOLB corresponds to a binary stream. byte [] is an array type, which is similar to the byte stream in IO. COLB corresponds to a text or String type, similar to the bytes stream in IO.