[Gvsig_english] gvSIG now connects to Oracle Spatial

[Simone Casciaroli]

Hi Wolfgang,
it's not important to have installed the oracle client, but for access
Oracle SDO table you need to download the ojdbc14.jar from the Oracle site
http://www.oracle.com/technology/software/htdocs/distlic.html?url=http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/htdocs/jdbc_10201.html
)
and put them in the GVSIG_HOME/bin/gvSIG/extensiones/com.iver.cit.gvsig/lib
(as is wroted in the user manual
http://www.gvsig.gva.es/fileadmin/conselleria/images/Documentacion/descargas/ficheros/Extensiones/gvSIG-1_0_2-geoBD-man-1_0-es.pdf
).
Best regards

Simone

On 5/16/07, Wolfgang Qual <wolfgang.qual at gmx.net> wrote:
>
> Hello Mario,
> it is very cool that there is now the possibility to connect also to
> Oracle.
> I have 2 questions on this extension:
> 1) The administrator of our oracleDB said that a table for this DB
> contains at
> least two columns: GEOM of type mdsys.sdo_geometry and OGR_FID, type
> number(38) - is this supported by the new extension?
> 2) I installed the new extension on a standalone computer, as I do not yet
> have the permission to connect to the database. When I open gvSIG on this
> computer now, I can acces the GeoBD-dialogue in the add-layer dialogue.
> However, I do not see an option Oracle spatial or something like this;
> only
> HSQLDB, mysql and PostGIS JDBC is displayed- is this ok? Does gvSIG
> automatically add this option, if there's an oracle client installed on
> the
> machine? gvSIG is installed on a debian sarge machine.
>
> Any comments are appreciated.
> Best regards,
> Wolfgang
>
> Am Montag 14 Mai 2007 pH:37:17 nachmittags/abends schrieb Mario Carrera:
> > geoBD extension that allows access to spatial databases, modifying the
> > old interface to access them is available in gvSIG. It also provides the
> > Oracle Spatial connector to the spatial database connector already
> > existing (PostGIS, MySQL, and HSQLDB) allowing the user to access to a
> > any table from either Oracle Spatial or Oracle Locater (since Oracle 9i)
> > containing a geometry column of type SDO GEOMETRY.
> >
> > It is available in the Extensions
> > (http://www.gvsig.gva.es/index.php?id=1652&L=2
> > <http://www.gvsig.gva.es/index.php?id=1652&L=2>) option from the
> > Downloads section of the web page.
> >
> > Advice: To install this extension you must have correctly installed
> > gvSIG 1.0.2 version
> >
> >
> > Regards
> _______________________________________________
> Gvsig_internacional mailing list
> Gvsig_internacional at runas.cap.gva.es
> http://runas.cap.gva.es/mailman/listinfo/gvsig_internacional
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://runas.cap.gva.es/pipermail/gvsig_internacional/attachments/20070516/d09871c4/attachment.htm