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

[Haris Kurtagic]

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