|
Home > Archive > Apache JDO Project > March 2006 > Testing with Oracle
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Testing with Oracle
|
|
| Craig L Russell 2006-03-21, 5:46 pm |
| | |
| Andy Jefferson 2006-03-21, 5:46 pm |
| Hi Craig,
> I'd like to be sure we know how to configure a JPOX TCK run for Oracle. Has
anyone done this?
Not me. I don't have Oracle either. There are many JPOX users using Oracle
(including Jorg) on their own apps. There's an outstanding issue with large
BLOB/CLOBs but not sure if you'll hit that with the TCK.
> The only issue I know of is that Oracle doesn't support IDENTITY columns for
datastore identity.
> I'd consider changing the run rules to allow either IDENTITY or SEQUENCE to be
used, but
> I don't know the details on how to configure the .orm file for datastore
identity when using SEQUENCE.
That is probably the only significant issue I can think of.
See below also.
> I understand that JPOX made some changes to be able to support NATIVE for both
Derby and Oracle;
> can you tell me what the status of this change is?
JPOX supports "native" on all major RDBMS. These do include Oracle 8-10. "native"
for Oracle will mean to use SEQUENCE if the user also specifies the <field>
"sequence" attribute specifying the sequence name, otherwise to use our
incrementing id generator.
--
Andy
| |
| Erik Bengtson 2006-03-23, 8:46 pm |
| Hi,
I have not. If someone validates the schema against Oracle, I would run tck
against JPOX and report issues.
Quoting Craig L Russell <Craig.Russell@Sun.COM>:
> Javadogs,
>
> I'd like to be sure we know how to configure a JPOX TCK run for
> Oracle. Has anyone done this?
>
> The only issue I know of is that Oracle doesn't support IDENTITY
> columns for datastore identity. I'd consider changing the run rules
> to allow either IDENTITY or SEQUENCE to be used, but I don't know the
> details on how to configure the .orm file for datastore identity when
> using SEQUENCE.
>
> I understand that JPOX made some changes to be able to support NATIVE
> for both Derby and Oracle; can you tell me what the status of this
> change is?
>
> Thanks,
>
> Craig
>
> Craig Russell
> Architect, Sun Java Enterprise System http://java.sun.com/products/jdo
> 408 276-5638 mailto:Craig.Russell@sun.com
> P.S. A good JDO? O, Gasp!
>
>
|
|
|
|
|