From: Markus Fuchs <Markus.Fuchs_at_Sun.COM>
Date: Wed, 23 Aug 2006 17:55:45 -0700

Hi Tom,

Issue 691 is about Java2DB creating a table having two LONG fields on
Oracle. Oracle does not permit to create such a table, and the test
fails. The entity in the test has two fields that are annotated @Lob,

   @Lob
   @Column(name = "BLOBDATA")
   public byte[] getBlobData(){

and

   @Lob
   @Column(name = "CLOBDATA")
   public String getClobData(){

Because of the @Lob annotation, these fields are recognized by TopLink
as type java.sql.Blob and java.sql.Clob respectively. I've changed
OraclePlatform to register column type BLOB and CLOB the these java
types in fieldTypeMapping, please see attached. After the change, the
table has a BLOB and a CLOB column, and can be created successfully.

I ran QL and TL unit tests successfully.

Thanks!

-- markus.