[Gvsig_english] Oracle Spatial and JDBC

[Juan Lucas Dominguez Rubio]

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
	
	


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