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

Nick Adams nick.adams at 1spatial.com
Fri Nov 21 09:16:35 EST 2008 


Output from the log file:
...
<325-10-21 13:59:41>c_KgOraConnection3::Open OK
<325-10-21 13:59:41>c_KgOraConnection3::GetConnectionState
<325-10-21 13:59:41>c_KgOraConnection3::GetConnectionState
<325-10-21 13:59:41>c_KgOraConnection::CreateCommand 0
'FdoCommandType_Select'
<325-10-21 13:59:41>c_KgOraConnection3::GetConnectionState
<325-10-21 13:59:41>c_KgOraConnection3::GetConnectionState
<325-10-21 13:59:41>c_KgOraSelectCommand.Execute: Command Parameters
<325-10-21 13:59:41>c_KgOraSelectCommand.Execute Select List: 'SHAPE,KEYVAL'
<325-10-21 13:59:41>c_KgOraSelectCommand.Execute Filter: 'SHAPE
ENVELOPEINTERSECTS GeomFromText('POLYGON ((325400 701400, 325600 701400,
325600 701600, 325400 701600, 325400 701400))')'
<325-10-21 13:59:41>c_KgOraConnection3::GetConnectionString

Then I get the usual error:  Attempted to read or write protected memory.


Nick


haris kurtagic wrote:
> 
> 
> Here is king.oracle 0.8.5 version which has additional logging enabled;
> http://www.sl-king.com/fdooracle/download/KingOra_0_8_5_log.rar
> 
> It will log executed sql's in KingOra.log file in same folder as
> provider.
> If you try perhaps we can figure out what is going on.
> 
> 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: Friday, November 21, 2008 12:21 PM
> To: mapguide-users at lists.osgeo.org
> Subject: RE: [mapguide-users] New King.Oracle 0.8 - improved performance
> 
> 
> Hi Harris,
> 
> I've tried:
> - Oracle 10.2 instant client
> - Oracle 11g client
> 
> Both give the same:
> Attempted to read or write protected memory... error.
> 
> I can also concur with FISHeR1: 0.8.4 gives an Unclassified Exception
> when
> rendering a layer in MGOS 2.02, using the instant client.
> I'm not 100% certain, but from recollection 0.8.2 was the last version I
> saw
> working in MGOS.
> 
> 
> Nick
> 
> 
> haris kurtagic wrote:
>> 
>> 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
>> _______________________________________________
>> 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
> 002p20619229.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-tp20580002p20621925.html
Sent from the MapGuide Users mailing list archive at Nabble.com.

More information about the mapguide-users mailing list