[mapguide-users] Oracle 11gR2 - Basics..
Hi, Ive just installed Oracle 11gR2 and I need to create a new table import data to that table show the data in Mapguide. So far I've been able to install Oracle, create the table and importing the data to that table. Im also able to create a feature source (with KingOracle) to my Oracle database with the following connection parameters: Username: Password: Service : xe OracleSchema: empty KindFdoClass: empty SDE Schema : empty But when I create a layer for my Oracle feature source, I recevie the following error message: Feature Source (Library://.) has no usable feature classes. Choose a different feature source. Does the error message mean that my database doesnt have a table with spatial context? if yes, what can I do to correct this? Regards, Birgir -- View this message in context: http://osgeo-org.1560.n6.nabble.com/Oracle-11gR2-Basics-tp4340841p4340841.html Sent from the MapGuide Users mailing list archive at Nabble.com. ___ mapguide-users mailing list mapguide-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapguide-users
Re: [mapguide-users] Oracle 11gR2 - Basics..
Hi!
Set your OracleSchema value to (you username or schema name where
table with geometry is stored)
OracleSchema:
Otherwise check USER_SDO_GEOM_METADATA view.
King.Oracle provider will read ALL_SDO_GEOM_METADATA View and find tables
and columns with SDO_GEOMETRY data type.
For each pair Table-Column King.Oracle will create an FDO Feature class.
If you want a FDO Feature class to be created based on Oracle View than you
need to add a row in USER_SDO_GEOM_METADATA for that View.
Check and Update/Insert statement for USER_SDO_GEOM_METADATA for your
geometry
INSERT INTO USER_SDO_GEOM_METADATA
VALUES(
'EVENTS','GEOM',
MDSYS.SDO_DIM_ARRAY(
MDSYS.SDO_DIM_ELEMENT('X', -180, 180, 0.5),
MDSYS.SDO_DIM_ELEMENT('Y', -90, 90, 0.5)
),
4326 -- SRID
);
You must also create Spatial index on that geometry.
Regards,
Simon
On Thu, Jan 26, 2012 at 3:54 PM, Birgir b...@geograf.dk wrote:
Hi,
Ive just installed Oracle 11gR2 and I need to
create a new table
import data to that table
show the data in Mapguide.
So far I've been able to install Oracle, create the table and importing the
data to that table.
Im also able to create a feature source (with KingOracle) to my Oracle
database with the following connection parameters:
Username:
Password:
Service : xe
OracleSchema: empty
KindFdoClass: empty
SDE Schema : empty
But when I create a layer for my Oracle feature source, I recevie the
following error message:
Feature Source (Library://.) has no usable feature classes. Choose a
different feature source.
Does the error message mean that my database doesnt have a table with
spatial context? if yes, what can I do to correct this?
Regards,
Birgir
--
View this message in context:
http://osgeo-org.1560.n6.nabble.com/Oracle-11gR2-Basics-tp4340841p4340841.html
Sent from the MapGuide Users mailing list archive at Nabble.com.
___
mapguide-users mailing list
mapguide-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapguide-users
___
mapguide-users mailing list
mapguide-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapguide-users
RE: [mapguide-users] Oracle 11gR2 - Basics..
Specify the _OracleSchema_ (aka - object owner) r, dennis ___ mapguide-users mailing list mapguide-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapguide-users
Re: [mapguide-users] Oracle 11gR2 - Basics..
you need to flush the FDO connection to see any schema changes either use maestro's right click option or resave the feature source which does the same thing z On Fri, Jan 27, 2012 at 3:37 AM, Jonio, Dennis (Aviation) djo...@miami-airport.com wrote: Specify the _OracleSchema_ (aka - object owner) r, dennis ___ mapguide-users mailing list mapguide-users@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@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapguide-users
[mapguide-users] Questions for Maestro users on Linux/Mac
Hi All, I'd like to pose some questions for the Linux/Mac users out there using Maestro via Mono. I am considering migrating Maestro to target .net Framework 4.0 (we currently still target .net Framework 2.0). The primary reason for this move is because the next version of the official MapGuide .net API will be targeting 4.0 and if we don't upgrade Maestro to target 4.0, we lose the ability to have LocalNative connection support for future versions of MapGuide/AIMS. If we migrate to .net 4.0, we still retain the ability to reference assemblies of older framework versions, so we can still have LocalNative connection support for the current and older versions of the MapGuide .net API. The reason I have been very conservative thus far by staying on .net Framework 2.0 is to ensure Maestro will work better on Mono (generally speaking, the older the .net Framework version, the better support in Mono). If we do migrate Maestro to .net Framework 4.0, the minimum version of Mono that will theoretically work with this migrated version of Maestro will be 2.8 So my questions to the Linux/Mac Maestro users are: 1. What version of Mono are you currently using? 2. Are you capable of using Mono 2.8 or newer? I know Ubuntu for example, is very conservative with their releases of Mono and may not have the version of Mono that we require. - Jackie -- View this message in context: http://osgeo-org.1560.n6.nabble.com/Questions-for-Maestro-users-on-Linux-Mac-tp4342196p4342196.html Sent from the MapGuide Users mailing list archive at Nabble.com. ___ mapguide-users mailing list mapguide-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapguide-users
Re: [mapguide-users] Questions for Maestro users on Linux/Mac
1. What version of Mono are you currently using? 2.10.5 2. Are you capable of using Mono 2.8 or newer? I know Ubuntu for example, is very conservative with their releases of Mono and may not have the version of Mono that we require. Ubuntu current version (oneiric) has 2.10.5 in their official repository http://packages.ubuntu.com/search?keywords=mono-runtimesearchon=namessuite=allsection=all Mono currently has a lot of glitches, most of which are very annoying but do not prevent the use of Maestro. Probably switching to a more recent version of .net will expose some more serious (functional) bugs, I'll be glad to help find them. It will probably require some work on your side to circumvent them. Regards, Gabriele ___ mapguide-users mailing list mapguide-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapguide-users
