Hi Julian,
jberti wrote:
> I don't see any problems with the way its set up.
> I had trouble with the older GeoServer versions that I had errors like
> that
> coming up when I tried to use a non schema owner to connect to some
> Views or
> Tables.
> However with GeoServer 2.0 these issues got resolved and the primary
> key
> error message only pops up if there really wasn't any primary key
> applied or
> the schema you are trying to connect as doesn't have enough privs.
> Maybe it is just me that I did something along the way different in the
> way
> I connect to the databases and everything.
Yep. You are specifying a schema.
> Can you try to explain what the issue exactly is that you are looking
> at here?
The issue is that users do try to use the oracle datastore without specifying a
schema, which results in an exception if they try to use a table outside of
their default schema.
The reason it isn't affecting you is because you are specifying a schema.
> Right now you should only be able to apply one Schema per datastore
Incorrect. As it stands you can choose not to specify a schema when creating
the Oracle datastore.
> which
> can be seen either as a bad or good solution, depending on the way you
> look
> at it. If you chose that datastore to add a new layer, you get a list
> which shows all the views and tables this Schema can access.
> So there shouldn't be
> any issues here. Then when it can't find an entry in the
> USER_SDO_GEOM_METADATA it looks in the ALL_SDO_GEOM_METADATA and should
> find
> it in there. If it doesn't it will throw the primary key and
> insufficient
> privileges error from my experience. At least thats how the old version
> of
> GeoServer handled it for me.
>
> Please correct me if I'm wrong in any of these assumptions.
I hope this clarifies the issue for you :)
-Miles
___________________________________________________________________________
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/
___________________________________________________________________________
------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
_______________________________________________
Geoserver-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-devel
