VDS Technologies

 

oracle layer problem

5/3/2014 8:57:19 AM
Total Posts 5

oracle layer problem

hi

i download the last version of aspmap 4.8.3, every thing goes ok,but suddenly i face this problem ora-01000:maximun open cursors exceeded at this line:

Layer layer = map.addLayer(oracleLayer);

i increase the open_cursor of oracle database,but also i face same problem.

how can i solve this problem,because i plan to update my current aspmap version to aspmap 4.8.3.

 

thanks

maher

 

 

5/5/2014 5:37:58 AM
MVP
Total Posts 323

Re: oracle layer problem

Please let us know the type of Oracle provider you are using (.NET built-in or the provider for Oracle) and send us the code of your project(.aspx.cs/vb) as a support ticket at http://vdstech.com/ccp.aspx

5/5/2014 12:49:40 PM
Total Posts 5

Re: oracle layer problem

hi

i ma using provider for Oracle

Oracle Data Access Components (ODAC) for Windows

 

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using AspMap;
using AspMap.Web;
using AspMap.Data;
using System.Drawing;
using Oracle.DataAccess.Client;
using Microsoft.ApplicationBlocks.Data;
using System.Data.OleDb;
using System.Drawing.Imaging;
using System.IO;
using ExifLib;
using System.Drawing;

 protected void getLayers()
    {

        String connectionString = OraHelper.DbConnectionStatic();
        String tableName = "ALL_PLACES";
        String providerName     = "Oracle.DataAccess.Client";

        OracleLayer oracleLayer ;

 

        tableName = "ALL_PLACES";

         oracleLayer = new OracleLayer(providerName, connectionString, tableName, "GEOM");
         oracleLayer.FieldList = "PLACE_NAME, PLACE_NO, LAYER_CODE";

        Layer layer = map.AddLayer(oracleLayer);

        // layer.EnablePassthroughQuery = true;
        layer.Name = "POINTS";
        layer.LabelField = "PLACE_NAME";
        
        

       
    }