Re: [udig-devel] Oracle Spatial Connection Bug

[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