Re: [udig-devel] Oracle Spatial Connection Bug

[Jody Garnett <jody.garnett@xxxxxxxxx>]

what oracle do you have? We can ask on the geotools list - or that
Simon guy knows a lot about this stuff.
Jody

2009/6/22 Rahul... हम पंछी उन्मुक्त गगन के <rahul.official@xxxxxxxxx>:
> Hi Jody, I am debugging the oracle Spatial, and found that It is throwing an
> exception at OracleDataStore file. The line that is throwing the exception
> is inside the getEnvelope function:
> results = statement.executeQuery(query);
>
> The query string that is passed at that point of time is:
>
> SELECT SDO_TUNE.EXTENT_OF('MUNICIPALITY', 'GEOM') from dual.
>
> Can it be a possibility that my oracle DB doesn't support this query?
>
>
>
>
> 2009/6/22 Jody Garnett <jody.garnett@xxxxxxxxx>
>>
>> Thanks for the research: I have been on the road and not near an
>> oracle instance to check myself.
>>
>> Do you have a strack trace for your next NPE? Perhaps we can gather
>> some clues; or is this it on that bug report:
>> at
>> org.eclipse.emf.common.util.BasicEList$EIterator.next(BasicEList.java:1312)
>> at
>> net.refractions.udig.project.internal.impl.LayersList2.addDeepAdapter(LayersList2.java:67)
>> at
>> net.refractions.udig.project.internal.impl.MapImpl.addDeepAdapter(MapImpl.java:1721)
>>
>> Jody
>>
>> 2009/6/17 Rahul... हम पंछी उन्मुक्त गगन के <rahul.official@xxxxxxxxx>:
>> > Yes, I after the schema list is populated, I can select an entry and
>> > after
>> > clicking on connect, and then next, it goes to the next page(but with
>> > null
>> > pointer exceptions ;-( ). Also, once the schema list is populated, it
>> > doesn't get populated for the next time( it says connection closed when
>> > I
>> > click the lookup button). I have also tested it on 1.2M5 and have
>> > updated
>> > the bug description. http://jira.codehaus.org/browse/UDIG-844
>> >
>> > 2009/6/17 Jody Garnett <jody.garnett@xxxxxxxxx>
>> >>
>> >> Interesting; could you try choosing a schema from the drop down list
>> >> and see if the form works?
>> >>
>> >> Jody
>> >>
>> >> 2009/6/16 Rahul... हम पंछी उन्मुक्त गगन के <rahul.official@xxxxxxxxx>:
>> >> > I tried to debug the oracle spatial plugin and found a bug in
>> >> >
>> >> >
>> >> > /net.refractions.udig.catalog.ui/src/net/refractions/udig/catalog/ui/wizard/DataBaseRegistryWizardPage.java
>> >> > file. The problem is with the following function.
>> >> >
>> >> > protected boolean couldConnect() {
>> >> >
>> >> > if ((currentDBCI.getHostString().length() > 0) &&
>> >> > (currentDBCI.getPortString().length() > 0)
>> >> > && (currentDBCI.getUserString().length() > 0)
>> >> > && (currentDBCI.getPassString().length() > 0)
>> >> > && (currentDBCI.getDbString().length() > 0)) {
>> >> >
>> >> > if (!dbmsUsesSchema())
>> >> > // All are set and we don't use schema
>> >> > return (true);
>> >> > // Need a schema and have one
>> >> > if (currentDBCI.getSchemaString().length() > 0)
>> >> > return (true);
>> >> > // Need schema but don't have one.
>> >> > return (false);            // if no schema is there then it returns
>> >> > false.
>> >> > When I set it as true. the list
>> >> >                                          //schema was populated. But
>> >> > when I
>> >> > restarted the Udig, I again had to set it false, to populate the
>> >> > schema
>> >> > list.
>> >> > }
>> >> > // One or more are not set
>> >> > return (false);
>> >> > }
>> >> >
>> >> > --
>> >> > Thanks,
>> >> > Rahul
>> >> >
>> >> >
>> >
>> >
>> >
>> > --
>> > Thanks,
>> > Rahul
>> >
>
>
>
> --
> Thanks,
> Rahul
>