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

[Zac Spitzer]

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