Convert Clob Type to String In Java

An SQL clob to used to store large amount of textual data in the database.The sql clob interface represents the clob data type.

In this tutorial I am going to explain how to convert clob to string in Java.

In an ideal scenario you read the clob data from the database and convert it to String and display it on console and may be display it on a UI(User Interface)

Steps to convert Clob to String

  • Read the clob value using getCharacterStream() method.
Reader r = clobData.getCharacterStream();
  • Read each character one by one from the retrieved stream of characters and append it to string buffer.
StringBuffer buffer = new StringBuffer();
int ch;
while ((ch = r.read())!=-1) {
buffer.append(""+(char)ch);
}
  • Display the obtained String

Example:-

Happy Learning 🙂

Published by Anna

Just a simple girl who loves to code. .I am primarily a Java developer by profession and I am here to share my love for coding with you all I hope you enjoy reading my blog. Happy Coding Guys :-)

Leave a comment

Your email address will not be published. Required fields are marked *