1.9 RC2 and Oracle 11g

3 messages Options
Embed this post
Permalink
piero.cavalieri

1.9 RC2 and Oracle 11g

Reply Threaded More More options
Print post
Permalink
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
[hidden email]
http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional
jldominguez

Re: 1.9 RC2 and Oracle 11g

Reply Threaded More More options
Print post
Permalink
Some javascript/style in this post has been disabled (why?)
[Gvsig_english] 1.9 RC2 and Oracle 11g
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:
 
 
If you are more comfortable with Italian you can also see it in page 179 of this manual:
 
 
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: [hidden email] en nombre de Piero Cavalieri
Enviado el: mié 28/10/2009 11:07
Para: [hidden email]
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
[hidden email]
http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional


_______________________________________________
Gvsig_internacional mailing list
[hidden email]
http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional
piero.cavalieri

Re: 1.9 RC2 and Oracle 11g

Reply Threaded More More options
Print post
Permalink
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 <[hidden email]>:

> 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: [hidden email] en nombre de Piero Cavalieri
> Enviado el: mié 28/10/2009 11:07
> Para: [hidden email]
> 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
> [hidden email]
> http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional
>
> _______________________________________________
> Gvsig_internacional mailing list
> [hidden email]
> http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional
>
>



--
Piero Cavalieri
_______________________________________________
Gvsig_internacional mailing list
[hidden email]
http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional