I'm glad to see the '-' dash solved the schema issue (I think a space should
have been good too,
but I'm too sleepy now to check)...
The error seems to indicate that the function MDSYS.SDO_TUNE or something alike
is not recognized,
so it may not be available (not installed) or it may be unaccessible by the
logged-in Oracle user.
You may try the same SQL select syntax from an Oracle client of some sort
(logged in as the same user)
and see if you get the same error or not. And try also reading the Oracle docs
for spatial SQL
and see what it says about SDO_TUNE and/or EXTENT_OF.
The function is used inside:
DataStoreMetadata.getExtents( String datasetName, String attributeName )
used by OJ to know the complete extent of a layer (I think).
I have no idea how Oracle implements it...
Does it need to find an entry inside the USER_SDO_GEOM_METADATA table???
Maybe there _must_ be a spatial index on the geometric column for it work (I'm
quite sure it's mandatory).
Please, keep in mind that I'm not an Oracle expert and that I tested (briefly I
should add) the plugin only with
two Oracle servers, so it is not guaranteed to work in any environment, I'm
sorry... :-(
Regarding the documentation you are right... I wrote a (very) little readme,
but a few examples may be a good
starting point. But this is maybe just the second person actually using it
(that I heard of, at least)...
Bye
Paolo Rizzi
________________________________
Da: Stefan Steiniger [mailto:[EMAIL PROTECTED]
Inviato: mar 02/12/2008 19.29
A: List for discussion of JPP development and use.
Oggetto: [JPP-Devel] [Fwd: [jump-pilot - Problems with PlugIns] RE: Problems
getting Oracle Connection]
fixed one - and he found another one
.. can be a good documentation if we continue that way ;)
stefan
-------- Original Message --------
Subject: [jump-pilot - Problems with PlugIns] RE: Problems getting
Oracle Connection
Date: Tue, 02 Dec 2008 11:19:25 +0000
From: SourceForge.net <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Read and respond to this message at:
https://sourceforge.net/forum/message.php?msg_id=5747126
By: simonecampora
Sorry for the double posting but I posted the wrong Exception before... I will
copy paste the same message but adding the RIGHT Exception thrown.
Thanks for the help to everybody,however now the connection seems to work
properly,
no geometry has been shown.
First of all, I will post the problems that you solved to me:
1- Firstly I was using a wrong SID in the Oracle Connection Descriptor while
creating my TNS string. I solved it looking directly into the tnsnames.ora of
the server
2- As the last reply has shown to me, there was an "unknown" problem while
recognizing the schema, hence when I used the "-" dash, everything worked fine!
(I tried using the " " space instead because I misunderstood the guidelines.. !)
Now my problem is another one: When I'm loading the SDO_GEOMETRY column it gives
me in the status bar (in the bottom right corner of openjump main window) a
yellow box saying:
------------
StatementCallback; uncategorized SQLException for SQL [SELECT
SDO_TUNE.EXTENT_OF('MYUSER.MYTABLE','MYCOLUMNATTR') from DUAL t]; SQL state
[99999]; error CODE [44003]; ORA-44003: invalid SQL nameORA-06512: at
MDSYS.SDO_TUNE
line 881; nested exception is java.sql.SqlException: ORA-44003: invalid SQL
nameORA-06512: at MDSYS.SDO_TUNE line 881 (Uncategorized SQL Exception)
------------
The problem is that I cannot see anything (I also tried changing the style)
on my added layer. It could be a problem related to that exception? If you want
I can link a screenshot.
p.s. I tried opening the same SDO_GEOMETRY columns with other GIS tools like
Manifold, and the data wew visualized properly, so I supose it could not be
a problem of the data.
thanks again for the help!
Simone
______________________________________________________________________
You are receiving this email because you elected to monitor this forum.
To stop monitoring this forum, login to SourceForge.net and visit:
https://sourceforge.net/forum/unmonitor.php?forum_id=729480
-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Jump-pilot-devel mailing list
Jump-pilot-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Jump-pilot-devel mailing list
Jump-pilot-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
