Andrea Aime wrote: > Christian Müller ha scritto: >> 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. > > That won't solve the problem with Oracle Spatial anyways. Whilst > Oracle in general can deal with mixed case names if you quote them, > the spatial extension enforces uppercase names no matter what. > There is no way around it. > > Cheers > Andrea > Oracle in general enforces uppercased table-names, from my past as an Oracle DBA I would advice against using quoted table names - it's just ugly :) I think the best solution would be to automatically uppercase the appropriotate values when the oracle spatial extension is specified in the mapping.xml (either when generating DDL, or importing the rasters).
Regard, Robert -- ------------------------------------------------------- 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 ------------------------------------------------------- ------------------------------------------------------------------------------ Register Now & Save for Velocity, the Web Performance & Operations Conference from O'Reilly Media. Velocity features a full day of expert-led, hands-on workshops and two days of sessions from industry leaders in dedicated Performance & Operations tracks. Use code vel09scf and Save an extra 15% before 5/3. http://p.sf.net/sfu/velocityconf _______________________________________________ Geotools-gt2-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users
