[Geoserver-users] Geoserver-users Digest, Vol 12, Issue 33

Please can i have some help with my code here
Its not easy for me cause am not a programmer

I followed the instructions to set up a tiiling from geoserver with my data but the result is tiiling on hybrid map and i do not want this

I need the simple map (nor sattelite or hybrid )

the implementation is here http://www.mpe.gr/gmaps/arxaia.html

ps : i think that someone should rewrite the google tilling code cause google api has changed to v2, and some instructions to do simple things like that would be very helpful. :slight_smile:

keep on the good work guys, geoserver was the solution for me. im not a programmer but im able to publish my data

On 5/25/07, geoserver-users-request@lists.sourceforge.net <geoserver-users-request@lists.sourceforge.net> wrote:

Send Geoserver-users mailing list submissions to
geoserver-users@lists.sourceforge.net

To subscribe or unsubscribe via the World Wide Web, visit
https://lists.sourceforge.net/lists/listinfo/geoserver-users
or, via email, send a message with subject or body ‘help’ to
geoserver-users-request@lists.sourceforge.net

You can reach the person managing the list at
geoserver-users-owner@lists.sourceforge.net

When replying, please edit your Subject line so it is more specific
than “Re: Contents of Geoserver-users digest…”

Today’s Topics:

  1. Re: null value in log file (Andrea Aime)
  2. Re: null value in log file (Steve Marshall)
  3. Re: null value in log file (Andrea Aime)
  4. output format SHAPe-ZIP corrupt (Pilon J. (Jos))
  5. Re: Problems including Views from Oracle Spatial (Rahkonen Jukka)
  6. Re: Problems including Views from Oracle Spatial (Luca Morandini)
  7. Re: Problems including Views from Oracle Spatial (Rahkonen Jukka)

Message: 1
Date: Thu, 24 May 2007 16:42:27 +0200
From: Andrea Aime <aaime@…1…>
Subject: Re: [Geoserver-users] null value in log file
To: “jan w.” < wrobel.jan@…562…>
Cc: Steve Marshall <smarshall@…1212…>,
geoserver-users@lists.sourceforge.net
Message-ID: <4655A453.6050002@…1…>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed

jan w. ha scritto:

hi,

my requests come from on php script running on an IIS, seems to be a
problem with IIS?!
i could never reproduce the behaviour…

Ah, one thing you could do, if the problem is relatively easy to
reproduce, is to run Geoserver interactively, instead of running
it as a service, and copy the stack traces you see from the console
window.

Cheers
Andrea


Message: 2
Date: Thu, 24 May 2007 11:13:31 -0700 (PDT)
From: Steve Marshall <smarshall@…1212…>
Subject: Re: [Geoserver-users] null value in log file
To: geoserver-users@lists.sourceforge.net
Message-ID: <10789565.post@…381…>
Content-Type: text/plain; charset=us-ascii

my requests come from on php script running on an IIS, seems to be a
problem with IIS?!
i could never reproduce the behaviour…

Ah, one thing you could do, if the problem is relatively easy to
reproduce, is to run Geoserver interactively, instead of running
it as a service, and copy the stack traces you see from the console
window.

Andrea,
Sounds like a good sugestion. Unfortunately, the problem is actually rather
difficult to reproduce (the cause is unknown). Therefore, watching the
console is like looking for a needle in a haystack. I tried to startup
GeoServer in a console window, redirecting stdout and stderr to a log file
so I could search through loads of console information at my leisure. I did
the output redirection in the standard Linux way, i.e. by appending" >
log-file 2>&1" to the command. I believe this is also valid syntax for
Windows. However, when started this way, GeoServer seems to be unresponsive
after issuing this log message:

14297 [FINE] org.geotools.data.jdbc.ConnectionPool - Getting available
connection.

Any thoughts why this would happen? Are there any services associated with
Jetty I should restart to make changes take effect?

Thanks for any insights,
Steve


