problems with long fields and JAC in Oracle Lite

We have encountered several problems while evaluating Oracle8i Lite 4.0.0.1.0 for Windows NT/98:

1. Long data types (created in SQL) are not recognized by Oracle Lite Designer or Java applications. Error: "unknown sdtTypeCode from getTypeCode method".
2. Inserting text longer than 4097 bytes into long fields results in POL-2403 ("string was right truncated")/SQL 22001 ("allocate a longer buffer"). However, no information about how to allocate different buffer sizes is available.
3. Error in the example for JAC simple persistent objects (University.class). An array of students is assigned to a course object. However, only the first student object in the array shows up when the course object is retrieved from the persistent state by the provided Java example code or when it is inspected by Oracle Lite Designer.

The full functionality of these features is crucial to our objectives of storing complex biological objects in the database. For storing genomic sequence information we need the "long" data type, and arrays and object hierarchies for storing the sequence-encoded features.

For making any purchase decisions, we need to know whether these problems represent bugs or "features" and whether it will be possible to resolve them.

Dr. Les Klimczak              |  mailto:lklimcza_at_sas.upenn.edu
Senior Scientist              |  http://www.sas.upenn.edu/~lklimcza

Akkadix Corporation, S. 160   |  http://www.akkadix.com/lkl.html

11099 N. Torrey Pines Rd.     |  Tel.:     (619) 646 8241
La Jolla, CA 92037            |  FAX:      (619) 452 6653


_____________________________________________________________________