Most efficient solution for reading CLOB to String, and String to CLOB in Java?

by

Ok I will suppose a general use, first you have to download apache commons, there you will find an utility class named IOUtils which has a method named copy();

Now the solution is: get the input stream of your CLOB object using getAsciiStream() and pass it to the copy() method.

InputStream in = clobObject.getAsciiStream();
StringWriter w = new StringWriter();
IOUtils.copy(in, w);
String clobAsString = w.toString();

More Related Contents:

  1. how to get elements from JSONObject and write it to file
  2. StringBuilder vs String concatenation in toString() in Java
  3. Difference between StringBuilder and StringBuffer
  4. String, StringBuffer, and StringBuilder
  5. Why StringBuilder when there is String?
  6. How can I clear or empty a StringBuilder? [duplicate]
  7. Java: String concat vs StringBuilder – optimised, so what should I do?
  8. Remove last character of a StringBuilder?
  9. Correct way to use StringBuilder in SQL
  10. How to convert byte array to hex format in Java
  11. How do I prove programmatically that StringBuilder is not threadsafe?
  12. What is the difference between String and StringBuffer in Java?
  13. Disabling contextual LOB creation as createClob() method threw error
  14. String builder vs string concatenation [duplicate]
  15. StringBuilder capacity()
  16. Java: How to insert CLOB into oracle database
  17. Why StringJoiner when we already have StringBuilder?
  18. Program that solves a simple math equation [closed]
  19. Java – escape string to prevent SQL injection
  20. Unable to execute dex: Multiple dex files define
  21. running rmi server, classnotfound [duplicate]
  22. i18n with UTF-8 encoded properties files in JSF 2.0 application
  23. URLConnection getContentLength() is returning a negative value
  24. Reliable data serving
  25. Java generics, nested collection of wildcard
  26. Trying to implement text-based Hangman game in Java
  27. Creating InetAddress object in Java
  28. Trying to use Spring Boot REST to Read JSON String from POST
  29. “Could not find the main class” when double-clicking .jar file
  30. How do I transfer a file from one directory to another using Java SFTP Library JSch?

Leave a Comment