Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> problems with long fields and JAC in Oracle Lite

problems with long fields and JAC in Oracle Lite

From: Les Klimczak <lklimcza_at_mail1.sas.upenn.edu>
Date: 30 Sep 1999 20:56:54 GMT
Message-ID: <7t0iqm$ld0$1@netnews.upenn.edu>


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

_____________________________________________________________________
Received on Thu Sep 30 1999 - 15:56:54 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US