<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Hi Benedikt,<br>
<br>
Thanks for the tip. My problem is that the queries are highly dynamic.
Using views would imply view managment (creation, cleanup). I'll keep
that idea if I run into problem with Andreas' solution.<br>
<br>
Thanks, and regards,<br>
Damien Corpataux<br>
<br>
Benedikt Rothe wrote:
<blockquote
cite="midOF77BC2851.BDDAC143-ONC1257353.00239D52-C1257353.002A411B@hydrotec.de"
type="cite"><br>
<font face="sans-serif" size="2">Hi Emmanuell</font>
<br>
<br>
<font face="sans-serif" size="2">If your project is stuck with this
problem:
In cases like this, I always try to avoid long SQL-statements in
mapfiles</font>
<br>
<font face="sans-serif" size="2">anyway. Instead I put the complexity
in a view and use in the mapfile just this view.</font>
<br>
<br>
<font face="sans-serif" size="2">Benedikt Rothe</font>
<br>
<br>
<tt><font size="2">UMN MapServer Users List
<a class="moz-txt-link-rfc2396E" href="mailto:MAPSERVER-USERS@LISTS.UMN.EDU"><MAPSERVER-USERS@LISTS.UMN.EDU></a>
schrieb am 10.09.2007 18:28:00:<br>
<br>
> Hi Fernando,<br>
> <br>
> thank you for investigating. We need this for a project, where it
is not<br>
> possible to use PostGIS.<br>
> <br>
> Do you have an idea how long it would take to fix the problem? Can
we<br>
> help you in some manner?<br>
> <br>
> Best regards,<br>
> <br>
> Emmanuel<br>
> <br>
> <br>
> <br>
> <br>
> <br>
> Fernando Simon wrote:<br>
> > Hi all,<br>
> > I will investigate the problem. I believe that it's
relate with the<br>
> > msSplitData function in the driver source code.<br>
> > Thanks for the reply about the error.<br>
> > Best regards.<br>
> > <br>
> > ---------------------------------------------------------<br>
> > Fernando Simon<br>
> > UMN Mapserver and Oracle Spatial developer<br>
> > <br>
> > Emmanuel BELO wrote:<br>
> >> After some investigation, we could identify that this
occurs
only with<br>
> >> an Oracle connector. It's not reproducible with a PostGIS
connection.<br>
> >><br>
> >> Here our testcase outline:<br>
> >><br>
> >><br>
> >> LAYER<br>
> >> CONNECTION "user/password@myoracleoracle9instance"<br>
> >> CONNECTIONTYPE ORACLESPATIAL<br>
> >> DATA "[Put a query larger than 2037 characters
here]"<br>
> >> METADATA<br>
> >> END<br>
> >> NAME "oracle_test_layer"<br>
> >> PROJECTION<br>
> >> "init=epsg:4326"<br>
> >> END<br>
> >> SIZEUNITS PIXELS<br>
> >> STATUS ON<br>
> >> TOLERANCEUNITS PIXELS<br>
> >> TYPE POLYGON<br>
> >> UNITS METERS<br>
> >> CLASS<br>
> >> METADATA<br>
> >> END<br>
> >> STYLE<br>
> >> ANGLE 360<br>
> >> OUTLINECOLOR 255 0 0<br>
> >> END<br>
> >> END<br>
> >> END<br>
> >><br>
> >> You can build a large sql query by adding a lot of
"always
true"<br>
> >> clauses, or by padding it with a lot of spaces<br>
> >> eg. shape from (select shape from my_table where
'djfksdhfjkdsf'
=<br>
> >> 'djfksdhfjkdsf' and 'djfksdhfjkdsf' = 'djfksdhfjkdsf'
[...])<br>
> >><br>
> >><br>
> >> Best regards,<br>
> >><br>
> >> Emmanuel BELO<br>
> >><br>
> >><br>
> >><br>
> >> Damien Corpataux wrote:<br>
> >> <br>
> >>> Hello List,<br>
> >>><br>
> >>> I ran into memory corrption with a long sql query in
the DATA object,<br>
> >>> for an Oracle LAYER. It is obviously due to Mapserver
memory allocation<br>
> >>> mechanism. The corruption occurs when the DATA is
longer
than ca. 2037<br>
> >>> characters.<br>
> >>><br>
> >>> Do you know if Mapserver has a way of modifying the
possible
allocated<br>
> >>> memory limit? In header files? By applying a patch?<br>
> >>><br>
> >>> Any idea is welcome!<br>
> >>><br>
> >>><br>
> >>> Thanks in advance, regards,<br>
> >>> Damien Corpataux<br>
> >>> <br>
> >><br>
> >> <br>
> > <br>
> <br>
> -- <br>
> Camptocamp SA<br>
> Emmanuel BELO<br>
> PSE A<br>
> CH-1015 Lausanne<br>
> <br>
> +41 21 619 10 25 (direct)<br>
> +41 21 619 10 10 (centrale)<br>
> +41 21 619 10 00 (fax)<br>
</font></tt>
</blockquote>
<br>
<br>
<div class="moz-signature">-- <br>
<style>
<!--
.signature {
font-family:verdana,helvetica,sans-serif;
font-size:0.8em;
line-height: 1.25em;
color: #9999BB;
width: 27em;
}
.signature div {
padding: 0.22em;
margin-bottom: 0.5em;
margin-top: 0.5em;
border-bottom: 1px dotted lightgray;
background-color: #FCFCFF;
}
.signature .attention {
background-color: #FFFAFA;
color: #FFBBBB;
font-size: 0.8em;
font-weight: bold;
}
.header {
}
-->
</style>
<div class="signature">
<div> <span style="font-weight: bold;">Camptocamp SA</span><br>
Damien Corpataux<br>
PSE A<br>
CH-1015 Lausanne<br>
</div>
<div> +41 21 619 10 22 <span class="header">(Direct)</span><br>
+41 21 619 10 10 <span class="header">(Centrale)</span><br>
+41 21 619 10 00 <span class="header">(Fax)</span><br>
</div>
<div style="color: rgb(102, 204, 102);"> <span
style="position: relative; top: -3px; font-family: Webdings; font-size: 24pt;">P</span>
<span style="">Please consider the environment <br>
Do you really need to print this email?</span>
</div>
</div>
</div>
</body>
</html>