Re: [Geotools-devel] JDBCAccessPGRaster - updating mosaic extent/resolutions table
Hi Christian, had you any chance to take a look on that? Should I open a JIRA? Cheers, Daniele == Our support, Your Success! Visit http://opensdi.geo-solutions.it for more information. == Ing. Daniele Romagnoli Senior Software Engineer GeoSolutions S.A.S. Via Poggio alle Viti 1187 55054 Massarosa (LU) Italy phone: +39 0584 962313 fax: +39 0584 1660272 http://www.geo-solutions.it http://twitter.com/geosolutions_it --- On Wed, Jul 24, 2013 at 12:28 PM, Daniele Romagnoli daniele.romagn...@geo-solutions.it wrote: Hi Christian, On Wed, Jul 10, 2013 at 4:24 PM, Christian Mueller christian.muel...@os-solutions.at wrote: Hi Daniele Strange, I see the rollback is out-commented too. Please remove the comments for rollback and commit and check the result. I think I know why they have been commented: if out-commented, the statementMap map is empty (since it isn't updated due to resolutions and extents being known in advance). This result into errors when starting tile decoders which are taking the gridStatement from the statementMap. We may consider opening a JIRA for this. Cheers, Daniele 2013/7/10 Daniele Romagnoli daniele.romagn...@geo-solutions.it Hi Christian, I'm playing with the ImageMosaicJDBC using PGRaster. I have noticed that the JDBCAccessPGRaster class does some initialization steps where it looks for overviews (ImageLevelInfo) extents and resolutions. Then it setup values for preparedStatement to do updates of resolutoins and extent within the MOSAIC table (which contains the name of the coverage, the name of the table containing a specific level, extent and resolution). However, I see that line 116 contains a con.commit(); being commented-out. Therefore, no fields are updated into the DB since no commit occurs.(moreover, line 109 set autocommit fo talse). Is there any reason for this or it's a simple oversight (Maybe you have commented out during tests and then forgot to restore it)? Please, let me know. Cheers, Daniele == Our support, Your Success! Visit http://opensdi.geo-solutions.it for more information. == Ing. Daniele Romagnoli Senior Software Engineer GeoSolutions S.A.S. Via Poggio alle Viti 1187 55054 Massarosa (LU) Italy phone: +39 0584 962313 fax: +39 0584 1660272 http://www.geo-solutions.it http://twitter.com/geosolutions_it --- -- See everything from the browser to the database with AppDynamics Get end-to-end visibility with application monitoring from AppDynamics Isolate bottlenecks and diagnose root cause in seconds. Start your free trial of AppDynamics Pro today! http://pubads.g.doubleclick.net/gampad/clk?id=48808831iu=/4140/ostg.clktrk ___ GeoTools-Devel mailing list GeoTools-Devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geotools-devel -- DI Christian Mueller MSc (GIS), MSc (IT-Security) OSS Open Source Solutions GmbH -- Get your SQL database under version control now! Version control is standard for application code, but databases havent caught up. So what steps can you take to put your SQL databases under version control? Why should you start doing it? Read more to find out. http://pubads.g.doubleclick.net/gampad/clk?id=49501711iu=/4140/ostg.clktrk___ GeoTools-Devel mailing list GeoTools-Devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geotools-devel
Re: [Geotools-devel] JDBCAccessPGRaster - updating mosaic extent/resolutions table
Hi Daniele Please open a JIRA, no chance to invest some time at the moment. 2013/7/31 Daniele Romagnoli daniele.romagn...@geo-solutions.it Hi Christian, had you any chance to take a look on that? Should I open a JIRA? Cheers, Daniele == Our support, Your Success! Visit http://opensdi.geo-solutions.it for more information. == Ing. Daniele Romagnoli Senior Software Engineer GeoSolutions S.A.S. Via Poggio alle Viti 1187 55054 Massarosa (LU) Italy phone: +39 0584 962313 fax: +39 0584 1660272 http://www.geo-solutions.it http://twitter.com/geosolutions_it --- On Wed, Jul 24, 2013 at 12:28 PM, Daniele Romagnoli daniele.romagn...@geo-solutions.it wrote: Hi Christian, On Wed, Jul 10, 2013 at 4:24 PM, Christian Mueller christian.muel...@os-solutions.at wrote: Hi Daniele Strange, I see the rollback is out-commented too. Please remove the comments for rollback and commit and check the result. I think I know why they have been commented: if out-commented, the statementMap map is empty (since it isn't updated due to resolutions and extents being known in advance). This result into errors when starting tile decoders which are taking the gridStatement from the statementMap. We may consider opening a JIRA for this. Cheers, Daniele 2013/7/10 Daniele Romagnoli daniele.romagn...@geo-solutions.it Hi Christian, I'm playing with the ImageMosaicJDBC using PGRaster. I have noticed that the JDBCAccessPGRaster class does some initialization steps where it looks for overviews (ImageLevelInfo) extents and resolutions. Then it setup values for preparedStatement to do updates of resolutoins and extent within the MOSAIC table (which contains the name of the coverage, the name of the table containing a specific level, extent and resolution). However, I see that line 116 contains a con.commit(); being commented-out. Therefore, no fields are updated into the DB since no commit occurs.(moreover, line 109 set autocommit fo talse). Is there any reason for this or it's a simple oversight (Maybe you have commented out during tests and then forgot to restore it)? Please, let me know. Cheers, Daniele == Our support, Your Success! Visit http://opensdi.geo-solutions.it for more information. == Ing. Daniele Romagnoli Senior Software Engineer GeoSolutions S.A.S. Via Poggio alle Viti 1187 55054 Massarosa (LU) Italy phone: +39 0584 962313 fax: +39 0584 1660272 http://www.geo-solutions.it http://twitter.com/geosolutions_it --- -- See everything from the browser to the database with AppDynamics Get end-to-end visibility with application monitoring from AppDynamics Isolate bottlenecks and diagnose root cause in seconds. Start your free trial of AppDynamics Pro today! http://pubads.g.doubleclick.net/gampad/clk?id=48808831iu=/4140/ostg.clktrk ___ GeoTools-Devel mailing list GeoTools-Devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geotools-devel -- DI Christian Mueller MSc (GIS), MSc (IT-Security) OSS Open Source Solutions GmbH -- DI Christian Mueller MSc (GIS), MSc (IT-Security) OSS Open Source Solutions GmbH -- Get your SQL database under version control now! Version control is standard for application code, but databases havent caught up. So what steps can you take to put your SQL databases under version control? Why should you start doing it? Read more to find out. http://pubads.g.doubleclick.net/gampad/clk?id=49501711iu=/4140/ostg.clktrk___ GeoTools-Devel mailing list GeoTools-Devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geotools-devel
Re: [Geotools-devel] JDBCAccessPGRaster - updating mosaic extent/resolutions table
Ok. No problem. I'm gonna opening a ticket. Cheers, Daniele == Our support, Your Success! Visit http://opensdi.geo-solutions.it for more information. == Ing. Daniele Romagnoli Senior Software Engineer GeoSolutions S.A.S. Via Poggio alle Viti 1187 55054 Massarosa (LU) Italy phone: +39 0584 962313 fax: +39 0584 1660272 http://www.geo-solutions.it http://twitter.com/geosolutions_it --- On Wed, Jul 31, 2013 at 4:30 PM, Christian Mueller christian.muel...@os-solutions.at wrote: Hi Daniele Please open a JIRA, no chance to invest some time at the moment. 2013/7/31 Daniele Romagnoli daniele.romagn...@geo-solutions.it Hi Christian, had you any chance to take a look on that? Should I open a JIRA? Cheers, Daniele == Our support, Your Success! Visit http://opensdi.geo-solutions.it for more information. == Ing. Daniele Romagnoli Senior Software Engineer GeoSolutions S.A.S. Via Poggio alle Viti 1187 55054 Massarosa (LU) Italy phone: +39 0584 962313 fax: +39 0584 1660272 http://www.geo-solutions.it http://twitter.com/geosolutions_it --- On Wed, Jul 24, 2013 at 12:28 PM, Daniele Romagnoli daniele.romagn...@geo-solutions.it wrote: Hi Christian, On Wed, Jul 10, 2013 at 4:24 PM, Christian Mueller christian.muel...@os-solutions.at wrote: Hi Daniele Strange, I see the rollback is out-commented too. Please remove the comments for rollback and commit and check the result. I think I know why they have been commented: if out-commented, the statementMap map is empty (since it isn't updated due to resolutions and extents being known in advance). This result into errors when starting tile decoders which are taking the gridStatement from the statementMap. We may consider opening a JIRA for this. Cheers, Daniele 2013/7/10 Daniele Romagnoli daniele.romagn...@geo-solutions.it Hi Christian, I'm playing with the ImageMosaicJDBC using PGRaster. I have noticed that the JDBCAccessPGRaster class does some initialization steps where it looks for overviews (ImageLevelInfo) extents and resolutions. Then it setup values for preparedStatement to do updates of resolutoins and extent within the MOSAIC table (which contains the name of the coverage, the name of the table containing a specific level, extent and resolution). However, I see that line 116 contains a con.commit(); being commented-out. Therefore, no fields are updated into the DB since no commit occurs.(moreover, line 109 set autocommit fo talse). Is there any reason for this or it's a simple oversight (Maybe you have commented out during tests and then forgot to restore it)? Please, let me know. Cheers, Daniele == Our support, Your Success! Visit http://opensdi.geo-solutions.it for more information. == Ing. Daniele Romagnoli Senior Software Engineer GeoSolutions S.A.S. Via Poggio alle Viti 1187 55054 Massarosa (LU) Italy phone: +39 0584 962313 fax: +39 0584 1660272 http://www.geo-solutions.it http://twitter.com/geosolutions_it --- -- See everything from the browser to the database with AppDynamics Get end-to-end visibility with application monitoring from AppDynamics Isolate bottlenecks and diagnose root cause in seconds. Start your free trial of AppDynamics Pro today! http://pubads.g.doubleclick.net/gampad/clk?id=48808831iu=/4140/ostg.clktrk ___ GeoTools-Devel mailing list GeoTools-Devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geotools-devel -- DI Christian Mueller MSc (GIS), MSc (IT-Security) OSS Open Source Solutions GmbH -- DI Christian Mueller MSc (GIS), MSc (IT-Security) OSS Open Source Solutions GmbH -- Get your SQL database under version control now! Version control is standard for application code, but databases havent caught up. So what steps can you take to put your SQL databases under version control? Why should you start doing it? Read more to find out. http://pubads.g.doubleclick.net/gampad/clk?id=49501711iu=/4140/ostg.clktrk___ GeoTools-Devel mailing list GeoTools-Devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geotools-devel
Re: [Geotools-devel] JDBCAccessPGRaster - updating mosaic extent/resolutions table
Hi Christian, On Wed, Jul 10, 2013 at 4:24 PM, Christian Mueller christian.muel...@os-solutions.at wrote: Hi Daniele Strange, I see the rollback is out-commented too. Please remove the comments for rollback and commit and check the result. I think I know why they have been commented: if out-commented, the statementMap map is empty (since it isn't updated due to resolutions and extents being known in advance). This result into errors when starting tile decoders which are taking the gridStatement from the statementMap. We may consider opening a JIRA for this. Cheers, Daniele 2013/7/10 Daniele Romagnoli daniele.romagn...@geo-solutions.it Hi Christian, I'm playing with the ImageMosaicJDBC using PGRaster. I have noticed that the JDBCAccessPGRaster class does some initialization steps where it looks for overviews (ImageLevelInfo) extents and resolutions. Then it setup values for preparedStatement to do updates of resolutoins and extent within the MOSAIC table (which contains the name of the coverage, the name of the table containing a specific level, extent and resolution). However, I see that line 116 contains a con.commit(); being commented-out. Therefore, no fields are updated into the DB since no commit occurs.(moreover, line 109 set autocommit fo talse). Is there any reason for this or it's a simple oversight (Maybe you have commented out during tests and then forgot to restore it)? Please, let me know. Cheers, Daniele == Our support, Your Success! Visit http://opensdi.geo-solutions.it for more information. == Ing. Daniele Romagnoli Senior Software Engineer GeoSolutions S.A.S. Via Poggio alle Viti 1187 55054 Massarosa (LU) Italy phone: +39 0584 962313 fax: +39 0584 1660272 http://www.geo-solutions.it http://twitter.com/geosolutions_it --- -- See everything from the browser to the database with AppDynamics Get end-to-end visibility with application monitoring from AppDynamics Isolate bottlenecks and diagnose root cause in seconds. Start your free trial of AppDynamics Pro today! http://pubads.g.doubleclick.net/gampad/clk?id=48808831iu=/4140/ostg.clktrk ___ GeoTools-Devel mailing list GeoTools-Devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geotools-devel -- DI Christian Mueller MSc (GIS), MSc (IT-Security) OSS Open Source Solutions GmbH -- See everything from the browser to the database with AppDynamics Get end-to-end visibility with application monitoring from AppDynamics Isolate bottlenecks and diagnose root cause in seconds. Start your free trial of AppDynamics Pro today! http://pubads.g.doubleclick.net/gampad/clk?id=48808831iu=/4140/ostg.clktrk___ GeoTools-Devel mailing list GeoTools-Devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geotools-devel
[Geotools-devel] JDBCAccessPGRaster - updating mosaic extent/resolutions table
Hi Christian, I'm playing with the ImageMosaicJDBC using PGRaster. I have noticed that the JDBCAccessPGRaster class does some initialization steps where it looks for overviews (ImageLevelInfo) extents and resolutions. Then it setup values for preparedStatement to do updates of resolutoins and extent within the MOSAIC table (which contains the name of the coverage, the name of the table containing a specific level, extent and resolution). However, I see that line 116 contains a con.commit(); being commented-out. Therefore, no fields are updated into the DB since no commit occurs.(moreover, line 109 set autocommit fo talse). Is there any reason for this or it's a simple oversight (Maybe you have commented out during tests and then forgot to restore it)? Please, let me know. Cheers, Daniele == Our support, Your Success! Visit http://opensdi.geo-solutions.it for more information. == Ing. Daniele Romagnoli Senior Software Engineer GeoSolutions S.A.S. Via Poggio alle Viti 1187 55054 Massarosa (LU) Italy phone: +39 0584 962313 fax: +39 0584 1660272 http://www.geo-solutions.it http://twitter.com/geosolutions_it --- -- See everything from the browser to the database with AppDynamics Get end-to-end visibility with application monitoring from AppDynamics Isolate bottlenecks and diagnose root cause in seconds. Start your free trial of AppDynamics Pro today! http://pubads.g.doubleclick.net/gampad/clk?id=48808831iu=/4140/ostg.clktrk___ GeoTools-Devel mailing list GeoTools-Devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geotools-devel
Re: [Geotools-devel] JDBCAccessPGRaster - updating mosaic extent/resolutions table
Hi Daniele Strange, I see the rollback is out-commented too. Please remove the comments for rollback and commit and check the result. Another question: There is a new API supporting multiple coverages for a reader. This is the way the imagemosaic-jdbc module should work, but I have no time left at the moment. At the end of the day, merging the jdbc module into your module(s) would be nice. Are there any intentions ? Cheers Christian 2013/7/10 Daniele Romagnoli daniele.romagn...@geo-solutions.it Hi Christian, I'm playing with the ImageMosaicJDBC using PGRaster. I have noticed that the JDBCAccessPGRaster class does some initialization steps where it looks for overviews (ImageLevelInfo) extents and resolutions. Then it setup values for preparedStatement to do updates of resolutoins and extent within the MOSAIC table (which contains the name of the coverage, the name of the table containing a specific level, extent and resolution). However, I see that line 116 contains a con.commit(); being commented-out. Therefore, no fields are updated into the DB since no commit occurs.(moreover, line 109 set autocommit fo talse). Is there any reason for this or it's a simple oversight (Maybe you have commented out during tests and then forgot to restore it)? Please, let me know. Cheers, Daniele == Our support, Your Success! Visit http://opensdi.geo-solutions.it for more information. == Ing. Daniele Romagnoli Senior Software Engineer GeoSolutions S.A.S. Via Poggio alle Viti 1187 55054 Massarosa (LU) Italy phone: +39 0584 962313 fax: +39 0584 1660272 http://www.geo-solutions.it http://twitter.com/geosolutions_it --- -- See everything from the browser to the database with AppDynamics Get end-to-end visibility with application monitoring from AppDynamics Isolate bottlenecks and diagnose root cause in seconds. Start your free trial of AppDynamics Pro today! http://pubads.g.doubleclick.net/gampad/clk?id=48808831iu=/4140/ostg.clktrk ___ GeoTools-Devel mailing list GeoTools-Devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geotools-devel -- DI Christian Mueller MSc (GIS), MSc (IT-Security) OSS Open Source Solutions GmbH -- See everything from the browser to the database with AppDynamics Get end-to-end visibility with application monitoring from AppDynamics Isolate bottlenecks and diagnose root cause in seconds. Start your free trial of AppDynamics Pro today! http://pubads.g.doubleclick.net/gampad/clk?id=48808831iu=/4140/ostg.clktrk___ GeoTools-Devel mailing list GeoTools-Devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geotools-devel
