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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Nick Adams Sent: Friday, November 21, 2008 12:21 PM To: [email protected] 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: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Nick Adams > Sent: Thursday, November 20, 2008 5:04 PM > To: [email protected] > 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: [EMAIL PROTECTED] >>> [mailto:[EMAIL PROTECTED] On Behalf Of Nick > Adams >>> Sent: Thursday, November 20, 2008 3:55 PM >>> To: [email protected] >>> 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: [EMAIL PROTECTED] >>>> [mailto:[EMAIL PROTECTED] On Behalf Of Nick >>> Adams >>>> Sent: Thursday, November 20, 2008 2:57 PM >>>> To: [email protected] >>>> 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 >>>>> [email protected] >>>>> 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 >>>> [email protected] >>>> http://lists.osgeo.org/mailman/listinfo/mapguide-users >>>> _______________________________________________ >>>> mapguide-users mailing list >>>> [email protected] >>>> 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 >>> [email protected] >>> http://lists.osgeo.org/mailman/listinfo/mapguide-users >>> _______________________________________________ >>> mapguide-users mailing list >>> [email protected] >>> 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 > [email protected] > http://lists.osgeo.org/mailman/listinfo/mapguide-users > _______________________________________________ > mapguide-users mailing list > [email protected] > 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 [email protected] http://lists.osgeo.org/mailman/listinfo/mapguide-users _______________________________________________ mapguide-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapguide-users
