Re: [udig-devel] Oracle Spatial Connection Bug

[Jody Garnett <jody.garnett@xxxxxxxxx>]

Sorry I was thinking of Simon Greener (one of the more knolwedgeble
database hackers around).

Simon is the SELECT SDO_TUNE.EXTENT_OF function available on all
versions of oracle spatial?
Jody

2009/6/22 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
>>
>