Hi Miles,
It is most common error occurred for us too (inform DBA to fix metadata &
Spatial Index problems), when imported different types of geodata to into
oracle tables. The metadata (Spatial extent or bounding box of the gis layer
present in oracle tables) is not updated after geodata import.
Try to install Georaptor in sqldeveloper (its added as a plugin to
sqldeveloper) and update metadata and check for spatial indexes created?
other wise it will error as OCIIndexerror. After this process, geoserver
You can install Georaptor in sqldeveloper as given below
Open sqldeveloper and click on help, check for updates, A new window will
open with welcome, source, updates, sownload, summary links in the lefthand
side. click next and source is highlighted, click add button and give
Georaptor as name and http://georaptor.sourceforge.net/install.xml url as
location. click next till end.
after the process, restart your sqldeveloper and when you right click, you
can find Georaptor as an option, by clicking manage metadata, it will open
new window with bounding box default parameters (which are not correct).
click on calibrate MBR and then click on update and close.
I hope that this solves your problem.
Regards,
Hari.
On Thu, Jun 9, 2011 at 5:57 AM, Miles Jordan <[email protected]>wrote:
> If it doesn’t show up in the layers list then the most likely cause is a
> missing entry in USER_SDO_GEOM_METADATA. Try logging into SQL Developer with
> the same user and double check if the table is listed in there properly.
>
>
>
> -Miles
>
>
>
> *From:* Erlandsson Anders
>
> I have a lot of 2D point tables that does not show up in the available
> Layers list when trying to publish a new layer. 3D layers of the same
> dataset shows fine and the only difference I can see in the two tables are
> the GTYPE, that is set to 2001 for the 2D-data and 3001 for the 3D-data. I
> have tried to select records using SQL Developer with the same user account
> as in Geoserver, and it works fine.
>
>
>
> Any suggestions on what might be wrong?
>
>
>
>
>
> ___________________________________________________________________________
>
> Australian Antarctic Division - Commonwealth of Australia
> IMPORTANT: This transmission is intended for the addressee only. If you are
> not the
> intended recipient, you are notified that use or dissemination of this
> communication is
> strictly prohibited by Commonwealth law. If you have received this
> transmission in error,
> please notify the sender immediately by e-mail or by telephoning +61 3 6232
> 3209 and
> DELETE the message.
> Visit our web site at http://www.antarctica.gov.au/
> ___________________________________________________________________________
>
>
> ------------------------------------------------------------------------------
> EditLive Enterprise is the world's most technically advanced content
> authoring tool. Experience the power of Track Changes, Inline Image
> Editing and ensure content is compliant with Accessibility Checking.
> http://p.sf.net/sfu/ephox-dev2dev
> _______________________________________________
> Geoserver-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/geoserver-users
>
>
------------------------------------------------------------------------------
EditLive Enterprise is the world's most technically advanced content
authoring tool. Experience the power of Track Changes, Inline Image
Editing and ensure content is compliant with Accessibility Checking.
http://p.sf.net/sfu/ephox-dev2dev
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
