/* CAN ANYONE PLEASE HELP ME OUT WITH THIS PROGRAM. PLEASE READ THE COMPLETE PROGRAM AND GIVE ME YOUR SUGESTIONS.
THE DATABASE BEING USED IS MS SQLSERVER
This program retreives the text file stored in the database installed by the previous program SaveToClob() (Not displayed in this snippet).
The table created in the database consists of the following columns := static String SQLCommand = "CREATE Table DOCUMENTS(" + "MEMBERID INTEGER NOT NULL PRIMARY KEY, " + "TITLE VARCHAR(20) NOT NULL , " + "DOCUMENT TEXT NOT NULL " + ");";
Program SaveToClob sucessfully saved the following := values = 01, "GLENS_DOCUMENT", "EMPDOCUMENT" Note: "DOCUMENT" is stored as a text file.
When I run the program retreiveFromClob (written below)to retreive the clob I get an error which ia as follows:=
java.lang.UnsupportedOperationException at sun.jdbc.odbc.JdbcOdbcResultSet.getClob(JdbcOdbcResultSet.java:4287) at retreivefromclob.RetreiveFromClob.getFileFromClob(RetreiveFromClob.java:31) at retreivefromclob.RetreiveFromClob.main(RetreiveFromClob.java:60) Exception in thread "main"
It seems to me that MS SQLServer the database I am using doesent support Clobs. If is the case is there any other way of retreiving a clob from this database or what is the alternate name for it.