Hi all,
I started implementing the createSchema() method for OracleDataStore.
Basically it is simply a matter of producing the correct SQL statements
strings
and applying them to the Oracle connection.
I'd like to keep the two things well separated, so that one should be able
to simply
collect the SQL strings, mail them to the Oracle administrator and let him
apply them to the DB.
This is something I'd like to see all over the JDBC based DataStores, have
them work even disconnected,
simply producing the relevant SQL strings.
I looked into the the code and saw two different SQL encoder, one is
org.geotools.data.oracle.SqlStatementEncoder
and it seems not used anywhere, so is it very old or very new???
The other is
org.geotools.filter.SQLEncoderOracle
and it seems to be the one used for filters and the like.
By the way, why is it in the org.geotools.filter package instead of
something like org.geotools.filter.oracle???
Now I want to add somewhere a makeCreateSQL() method or something similar,
that simply
creates the SQL strings, and then have the createSchema() method call it.
Where should I put this SQL creating method??? In one of the mentioned
classes,
in the OracleDataStore itself or I better create a new class??? And where
should I put it???
I'd prefer it to be outside of the OracleDataStore itself to start going in
the direction
of separating SQL creation from it's application to the JDBC connection.
After I'll have created and committed the relevant code, Marc may take care
of it
in terms of Oracle expertness, since he should be the one, or not???
What do you think???
Bye
Paolo Rizzi
AVVERTENZE AI SENSI DEL D. LGS. 196/2003
Le informazioni contenute in questo messaggio di posta elettronica e/o nel/i
file/s allegato/i, sono da considerarsi strettamente riservate. Il loro
utilizzo è consentito esclusivamente al destinatario del messaggio, per le
finalità indicate nel messaggio stesso. Qualora riceveste questo messaggio
senza esserne il destinatario, Vi preghiamo cortesemente di darcene notizia
via e-mail e di procedere alla distruzione del messaggio stesso,
cancellandolo dal Vostro sistema; costituisce comportamento contrario ai
principi dettati dal D. Lgs. 196/2003 il trattenere il messaggio stesso,
divulgarlo anche in parte, distribuirlo ad altri soggetti, copiarlo, od
utilizzarlo per finalità diverse.
-------------------------------------------------------
This SF.Net email is sponsored by:
Power Architecture Resource Center: Free content, downloads, discussions,
and more. http://solutions.newsforge.com/ibmarch.tmpl
_______________________________________________
Geotools-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geotools-devel
