RE: [mapguide-users] Problems with SDF/Database Joins (Oracle)
Jackie, If you want to disable FDO caching for a specific provider you can do the following: In the serverconfig.ini file edit the DataConnectionPoolExcludedProviders parameter. Example below: (disables it for ODBC and MySql) DataConnectionPoolExcludedProviders = OSGeo.ODBC,OSGeo.MySQL If you want to disable it for all providers you can do the following: DataConnectionPoolEnabled = 0 Warning: Doing this does impact performance, especially for RDBMS (Oracle, etc...) Note: The SDF and SHP providers are already excluded from the data connection pooling because of a FDO defect, but even though they are excluded they are still fast. Thanks, Bruce -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jackie Ng Sent: Monday, March 10, 2008 10:40 PM To: mapguide-users@lists.osgeo.org Subject: RE: [mapguide-users] Problems with SDF/Database Joins (Oracle) Hi Bruce, I too find this problem annoying during the development/testing stages, as our db schemas are in flux. Having to restart mapguide everytime the db changes is time consuming. So how would I go about disabling caching on a per-provider level? - Jackie Bruce Dechant wrote: Max, This is related to the caching done by the MapGuide server, but is not a defect. The problem is that the MapGuide server has no idea that the underlying feature source schema changed. There is no callback from Oracle (or any other provider) to FDO and then finally to the MapGuide server to inform about any schema changes. If you are going to be making schema changes while you are developing your site then you could temporarily disable the caching of the specific FDO provider you are using. This will also disable the caching of the underlying schemas and classes. Then turn it back on once your schema changes are done. Alternatively, you can disable the caching of all schemas and classes by setting the CacheSize parameter in the serverconfig.ini file to 0. Be warned that by doing this the MapGuide server will be MUCH slower because it will have to get this information from the underlying FDO providers for everything it does. I can see adding an API to MapGuide that you can call to clear the FDO schema/classes cache being useful in this case. The WebAdmin could be updated to call this to clear the cache without stopping the MapGuide server whenever you made changes to your schemas. Thanks, Bruce -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bob Cassarly Sent: Sunday, March 09, 2008 3:06 PM To: mapguide-users@lists.osgeo.org 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@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 -- View this message in context: http://www.nabble.com/Problems-with-SDF-Database-Joins-%28Oracle%29-tp15906732s16610p15974750.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
Re: [mapguide-users] Problems with SDF/Database Joins (Oracle)
you can just 'touch' the datasource to force a refresh of the cached schema just get the XML resourceContent and overwrite the existing featureSource On Wed, Mar 12, 2008 at 3:13 AM, Bruce Dechant [EMAIL PROTECTED] wrote: Jackie, If you want to disable FDO caching for a specific provider you can do the following: In the serverconfig.ini file edit the DataConnectionPoolExcludedProviders parameter. Example below: (disables it for ODBC and MySql) DataConnectionPoolExcludedProviders = OSGeo.ODBC,OSGeo.MySQL If you want to disable it for all providers you can do the following: DataConnectionPoolEnabled = 0 Warning: Doing this does impact performance, especially for RDBMS (Oracle, etc...) Note: The SDF and SHP providers are already excluded from the data connection pooling because of a FDO defect, but even though they are excluded they are still fast. Thanks, Bruce -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jackie Ng Sent: Monday, March 10, 2008 10:40 PM To: mapguide-users@lists.osgeo.org Subject: RE: [mapguide-users] Problems with SDF/Database Joins (Oracle) Hi Bruce, I too find this problem annoying during the development/testing stages, as our db schemas are in flux. Having to restart mapguide everytime the db changes is time consuming. So how would I go about disabling caching on a per-provider level? - Jackie Bruce Dechant wrote: Max, This is related to the caching done by the MapGuide server, but is not a defect. The problem is that the MapGuide server has no idea that the underlying feature source schema changed. There is no callback from Oracle (or any other provider) to FDO and then finally to the MapGuide server to inform about any schema changes. If you are going to be making schema changes while you are developing your site then you could temporarily disable the caching of the specific FDO provider you are using. This will also disable the caching of the underlying schemas and classes. Then turn it back on once your schema changes are done. Alternatively, you can disable the caching of all schemas and classes by setting the CacheSize parameter in the serverconfig.ini file to 0. Be warned that by doing this the MapGuide server will be MUCH slower because it will have to get this information from the underlying FDO providers for everything it does. I can see adding an API to MapGuide that you can call to clear the FDO schema/classes cache being useful in this case. The WebAdmin could be updated to call this to clear the cache without stopping the MapGuide server whenever you made changes to your schemas. Thanks, Bruce -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bob Cassarly Sent: Sunday, March 09, 2008 3:06 PM To: mapguide-users@lists.osgeo.org 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@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapguide-users
Re: [mapguide-users] Problems with SDF/Database Joins (Oracle)
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 [EMAIL PROTECTED] To: mapguide-users@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@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___ mapguide-users mailing list mapguide-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapguide-users
RE: [mapguide-users] Problems with SDF/Database Joins (Oracle)
Hi Bruce, I too find this problem annoying during the development/testing stages, as our db schemas are in flux. Having to restart mapguide everytime the db changes is time consuming. So how would I go about disabling caching on a per-provider level? - Jackie Bruce Dechant wrote: Max, This is related to the caching done by the MapGuide server, but is not a defect. The problem is that the MapGuide server has no idea that the underlying feature source schema changed. There is no callback from Oracle (or any other provider) to FDO and then finally to the MapGuide server to inform about any schema changes. If you are going to be making schema changes while you are developing your site then you could temporarily disable the caching of the specific FDO provider you are using. This will also disable the caching of the underlying schemas and classes. Then turn it back on once your schema changes are done. Alternatively, you can disable the caching of all schemas and classes by setting the CacheSize parameter in the serverconfig.ini file to 0. Be warned that by doing this the MapGuide server will be MUCH slower because it will have to get this information from the underlying FDO providers for everything it does. I can see adding an API to MapGuide that you can call to clear the FDO schema/classes cache being useful in this case. The WebAdmin could be updated to call this to clear the cache without stopping the MapGuide server whenever you made changes to your schemas. Thanks, Bruce -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bob Cassarly Sent: Sunday, March 09, 2008 3:06 PM To: mapguide-users@lists.osgeo.org 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@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 -- View this message in context: http://www.nabble.com/Problems-with-SDF-Database-Joins-%28Oracle%29-tp15906732s16610p15974750.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] Problems with SDF/Database Joins (Oracle)
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 !! - Original Message From: Bob Cassarly [EMAIL PROTECTED] To: mapguide-users@lists.osgeo.org Sent: Friday, March 7, 2008 9:29:30 AM Subject: [mapguide-users] Problems with SDF/Database Joins (Oracle) I have been trying to establish a connection directly to an Oracle database. My desired result is to use a database table and/or view as a secondary data source joined to an SDF. In the two cases (3 and 4 below) where the Oracle database test is successful the “Secondary class (table):” list does not fill out (in the SDF join properties). As such I cannot actually create the join against an Oracle table in MG Studio. The only way I have been able to successfully do a join between a database and an SDF is to dump my oracle tables into an Access database. Though this does work this is definitely not a reasonable solution, plus it seems to be vey slow. I have also tried the King drivers against MGOS 1.2 quite a while ago and had similar issues. It's probably me so any help would be great! Database connection tests… 1. ODBC FDO Connect to a Database using the Oracle (Oracle Diver) and providing credentials. Upon testing I get this error An exception occurred in FDO component. RDBMS: No current open database. 2. ODBC FDO Connect via a Data Source Name (DSN) set up on this server. The DSN I setup uses the “Oracle in instantclient 10_2” Upon testing I get this error. An exception occurred in FDO component. RDBMS: No current open database. 3. ODBC FDO Connect to a Database using the Oracle (Microsoft Diver) and providing credentials. Upon testing I get Successful connection 4. ODBC FDO Connect via a Data Source Name (DSN) set up on this server. The DSN I setup uses the “Oracle Microsoft ODBC for Oracle”. Upon testing I get. Successful connection Any help would be greatly appreciate -- View this message in context: http://www.nabble.com/Problems-with-SDF-Database-Joins-%28Oracle%29-tp15906732s16610p15906732.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 Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ ___ mapguide-users mailing list mapguide-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapguide-users