1. How to Deal with clob in MySQL and Oracle databases. BLOB data type (1) cannot be connected to clob in the database. The Blob type is as follows:
MySQL: clob corresponds to text and blob
In DB2/Oracle: clob corresponds to clob and blob(2)
From csdn
========================================================
In Oracle, four lobs types are available: blob, clob, bfile, and nclob.
The following is a brief introduction to the lob data type.
L BLOB: Binary lob, Which is binary data. It can
Environment: eclipse3.1 + hibernate2 + Oracle 10gNote: In this example, eclipse3.1 is used to read and write blob/clob data in Oracle through a Java project.1. Create a new table in the Oracle database named bigdata. The SQL statement is as
Reprinted please indicate the source: http://blog.csdn.net/sunyujia/
I have never used clob because I did not have this problem on the Forum. But how can I find a solution as quickly as possible to compete for points, because spring encapsulates ORM
Many Java operations on blob and clob fields in Oracle on the network are not comprehensive, some are inaccurate, and some are even nonsense. The recent project uses this knowledge and summarizes it here.Environment:Database: Oracle 9iAPP server:
The database provides three field types: Varchar2, Blob, and Clob, which are used to store string or binary data. Varchar2 and Clob are used to store string data, while Blob is used to store binary data.
Varchar2 is stored in a single byte and has
In fact, I have never used Clob because I do not have this requirement. But how can I find a solution as quickly as possible to grab points?
In fact, I have never used Clob because I do not have this requirement. But how can I find a solution as
Java cannot directly insert Clob Data Types in Oracle, but it can write or read clob data in the form of a stream. The online code is not too much, I have summarized and summarized the online materials. For details, refer to the Code:
Write clob
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.