1. 云栖社区>
  2. PHP教程>
  3. 正文

[geoserver] having duplicate columns in your oracle based layer

作者:用户 来源:互联网 时间:2017-12-01 19:04:48

[geoserver] having duplicate columns in your oracle based layer - 摘要: 本文讲的是[geoserver] having duplicate columns in your oracle based layer, Updating geoserver did not fix my problem: my layer still had some duplicate columnnames. This might not be such a big

Updating geoserver did not fix my problem: my layer still had some duplicate columnnames. This might not be such a big problem: everything is drawn correctly, WMS calls work, but WFS calls gave the irritating yet predictable errorORA-00918: column ambiguously defined. Annoying.

So how does one find column-names for a table in oracle? With a query like:

select * from dba_tab_columns where table_name = 'YOUR_TABLE_NAME';

and all of a sudden I saw the same set of column-names, with some duplication. Apparently my oracle database contains the table twice, in two different schema’s. Since my user had the permissions to access the other schema, it seems geoserver does not limit the query to the (specified) schema at all.

The fix then was easy: make the other schema unaccessible. In my case the second schema was for testing purposes, so I could just delete it.

以上是[geoserver] having duplicate columns in your oracle based layer的全部内容,在云栖社区的博客、问答、公众号、人物、课程等栏目也有其他相关内容,欢迎继续使用右上角搜索按钮进行搜索,以便于您获取更多的相关知识。