Re: [JPP-Devel] R: R: R: [Fwd: [jump-pilot - Problems with PlugIns] RE: Problems getting Oracle Connection]
Hi, All I can say right now is that I have been using succesfully SIS plugin with Oracle so it is for sure possible. It was good to have the normal tricks performed in the database. That is, to have a spatial index and correct entry in user_sdo_geom_metadata. Lately I have been using mostly another OJ plugin, JUMP DB Query Plugin and it works fine. I remember I had first some problems due to different ojdbc14.jar versions I had on my computer, but by trial and error I found one the worked for me. -Jukka Rahkonen- -Alkuperäinen viesti- Lähettäjä: Stefan Steiniger [mailto:[EMAIL PROTECTED] Lähetetty: pe 5.12.2008 19:57 Vastaanottaja: List for discussion of JPP development and use. Aihe: [JPP-Devel] R: R: R: [Fwd: [jump-pilot - Problems with PlugIns] RE: Problems getting Oracle Connection] and it continues.. but he started to program now to solve it :) Original Message Subject:[jump-pilot - Problems with PlugIns] RE: Problems getting Oracle Connection Date: Fri, 05 Dec 2008 16:09:11 + From: SourceForge.net [EMAIL PROTECTED] To: [EMAIL PROTECTED] Read and respond to this message at: https://sourceforge.net/forum/message.php?msg_id=5762225 By: simonecampora hi, I tried the select sys_context( 'userenv', 'current_schema' ) from dual and it returns exactly my default schema name. Then I made the modification on the source code as you said (just to check if the problems was solved by selecting the table without the schemaspace. before) and the problem disappeared! I was albe to start the query, OpenJump recognize the right extention of my geometries, but It didn't load anything. Actually after 30 minutes of compiting I stopped it but I do believe it was sufficient to say that had some problems while loading the data. I also tried making one query to retrieve just one geomtrey and the problem was still there: It finds the right extention but without loading any geometry. I would like to know more about your plugin, do you have any documentation or at least could you give me a piece of advise on how I can understand what is doing the software? e.g. I don't understand the meaning of the modification that I did. (actually I know what but I don't know what those ${variables} are used for) thanks again! 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 -- SF.Net email is Sponsored by MIX09, March 18-20, 2009 in Las Vegas, Nevada. The future of the web can't happen without you. Join us at MIX09 to help pave the way to the Next Web now. Learn more and register at http://ad.doubleclick.net/clk;208669438;13503038;i?http://2009.visitmix.com/ ___ Jump-pilot-devel mailing list Jump-pilot-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel -- SF.Net email is Sponsored by MIX09, March 18-20, 2009 in Las Vegas, Nevada. The future of the web can't happen without you. Join us at MIX09 to help pave the way to the Next Web now. Learn more and register at http://ad.doubleclick.net/clk;208669438;13503038;i?http://2009.visitmix.com/ ___ Jump-pilot-devel mailing list Jump-pilot-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
[JPP-Devel] R: R: R: [Fwd: [jump-pilot - Problems with PlugIns] RE: Problems getting Oracle Connection]
I tryies using the '-' so I got access to the default schema for the logged-in user. Maybe it's this the culprit, something in how your server/database/schena/user, etc. are configured...??? Try with this SQL from any Oracle client: select sys_context( 'userenv', 'current_schema' ) from dual It should return the current default schema for the logged-in user. If it's different from the one you see in the EXTENT_OF() call, then that may be the problem. Then you can manually try the EXTENT_OF() using 'SCHEMA.TABLE' with this schema, if it's different. I don't know if the EXTENT_OF() needs an entry for the table you want the extent of inside the user_sdo_geom_metadata table, but check it's presence. And also check if it's listed there with just the TABLE_NAME or the SCHEMA_NAME also. I'm not the owner of the Oracles I connect to, so I'm sure about the version, but I think it's the same of yours 10g and it contains a few schemas (one for each user, that's the way Oracle works, I think)... Now, and up to Friday, I have no access to the server, so I can't make any other check. Bye Paolo Rizzi Da: Stefan Steiniger [mailto:[EMAIL PROTECTED] Inviato: mer 03/12/2008 20.22 A: List for discussion of JPP development and use. Oggetto: [JPP-Devel] R: R: [Fwd: [jump-pilot - Problems with PlugIns] RE: Problems getting Oracle Connection] Original Message Subject:[jump-pilot - Problems with PlugIns] RE: Problems getting Oracle Connection Date: Wed, 03 Dec 2008 19:02:18 + From: SourceForge.net [EMAIL PROTECTED] To: [EMAIL PROTECTED] Read and respond to this message at: https://sourceforge.net/forum/message.php?msg_id=5753244 By: simonecampora Oh I'm really sorry! I was citing the code by heart... actually my synthax is exactly like yours the second parameter is the geometry column ( incidently it's the same as the schema name in my case) anyway I still don't know why in my case it is not working while I'm specifying the SCHEMA.TABLE but it works when I use just the TABLE. are you using the - or in the schema parameter? how many shcemas do you have in your database? are you using which version of Oracle? mine is Oracle 10g Entreprise Edition I will try doing that small modification on the code just to see if it's really the problem raised or if there's something more behind... thanks you so much for your precisations :) they are really precious! 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=100url=/ ___ 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=100url=/___ Jump-pilot-devel mailing list Jump-pilot-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel