[Gvsig_english] 1.9 RC2 and Oracle 11g

[Juan Lucas Dominguez Rubio]

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 <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


-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://listserv.gva.es/pipermail/gvsig_internacional/attachments/20091028/d2b204db/attachment.htm