[Gvsig_english] 1.9 RC2 and Oracle 11g

[Piero Cavalieri]

Ok, thank you for the answer.
I didn't read the manual (cause I just started with Oracle and gvSIG
yesterday evening) so I took the wrong gvSIG lib dir...
For the deprecated jdbc namespace, I think you will do the right tests.

Thanks again
 Piero



2009/10/28 Juan Lucas Dominguez Rubio <jldominguez at prodevelop.es>:
> Hello, Piero,
>
> the file ojdbcX.jar must be copied to the folder:
>
> gvSIG_XXX / bin / gvSIG / extensiones / com.iver.cit.gvsig / lib
>
> as described in page 158 of this manual:
>
> ftp://downloads.gvsig.org/gva/descargas/manuales/gvSIG-1_1-man-v1-en.pdf
>
> If you are more comfortable with Italian you can also see it in page 179 of
> this manual:
>
> ftp://downloads.gvsig.org/gva/descargas/manuales/gvSIG-1_1-man-v1-it.pdf
>
> kindly translated by the Italian gvSIG community.
>
> As for the new driver recommended by Oracle, thanks, we'll look into it, but
> it shouldn't cause existing software to stop working.
>
> Regards,
>
> Juan Lucas Domínguez Rubio
> ---
> Prodevelop SL, Valencia (España)
> Tlf.: 96.351.06.12 -- Fax: 96.351.09.68
> http://www.prodevelop.es
> ---
> ________________________________
> De: gvsig_internacional-bounces at listserv.gva.es en nombre de Piero Cavalieri
> Enviado el: mié 28/10/2009 11:07
> Para: gvsig_internacional at listserv.gva.es
> Asunto: [Gvsig_english] 1.9 RC2 and Oracle 11g
>
> Hi all,
>
> I'm new to gvSIG (and Oracle too, having a MSSQL background ), and
> wanted to try gvSIG with Oracle 11g Standard (with Spatial extension)
> to make some (spatial) editing tests with this DB.
>
> The Oracle extension is not loaded and in gvSIG logs:
>
> ...
> Caused by: java.lang.RuntimeException:
> java.lang.ClassNotFoundException: IO
> error:oracle.jdbc.driver.OracleDriver
>         at
> es.prodevelop.cit.gvsig.fmap.drivers.jdbc.oracle.OracleSpatialDriver.<clinit>(OracleSpatialDriver.java:176)
>         ... 21 more
> Caused by: java.lang.ClassNotFoundException: IO
> error:oracle.jdbc.driver.OracleDriver
>         at
> com.iver.andami.plugins.PluginClassLoader.loadClass(PluginClassLoader.java:251)
>         at java.lang.ClassLoader.loadClass(Unknown Source)
>         at java.lang.ClassLoader.loadClassInternal(Unknown Source)
>         at java.lang.Class.forName0(Native Method)
>         at java.lang.Class.forName(Unknown Source)
>         at
> es.prodevelop.cit.gvsig.fmap.drivers.jdbc.oracle.OracleSpatialDriver.<clinit>(OracleSpatialDriver.java:173)
>         ... 21 more
> ...
> ...
> Unable to instantiate ROWID (oracle jar missing?) : IO
> error:oracle.sql.ROWID
> WARN AWT-EventQueue-1
> es.prodevelop.cit.gvsig.jdbc_spatial.ExportOracleExtension -
> *-----------------------------------------------------------------------*
> WARN AWT-EventQueue-1
> es.prodevelop.cit.gvsig.jdbc_spatial.ExportOracleExtension - * Oracle
> JDBC library (ojdbc*.jar) not found. You need to copy that
> WARN AWT-EventQueue-1
> es.prodevelop.cit.gvsig.jdbc_spatial.ExportOracleExtension - * jar
> file to gvSIG's main lib folder if you intend to access
> WARN AWT-EventQueue-1
> es.prodevelop.cit.gvsig.jdbc_spatial.ExportOracleExtension - * Oracle
> Spatial/Locator databases.
> WARN AWT-EventQueue-1
> es.prodevelop.cit.gvsig.jdbc_spatial.ExportOracleExtension - * Read
> gvSIG manual (Oracle driver section) for details.
> WARN AWT-EventQueue-1
> es.prodevelop.cit.gvsig.jdbc_spatial.ExportOracleExtension -
> *-----------------------------------------------------------------------*
> ...
>
> The jar file is in the right place
>
> gvSIG_1.9_RC2\lib\ojdbc5.jar
>
>
> But, as Oracle reported in the jdbc READEME:
>
> ...Desupport of oracle.jdbc.driver...In every release
>     since 9.0.1 we have encouraged customers to switch to oracle.jdbc
>     and stated that oracle.jdbc.driver would be desupported. The time
>     has come. Customer code that references oracle.jdbc.driver will
>     not compile and will not execute in this and future releases of
>     the Oracle JDBC drivers. Please use oracle.jdbc instead.
>
>
> If it's "only" a namespace problem,is there any plan to adjust to the
> correct namespace (or there are customers around which use versions
> prior 9.01. ?)
>
> Thanks in advance
>  Piero
>
> --
> Piero Cavalieri
> _______________________________________________
> Gvsig_internacional mailing list
> Gvsig_internacional at listserv.gva.es
> http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional
>
> _______________________________________________
> Gvsig_internacional mailing list
> Gvsig_internacional at listserv.gva.es
> http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional
>
>



-- 
Piero Cavalieri