[mapguide-users] New King.Oracle 0.8 - improved performance

Nick Adams nick.adams at 1spatial.com
Thu Nov 20 10:33:34 EST 2008



Ok. I've tried 0.8.3 and I'm now getting:
Attempted to read or write protected memory. This is often an indication
that other memory is corrupt.


Nick


haris kurtagic wrote:
> 
> I posted 0.8.3 which should fix first problem.
> 
> Regarding SDO_FILTER If I remember correcly that is problem with 9.1 (
> provider works in 9.2 ? ).
> 
> I don't have 9 versions available to test but if I look at docs and you
> try it perhaps we can fix it without me trying it.
> 
> Haris
> 
> -----Original Message-----
> From: mapguide-users-bounces at lists.osgeo.org
> [mailto:mapguide-users-bounces at lists.osgeo.org] On Behalf Of Nick Adams
> Sent: Thursday, November 20, 2008 3:55 PM
> To: mapguide-users at lists.osgeo.org
> Subject: RE: [mapguide-users] New King.Oracle 0.8 - improved performance
> 
> 
> 
> - I have been using OracleSchema and it was set to the same as the
> username
> - Previously I was using 0.7.4.
>   Unfortunately this didn't work. Then I was getting the error:
>   ORA-29900: operator binding does not exist ORA-06553: PLS-306: wrong
> number or types of arguments in call to 'SDO_FILTER'
> 
> This I understand to be down to the fact that SDO_FILTER requires 3
> arguments in 9i where-as the third one is optional in 10g. I was hoping
> 0.8.x might solve this.
> 
> 
> Nick
> 
> 
> haris kurtagic wrote:
>> 
>> I am looking at code and I have two questions :
>> 
>> - are you using connection property OracleSchema, and value is same as
>> UserName ?
>> - this has worked for you before release 0.8.2 ?
>> 
>> Haris
>> 
>> -----Original Message-----
>> From: mapguide-users-bounces at lists.osgeo.org
>> [mailto:mapguide-users-bounces at lists.osgeo.org] On Behalf Of Nick
> Adams
>> Sent: Thursday, November 20, 2008 2:57 PM
>> To: mapguide-users at lists.osgeo.org
>> Subject: Re: [mapguide-users] New King.Oracle 0.8 - improved
> performance
>> 
>> 
>> 
>> Hi Haris,
>> 
>> I've just downloaded version 0.82 a tried it.
>> The problem I'm working on is using the King Oracle provider with .Net
>> to
>> connect to a 9i oracle database.
>> 
>> The query I'm making is:
>> SHAPE ENVELOPEINTERSECTS GeomFromText('POLYGON ((325400 701400, 325600
>> 701400, 325600 701600, 325400 701600, 325400 701400))')
>> 
>> The current error it's giving me when I try this is:
>> 
>> ORA-00904: "C"."SDO_INDEX_OWNER": invalid identifier 
>>  
>> Any suggestions would be appreciated.
>> 
>> 
>> Nick
>> 
>> 
>> haris kurtagic wrote:
>>> 
>>> Hi,
>>> 
>>>  
>>> 
>>> I have released new version of King.Oracle provider 0.8.
>>> 
>>> It is much faster than previous releases. Lot of code is changed.
>>> King.Oracle passed my UniTests but it has to be tested more so your
>>> feedback is appreciated.
>>> 
>>>  
>>> 
>>> List of changes:
>>> 
>>> Improved performance - very significant improvement
>>> 
>>> Support for SelectAggregate
>>> 
>>> FDO schema creation is now faster , especially when
>> OracleScema=UserName
>>> 
>>> Reintroduced schema caching
>>> 
>>> Full Unicode support
>>> 
>>> Using OCI interface
>>> 
>>>  
>>> 
>>>  
>>> 
>>> You can get it here: www.sl-king.com/fdooracle
>>> 
>>>  
>>> 
>>> Haris
>>> 
>>>  
>>> 
>>>  
>>> 
>>> 
>>> _______________________________________________
>>> mapguide-users mailing list
>>> mapguide-users at lists.osgeo.org
>>> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>>> 
>>> 
>> 
>> -- 
>> View this message in context:
>>
> http://www.nabble.com/New-King.Oracle-0.8---improved-performance-tp20580
>> 002p20601567.html
>> Sent from the MapGuide Users mailing list archive at Nabble.com.
>> 
>> _______________________________________________
>> mapguide-users mailing list
>> mapguide-users at lists.osgeo.org
>> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>> _______________________________________________
>> mapguide-users mailing list
>> mapguide-users at lists.osgeo.org
>> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>> 
>> 
> 
> -- 
> View this message in context:
> http://www.nabble.com/New-King.Oracle-0.8---improved-performance-tp20580
> 002p20602909.html
> Sent from the MapGuide Users mailing list archive at Nabble.com.
> 
> _______________________________________________
> mapguide-users mailing list
> mapguide-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapguide-users
> _______________________________________________
> mapguide-users mailing list
> mapguide-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapguide-users
> 
> 

-- 
View this message in context: http://www.nabble.com/New-King.Oracle-0.8---improved-performance-tp20580002p20603857.html
Sent from the MapGuide Users mailing list archive at Nabble.com.



More information about the mapguide-users mailing list