db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Michael Segel" <mse...@segel.com>
Subject RE: Using JPOX JDO with Derby
Date Thu, 09 Mar 2006 23:43:47 GMT

Not to nitpick...

There appears to be a problem with your model.

Your cities table doesn't map to your flights table.

Note: you id airports via their 3 letter code.
But you don't map this to the cities.

While this is an example, note that some cities have multiple airports.
(NY has 3*, Chicago has 2 )

Either you goofed on the Airport being a VARCHAR() or you just forgot it....

But hey, what do I know? ;-) Its your paper and your example...



> -----Original Message-----
> From: Susan Cline [mailto:home4slc@pacbell.net]
> Sent: Thursday, March 09, 2006 11:00 AM
> To: derby-user@db.apache.org
> Subject: Using JPOX JDO with Derby
> Hi,
> I wrote a "cook-book" like paper which is now on the Derby
> web site (thanks Jean!) which shows how to use JPOX JDO 1.1
> (the reference implementation of the JDO 2.0 specification)
> with Derby.
>   http://db.apache.org/derby/integrate/JPOX_Derby.html
> Please send any comments, suggestions or corrections to this
> mailing list so I can make sure the paper remains up to date
> and/or is useful to folks.
> The paper includes a download which contains a sample Derby
> database, Java source files and the JPOX JDO meta-data (XML)
> configuration file which maps the Java objects to the
> Derby database tables.
> Cheers,
> Susan

View raw message