[mapguide-users] Problems with SDF/Database Joins (Oracle)

[Rahul]

Hi Bob,

            I think the issue which you talking about is due to caching problem of MapGuide ,i also tried with KingOracle Provider  and in that case also  if you change or add new column it will show only once you restart the Map Server.

Anyway you can give a  try with King Oracle FDO Provider and you can also download fdo2fdo tools in order to create KingFdo Class Table for Oracle.

Max 



----- Original Message ----
From: Bob Cassarly <bob.cassarly at famis.com>
To: mapguide-users at lists.osgeo.org
Sent: Monday, March 10, 2008 4:06:08 AM
Subject: Re: [mapguide-users] Problems with SDF/Database Joins (Oracle)


Max,

That is the driver I was using from my DSN.
My problem appears to be a problem is with the way MapGuide OS is caching
the database table/columns

If you first create a new Data Connection that uses a DSN (that uses the
Oracle Instant Client 10.2.0.3) it does indeed work and the tables
enumerate.  The problem I noticed with this is that if you change a table or
view definition to add a table/view column the new column does not appear in
the label/theme list.  This seems like a bug to me (especially considering
there does not seem to be a mechanism to update the cache).

If create a Data Source that uses the FDO ODBC Microsoft for Oracle driver
it connect sucessfully to the database but the tables do not enumerate.  If
I save that Data Connection as then later change Data Connection to use a
DSN the tables do not enumerate.  This also seems like a bug to me.

So the question is where are the database tables/columns cached too and is
it possible to refresh the cache.  Personally I would prefer that the
table/column NOT be cached at all but maybe I am asking too much.  

Bob



Hi,
        I think you try to connect Oracle Database  with Oracle Instant
Client 10.2.0.3 and  oracle odbc driver-win32 10.2.0.3 . 

Try ODBC FDO "Connect via a Data Source Name (DSN) set up on this server"
and use the above DSN which you created using the oracle odbc driver-win32
10.2.0.3 . 


Max !!


-- 
View this message in context: http://www.nabble.com/Problems-with-SDF-Database-Joins-%28Oracle%29-tp15906732s16610p15946485.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


      ____________________________________________________________________________________
Looking for last minute shopping deals?  
Find them fast with Yahoo! Search.  http://tools.search.yahoo.com/newsearch/category.php?category=shopping
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapguide-users/attachments/20080310/89a92c74/attachment.html