View this message in context: http://www.nabble.com/null-value-in-log-file-tf3680605.html#a10789565
Sent from the GeoServer - User mailing list archive at Nabble.com.


Message: 3
Date: Thu, 24 May 2007 20:21:28 +0200
From: Andrea Aime < aaime@…1…>
Subject: Re: [Geoserver-users] null value in log file
To: Steve Marshall <smarshall@…1212…>
Cc: geoserver-users@lists.sourceforge.net
Message-ID: <4655D7A8.8030307@…1…>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed

Steve Marshall ha scritto:

Any thoughts why this would happen? Are there any services associated with
Jetty I should restart to make changes take effect?

Not really, but I think I have a better suggestion.
Go in the Geoserver control panel, server section, and tell it to save
the logs to file, set a “CONFIG” logging level, submit, apply, and save.
To make sure the file is generated, kill and restart Geoserver, then
you should see a log directory in the Geoserver data dir with a
Geoserver.log file. The file growth will be jumpy, because we buffer
logs in memory and dump them every few kb to avoid slowing it down
too much, but once you have reproduced the issue, just stop
geoserver, and send me the log (by private mail, since the
mailing list won’t accept attachments).

Cheers
Andrea


Message: 4
Date: Fri, 25 May 2007 10:32:21 +0200
From: “Pilon J. (Jos)” < J.Pilon@…273…>
Subject: [Geoserver-users] output format SHAPe-ZIP corrupt
To: <geoserver-users@lists.sourceforge.net>
Message-ID:
< 25BB09C025B3A24F9F035EEDC27EA4DB03E5A43F@…1213…>
Content-Type: text/plain; charset=“us-ascii”

Hi,

I have a few Oracle spatial (10.2) tables that I want to export as shape
files. But the zipped shapefile produced by Geoserver is corrupt
(terminated abnormally according to WinRar). Any ideas?

Jos Pilon

Dit e-mail bericht is vertrouwelijk. Het is uitsluitend bestemd voor de geadresseerde.
Indien u niet de geadresseerde bent, verzoeken we u dringend ons direct te informeren en om dit bericht en eventuele bijlage(n) te verwijderen, zonder het te kopieren, door te zenden of op enige andere wijze te openbaren of te gebruiken. KLM Aerocarto BV, statutair gevestigd in Arnhem en geregistreerd in het Handelsregister onder nr. 09092085, is niet aansprakelijk voor welke schade dan ook als gevolg van communicatie per e-mail en verzending van documenten en gegevens. Tevens handelend onder de naam ARCADIS Ruimtelijke Informatie.

This e-mail is confidential and may also be privileged. It is intended for use by the addressee only.
If you are not the intended addressee, we request that you notify us immediately and delete this e-mail, and any attachment(s), without copying, forwarding, disclosing or using it in any other way. KLM Aerocarto BV, with registered office at Arnhem, The Netherlands registered with the trade register under number 09092085, will not be liable for damage relating to the communication by e-mail of data or documents. Also active under the brand name ARCADIS Spatial Information.
-------------- next part --------------
An HTML attachment was scrubbed…


Message: 5
Date: Fri, 25 May 2007 13:58:37 +0300
From: “Rahkonen Jukka” < Jukka.Rahkonen@…486…>
Subject: Re: [Geoserver-users] Problems including Views from Oracle
Spatial
To: <geoserver-users@lists.sourceforge.net >
Message-ID:
<CC197224AC75CE4DB23F739B16891B86668969@…487…>
Content-Type: text/plain; charset=“iso-8859-1”

Hi,

I am also having problems with Oracle spatial view and Geoserver 1.5.0. I am sure I have used views sometimes earlier, but I have no success in it now.
In order to make things as simple as possible I have created a view as a copy from a table that works as FeatureType (SELECT all fields without any WHEREs). USER_SDO_GEOM_METADATA is similar, despite TABLE_NAME, of course. The view works fine from SQL+. I can make FeatureType out of the view with administration utility and everything seems to be OK, including DescribeFeatureType, but all WFS queries are failing.

