Ok, sounds like you're the third person with this problem (see:
http://comments.gmane.org/gmane.comp.gis.geoserver.user/237). John and
Dirk, I'd like to try to get to the bottom of this. You guys never
found a solution or work around, did you? It's weird, because not all
oracle users have this problem.
I created a JIRA task, and if you guys could comment on it that'd be
great. http://jira.codehaus.org/browse/GEOS-402 Or if it's easier
just answer my questions here:
What version of oracle are you using?
Is this a problem on _all_ tables? Like are you ever able to create a
featureType? If not, what is unique about these tables?
Could you try ones that don't have any geometry? (not sure if this is
possible with oracle + gt2, but I know on postgis it is)
What is the structure of your tables? Like what's the statement to
create them? We can try it out on other oracle instances, see if we
get the same problem there...
Is your geometry properly registered in the oracle meta table (I forget
what it's called at the moment).
Any other relevant information you can think of?
Basically GeoTools seems to think that there are two attributes of the
same name. I have no idea why...
best regards,
Chris
Quoting Robin den Adel <robin.den.adel@anonymised.com>:
Chris,
Here is the log you requested.
I also added the error desriptions.Robin
> -----Original Message-----
> From: Chris Holmes [mailto:cholmes@anonymised.com]
> Sent: Tuesday, September 13, 2005 9:33
> To: Robina
> Subject: Re: [Geoserver-users] Error adding new FeatureType
> (Oracle Spatial)
>
> If you're using the exe or bin version, then it should go to
> standard output. Like when you hit start text will go by.
> Just copy and paste it, and send it.
>
> Chris
>
> Quoting Robina <robina@anonymised.com>:
>
> > Can you tell me where I can find the logs?
> >
> > Robin
> >
> > On Mon, 12 Sep 2005 16:34:41 -0400, Chris Holmes wrote:
> > > Could you send the logs? I vaguely remember something like
this,
> > but
> > > forget the solution...
> > >
> > > Chris
> > >
> > > Quoting Robin den Adel <robin.den.adel@anonymised.com>:
> > >
> > > > Hello,
> > > >
> > > > I just installed GeoServer and added some datastores.
> > > > The according FeatureType of a ShapeFile can easily be added.
> > > >
> > > > When I try to add the a FeatureType pointing to a table of an
> > Oracle
> > > > TableSpace, the following error is given:
> > > >
> > > > HTTP ERROR: 500
> > > >
> > >
> >
> Duplicate+AttributeTypes+DefaultAttributeType+%5Bname%3DA5898+
%2C+type%3
> Duplicate+AttributeTypes+DefaultAttributeType+Dcla
> > > >
> >
ss+java%2Elang%2EString+%2C+nillable%3Dtrue%2C+min%3D1%2C+max%3D1%5D
> > > >
> > > > Another table (GEBOUW) generates the following error:
> > > >
> > > > HTTP ERROR: 500
> > > >
> > >
> >
> SQL+Error+building+FeatureType+for+GEBOUW+ORA%2D00904%3A+%22ID
%22%3A+inv
> SQL+Error+building+FeatureType+for+GEBOUW+alid
> > > > +identifier%0A<
> > > >
> > > > The connection to the tablespace can't be the problem, since
all
> > the
> > > > tables
> > > > of the schema are listed.
> > > >
> > > > Any help would be appreciated.
> > > >
> > > > Best Regards,
> > > >
> > > > Robin
> > > >
> > > >
> > > >
> > > > -------------------------------------------------------
> > > > SF.Net email is Sponsored by the Better Software Conference &
> > EXPO
> > > > September 19-22, 2005 * San Francisco, CA * Development
> Lifecycle
> > > > Practices Agile & Plan-Driven Development * Managing Projects
&
> > > > Teams *
> > Testing
> > > > & QA
> > > > Security * Process Improvement & Measurement *
> > > > http://www.sqe.com/bsce5sf
> > > > _______________________________________________
> > > > Geoserver-users mailing list
> > > > Geoserver-users@lists.sourceforge.net
> > > > https://lists.sourceforge.net/lists/listinfo/geoserver-users
> > > >
> > >
> > >
> > >
> > >
> > > ----------------------------------------------------------
> > > This mail sent through IMP: https://webmail.limegroup.com/
> > >
> > >
> > >
> >
> >
> >
> >
> > --
> > XS2Mail: Check your mail anywhere
> > http://www.xs2mail.com/
> >
>
>
>
>
> ----------------------------------------------------------
> This mail sent through IMP: https://webmail.limegroup.com/
>
----------------------------------------------------------
This mail sent through IMP: https://webmail.limegroup.com/