The case sensitivity is a nasty problem. If you look at this section in the user documentation http://docs.codehaus.org/display/GEOTDOC/Image+Mosaicing+Pyramidal+JDBC+Plug in#ImageMosaicingPyramidalJDBCPlugin-Important%3A
you will find a link http://en.wikibooks.org/wiki/SQL_dialects_reference/Data_structure_definitio n/Delimited_identifiers Then you see my problem. I thought about creating the statements with delimiter to preserve case, but the disadvantage is that you have to use the delimiters also if you sit in front of your interactive sql tool. Most people are not used to that and the first question is "Where are my tables ?". Until know, I have no good idea how to resolve this issue. Anyway, good news, keep us informed. Robert van Drunen writes: > Hello Christian and Simone, > > Actually it all worked out-of-the-box. I used the description on this page: > > http://geoserver.org/display/GEOSDOC/Using+the+ImageMosaic+JDBC+Plugin > > to setup the JDBC connection to Oracle, create the metadata scripts and > load some sample geotiffs using the mosaicjdbc jar. > > The only difficulty I had was that Oracle uppercases it's tablenames > when you query them, so you need them uppercased in gdal commands as well :) > > Now it's upto my cliënt to agree with this approach instead of using > actual Georasters and see what the performance is when we load the > entire dataset this way. > > Thanks for the help, it's much appreciated! > > Robert. > > Christian Müller wrote: >> To answer the questions >> 1) Performance >> I am handling 3 maps with about 8 million tiles , biggest map 4 >> million tiles , biggest layer consists of 2 million tiles. >> The tiles are stored in png format. (Compression). Tile sizes are >> 256x256 and 512x512. >> The decoding (Decompression) of the tiles is done in a multithreaded >> manner. Multiple/Multicore CPUs will be used if present. >> The db lookup to find the right tiles is very fast if you have the >> proper indexes. Decoding starts when the first tile is fetched, >> fetching and decoding works like streaming using a queue from the >> java.concurrent package. >> Store your tiles as single banded images with a color table. Check >> with gdalinfo, if you have multiple bands use gdal_merge >> with the -pct option to produce a big picture. Afterwards apply >> gdal_retile. >> You can import the output of gdal_retile. >> Performance decreases when doing a request with a different CRS, >> because the whole picture has to be transformed. You will get see a >> WARNING in the log file. Try to avoid it. >> Environment: Geoserver running on Linux PPC using DB2 Spatial Extender >> on an AIX Box >> 2) >> If you have to use Oracle Georaster. I agree to Simone. The best would >> be to implement a special coverage store. >> 3) At the moment, the plugin is not able to handle rotated or skewed >> images, but if necessary, I would add this feature. >> >> christian >> >> > > -- > ------------------------------------------------------- > BEng. R.J.M. van Drunen > Anargistic > Owner - Software Engineer > Sint Luciaplein 27 > 5211 ZR 's-Hertogenbosch > > mob: +31 062369319 > > http://www.anargistic.nl > http://www.linkedin.com/in/robertvandrunen > ------------------------------------------------------- > > > > ------------------------------------------------------------------------------ > Stay on top of everything new and different, both inside and > around Java (TM) technology - register by April 22, and save > $200 on the JavaOne (SM) conference, June 2-5, 2009, San Francisco. > 300 plus technical and hands-on sessions. Register today. > Use priority code J9JMT32. http://p.sf.net/sfu/p > _______________________________________________ > Geotools-gt2-users mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users ------------------------------------------------------------------------------ Stay on top of everything new and different, both inside and around Java (TM) technology - register by April 22, and save $200 on the JavaOne (SM) conference, June 2-5, 2009, San Francisco. 300 plus technical and hands-on sessions. Register today. Use priority code J9JMT32. http://p.sf.net/sfu/p _______________________________________________ Geotools-gt2-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users
