keeps going - but I like the thread (sadly for Paolo) -------- Original Message -------- Subject: [jump-pilot - Problems with PlugIns] RE: Problems getting Oracle Connection Date: Wed, 03 Dec 2008 13:45:08 +0000 From: SourceForge.net <[EMAIL PROTECTED]> To: [EMAIL PROTECTED]
Read and respond to this message at: https://sourceforge.net/forum/message.php?msg_id=5752065 By: simonecampora Hi! Well, I hope to be more helpful for the development of this plugin! I tried to look at the source but I don't know how to solve it, however I know where the problem is. I tried to run the same query on Oracle 10g and obviously it didn't work. the query is something like: select SDO_TUNE.EXTENT_OF('SCHEMA.MYTABLE','MYUSERNAME') from dual t; the problem is that on Oracle the same query is working when i use the synthax select SDO_TUNE.EXTENT_OF('MYTABLE','MYUSERNAME') from dual t; do you know how to modify that query on your plugin code? I've just seen something like ---SISDBSMetadata.java----- public Envelope getExtents( String datasetName, String attributeName ) { //use geometry(extent()) to make sure a geometry is returned, not a BOX CommandBuilder builder = new CommandBuilder(conn.getData()); //builder.appendLine("SELECT geometry(extent(${specifiedgeom}))"); //to support all different adapters, let them specify the table to act upon, //because some of them will want to use something like "SELECT xxx FROM DUAL" //instead of "SELECT xxx FROM some_table" //builder.appendLine("SELECT ${EXTENT} FROM ${st} t"); builder.appendLine("SELECT ${EXTENT} FROM ${EXTENT_TABLE} t"); -------- and I imagine I should modify the ${EXTENT} string but I don't know how. thanks for the help ______________________________________________________________________ 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