How to upload and retrieve text files to/from Database CLOB column?
By sakthi on Feb 01, 2006
This Simple Creator 2 Project zip demos how to upload text files into database CLOB column and retrieve back those files.
How to get the sample app running:
CREATE TABLE DEMO_CLOB ( ID_COL INTEGER IDENTITY PRIMARY KEY, CLOB_COL CLOB)
What's wired in this project:
- A ClobConverter class. It is declared in WEB-INF/faces-config.xml and the attribute converter="ClobConverter" is added in JSP to the tableColumn bound to CLOB_COL
- Upload button action fetches the file contents and updates the database