[Gvsig_english] Oracle Spatial and JDBC

Thu Feb 19 13:34:37 CET 2009

Hello,

you need to copy the 'ojdbc5.jar' file to the folder:

[GVSIG_FOLDER]\bin\gvSIG\extensiones\com.iver.cit.gvsig\lib\

and restart gvSIG. It can be also downloaded from:

http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/index.html

I still have not tested ojdbc6.jar, but I dont think you have any problem with it.

Regards,

Juan Lucas Domínguez Rubio
---
Prodevelop SL, Valencia (España)
0° 22' 49.62" W, 39° 28' 25.45" N
Tlf.: 96.351.06.12 -- Fax: 96.351.09.68
http://www.prodevelop.es <http://www.prodevelop.es/> 
---

________________________________

De: gvsig_internacional-bounces at runas.cap.gva.es en nombre de Antonio Pedro
Enviado el: jue 19/02/2009 13:17
Para: Users and Developers mailing list
Asunto: Re: [Gvsig_english] Oracle Spatial and JDBC

Ok, but I onlY see 3 drivers and no one is Oracle JDBC as you can see in the images. 

Thanks a lot!
aps

On Thu, Feb 19, 2009 at 11:30 AM, Juan Lucas Dominguez Rubio <jldominguez at prodevelop.es> wrote:

	Hello.

	From the log file you have sent, I guess you are trying to add a table to your gvSIG project (project manager - table - new - database). This functionality is normally used with alphanumeric databases but has known bugs, and does not work most of the times.

	But you say you have an Oracle Spatial database. If your tables have geometry fields, you can add them as vector layers (project manager - view - new - add layer - GeoBD) and then the attributes of that layer will be filled with the alphanumeric columns of the table. If your tables do not have geometry fields, perhaps you can add a geometry field with a NULL value, or a very simple geometry. In this case, you will have to update the view MDSYS.USER_SDO_GEOM_METADATA.

	Regards,

	Juan Lucas Domínguez Rubio
	---
	Prodevelop SL, Valencia (España)
	0° 22' 49.62" W, 39° 28' 25.45" N
	Tlf.: 96.351.06.12 -- Fax: 96.351.09.68
	http://www.prodevelop.es <http://www.prodevelop.es/> 
	---

________________________________

	De: gvsig_internacional-bounces at runas.cap.gva.es en nombre de Antonio Pedro

	Enviado el: jue 19/02/2009 11:10
	Para: Users and Developers mailing list
	Asunto: Re: [Gvsig_english] Oracle Spatial and JDBC

	Hi Juan,

	I want to be a gvSIG user but i'm also an Oracle developer. 

	In the directory C:\oracle\ora11g\product\11.1.0\client_1\jdbc\lib I have ojdbc5.jar, ojdbc5_g.jar, ojdbc6.jar and ojdbc6_g.jar.

	The log is in attach.

	Thanks a lot,
	aps

	On Wed, Feb 18, 2009 at 7:34 PM, Juan Lucas Dominguez Rubio <jldominguez at prodevelop.es> wrote:

		Hello, Antonio.

		Are you talking as a user or as a developer?
		Have you downloaded the file ojdbc14.jar from the Oracle website as the user manual says?
		Can you send the full log file to the list? (c:\documents and settings\<user>\gvSIG\gvSIG.log)

		Regards,

		Juan Lucas Domínguez Rubio
		---
		Prodevelop SL, Valencia (España)
		0° 22' 49.62" W, 39° 28' 25.45" N
		Tlf.: 96.351.06.12 -- Fax: 96.351.09.68
		http://www.prodevelop.es <http://www.prodevelop.es/> 
		---

		-----Mensaje original-----
		De: gvsig_internacional-bounces at runas.cap.gva.es en nombre de Antonio Pedro
		Enviado el: mié 18/02/2009 19:45
		Para: gvsig_internacional at runas.cap.gva.es
		Asunto: [Gvsig_english] Oracle Spatial and JDBC 

		Hi all,
		I have Oracle Spatial 11g and I want to connect gvSIG with the DB and gives
		me the error:

		java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver

		I searched in my ORACLE_HOME and I found this
		in C:\oracle\ora11g\product\11.1.0\client_1\jdbc\Readme.txt:

		Support for Java Standard Edition 6 (JSE6) and JDBC 4.0
		    JSE 6 (AKA Mustang) is supported by the Thin and OCI drivers
		    including support for the new JDBC spec, JDBC 4.0. The new
		    java.sql.SQLXML type is not supported in this release. JSE 6 is
		    supported by the new Oracle JDBC jar files: ojdbc6.jar,
		    ojdbc6_g.jar, ojdbc6dms.jar, and ojdbc6dms_g.jar. This
		    release conforms with the JSE 6 production release.

		    J2SE 5.0 and JDBC 3.0 are fully supported by the other jars
		    contained in this release. The Server Internal Driver and Thin in
		    the Server driver support J2SE 5/ JDK 1.5 only.

		Desupport of oracle.jdbc.driver
		    In the initial release of the Oracle JDBC drivers customers were
		    advised to use the classes defined in the package
		    oracle.jdbc.driver. This has caused problems for customers and for
		    Oracle. In Oracle JDBC release 9.0.1 customer use of the classes
		    in that package was deprecated. A new package, oracle.jdbc, was
		    introduced and customers were advised to begin using the
		    interfaces and classes defined in oracle.jdbc. 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 you are using a class in oracle.jdbc.driver which does
		    not have an equivalently named type in oracle.jdbc, then customer
		    use of that class was never supported and you will need to find
		    another solution. The only exception is
		    oracle.jdbc.driver.OracleLog. Customers can still reference that
		    class for debugging purposes. Even in that case Oracle reccommends
		    that you use the Oracle JDBC Diagnosability MBean instead. See the
		    Oracle JDBC Developer's Guide for details.

		I have gvSIG 1.1.2 and Java 1.5.0_11.

		Is there a version that works with oracle.jdbc?

		Thanks,
		Antonio Pedro Santos

		_______________________________________________
		Gvsig_internacional mailing list
		Gvsig_internacional at runas.cap.gva.es
		http://runas.cap.gva.es/mailman/listinfo/gvsig_internacional

	_______________________________________________
	Gvsig_internacional mailing list
	Gvsig_internacional at runas.cap.gva.es
	http://runas.cap.gva.es/mailman/listinfo/gvsig_internacional

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://runas.cap.gva.es/pipermail/gvsig_internacional/attachments/20090219/296753f4/attachment.htm