I have here whole lot of text captured from Geoserver console. If there is somebody interested in it I can send it in another mail.

Regards,

-Jukka Rahkonen-


L?hett?j?: geoserver-users-bounces@lists.sourceforge.net puolesta: Tom (JDi Solutions)
L?hetetty: ti 22.5.2007 23:07
Vastaanottaja: Andrea Aime
Kopio: geoserver-users@lists.sourceforge.net
Aihe: Re: [Geoserver-users] Problems including Views from Oracle Spatial

The view is user_sdo_geom_metadata. When you insert a record into it you must be logged in as the user who owns the view you’re adding and one of the fields (diminfo) in the user_sdo_geom_meta_data view requires an Oracle object constructor so it’s usually easier to copy one from a table that’s already registered (usually the one you’re basing the view on) for example:

INSERT INTO user_sdo_geom_metadata
(table_name, column_name, diminfo, srid)
SELECT ‘my_view’, ‘my_spatial_column’, diminfo, 4326
FROM user_sdo_geom_metadata
WHERE table_name = ‘my_base_table’;

Hope that makes sense!

On 5/22/07, Andrea Aime <aaime@…1…> wrote:

Tim Englich ha scritto:

Hello,

I try to integrate a View from Oracle Spatial as an FeatureType to Geoserver
1.5.0 using the Webfrondend.
This failed.
When I configure the FeatureType manually by creating an Folder with info.xml
and schema.xml everything works fine.
Has anyone an Idea how I can tell the Webfrontend to do this?

Well, usually you have to register view against some metadata table…
can’t remember the exact name, there should be some
USER_GEOMETRY_COLUMNS updatable view in MSYS_SDO (trying to remember,
haven’t checked so names may be quite a bit off the real ones).
Anyways, did you see any error in the Geoserver log when your attempt
failed?

Cheers
Andrea


This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/


Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users


Message: 6
Date: Fri, 25 May 2007 13:51:12 +0200
From: Luca Morandini <lmorandini@…309…>
Subject: Re: [Geoserver-users] Problems including Views from Oracle
Spatial
To: geoserver-users@lists.sourceforge.net
Message-ID: <f36ijh$c1k$1@…101…>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed

Rahkonen Jukka wrote:

Hi,

I am also having problems with Oracle spatial view and Geoserver
1.5.0. I am sure I have used views sometimes earlier, but I have no
success in it now. In order to make things as simple as possible I
have created a view as a copy from a table that works as FeatureType
(SELECT all fields without any WHEREs). USER_SDO_GEOM_METADATA is
similar, despite TABLE_NAME, of course. The view works fine from
SQL+. I can make FeatureType out of the view with administration
utility and everything seems to be OK, including DescribeFeatureType,
but all WFS queries are failing.

Have you already defined a Primary Key for such views ?

Regards,


Luca Morandini
www.lucamorandini.it


Message: 7
Date: Fri, 25 May 2007 15:18:23 +0300
From: “Rahkonen Jukka” < Jukka.Rahkonen@…486…>
Subject: Re: [Geoserver-users] Problems including Views from Oracle
Spatial
To: <lmorandini@…309…>, < geoserver-users@lists.sourceforge.net>
Message-ID:
<CC197224AC75CE4DB23F739B16891B8666896E@…487…>
Content-Type: text/plain; charset=“iso-8859-1”

L?hett?j?: geoserver-users-bounces@lists.sourceforge.net puolesta: Luca Morandini
L?hetetty: pe 25.5.2007 14:51

Rahkonen Jukka wrote:

Hi,

I am also having problems with Oracle spatial view and Geoserver
1.5.0. I am sure I have used views sometimes earlier, but I have no
success in it now. In order to make things as simple as possible I
have created a view as a copy from a table that works as FeatureType
(SELECT all fields without any WHEREs). USER_SDO_GEOM_METADATA is
similar, despite TABLE_NAME, of course. The view works fine from
SQL+. I can make FeatureType out of the view with administration
utility and everything seems to be OK, including DescribeFeatureType,
but all WFS queries are failing.

