[mapguide-users] New King.Oracle 0.8 - improved performance
Haris Kurtagic
haris at sl-king.com
Thu Nov 20 12:12:00 EST 2008
Hm, thinks work ok with 0.8.4 for me.
Have you tried it in MG or ..
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
More information about the mapguide-users
mailing list