On Mon, Oct 11, 2010 at 5:29 PM, Luca Morandini <[email protected]> wrote:
> On 10/11/2010 02:03 PM, marwa El-said wrote:
> >
> > Hello all,
> >
> > I'm using geoServer 2.0.2 & oracle server 10g,
> >
> > I' connected now to oracle and my layers are listed but i saw anither
> > hyndreds of tables with names like
> > "
> > ALL$AW_CUBE_AGG_LEVELS Publish
> > ALL$AW_CUBE_AGG_MEASURES Publish
> > ALL$AW_CUBE_AGG_PLANS Publish
>
> It seems you've stumbled upon your company's Data Warehouse ;)
>
>
> > are those tables are the default system tables be created with any new
> user?
>
> Nay, those tables I've nothing to do with GeoServer.
>
>
> > if not how can i eleminate them from listing on my geoserver?
>
> I presume you have to restrict the tables your Oracle user has access to,
> or
> specify a schema in the GS connection to Oracle... funny though that
> GeoServer
> lists tables that are not registered in the Oracle Spatial metadata table.
>
>
Nothing funny with that. People want to publish also geometryless tables
with WFS
occasionally, so we list everything we find.
If someone has an interest in just listing spatial tables, a way would be
to roll a store
configuration that makes the dialect filter out all non spatial tables.
A patch for a rainy and boring day maybe?
Cheers
Andrea
-----------------------------------------------------
Ing. Andrea Aime
Senior Software Engineer
GeoSolutions S.A.S.
Via Poggio alle Viti 1187
55054 Massarosa (LU)
Italy
phone: +39 0584962313
fax: +39 0584962313
http://www.geo-solutions.it
http://geo-solutions.blogspot.com/
http://www.linkedin.com/in/andreaaime
http://twitter.com/geowolf
-----------------------------------------------------
------------------------------------------------------------------------------
Beautiful is writing same markup. Internet Explorer 9 supports
standards for HTML5, CSS3, SVG 1.1, ECMAScript5, and DOM L2 & L3.
Spend less time writing and rewriting code and more time creating great
experiences on the web. Be a part of the beta today.
http://p.sf.net/sfu/beautyoftheweb
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
