[mapguide-users] Retrieving data from Oracle for MapGuide OS

[Eric Poon]

Hi Zack,

I am currently using MapGuide Open Source 2.1 and I've updated all the FDO
to ver 3.4.

The table has roughly 600 rows of data (for testing purposes), with 5
columns, and 2 of them are lat/long values. This company used to have all
non-spatial data (properties listings) and we are planning to add lat/long
values to those tables so we can map them out to do some spatial analysis
for research purposes. I thought about using real Oracle spatial data, but
because I have limited access to the database and the DBA is also located on
the otherside of the country I would prefer to go to the 'easiest' way in
terms of setting up the data within Oracle.

I checked the access.logs file on the server and I get these:

<2011-03-31T16:28:23>  2184 MapGuide Maestro
v2.0.0.4650 127.0.0.1 Administrator TestFeatureSourceConnection

followed by EnumerateResourceData.1.0.0:1 and SetResource.1.0.0:3 when I
clicked "test connection", and "configure columns" withn Maestro.

Also, are we suppose to see the list of filenames on that listbox within the
ODBC FDO menu after clicking "Test Connection"?

Thanks in advance for all the help!
Eric


On Thu, Mar 31, 2011 at 4:22 PM, Zac Spitzer <zac.spitzer at gmail.com> wrote:

> Hi Eric,
>
> it's always good to mention which version of MapGuide your using :)
>
> how many rows in the table your trying to access? Can you
> check the server access.logs to see if your seeing a lot
> of getDataRow requests?
>
> We found a similiar bug in King Oracle yesterday, which will be fixed
> in the final release of MapGuide 2.2
>
> I would highly recommend using King Oracle and real spatial
> over lat lon columns, especially if your using anything beyond
> very small amounts of data.
>
> Regards
>
> Zac
>
> On Fri, Apr 1, 2011 at 10:15 AM, Eric Poon <ericpoon124 at gmail.com> wrote:
> > Hi Everyone,
> >
> > I am a GIS student currently working on a MapGuide OS web mapping project
> > for a real estate company. I am currently working on a connection setup
> to
> > the Oracle Database. The Oracle database is located on another server,
> and I
> > have both OracleInstantClient and the corresponding ODBC driver installed
> on
> > my local workstation (the one that holds the MapGuide Server).
> >
> > On the Oracle side, I have non-spatial data where I have normal data with
> > two extra columns that hold the lat/long values, the DBA has created a
> VIEW
> > for my user account to access and retrieve data. Knowing that I will have
> to
> > define x,y within Maestro, I decided to use the ODBC FDO connection
> instead
> > of the King Oracle. I first setup a System/User DSN for the Oracle
> > Connection with connection tested without problems. Then I defined a new
> > data connection in Maestro 2.0 using ODBC FDO with DSN connection. The
> > connection was tested within Maestro without any problems reported.
> >
> > I then proceed to Configure Column within Maestro, where I waited for 1-2
> > min and Maestro returned an error saying Resource is busy. I tried
> > connecting to the Database through OpenOffice Base using the same ODBC
> > connection and although I was not able to see the VIEW, I was able to see
> > the other tables no problem.
> >
> > My question is, is there any additional settings that I have to define
> > within Maestro? Such as the ConnectionString? currently, my
> ConnectionString
> > is empty (I only enter information for userid, password, and
> DataSourceName.
> > I assume if OpenOffice Base was able to connect and retrieve those table,
> > then Maestro should have no problem in reading those tables as well.
> >
> > Any help will be appreciated!!
> > Thanks,
> > Eric
> >
> > --
> > View this message in context:
> http://osgeo-org.1803224.n2.nabble.com/Retrieving-data-from-Oracle-for-MapGuide-OS-tp6228945p6228945.html
> > Sent from the MapGuide Users mailing list archive at Nabble.com.
> > _______________________________________________
> > mapguide-users mailing list
> > mapguide-users at lists.osgeo.org
> > http://lists.osgeo.org/mailman/listinfo/mapguide-users
> >
>
>
>
> --
> Zac Spitzer
> Solution Architect / Director
> Ennoble Consultancy Australia
> http://www.ennoble.com.au
> http://zacster.blogspot.com
> +61 405 847 168
>  _______________________________________________
> mapguide-users mailing list
> mapguide-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapguide-users/attachments/20110331/0ae48250/attachment.html