Have you already defined a Primary Key for such views ?

That was it. However, I faced a new problem next. Or actually it is an old problem that popped up again: Geoserver is creating invalid fids. Here is an example:
<gml:PERUSLOHKOT2 fid=“PERUSLOHKOT2.1602c310 :112c2aad0ac:3ffb”>

Those colon characters make that fid is invalid, and my WFS client does not accept the data. My Geoserver version is 1.5.0 and that problem should be corrected in it. Obviously it is not the case in all situations.

-Jukka-



This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/



Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

End of Geoserver-users Digest, Vol 12, Issue 33


Γεώργιος Τσολάκης - Περιβαλλοντολόγος
Γραφείο Περιβαλλοντικών Μελετών
Ζήνωνος 57. Περιστέρι. Αθήνα
tel: +30 210 5727615
fax: +30 210 5727995
mobile: + 30 6977 158693
email: gtsolakis@…84…
URL : www.mpe.gr

I'm not google maps expert, but I think you just need to use:
G_NORMAL_MAP

like
var layer3=[G_NORMAL_MAP.getTileLayers()[0],tileCountry];

instead of

var layer3=[G_SATELLITE_MAP.getTileLayers()[0],G_HYBRID_MAP.getTileLayers()[1],tileCountry];

But I could be wrong...

Also the google code we use is for for v2 of the gmaps api.

Chris

George Tsolakis wrote:

Please can i have some help with my code here
Its not easy for me cause am not a programmer

I followed the instructions to set up a tiiling from geoserver with my data but the result is tiiling on hybrid map and i do not want this

I need the simple map (nor sattelite or hybrid )

the implementation is here http://www.mpe.gr/gmaps/arxaia.html

ps : i think that someone should rewrite the google tilling code cause google api has changed to v2, and some instructions to do simple things like that would be very helpful. :slight_smile:

keep on the good work guys, geoserver was the solution for me. im not a programmer but im able to publish my data

