Re: [Geotools-devel] EPSGFactory

[Harald W. <hw...@hs...>]

Hi Martin,

thanks for your fast answer!

> 
> We though about PostgreeSQL support some time ago, but didn't worked on 
> it yet... Since EPSG release their database in MS-Access format only, 
> the CoordinateSystemEPSGFactory was designed with this particular 
> database in mind, but it was clear that "[" and "]" would be a 
> problem... However, there is a hook for fixing the problem: all SQL 
> statement are executed throug a private "prepareStatement" method. My 
> idea was to add a protected method, something like:
> 
>     String adaptSQL(String sql)
> 
> (or maybe a better name if you have any idea). This method would be 
> invoked every time a SQL statement is about to be executed the first 
> time. In input, this method would receive the MS-Access SQL statement 
> with its "[" and "]" (by the way, if you know a way to access name like 
> "[Coordinate Reference System]" without putting them between "[" and 
> "]", it would be nice). 

I don't know whether there is a possibility in access without using "[" 
and "]". In postgres you just have to quote the names:

select * from "Coordinate System";

This does not work in access.

>A subclass could overrides this method and 
> returns a modified string replacing the spaces by "_" and removing the 
> "[" and "]". Would it help? Is there any idea about how to name this 
> method?

I think this solution would help. Method name is ok for me as I am not 
familiar with your naming conventions at the moment. It would be very 
nice if you could commit this change to cvs.

Thanks for your help.

Harald