[Gvsig_english] Oracle Spatial and JDBC

Thu Feb 19 14:58:04 CET 2009

It's working!
Thanks!!!

On Thu, Feb 19, 2009 at 12:34 PM, Juan Lucas Dominguez Rubio <
jldominguez at prodevelop.es> wrote:

>  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
> ---
>
> ------------------------------
> *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
>> ---
>>
>> ------------------------------
>>  *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
>>> ---
>>>
>>>
>>>
>>> -----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
>>
>>
>
> _______________________________________________
> 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/39c95c89/attachment.htm