<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.6001.18248" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=090182411-06082009><FONT face=Arial size=2>Don't you mean that
you don't want your Oracle connection opened and closed for each layer? If
that's the case, you can use the setting </DIV><PRE><SPAN class=k>PROCESSING</SPAN> <SPAN class=s>"CLOSE_CONNECTION=DEFER"</SPAN>
</PRE>
<DIV><FONT color=#0000ff></FONT> </DIV>
<DIV> </DIV>
<DIV>in your Layer.</FONT></SPAN></DIV>
<DIV><SPAN class=090182411-06082009><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=090182411-06082009><FONT face=Arial size=2>See <A
href="http://ms.gis.umn.edu/docs/reference/mapfile/layer"><FONT
color=#000000>http://ms.gis.umn.edu/docs/reference/mapfile/layer</FONT></A> or
<A href="http://mapserver.org/input/vector/ogr.html"><FONT
color=#000000>http://mapserver.org/input/vector/ogr.html</FONT></A></FONT></SPAN></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><SPAN class=090182411-06082009><FONT face=Arial
size=2>Regards,</FONT></SPAN></DIV>
<DIV><SPAN class=090182411-06082009><FONT face=Arial
size=2>Jelmer</FONT></SPAN></DIV>
<DIV><U><FONT face=Arial color=#0066cc size=2></FONT></U><BR> </DIV>
<BLOCKQUOTE
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> mapserver-users-bounces@lists.osgeo.org
[mailto:mapserver-users-bounces@lists.osgeo.org] <B>On Behalf Of </B>Mr. Bic
Phuong<BR><B>Sent:</B> donderdag 6 augustus 2009 11:32<BR><B>To:</B> Pavel
Iacovlev<BR><B>Cc:</B> mapserver-users@lists.osgeo.org<BR><B>Subject:</B>
[mapserver-users] How to use 01 connection for all layers in map
file<BR></FONT><BR></DIV>
<DIV></DIV>
<TABLE cellSpacing=0 cellPadding=0 border=0>
<TBODY>
<TR>
<TD vAlign=top><BR>Your reply is really good news,<BR><BR>Will you
please to tell me details on details how can I do like you with a map
file which has more than 17 connection now?<BR><BR>I do not understand
yet clearly how to use "single" MapServer layer for all?<BR><BR>Thanks
so much and I hope you can help me more!<BR><FONT size=3><SPAN
style="FONT-WEIGHT: bold; FONT-FAMILY: times new roman"><BR></SPAN></FONT><BR><BR>---
On <B>Thu, 8/6/09, Pavel Iacovlev <I><<SPAN class=yshortcuts
id=lw_1249551026_0
style="CURSOR: pointer; BORDER-BOTTOM: rgb(0,102,204) 1px dashed">iacovlev.pavel@gmail.com</SPAN>></I></B>
wrote:<BR><BR>From: Pavel Iacovlev
<iacovlev.pavel@gmail.com><BR>Subject: Re: [mapserver-users] How
to use 01 connection for all layers in map file<BR>To: "Mr. Bic Phuong"
<bicphuongonline@yahoo.com><BR>Date: Thursday, August 6, 2009,
3:16 PM<BR><BR>Hope I get your question right.<BR><BR>We have around 32
layers in one of the project, the approach is rather<BR>simple, you just
use a "single" Mapserver layer so there is always 1<BR>request to
Mapserver from OpenLayers. The request layer is the<BR>combination of
all your layers, the overlaying is made server
side.<BR><BR>Details:<BR>1. We have a custom "layer switcher" that user
selects what layers he<BR>wants to see and this data is saved, in a php
session for example.<BR>2. Then the user requests a map from a
PHPMapscript(mapserver) server,<BR>using php you fetch all the layers
selected by the user previously<BR>3. Dispatch the
result<BR><BR></TD></TR></TBODY></TABLE><BR></BLOCKQUOTE></BODY></HTML>