Hi Niels,
This thread as a lot of interesting information (thanks for the extra info
Ami). That said, I think that to make
a decision we need a summarized description of what are the options \
alternatives and what are the
consequences of those choices (who will this affect users and current
installations).
Unless I'm missing something, any upgrade on the standalone GeoFence version
will also affect the integrated one no ?
Regards,
Nuno Oliveira
On 07/18/2017 04:03 PM, Niels Charlier wrote:
We agree now about the refactoring of the DAO, but do we definitely agree about
which version to upgrade to?
I need to make sure everyone is on the same page before I start work.
Ami suggests upgrading the geofence modules to JDBC 4.2, but leave the
integrated geofence to work with the older geofence modules until the hibernate
PR for jdbc 4.2 has been merged.
Do the maintainers of the geofence modules agree with this plan?
Alternatively, I suggest we could upgrade to jdbc4 for now, since that seems to
work with most modules in geotools/geoserver anyway.
Kind Regards
Niels
On 03-07-17 12:01, Niels Charlier wrote:
Ami,
In any case, the biggest load of the work will be rewriting the DAO's which
needs to be done either way.
I am wondering if it wouldn't be an option to upgrade to hibernate 5.1 /jdbc4
for now, and make a further upgrade later (which would likely require little
work anyway).
Just a suggestion.
Kind Regards
Niels
On 02-07-17 19:01, Amiram Rahav wrote:
Taking another look at Hibernate, things might be a bit more complicated.
There is a PR to add some JDBC 4.2 type names -
https://github.com/hibernate/hibernate-orm/pull/1940
<https://github.com/hibernate/hibernate-orm/pull/1940>.
We will likely see some version conflict with other Geotools dependencies:
For Oracle the suggestion is to use ojdbc6/7 (JDBC 4.0/4.1), but the hibernate
PR from above will pull in ojdbc8.
For MSSQL the suggestion is to use sqljdbc41, however I've been using JDBC 4.2
at several clients.
mysql looks to be 4.0, however it might have limited implementation of 4.1.
H2 looks like JDBC3, it might implement JDBC 4.0, however based on the
version/age that is probably minimal.
I still think the Geofence work should be done against JDBC 4.2 and not 4.0,
however the Geoserver integrated GeoFence version will likely have to wait
until that Hibernate PR is merged.
On Sun, Jul 2, 2017 at 9:20 AM, Amiram Rahav <ara...@boundlessgeo.com
<mailto:ara...@boundlessgeo.com>> wrote:
I should have said Postgres :-)
On Sun, Jul 2, 2017 at 9:15 AM Andrea Aime
<andrea.a...@geo-solutions.it
<mailto:andrea.a...@geo-solutions.it>> wrote:
On Sun, Jul 2, 2017 at 3:04 PM, Amiram Rahav
<ara...@boundlessgeo.com <mailto:ara...@boundlessgeo.com>> wrote:
Hi Niels,
Geotools is already using JDBC 4.2
Is GeoTools using JDBC 4.2 for all databases already, did you
check?
Using hibernate is partly about database independence, I know
that the postgis store
was recently updated, what about the others? (oracle,
sqlserver, mysql, H2, ...)
Cheer
Andrea
--
Regards,
Andrea Aime
==GeoServer Professional Services from the experts! Visit
http://goo.gl/it488V for more information.==Ing. Andrea Aime
@geowolfTechnical LeadGeoSolutions S.A.S.Via di Montramito
3/A55054 Massarosa (LU)phone: +39 0584 962313
<tel:+39%200584%20962313>fax: +39 0584 1660272
<tel:+39%200584%20166%200272>mob: +39 339 8844549
<tel:+39%20339%20884%204549>http://www.geo-solutions.ithttp://twitter.com/geosolutions_it
<http://twitter.com/geosolutions_it>
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 riceviate 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. Conservare il messaggio stesso, divulgarlo anche in
parte, distribuirlo ad altri soggetti, copiarlo, od
utilizzarlo per finalità diverse, costituisce comportamento
contrario ai principi dettati dal D.Lgs. 196/2003.
The information in this message and/or attachments, is
intended solely for the attention and use of the named
addressee(s) and may be confidential or proprietary in nature
or covered by the provisions of privacy act (Legislative
Decree June, 30 2003, no.196 - Italy's New Data Protection
Code).Any use not in accord with its purpose, any disclosure,
reproduction, copying, distribution, or either dissemination,
either whole or partial, is strictly forbidden except previous
formal approval of the named addressee(s). If you are not the
intended recipient, please contact immediately the sender by
telephone, fax or e-mail and delete the information in this
message that has been received in error. The sender does not
give any warranty or accept liability as the content, accuracy
or completeness of sent messages and accepts no responsibility
for changes made after they were sent or for other risks
which arise as a result of e-mail transmission, viruses, etc.
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Geoserver-devel mailing list
Geoserver-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-devel
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org!http://sdm.link/slashdot
_______________________________________________
Geoserver-devel mailing list
Geoserver-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-devel
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Geoserver-devel mailing list
Geoserver-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-devel
--
Regards,
Nuno Oliveira
==
GeoServer Professional Services from the experts! Visit http://goo.gl/it488V
for more information.
==
Nuno Miguel Carvalho Oliveira
@nmcoliveira
Software Engineer
GeoSolutions S.A.S.
Via di Montramito 3/A
55054 Massarosa (LU)
Italy
phone: +39 0584 962313
fax: +39 0584 1660272
http://www.geo-solutions.it
http://twitter.com/geosolutions_it
-------------------------------------------------------
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 riceviate 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. Conservare il messaggio stesso, divulgarlo anche in parte,
distribuirlo ad altri soggetti, copiarlo, od utilizzarlo per finalità diverse,
costituisce comportamento contrario ai principi dettati dal D.Lgs. 196/2003.
The information in this message and/or attachments, is intended solely for the attention and use of the named addressee(s) and may be confidential or proprietary in nature or covered by the provisions of privacy act (Legislative Decree June, 30 2003, no.196 - Italy's New Data Protection Code).Any use not in accord with its purpose, any disclosure, reproduction, copying, distribution, or either dissemination, either whole or partial, is strictly forbidden except previous formal approval of the named addressee(s). If you are not the intended recipient, please contact immediately the sender by telephone, fax or e-mail and delete the information in this message that has been received in error. The sender does not give any warranty or accept liability as the content, accuracy or completeness of sent messages and accepts no responsibility for changes made after they were sent or for other risks which arise as a result of e-mail transmission, viruses, etc.
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Geoserver-devel mailing list
Geoserver-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-devel
