Custom Query (278 matches)

Hi,

I have a web system that is heavily batabase dependent, and can use both Oracle and Postgres as database according to the user's request. This means that the two databases are identical, the tables are identical, the constraints are identical, the two sets of php-scripts are identical ( except for the database calls ) and so on.

I have noticed a problem with Oracle. Look at this:

foreach($aLayersIdx as $layerIndex) {

$oLayerK = $oMapK->getLayer($layerIndex); if ($bDebug) {

fwrite($f,"layer: ".$oLayerK->name."\r\n");

}

if ($oLayerK->name == "AVD" && $avd == "") {

$oLayerK->set("status",MS_OFF); continue;

}

$filter = ""; switch ($oLayerK->name) {

case "AVD" :

$filter = "([ORGID]='".$orgid."' AND [FV]='".$fv."' AND [BEV]='".$bev."' AND [SKIFTE]='".$skifte."' AND [AVD]='".$avd."')"; $data = "KARTOBJ_SDO FROM ".$dbowner.".AVD*AVD"; break;

case "X" :

$filter = "([ID]='".$sessid."')"; $data = "KARTOBJ_SDO FROM ".$dbowner.".KARTA*TMP2"; break;

}

$data = str_replace("*","$",$data);

$oLayerK->set("data", $data); $oLayerK->setFilter($filter); $oLayerK->setConnectionType(MS_ORACLESPATIAL); $oLayerK->set("connection", $conn); $oLayerK->set("status", MS_ON); if ($bDebug) {

fwrite($f,"connection: ".$conn."\r\n"); fwrite($f,"filter: ".$filter."\r\n"); fwrite($f,"data: ".$data."\r\n");

}

}

For layer 'X' filter does not work. Or rather it works but mapserver can't find any record. If the line '$filter = "([ID]='".$sessid."')";' is commented ( and the table contains one record ), it works. It seems that the select based on filter gets incorrect. Filter for layer 'AVD' works allright. No hint of errors in the debug file.

I have got other similar funny errors with Oracle filter for other tables. Some column names sometimes do not work ( that is no records are found ). Sometimes they work but not together with certain other columns in the filter. The error is consistent in that way that a certain filter never works, but another, almost similar filter for an other table always works. I have not found any pattern in this.

Björn D

I built a WFS server site on some Oracle data and another WMS site using the WFS layers in the first site (version=2.0.0) using the OGR WFS driver. It works but was slow as dough and when I checked the serverlogs I can see that the BBOX constraint given in the WMS call were not used in the calls to the underlying Oracle database (EXTENT from the mapfile is used).

It seems like SetSpatialFilter() (se ​http://www.gdal.org/drv_wfs.html) is not called in this case.

I can use external WFS 2.0 sources fine and I can call the WFS server from QGIS the expected spatial filter is used.

The libcurl.dll is in the directory.

I have no idea what to do. The System is a Microsoft Windows 8.1 x64 Enterprise edition.

I have linked my versions of shapetree and libcurl.dll to the ticket.