On 5/25/07, * geoserver-users-request@lists.sourceforge.net <mailto:geoserver-users-request@lists.sourceforge.net>* <geoserver-users-request@lists.sourceforge.net <mailto:geoserver-users-request@lists.sourceforge.net>> wrote:

    Send Geoserver-users mailing list submissions to
            geoserver-users@lists.sourceforge.net
    <mailto:geoserver-users@lists.sourceforge.net>

    To subscribe or unsubscribe via the World Wide Web, visit
            https://lists.sourceforge.net/lists/listinfo/geoserver-users
    or, via email, send a message with subject or body 'help' to
            geoserver-users-request@lists.sourceforge.net
    <mailto:geoserver-users-request@lists.sourceforge.net>

    You can reach the person managing the list at
             geoserver-users-owner@lists.sourceforge.net
    <mailto:geoserver-users-owner@lists.sourceforge.net>

    When replying, please edit your Subject line so it is more specific
    than "Re: Contents of Geoserver-users digest..."

    Today's Topics:

       1. Re: null value in log file (Andrea Aime)
       2. Re: null value in log file (Steve Marshall)
       3. Re: null value in log file (Andrea Aime)
       4. output format SHAPe-ZIP corrupt (Pilon J. (Jos))
       5. Re: Problems including Views from Oracle Spatial (Rahkonen Jukka)
       6. Re: Problems including Views from Oracle Spatial (Luca Morandini)
       7. Re: Problems including Views from Oracle Spatial (Rahkonen Jukka)

    ----------------------------------------------------------------------

    Message: 1
    Date: Thu, 24 May 2007 16:42:27 +0200
    From: Andrea Aime <aaime@anonymised.com <mailto:aaime@anonymised.com>>
    Subject: Re: [Geoserver-users] null value in log file
    To: "jan w." < wrobel.jan@anonymised.com
    <mailto:wrobel.jan@anonymised.com>>
    Cc: Steve Marshall <smarshall@anonymised.com <mailto:smarshall@anonymised.com>>,
             geoserver-users@lists.sourceforge.net
    <mailto:geoserver-users@lists.sourceforge.net>
    Message-ID: <4655A453.6050002@anonymised.com
    <mailto:4655A453.6050002@anonymised.com>>
    Content-Type: text/plain; charset=ISO-8859-1; format=flowed

    jan w. ha scritto:
     > hi,
     >
     > my requests come from on php script running on an IIS, seems to be a
     > problem with IIS?!
     > i could never reproduce the behaviour....

    Ah, one thing you could do, if the problem is relatively easy to
    reproduce, is to run Geoserver interactively, instead of running
    it as a service, and copy the stack traces you see from the console
    window.

    Cheers
    Andrea

    ------------------------------

    Message: 2
    Date: Thu, 24 May 2007 11:13:31 -0700 (PDT)
    From: Steve Marshall <smarshall@anonymised.com <mailto:smarshall@anonymised.com>>
    Subject: Re: [Geoserver-users] null value in log file
    To: geoserver-users@lists.sourceforge.net
    <mailto:geoserver-users@lists.sourceforge.net>
    Message-ID: <10789565.post@anonymised.com
    <mailto:10789565.post@anonymised.com>>
    Content-Type: text/plain; charset=us-ascii

     > my requests come from on php script running on an IIS, seems to be a
     > problem with IIS?!
     > i could never reproduce the behaviour....

    Ah, one thing you could do, if the problem is relatively easy to
    reproduce, is to run Geoserver interactively, instead of running
    it as a service, and copy the stack traces you see from the console
    window.

    Andrea,
    Sounds like a good sugestion. Unfortunately, the problem is
    actually rather
    difficult to reproduce (the cause is unknown). Therefore, watching the
    console is like looking for a needle in a haystack. I tried to startup
    GeoServer in a console window, redirecting stdout and stderr to a
    log file
    so I could search through loads of console information at my
    leisure. I did
    the output redirection in the standard Linux way, i.e. by appending" >
    log-file 2>&1" to the command. I believe this is also valid syntax for
    Windows. However, when started this way, GeoServer seems to be
    unresponsive
    after issuing this log message:

    14297 [FINE] org.geotools.data.jdbc.ConnectionPool - Getting available
    connection.

    Any thoughts why this would happen? Are there any services
    associated with
    Jetty I should restart to make changes take effect?

    Thanks for any insights,
    Steve

    --
    View this message in context:
    http://www.nabble.com/null-value-in-log-file-tf3680605.html#a10789565
    <http://www.nabble.com/null-value-in-log-file-tf3680605.html#a10789565&gt;
    Sent from the GeoServer - User mailing list archive at Nabble.com
    <http://Nabble.com>.

    ------------------------------

    Message: 3
    Date: Thu, 24 May 2007 20:21:28 +0200
    From: Andrea Aime < aaime@anonymised.com <mailto:aaime@anonymised.com>>
    Subject: Re: [Geoserver-users] null value in log file
    To: Steve Marshall <smarshall@anonymised.com <mailto:smarshall@anonymised.com>>
    Cc: geoserver-users@lists.sourceforge.net
    <mailto:geoserver-users@lists.sourceforge.net>
    Message-ID: <4655D7A8.8030307@anonymised.com
    <mailto:4655D7A8.8030307@anonymised.com>>
    Content-Type: text/plain; charset=ISO-8859-1; format=flowed

    Steve Marshall ha scritto:

     > Any thoughts why this would happen? Are there any services
    associated with
     > Jetty I should restart to make changes take effect?

    Not really, but I think I have a better suggestion.
    Go in the Geoserver control panel, server section, and tell it to save
    the logs to file, set a "CONFIG" logging level, submit, apply, and save.
    To make sure the file is generated, kill and restart Geoserver, then
    you should see a log directory in the Geoserver data dir with a
    Geoserver.log file. The file growth will be jumpy, because we buffer
    logs in memory and dump them every few kb to avoid slowing it down
    too much, but once you have reproduced the issue, just stop
    geoserver, and send me the log (by private mail, since the
    mailing list won't accept attachments).

    Cheers
    Andrea

    ------------------------------

    Message: 4
    Date: Fri, 25 May 2007 10:32:21 +0200
    From: "Pilon J. \(Jos\)" < J.Pilon@anonymised.com
    <mailto:J.Pilon@anonymised.com>>
    Subject: [Geoserver-users] output format SHAPe-ZIP corrupt
    To: <geoserver-users@lists.sourceforge.net
    <mailto:geoserver-users@lists.sourceforge.net>>
    Message-ID:
            <
    25BB09C025B3A24F9F035EEDC27EA4DB03E5A43F@anonymised.com
    <mailto:25BB09C025B3A24F9F035EEDC27EA4DB03E5A43F@anonymised.com>>
    Content-Type: text/plain; charset="us-ascii"

    Hi,

    I have a few Oracle spatial (10.2) tables that I want to export as shape
    files. But the zipped shapefile produced by Geoserver is corrupt
    (terminated abnormally according to WinRar). Any ideas?

    Jos Pilon

    Dit e-mail bericht is vertrouwelijk. Het is uitsluitend bestemd voor
    de geadresseerde.
    Indien u niet de geadresseerde bent, verzoeken we u dringend ons
    direct te informeren en om dit bericht en eventuele bijlage(n) te
    verwijderen, zonder het te kopieren, door te zenden of op enige
    andere wijze te openbaren of te gebruiken. KLM Aerocarto BV,
    statutair gevestigd in Arnhem en geregistreerd in het
    Handelsregister onder nr. 09092085, is niet aansprakelijk voor welke
    schade dan ook als gevolg van communicatie per e-mail en verzending
    van documenten en gegevens. Tevens handelend onder de naam ARCADIS
    Ruimtelijke Informatie.

    This e-mail is confidential and may also be privileged. It is
    intended for use by the addressee only.
    If you are not the intended addressee, we request that you notify us
    immediately and delete this e-mail, and any attachment(s), without
    copying, forwarding, disclosing or using it in any other way. KLM
    Aerocarto BV, with registered office at Arnhem, The Netherlands
    registered with the trade register under number 09092085, will not
    be liable for damage relating to the communication by e-mail of data
    or documents. Also active under the brand name ARCADIS Spatial
    Information.
    -------------- next part --------------
    An HTML attachment was scrubbed...

    ------------------------------

    Message: 5
    Date: Fri, 25 May 2007 13:58:37 +0300
    From: "Rahkonen Jukka" < Jukka.Rahkonen@anonymised.com
    <mailto:Jukka.Rahkonen@anonymised.com>>
    Subject: Re: [Geoserver-users] Problems including Views from Oracle
            Spatial
    To: <geoserver-users@lists.sourceforge.net
    <mailto:geoserver-users@lists.sourceforge.net>>
    Message-ID:
            <CC197224AC75CE4DB23F739B16891B86668969@anonymised.com
    <mailto:CC197224AC75CE4DB23F739B16891B86668969@anonymised.com>>
    Content-Type: text/plain; charset="iso-8859-1"

    Hi,

    I am also having problems with Oracle spatial view and Geoserver
    1.5.0. I am sure I have used views sometimes earlier, but I have no
    success in it now.
    In order to make things as simple as possible I have created a view
    as a copy from a table that works as FeatureType (SELECT all fields
    without any WHEREs). USER_SDO_GEOM_METADATA is similar, despite
    TABLE_NAME, of course. The view works fine from SQL+. I can make
    FeatureType out of the view with administration utility and
    everything seems to be OK, including DescribeFeatureType, but all
    WFS queries are failing.

    I have here whole lot of text captured from Geoserver console. If
    there is somebody interested in it I can send it in another mail.

    Regards,

    -Jukka Rahkonen-

    ________________________________

    L?hett?j?: geoserver-users-bounces@lists.sourceforge.net
    <mailto:geoserver-users-bounces@lists.sourceforge.net> puolesta: Tom
    (JDi Solutions)
    L?hetetty: ti 22.5.2007 23:07
    Vastaanottaja: Andrea Aime
    Kopio: geoserver-users@lists.sourceforge.net
    <mailto:geoserver-users@lists.sourceforge.net>
    Aihe: Re: [Geoserver-users] Problems including Views from Oracle Spatial

    The view is user_sdo_geom_metadata. When you insert a record into
    it you must be logged in as the user who owns the view you're adding
    and one of the fields (diminfo) in the user_sdo_geom_meta_data view
    requires an Oracle object constructor so it's usually easier to copy
    one from a table that's already registered (usually the one you're
    basing the view on) for example:

    INSERT INTO user_sdo_geom_metadata
    (table_name, column_name, diminfo, srid)
    SELECT 'my_view', 'my_spatial_column', diminfo, 4326
    FROM user_sdo_geom_metadata
    WHERE table_name = 'my_base_table';

    Hope that makes sense!

    On 5/22/07, Andrea Aime <aaime@anonymised.com
    <mailto:aaime@anonymised.com>> wrote:

            Tim Englich ha scritto:
            > Hello,
            >
            > I try to integrate a View from Oracle Spatial as an
    FeatureType to Geoserver
            > 1.5.0 using the Webfrondend.
            > This failed.
            > When I configure the FeatureType manually by creating an
    Folder with info.xml
            > and schema.xml everything works fine.
            > Has anyone an Idea how I can tell the Webfrontend to do this?

            Well, usually you have to register view against some
    metadata table...
            can't remember the exact name, there should be some
            USER_GEOMETRY_COLUMNS updatable view in MSYS_SDO (trying to
    remember,
            haven't checked so names may be quite a bit off the real ones).
            Anyways, did you see any error in the Geoserver log when
    your attempt
            failed?

            Cheers
            Andrea

            -------------------------------------------------------------------------

            This SF.net email is sponsored by DB2 Express
            Download DB2 Express C - the FREE version of DB2 express and
    take
            control of your XML. No limits. Just data. Click to get it now.
             http://sourceforge.net/powerbar/db2/
            _______________________________________________
            Geoserver-users mailing list
             Geoserver-users@lists.sourceforge.net
    <mailto:Geoserver-users@lists.sourceforge.net>
            https://lists.sourceforge.net/lists/listinfo/geoserver-users

    ------------------------------

    Message: 6
    Date: Fri, 25 May 2007 13:51:12 +0200
    From: Luca Morandini <lmorandini@anonymised.com <mailto:lmorandini@anonymised.com>>
    Subject: Re: [Geoserver-users] Problems including Views from Oracle
            Spatial
    To: geoserver-users@lists.sourceforge.net
    <mailto:geoserver-users@lists.sourceforge.net>
    Message-ID: <f36ijh$c1k$1@anonymised.com
    <mailto:f36ijh$c1k$1@anonymised.com>>
    Content-Type: text/plain; charset=ISO-8859-1; format=flowed

    Rahkonen Jukka wrote:
     > Hi,
     >
     > I am also having problems with Oracle spatial view and Geoserver
     > 1.5.0. I am sure I have used views sometimes earlier, but I have no
     > success in it now. In order to make things as simple as possible I
     > have created a view as a copy from a table that works as FeatureType
     > (SELECT all fields without any WHEREs). USER_SDO_GEOM_METADATA is
     > similar, despite TABLE_NAME, of course. The view works fine from
     > SQL+. I can make FeatureType out of the view with administration
     > utility and everything seems to be OK, including
    DescribeFeatureType,
     > but all WFS queries are failing.

    Have you already defined a Primary Key for such views ?

    Regards,

    --------------------
        Luca Morandini
    www.lucamorandini.it <http://www.lucamorandini.it>
    --------------------

    ------------------------------

    Message: 7
    Date: Fri, 25 May 2007 15:18:23 +0300
    From: "Rahkonen Jukka" < Jukka.Rahkonen@anonymised.com
    <mailto:Jukka.Rahkonen@anonymised.com>>
    Subject: Re: [Geoserver-users] Problems including Views from Oracle
            Spatial
    To: <lmorandini@anonymised.com <mailto:lmorandini@anonymised.com>>, <
    geoserver-users@lists.sourceforge.net
    <mailto:geoserver-users@lists.sourceforge.net>>
    Message-ID:
            <CC197224AC75CE4DB23F739B16891B8666896E@anonymised.com
    <mailto:CC197224AC75CE4DB23F739B16891B8666896E@anonymised.com>>
    Content-Type: text/plain; charset="iso-8859-1"

    L?hett?j?: geoserver-users-bounces@lists.sourceforge.net
    <mailto:geoserver-users-bounces@lists.sourceforge.net> puolesta:
    Luca Morandini
    L?hetetty: pe 25.5.2007 14:51

     >Rahkonen Jukka wrote:
     >> Hi,
     >>
     >> I am also having problems with Oracle spatial view and Geoserver
     >> 1.5.0. I am sure I have used views sometimes earlier, but I have no
     >> success in it now. In order to make things as simple as possible I
     >> have created a view as a copy from a table that works as FeatureType
     >> (SELECT all fields without any WHEREs). USER_SDO_GEOM_METADATA is
     >> similar, despite TABLE_NAME, of course. The view works fine from
     >> SQL+. I can make FeatureType out of the view with administration
     >> utility and everything seems to be OK, including
    DescribeFeatureType,
     >> but all WFS queries are failing.

     >Have you already defined a Primary Key for such views ?

    That was it. However, I faced a new problem next. Or actually it
    is an old problem that popped up again: Geoserver is creating
    invalid fids. Here is an example:
    <gml:PERUSLOHKOT2 fid="PERUSLOHKOT2.1602c310 :112c2aad0ac:3ffb">

    Those colon characters make that fid is invalid, and my WFS client
    does not accept the data. My Geoserver version is 1.5.0 and that
    problem should be corrected in it. Obviously it is not the case in
    all situations.

    -Jukka-

    ------------------------------

    -------------------------------------------------------------------------
    This SF.net email is sponsored by DB2 Express
    Download DB2 Express C - the FREE version of DB2 express and take
    control of your XML. No limits. Just data. Click to get it now.
    http://sourceforge.net/powerbar/db2/

    ------------------------------

    _______________________________________________
    Geoserver-users mailing list
    Geoserver-users@lists.sourceforge.net
    <mailto:Geoserver-users@lists.sourceforge.net>
    https://lists.sourceforge.net/lists/listinfo/geoserver-users
    <https://lists.sourceforge.net/lists/listinfo/geoserver-users&gt;

    End of Geoserver-users Digest, Vol 12, Issue 33
    ***********************************************

--
----------------------------------------------------
Ãåþñãéïò ÔóïëÜêçò - Ðåñéâáëëïíôïëüãïò
Ãñáöåßï Ðåñéâáëëïíôéêþí Ìåëåôþí
ÆÞíùíïò 57. ÐåñéóôÝñé. ÁèÞíá
tel: +30 210 5727615 fax: +30 210 5727995
mobile: + 30 6977 158693
email: gtsolakis@anonymised.com <mailto:gtsolakis@anonymised.com>
URL : www.mpe.gr <http://www.mpe.gr> !DSPAM:4005,46573400144201015089218!

------------------------------------------------------------------------

-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/

!DSPAM:4005,46573400144201015089218!

------------------------------------------------------------------------

_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

!DSPAM:4005,46573400144201015089218!

--
Chris Holmes
The Open Planning Project
http://topp.openplans.org