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

[Haris Kurtagic]

Which Oracle client and which version are you using ?

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 5:04 PM
To: mapguide-users at lists.osgeo.org
Subject: RE: [mapguide-users] New King.Oracle 0.8 - improved performance



0.8.4 is giving the same error:
Attempted to read or write protected memory. This is often an indication
that other memory is corrupt.


Nick


Nick Adams wrote:
> 
> 
> 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-tp20580
002p20604513.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