Hi Niels,
So I was trying out the Java class you shared. Here is what I did;
-> copied theJDBCexport into geoserver/WEB-INF/classes/
-> restarted the Tomcat
-> Tried to invoke the class on the browser with the following URLs;
http://host:port/geoserver/jdbcexport resulted into 404 Not Resource not
found
http://host:port/geoserver/rest/jdbcexport resulted into 403 Error
(Forbidden) Note that I'm logged into Geoserver as Admin
Is this the correct procedure I should use with this class?
<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail>
Virus-free.
www.avast.com
<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail>
<#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
Kind regards,
Steve Omondi
On Wed, Nov 15, 2017 at 5:02 PM, Niels Charlier <ni...@scitus.be> wrote:
> Steve,
>
> Sorry for the confusion. This was not in response to you, but Andrea about
> dropping the module from geoserver altogether. I understand your decision
> because I have also found that jdbcconfig is a problematic bottle neck
> (but as I mentioned, mostly because of the poor cache support and the
> unnecessarily repetitive queries).
>
> In the attachment you can find the code for exporting jdbc to hard drive.
> The file needs to be temporarily added to the class path and scanned by the
> spring appcontext, then when you are logged in as an admin you can call
> /jdbcexport from the browser to force the caching of the catalog. I hope
> you can use this somehow.
>
> Kind Regards
> Niels
>
>
> On 15-11-17 12:51, Steve Omondi wrote:
>
> Oh really, drop it? I thought jdbcconfig was the recommended way for
> clustering and is particularly useful when you are working with huge
> catalogs. I assumed it was actually being used in production by people.
>
> Our intention is not to drop it entirely. But to run more or less a
> catalog that is based on XML for some specific workspaces that we really
> need to be performant urgently.
>
>
> While we have found jdbcconfig to be an excellent solution for clustering,
> it
> also
>
> has made *3 Load balanced Geoserver 2.11.2 to be 6 times slower than 1
> Geoserver 2.9* all other configurations kept constant.
> And this is an issue that we can't ignore in PROD for our case.
>
> We intent to move a few of the workspaces and layers especially complex
> LayerGoups fron the JDBC catalog to achieve better performance over
> convenience of the DB Catalog.
>
> *Otherwise, JDBCConfig is an excellent module in use*.
>
>
>
>
> <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail>
> Virus-free.
> www.avast.com
> <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail>
>
> Kind regards,
> Steve Omondi
>
> On Wed, Nov 15, 2017 at 1:30 PM, Niels Charlier <ni...@scitus.be> wrote:
>
>> Oh really, drop it? I thought jdbcconfig was the recommended way for
>> clustering and is particularly useful when you are working with huge
>> catalogs. I assumed it was actually being used in production by people.
>>
>> The main problem seems to be the performance issues though, as this email
>> also proves, as well as both of the two PR's that are open who are related
>> to the same thing. But I believe this is rather solvable and would make a
>> huge difference.
>>
>> I can review these PRs no problem, since they are actually related to the
>> work I am doing for this module.
>>
>> Perhaps these improvements there can blow some new life into it.
>>
>> Regards
>>
>> Niels
>>
>> On 14-11-17 20:10, Andrea Aime wrote:
>>
>> Hi Niels,
>> today during the PSC meeting the topic came out of whether we should just
>> drop
>> JDBCConfig, since:
>>
>> - mails related to it are not really getting answered
>> - pull requests related to it are sitting there not getting reviewed
>>
>> We still have to see if there is some interested, but we need someone to
>> champion the module
>> just enough to make it worth keeping around (I'm not talking about
>> immediate answers, it's
>> a community/unsupported module, but at least some presence).
>> I'm also going to ping the people making pull requests.
>>
>> Cheers
>> Andrea
>>
>>
>> On Tue, Nov 14, 2017 at 5:24 PM, Niels Charlier <ni...@scitus.be> wrote:
>>
>>> Hello Steve,
>>>
>>> First I'd like to say I have been doing some work on considerable
>>> performance improvements for jdbcconfig. It happens to be the case that
>>> jdbcconfig doesn't take good use of its cache and repeatedly sends the same
>>> queries over and over again. It looks promising but I still need to do some
>>> improvements and write some tests and I had other work coming on top of it.
>>> But this is definitely coming.
>>>
>>> Also, I wrote some code in geoserver for myself to conveniently export
>>> the jdbc catalog back to the file system. I found a way to do this easily
>>> by firing a bunch of catalog change events to the file system catalog.
>>> However, I am not sure to make it easily available to end users at this
>>> point, I assume that just giving you the code won't be very helpful for
>>> you. Perhaps we can work something out if you are interested.
>>>
>>> Regards
>>>
>>> Niels
>>>
>>>
>>>
>>> On 09-11-17 11:02, Steve Omondi wrote:
>>>
>>> Hi guys,
>>>
>>> I have *JDBCConfig* enabled and connected to a Postgres DB. I have over
>>> 500 layers spread across different workspaces and layergroups.
>>>
>>> After running performance tests for GetMap requests against this
>>> configuration versus XML Catalog based geoserver I really need to revert my
>>> catalog back to XML in GEOSERVER DAT DIR and probably share it using NFS.
>>>
>>> *Is their a method to export the Database Catalog (based on JDBCConfig)
>>> back to XML Catalog?*
>>>
>>> Kind regards,
>>> Steve Omondi
>>>
>>>
>>> <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail>
>>> Virus-free.
>>> www.avast.com
>>> <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail>
>>>
>>>
>>> ------------------------------------------------------------------------------
>>> Check out the vibrant tech community on one of the world's most
>>> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
>>>
>>> _______________________________________________
>>> Geoserver-users mailing list
>>>
>>> Please make sure you read the following two resources before posting to
>>> this list:
>>> - Earning your support instead of buying it, but Ian Turton:
>>> http://www.ianturton.com/talks/foss4g.html#/
>>> - The GeoServer user list posting guidelines:
>>> http://geoserver.org/comm/userlist-guidelines.html
>>> Geoserver-users@lists.sourceforge.nethttps://lists.sourceforge.net/lists/listinfo/geoserver-users
>>>
>>> ------------------------------------------------------------------------------
>>> Check out the vibrant tech community on one of the world's most engaging
>>> tech sites, Slashdot.org! http://sdm.link/slashdot
>>> _______________________________________________ Geoserver-users mailing
>>> list Please make sure you read the following two resources before posting
>>> to this list: - Earning your support instead of buying it, but Ian Turton:
>>> http://www.ianturton.com/talks/foss4g.html#/ - The GeoServer user list
>>> posting guidelines: http://geoserver.org/comm/userlist-guidelines.html
>>> Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/
>>> lists/listinfo/geoserver-users
>>
>> --
>>
>> Regards,
>>
>> Andrea Aime
>>
>> == GeoServer Professional Services from the experts! Visit
>> http://goo.gl/it488V for more information. == Ing. Andrea Aime
>> <https://maps.google.com/?q=Via+di+Montramito+3/A+55054+%C2%A0Massarosa&entry=gmail&source=g>
>> @geowolf Technical Lead GeoSolutions S.A.S. Via di Montramito 3/A
>> <https://maps.google.com/?q=Via+di+Montramito+3/A+55054+%C2%A0Massarosa&entry=gmail&source=g>
>> 55054
>> Massarosa
>> <https://maps.google.com/?q=Via+di+Montramito+3/A+55054+%C2%A0Massarosa&entry=gmail&source=g>
>> (LU) phone: +39 0584 962313 fax: +39 0584 1660272 mob: +39 339 8844549
>> 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-users mailing list
Please make sure you read the following two resources before posting to this
list:
- Earning your support instead of buying it, but Ian Turton:
http://www.ianturton.com/talks/foss4g.html#/
- The GeoServer user list posting guidelines:
http://geoserver.org/comm/userlist-guidelines.html
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
