I CCed this to GeoTools, because it's where DataStores lives.
> -----Messaggio originale-----
> Da: Bart van den Eijnden [mailto:[EMAIL PROTECTED]
> Inviato: mercoledì 26 ottobre 2005 15.52
> A: [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]
> 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
[email protected]
https://lists.sourceforge.net/lists/listinfo/geotools-devel
