[Geotools-devel] R: Geoserver and Oracle

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view

[Geotools-devel] R: Geoserver and Oracle

P.Rizzi Ag.Mobilità Ambiente
I CCed this to GeoTools, because it's where DataStores lives.

> -----Messaggio originale-----
> Da: Bart van den Eijnden [mailto:[hidden email]]
> Inviato: mercoledì 26 ottobre 2005 15.52
> A: [hidden email]
> Cc: [hidden email]
> Oggetto: Re: [Geoserver-users] Geoserver and Oracle
> Hi Chris,
> thanks for your clear reply.
> I have opened up a JIRA task for the first one:
> http://jira.codehaus.org/browse/GEOS-432
> Best regards,
> Bart
Please, see my comment to the above JIRA.

> >
> > 2)  with PostGIS the geometry type is somehow deducted from
> the table
> > (or the metadata tables), ie in the feature type editor for PostGIS
> > it says:
> >
> >  the_geom:   multiPolygonProperty nillable:true
> min:0 max:1
> >
> > but for Oracle it says:
> >
> >  ORA_GEOMETRY:   nillable:true min:0 max:1
> >
> > so the geometry type does not seem to get deducted. Why is this?
> Because oracle's typing system is looser.  In Postgis if you have a
> multiline table, you can only stick in multilines.  In oracle you can
> stick in just about anything - it doesn't define constraints on your
> geometries, or at least not commonly.  I always get confused as to how
> much information you actually can determine - I think there's
> some code
> that may be able to distinguish between say lines and points.  But the
> basic answer is that oracle does not constrain it's columns, so we
> can't easily derive such information.
In Oracle there's no metadata about the specific Geometry type of a column.
Each record can contain a different type.
We may try to determine it by looking at the first record, but I don't know
if it's worth it. I filed an improvement-JIRA issue for this:

> best regards,
> Chris
> >
> > Best regards,
> > Bart

Paolo Rizzi

Le informazioni contenute in questo messaggio di posta elettronica e/o nel/i
file/s allegato/i, sono da considerarsi strettamente riservate. Il loro
utilizzo è consentito esclusivamente al destinatario del messaggio, per le
finalità indicate nel messaggio stesso. Qualora riceveste questo messaggio
senza esserne il destinatario, Vi preghiamo cortesemente di darcene notizia
via e-mail e di procedere alla distruzione del messaggio stesso,
cancellandolo dal Vostro sistema; costituisce comportamento contrario ai
principi dettati dal D. Lgs. 196/2003 il trattenere il messaggio stesso,
divulgarlo anche in parte, distribuirlo ad altri soggetti, copiarlo, od
utilizzarlo per finalità diverse.

This SF.Net email is sponsored by the JBoss Inc.
Get Certified Today * Register for a JBoss Training Course
Free Certification Exam for All Training Attendees Through End of 2005
Visit http://www.jboss.com/services/certification for more information
Geotools-devel mailing list
[hidden email]