[Gvsig_english] gvSIG now connects to Oracle Spatial

[Wolfgang Qual]

Dear Simone,
thanks for your message. Really helpful! Great.
Best regards,
Wolfgang


Am Mittwoch 16 Mai 2007 pH:11:16 nachmittags/abends schrieb 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://ww
>w.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/descarga
>s/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