Hi
I am planning to use JDO for the persistence framework of our application, and
i am in the process of evaluating different JDO implementation before commiting
to the right one.
It'll be greate if you could give me some feedback on these implementation:
TopLink
Openfusion / Prismtech
Castor
The code below shows the DDL of the User Defined data type, do you know if
Castor will be able to support Objects , REFs and Oracle VARRAYs ?
Many Thanks in Advance for your response.
Bruno Georges.
DDL
---
CREATE OR REPLACE TYPE Address_ot AS OBJECT(
adr_street_line_1 VARCHAR2(60),
adr_street_line_2 VARCHAR2(60),
adr_city VARCHAR2(30),
adr_post_code VARCHAR2(14),
adr_county VARCHAR2(35),
adr_country VARCHAR2(44),
adr_full VARCHAR2(255)
)
CREATE OR REPLACE TYPE Person_ot AS OBJECT(
prs_title VARCHAR2(15),
prs_suffix VARCHAR2(80),
prs_first_name VARCHAR2(30),
prs_middle_name VARCHAR2(10),
prs_last_name VARCHAR2(30),
prs_phone_nr VARCHAR2(50),
prs_fax_nr VARCHAR2(50),
prs_mobile_nr VARCHAR2(50),
prs_email VARCHAR2(100),
prs_address Address_ot
)
CREATE TYPE ProductsServices_va IS VARRAY (50) OF VARCHAR2(100)
/
CREATE TABLE Vendors (
vdr_id NUMBER(10) PRIMARY KEY, -- surrogate primary key generated using
sequence
vdr_pk VARCHAR2(50) NOT NULL, -- primary key used as application UNIQUE
identifier
vdr_username VARCHAR2(100) NOT NULL,
vdr_rowtimestamp DATE NOT NULL,
vdr_password VARCHAR2(20),
vdr_detail REF Person_ot, -- the vendor contact info
vdr_contact_detail REF Person_ot, -- the contact details
vdr_completion_address Address_ot,
vdr_news_offers VARCHAR2(10),
vdr_user_agreement VARCHAR2(10),
vdr_cc_email VARCHAR2(51),
vdr_products_services ProductsServices_va
)
-----------------------------------------------------------
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
unsubscribe castor-dev
