<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
Hi!<br>
I exported whole Sheboygan sample SDF files to Oracle .<br>
After extensively testing with provider version 0.8.5 i had no issues
with Sheboygan data.<br>
<br>
Simon<br>
<br>
Nick Adams wrote:
<blockquote cite="mid:20621925.post@talk.nabble.com" type="cite">
<pre wrap="">
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:
</pre>
<blockquote type="cite">
<pre wrap="">
Here is king.oracle 0.8.5 version which has additional logging enabled;
<a class="moz-txt-link-freetext" href="http://www.sl-king.com/fdooracle/download/KingOra_0_8_5_log.rar">http://www.sl-king.com/fdooracle/download/KingOra_0_8_5_log.rar</a>
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: <a class="moz-txt-link-abbreviated" href="mailto:mapguide-users-bounces@lists.osgeo.org">mapguide-users-bounces@lists.osgeo.org</a>
[<a class="moz-txt-link-freetext" href="mailto:mapguide-users-bounces@lists.osgeo.org">mailto:mapguide-users-bounces@lists.osgeo.org</a>] On Behalf Of Nick Adams
Sent: Friday, November 21, 2008 12:21 PM
To: <a class="moz-txt-link-abbreviated" href="mailto:mapguide-users@lists.osgeo.org">mapguide-users@lists.osgeo.org</a>
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:
</pre>
<blockquote type="cite">
<pre wrap="">Which Oracle client and which version are you using ?
Haris
-----Original Message-----
From: <a class="moz-txt-link-abbreviated" href="mailto:mapguide-users-bounces@lists.osgeo.org">mapguide-users-bounces@lists.osgeo.org</a>
[<a class="moz-txt-link-freetext" href="mailto:mapguide-users-bounces@lists.osgeo.org">mailto:mapguide-users-bounces@lists.osgeo.org</a>] On Behalf Of Nick
</pre>
</blockquote>
<pre wrap="">Adams
</pre>
<blockquote type="cite">
<pre wrap="">Sent: Thursday, November 20, 2008 5:04 PM
To: <a class="moz-txt-link-abbreviated" href="mailto:mapguide-users@lists.osgeo.org">mapguide-users@lists.osgeo.org</a>
Subject: RE: [mapguide-users] New King.Oracle 0.8 - improved
</pre>
</blockquote>
<pre wrap="">performance
</pre>
<blockquote type="cite">
<pre wrap="">
0.8.4 is giving the same error:
Attempted to read or write protected memory. This is often an
</pre>
</blockquote>
<pre wrap="">indication
</pre>
<blockquote type="cite">
<pre wrap="">that other memory is corrupt.
Nick
Nick Adams wrote:
</pre>
<blockquote type="cite">
<pre wrap="">
Ok. I've tried 0.8.3 and I'm now getting:
Attempted to read or write protected memory. This is often an
</pre>
</blockquote>
<pre wrap="">indication
</pre>
<blockquote type="cite">
<pre wrap="">that other memory is corrupt.
Nick
haris kurtagic wrote:
</pre>
<blockquote type="cite">
<pre wrap="">I posted 0.8.3 which should fix first problem.
Regarding SDO_FILTER If I remember correcly that is problem with 9.1
</pre>
</blockquote>
</blockquote>
<pre wrap="">(
</pre>
<blockquote type="cite">
<blockquote type="cite">
<pre wrap="">provider works in 9.2 ? ).
I don't have 9 versions available to test but if I look at docs and
</pre>
</blockquote>
</blockquote>
<pre wrap="">you
</pre>
<blockquote type="cite">
<blockquote type="cite">
<pre wrap="">try it perhaps we can fix it without me trying it.
Haris
-----Original Message-----
From: <a class="moz-txt-link-abbreviated" href="mailto:mapguide-users-bounces@lists.osgeo.org">mapguide-users-bounces@lists.osgeo.org</a>
[<a class="moz-txt-link-freetext" href="mailto:mapguide-users-bounces@lists.osgeo.org">mailto:mapguide-users-bounces@lists.osgeo.org</a>] On Behalf Of Nick
</pre>
</blockquote>
</blockquote>
<pre wrap="">Adams
</pre>
<blockquote type="cite">
<blockquote type="cite">
<pre wrap="">Sent: Thursday, November 20, 2008 3:55 PM
To: <a class="moz-txt-link-abbreviated" href="mailto:mapguide-users@lists.osgeo.org">mapguide-users@lists.osgeo.org</a>
Subject: RE: [mapguide-users] New King.Oracle 0.8 - improved
</pre>
</blockquote>
</blockquote>
<pre wrap="">performance
</pre>
<blockquote type="cite">
<blockquote type="cite">
<pre wrap="">
- 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:
</pre>
</blockquote>
</blockquote>
<pre wrap="">wrong
</pre>
<blockquote type="cite">
<blockquote type="cite">
<pre wrap="">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
</pre>
</blockquote>
</blockquote>
<pre wrap="">hoping
</pre>
<blockquote type="cite">
<blockquote type="cite">
<pre wrap="">0.8.x might solve this.
Nick
haris kurtagic wrote:
</pre>
<blockquote type="cite">
<pre wrap="">I am looking at code and I have two questions :
- are you using connection property OracleSchema, and value is same
</pre>
</blockquote>
</blockquote>
</blockquote>
<pre wrap="">as
</pre>
<blockquote type="cite">
<blockquote type="cite">
<blockquote type="cite">
<pre wrap="">UserName ?
- this has worked for you before release 0.8.2 ?
Haris
-----Original Message-----
From: <a class="moz-txt-link-abbreviated" href="mailto:mapguide-users-bounces@lists.osgeo.org">mapguide-users-bounces@lists.osgeo.org</a>
[<a class="moz-txt-link-freetext" href="mailto:mapguide-users-bounces@lists.osgeo.org">mailto:mapguide-users-bounces@lists.osgeo.org</a>] On Behalf Of Nick
</pre>
</blockquote>
<pre wrap="">Adams
</pre>
<blockquote type="cite">
<pre wrap="">Sent: Thursday, November 20, 2008 2:57 PM
To: <a class="moz-txt-link-abbreviated" href="mailto:mapguide-users@lists.osgeo.org">mapguide-users@lists.osgeo.org</a>
Subject: Re: [mapguide-users] New King.Oracle 0.8 - improved
</pre>
</blockquote>
<pre wrap="">performance
</pre>
<blockquote type="cite">
<pre wrap="">
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
</pre>
</blockquote>
</blockquote>
</blockquote>
<pre wrap="">.Net
</pre>
<blockquote type="cite">
<blockquote type="cite">
<blockquote type="cite">
<pre wrap="">to
connect to a 9i oracle database.
The query I'm making is:
SHAPE ENVELOPEINTERSECTS GeomFromText('POLYGON ((325400 701400,
</pre>
</blockquote>
</blockquote>
</blockquote>
<pre wrap="">325600
</pre>
<blockquote type="cite">
<blockquote type="cite">
<blockquote type="cite">
<pre wrap="">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:
</pre>
<blockquote type="cite">
<pre wrap="">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
</pre>
</blockquote>
</blockquote>
</blockquote>
</blockquote>
</blockquote>
<pre wrap="">your
</pre>
<blockquote type="cite">
<blockquote type="cite">
<blockquote type="cite">
<blockquote type="cite">
<blockquote type="cite">
<pre wrap="">feedback is appreciated.
List of changes:
Improved performance - very significant improvement
Support for SelectAggregate
FDO schema creation is now faster , especially when
</pre>
</blockquote>
<pre wrap="">OracleScema=UserName
</pre>
<blockquote type="cite">
<pre wrap="">Reintroduced schema caching
Full Unicode support
Using OCI interface
You can get it here: <a class="moz-txt-link-abbreviated" href="http://www.sl-king.com/fdooracle">www.sl-king.com/fdooracle</a>
Haris
_______________________________________________
mapguide-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:mapguide-users@lists.osgeo.org">mapguide-users@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="http://lists.osgeo.org/mailman/listinfo/mapguide-users">http://lists.osgeo.org/mailman/listinfo/mapguide-users</a>
</pre>
</blockquote>
<pre wrap="">--
View this message in context:
</pre>
</blockquote>
</blockquote>
</blockquote>
</blockquote>
<pre wrap=""><a class="moz-txt-link-freetext" href="http://www.nabble.com/New-King.Oracle-0.8---improved-performance-tp20580">http://www.nabble.com/New-King.Oracle-0.8---improved-performance-tp20580</a>
</pre>
<blockquote type="cite">
<blockquote type="cite">
<blockquote type="cite">
<blockquote type="cite">
<pre wrap="">002p20601567.html
Sent from the MapGuide Users mailing list archive at Nabble.com.
_______________________________________________
mapguide-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:mapguide-users@lists.osgeo.org">mapguide-users@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="http://lists.osgeo.org/mailman/listinfo/mapguide-users">http://lists.osgeo.org/mailman/listinfo/mapguide-users</a>
_______________________________________________
mapguide-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:mapguide-users@lists.osgeo.org">mapguide-users@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="http://lists.osgeo.org/mailman/listinfo/mapguide-users">http://lists.osgeo.org/mailman/listinfo/mapguide-users</a>
</pre>
</blockquote>
<pre wrap="">--
View this message in context:
</pre>
</blockquote>
</blockquote>
</blockquote>
<pre wrap=""><a class="moz-txt-link-freetext" href="http://www.nabble.com/New-King.Oracle-0.8---improved-performance-tp20580">http://www.nabble.com/New-King.Oracle-0.8---improved-performance-tp20580</a>
</pre>
<blockquote type="cite">
<blockquote type="cite">
<blockquote type="cite">
<pre wrap="">002p20602909.html
Sent from the MapGuide Users mailing list archive at Nabble.com.
_______________________________________________
mapguide-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:mapguide-users@lists.osgeo.org">mapguide-users@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="http://lists.osgeo.org/mailman/listinfo/mapguide-users">http://lists.osgeo.org/mailman/listinfo/mapguide-users</a>
_______________________________________________
mapguide-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:mapguide-users@lists.osgeo.org">mapguide-users@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="http://lists.osgeo.org/mailman/listinfo/mapguide-users">http://lists.osgeo.org/mailman/listinfo/mapguide-users</a>
</pre>
</blockquote>
<pre wrap="">
</pre>
</blockquote>
<pre wrap="">--
View this message in context:
</pre>
</blockquote>
<pre wrap=""><a class="moz-txt-link-freetext" href="http://www.nabble.com/New-King.Oracle-0.8---improved-performance-tp20580">http://www.nabble.com/New-King.Oracle-0.8---improved-performance-tp20580</a>
</pre>
<blockquote type="cite">
<pre wrap="">002p20604513.html
Sent from the MapGuide Users mailing list archive at Nabble.com.
_______________________________________________
mapguide-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:mapguide-users@lists.osgeo.org">mapguide-users@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="http://lists.osgeo.org/mailman/listinfo/mapguide-users">http://lists.osgeo.org/mailman/listinfo/mapguide-users</a>
_______________________________________________
mapguide-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:mapguide-users@lists.osgeo.org">mapguide-users@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="http://lists.osgeo.org/mailman/listinfo/mapguide-users">http://lists.osgeo.org/mailman/listinfo/mapguide-users</a>
</pre>
</blockquote>
<pre wrap="">--
View this message in context:
<a class="moz-txt-link-freetext" href="http://www.nabble.com/New-King.Oracle-0.8---improved-performance-tp20580">http://www.nabble.com/New-King.Oracle-0.8---improved-performance-tp20580</a>
002p20619229.html
Sent from the MapGuide Users mailing list archive at Nabble.com.
_______________________________________________
mapguide-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:mapguide-users@lists.osgeo.org">mapguide-users@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="http://lists.osgeo.org/mailman/listinfo/mapguide-users">http://lists.osgeo.org/mailman/listinfo/mapguide-users</a>
_______________________________________________
mapguide-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:mapguide-users@lists.osgeo.org">mapguide-users@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="http://lists.osgeo.org/mailman/listinfo/mapguide-users">http://lists.osgeo.org/mailman/listinfo/mapguide-users</a>
</pre>
</blockquote>
<pre wrap=""><!---->
</pre>
<pre wrap="">
<hr size="4" width="90%">
No virus found in this incoming message.
Checked by AVG - <a class="moz-txt-link-freetext" href="http://www.avg.com">http://www.avg.com</a>
Version: 8.0.175 / Virus Database: 270.9.9/1802 - Release Date: 20.11.2008 19:28
</pre>
</blockquote>
</body>
</html>