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
