A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
JDBC and Relational Databases
Joined: Mar 09, 2005
Jun 28, 2005 19:39:00
I have a huge text file which contains the emails and city .
There would be thousands of such records in the file .
I have uploaded the file into Oracle into a clob .
Now I want to read the clob and do some procesing for each line
i.e . : email,city
I want to get each line from the clob .
Could someone kindly point me to an example
Also what are the best practices while reading from clob ?
Thanks in advance ,
author & internet detective
Joined: May 26, 2003
Jun 29, 2005 18:04:00
The easest way is to call getCharacterStream() on the Clob. That way you can deal with the result as a familiar reader object.
OCA 8 book
How To Ask Questions The Smart Way
Blogging on Certs:
SCEA Part 1
Part 2 & 3
Core Spring 3
TOGAF part 1
It is sorta covered in the
JavaRanch Style Guide
subject: reading clob
clob.setCharacterStream(1); Unsupported feature
String -> MySQL CLOB
effcient way to parse clob data
HL7 HAPI 1.0 Parser
how to detect end of line
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2015