Using HSQLDB trying to store large data HTML source code clobs not implemented?

[steve labar]

Im trying to use a clob data type to store html source code because those files can get pretty large. However, it appears none of the setters to write clobs are currently supported? How else can I store this kind of data to a column in my hsqld? varchar is too small? Please any help will be greatly appreciated.

Here what was throwing not supported exception.

   	 public boolean sqlInsert(String uuid,String request,String response,String host,int thePortToUse,int thePortToUsed,boolean isSecure) {
	         boolean status = false;
	         try {
                
	        	     prstInsert.setString(1, uuid);
	        	     prstInsert.setClob(2, new JDBCClob(request));
	        	     prstInsert.setClob(3, new JDBCClob(response));
	        	     prstInsert.setString(4, host);
	        	     prstInsert.setInt(5, thePortToUse);
	        	     prstInsert.setInt(6, thePortToUsed);
	        	     prstInsert.setBoolean(7,isSecure);
	       
	                 // perform the insert statement
	                 int nbChanged = statementExecute(prstInsert);
	                 int id = -1;
	                 if(nbChanged > 0)
	                 {
	                	 status = true ;
	                 }
	                 
	                 prstRequest.setString(1, uuid);
	     			ResultSet rs =  queryExecute(prstRequest);
	     			rs.next();
	     			Clob req = rs.getClob("request");
	     			Writer w = null;
	     			w = req.setCharacterStream(1);<======================= no setter for clobs appear to be working?
	     			try {
						w.write("request");
						w.flush();
		     			w.close();
					} catch (IOException e) {
						// TODO Auto-generated catch block
						e.printStackTrace();
					}
					*/
	     			 
	                 System.out.println("Statement execute " + prstInsert + " rows affected " + nbChanged + " status " + status + " key: " + id);
	         }
	         catch(SQLException e) {
	                 System.out.println("Transaction sqlInsert() exception: " + e);
	         }
	         return status;
	 }
		  

I would also like to add that after more research it appearsblob setters for writing to db is also not supported? It looks like the largest thing i got is longvarchar but it looks like max on this is 32k not big enough. Wow this sucks!. I wonder if i serialize if that do the trick?