Hi Nicolas,

I clarify that your DataStore does read Oracle 11g. The issue is that before 
Ede was adding something to the soup the DB Query plugin was able to read also 
Oracle 12c (with ojdbc6.jar) but not afterwards. It feels to me that something 
in the package is not ready for 12c.

I have good opportunity to test during a few next weeks before we have switched 
everything into 12c.

-Jukka



Nicolas Ribot wrote:

Hi Jukka,

Yes it should read Oracle 11g.

I think I have some stuff to commit from this plugin and also from DataStore 
Panel.

I'm on it this afternoon and will keep you posted.

Nicolas

On 4 December 2015 at 14:16, Rahkonen Jukka (MML) 
<[email protected]<mailto:[email protected]>>
 wrote:
Hi Nicolas and Ede,

There may be something in Oracle Datastore plugin that does not work with new 
Oracle 12 c version.  The error I get is

"ORA-28040: No matching authentication protocol"

I noticed that with the snapshot versions r4559 and above. They do read data 
from Oracle 11g.

The error with recent snapshots affects also DB Query plugin. For example with 
version r4555 (2015-11-22) DB Query can read Oracle 12c. I suppose that there 
is some outdated component in the additions that Ede made which makes problem 
with 12c. If we can’t find and correct this issue we should consider reverting 
that changeset.

I have used same ojdbc6.jar and gt-oracle-spatial-2.3.2.jar in all tests.

-Jukka Rahkonen-


Nicolas Ribot wrote:

Hi,

yes, I made some tests (packed into a plugin) to add more spatial databases 
support in OJ, based on DBQuery plugin that can already access Sqlite and 
Oracle Spatial through direct SQL commands.

The plugin is read-only and allows to load Sqlite, MariaDB, OracleSpatial 
layers in the same Data Store Layer wizard used for PostGIS.

AFAIU from Michael, adding a generic write support would not trivial.

Nicolas

On 3 December 2015 at 12:16, <[email protected]<mailto:[email protected]>> 
wrote:
Nicolas released a plugin  early this year. Maybe that fit's your purpose?
 
http://jump-pilot-devel-openjump-develop-and-use.1063199.n5.nabble.com/JPP-Devel-Oracle-Spatial-DataStore-plugin-td5711015.html

just send it again as the previous mail was miraculously considered SPAM.

..ede

On 02.12.2015 18:12, Rahkonen Jukka (MML) wrote:
> Hi,
>
>
>
> The DB Query plugin is perhaps the most robust and fastest client for Oracle 
> Spatial but it is definitely read only and knowing the current developer team 
> I would say that read/write Oracle driver won’t come. For sure it will not be 
> based on DB Query because it is skipping all the metadata stuff in Oracle. I 
> would have a look at Kosmo GIS http://opengis.es/ instead which is much like 
> OpenJUMP and which can also edit Oracle Spatial data.
>
>
>
> -Jukka Rahkonen-
>
>
>
>
>
> Luis Paolini wrote:
>
>
>
> Hi folks,
>
>
>
>                              I’d like to know if OpenJump, using Database 
> Query Plugin, is able to edit geometries stored into Oracle Spatial tables.
>
>
>
> TIA,
>
> Luis
>
>
>
> ------------------------------------------------------------------------------
> Go from Idea to Many App Stores Faster with Intel(R) XDK
> Give your users amazing mobile app experiences with Intel(R) XDK.
> Use one codebase in this all-in-one HTML5 development environment.
> Design, debug & build mobile apps & 2D/3D high-impact games for multiple OSs.
> http://pubads.g.doubleclick.net/gampad/clk?id=254741911&iu=/4140
>
>
>
> _______________________________________________
> Jump-pilot-devel mailing list
> [email protected]<mailto:[email protected]>
> https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
>

------------------------------------------------------------------------------
Go from Idea to Many App Stores Faster with Intel(R) XDK
Give your users amazing mobile app experiences with Intel(R) XDK.
Use one codebase in this all-in-one HTML5 development environment.
Design, debug & build mobile apps & 2D/3D high-impact games for multiple OSs.
http://pubads.g.doubleclick.net/gampad/clk?id=254741911&iu=/4140
_______________________________________________
Jump-pilot-devel mailing list
[email protected]<mailto:[email protected]>
https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel


------------------------------------------------------------------------------
Go from Idea to Many App Stores Faster with Intel(R) XDK
Give your users amazing mobile app experiences with Intel(R) XDK.
Use one codebase in this all-in-one HTML5 development environment.
Design, debug & build mobile apps & 2D/3D high-impact games for multiple OSs.
http://pubads.g.doubleclick.net/gampad/clk?id=254741911&iu=/4140
_______________________________________________
Jump-pilot-devel mailing list
[email protected]<mailto:[email protected]>
https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel

------------------------------------------------------------------------------
Go from Idea to Many App Stores Faster with Intel(R) XDK
Give your users amazing mobile app experiences with Intel(R) XDK.
Use one codebase in this all-in-one HTML5 development environment.
Design, debug & build mobile apps & 2D/3D high-impact games for multiple OSs.
http://pubads.g.doubleclick.net/gampad/clk?id=254741911&iu=/4140
_______________________________________________
Jump-pilot-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel

Reply via email to