Overview of CLOB (Character Large Object)

This section describes what are CLOB (Character Large Object) data types and how to work with them.

CLOB (Character Large Object) is a large collection of character data stored in a database table. Different database servers handles CLOB differently. But there are some common characteristics like:

JDBC offers an interface, java.sql.Clob, to allow JDBC driver to provide generic functionalities to handle CLOB data in the database.

CLOB data can also be handled as character strings with the java.lang.String class.

CLOB data can also be handled as character streams with the java.io.Reader class.

Table of Contents

 About This Book

 JDBC (Java Database Connectivity) Introduction

 JDK (Java SE) Installation

 MySQL Installation on Windows

 MySQL JDBC Driver (MySQL Connector/J)

 MySQL - PreparedStatement

 MySQL - Reference Implementation of JdbcRowSet

 MySQL - JBDC CallableStatement

MySQL CLOB (Character Large Object) - TEXT

Overview of CLOB (Character Large Object)

 Create Tables with CLOB Columns

 Inserting CLOB Values with SQL INSERT Statements

 Inserting CLOB Values with setString() Method

 Inserting CLOB Values with setCharacterStream() Method

 Retrieving CLOB Values with getString() Method

 Retrieving CLOB Values with getCharacterStream() Method

 Retrieving CLOB Values with getClob() Method

 Inserting CLOB Values with setClob() Method

 MySQL BLOB (Binary Large Object) - BLOB

 Using Connection Pool with JDBC

 Archived Tutorials

 References

 Full Version in PDF/EPUB