Well, kind of funny anyway... :-)
I can't understand why you wrote:
select SDO_TUNE.EXTENT_OF('SCHEMA.MYTABLE','MYUSERNAME') from dual t;
it's the 'MYUSERNAME' part that makes me wonder...
The syntax is supposed to be:
SDO_TUNE.EXTENT_OF(
table_name IN VARCHAR2,
column_name IN VARCHAR2
) RETURN SDO_GEOMETRY;
so that parameter shuould be the geometric column name.
The one you chose in the "Add datastore Layer" dialog.
I tried using "my" Oracle server and it worked with this syntax:
SELECT SDO_TUNE.EXTENT_OF('INTERSCAMBIO.SIS_ELEMENTO_STRADALE','GEOM') FROM
DUAL t
As you can see the first parameter is the schema-qualified table name
and the second is the geometric column name. The schema name INTERSCAMBIO
is the default schema for the logged-in user INTERSCAMBIO, and gets
automatically used when you use that famous '-' dash.
Alas, in the "Add datastore Layer" dialog you are not forced to choose
only one of the listed table names, you can write it by yourself and you
can do it using a schema-qualified name (SCHEMA.TABLE) or omitting the
schema (TABLE). Try playing with that also.
I don't know, maybe there's a difference in the schemas structures
between "my" server and yours...
Or is the column name that's wrong...
If you want to modify the source code you can try with:
builder.appendLine("SELECT SDO_TUNE.EXTENT_OF('${t_nq}','${EXTENT_GEOM_nq}')
FROM ${EXTENT_TABLE} t");
but it may do more harm than heal...
The difference should just be in that '${t_nq}' that gets only the table name,
instead of the original '${st_nq}' that gets schema.table.
Good luck!!!
Bye
Paolo
P.S: If you modify the source like that it'll stoop working for PostGIS,
obviously...
> -----Messaggio originale-----
> Da: Stefan Steiniger [mailto:[EMAIL PROTECTED]
> Inviato: mercoledì 3 dicembre 2008 18.59
> A: List for discussion of JPP development and use.
> Oggetto: [JPP-Devel] R: [Fwd: [jump-pilot - Problems with PlugIns] RE:
> Problems getting Oracle Connection]
>
>
> 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
>
-------------------------------------------------------------------------
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
