Hi,
You could also take a look at the derby reference manual at this link

http://db.apache.org/derby/docs/10.1/ref/rrefclob.html

This page explains about the clob datatype and also contains an example 
of how to use it.

thanx,
V.Narayanan




Jean T. Anderson wrote:
> firstname lastname wrote:
> 
>> I need a simple but complete example of how to insert a CLOB into derby
>> via jdbc.
>> Any help would be appreciated.
> 
> 
> I keep thinking that there must be a complete example by now in the 
> derby mail archives, but I'm not putting my finger on one yet. In the 
> meantime, the functional tests might help:
> 
> http://svn.apache.org/repos/asf/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/ 
> 
> 
> You might look at the code in blobclob4BLOB.java, LOBTest.java, and 
> blobSetBinaryStream.java .
> 
> I hope this helps. Feel free to ask for help if you don't find what 
> you're looking for.
> 
>  -jean
> 
>