[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:
        http://jira.codehaus.org/browse/GEOT-743

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

Bye
Paolo Rizzi




AVVERTENZE AI SENSI DEL D. LGS. 196/2003  
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]
https://lists.sourceforge.net/lists/listinfo/geotools-devel