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