how to Retrive the CLOB value from Oracle using java

by

After retrieving your data, you can use the getClob () method to return your Clob. Then you needs to open the Clob’s stream to read the data (Mayb be char or binary data).

If the clob is known to be a plain string, you maybe also wish to use

clob.getSubString(1, (int) clob.length());

So try this

Clob clob = resultSet.getClob("DETAILED_DESCRIPTION")
record.add(clob.getSubString(1, (int) clob.length());

see http://www.java2s.com/Code/JavaAPI/java.sql/ResultSetgetClobintcolumnIndex.htm

More Related Contents:

  1. Android flashlight app using camera api 2 [closed]
  2. How to refacor a code use only loops and simple arrays?
  3. having an exception when saving oracle type object in some entity
  4. Java Getting values of 0 in Array
  5. What is the memory consumption of an object in Java?
  6. Update JLabel every X seconds from ArrayList – Java
  7. What causes “‘void’ type not allowed here” error
  8. What does the “static” modifier after “import” mean?
  9. Paginating text in Android
  10. Java GUI frameworks. What to choose? Swing, SWT, AWT, SwingX, JGoodies, JavaFX, Apache Pivot? [closed]
  11. Run a command over SSH with JSch
  12. leiningen – how to add dependencies for local jars?
  13. Throttling method calls to M requests in N seconds
  14. Spring Batch – Using an ItemWriter with List of Lists
  15. Sign CSR using Bouncy Castle
  16. How do I pass a variable from one Thread Group to another in JMeter
  17. How to use Jersey as JAX-RS implementation without web.xml?
  18. Spring session-scoped beans (controllers) and references to services, in terms of serialization
  19. Capture generated dynamic content at server side
  20. Disable ok button on JOptionPane.dialog until user gives an input
  21. Does java really have pointers or not? [closed]
  22. Get file name from FileOutputStream
  23. Compare two Byte Arrays? (Java)
  24. How to set JVM arguments in IntelliJ IDEA?
  25. Find the Number of Occurrences of a Substring in a String
  26. Why doesn’t volatile in java 5+ ensure visibility from another thread?
  27. How to sort JTable in shortest way?
  28. Can we run Java applications on iPhone? [closed]
  29. Spring application context : access web.xml context-params?
  30. Including external jar-files in a new jar-file build with Ant

Leave a Comment