Re: [Geoserver-users] JDBCConfig export Catalog to XML Catalog in GEOSERVER DAT DIR

Thanks Andrea. You've been very patient :-) On 20 March 2018 at 17:50, Andrea Aime wrote: > On Tue, Mar 20, 2018 at 6:35 PM, Manuel Timita wrote: > >> That is something I never thought about. I'll keep it mind. It is >> actually something I could personally try and help with. >> >> Particularly

Re: [Geoserver-users] JDBCConfig export Catalog to XML Catalog in GEOSERVER DAT DIR

On Tue, Mar 20, 2018 at 6:35 PM, Manuel Timita wrote: > That is something I never thought about. I'll keep it mind. It is actually > something I could personally try and help with. > > Particularly with user support, I'm actually very happy to do what I can, > as I think I got to know GeoServer v

Re: [Geoserver-users] JDBCConfig export Catalog to XML Catalog in GEOSERVER DAT DIR

Hi Andrea, Thank you for taking the time for such detailed explanation. It made things a lot clearer. " I do want to discourage the notion that people can just ask and developers have nothing better to do than follow their requests. " Yeah, this is simply not the kind of people I ever thought of

Re: [Geoserver-users] JDBCConfig export Catalog to XML Catalog in GEOSERVER DAT DIR

On Tue, Mar 20, 2018 at 5:10 PM, timita wrote: > Apologies if this sounds like criticism - far from my intention - but > saying > that it's irrelevant whether people use it or not sounds discouraging. > I don't mean to discourage contribution, mind, but I do want to discourage the notion that pe

Re: [Geoserver-users] JDBCConfig export Catalog to XML Catalog in GEOSERVER DAT DIR

geowolf wrote > Whether people are using it or not is, in the end, more or less > irrelevant, > because this community > is not a public service, it's a body of work shared by some people, and > used by many others. Thank you, Andrea. I am acutely aware of that, just like, I think, many of GeoSer

Re: [Geoserver-users] JDBCConfig export Catalog to XML Catalog in GEOSERVER DAT DIR

On Tue, Mar 20, 2018 at 11:11 AM, timita wrote: > geowolf wrote > > Nobody at the PSC meeting yesterday was dealing with a production system > > using it (I have helped set up > > a couple in the past, making several code adjustment to give them a > > fighting chance of working, but have > > not

Re: [Geoserver-users] JDBCConfig export Catalog to XML Catalog in GEOSERVER DAT DIR

geowolf wrote > Nobody at the PSC meeting yesterday was dealing with a production system > using it (I have helped set up > a couple in the past, making several code adjustment to give them a > fighting chance of working, but have > not used it in a long while). Sorry for bumping this old-ish thre

Re: [Geoserver-users] JDBCConfig export Catalog to XML Catalog in GEOSERVER DAT DIR

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 no

Re: [Geoserver-users] JDBCConfig export Catalog to XML Catalog in GEOSERVER DAT DIR

No, applicationContext.xml Regards Niels On 24-11-17 11:20, Steve Omondi wrote: This is somewhere in WEB-IN/web.xml I presume? Kind regards, Steve Omondi On Fri, Nov 24, 2017 at 1:09 PM, Niels Charlier > wrote: Hi Steve, You need to add a | to the

Re: [Geoserver-users] JDBCConfig export Catalog to XML Catalog in GEOSERVER DAT DIR

This is somewhere in WEB-IN/web.xml I presume? Kind regards, Steve Omondi On Fri, Nov 24, 2017 at 1:09 PM, Niels Charlier wrote: > Hi Steve, > > You need to add a > > > > to the spring context for it to work. > > Regards > Niels > > > On 24-11-17 09:20, Steve Omondi wrote: > > So I temporarily

Re: [Geoserver-users] JDBCConfig export Catalog to XML Catalog in GEOSERVER DAT DIR

Hi Steve, You need to add a | to the spring context for it to work. Regards Niels | On 24-11-17 09:20, Steve Omondi wrote: So I temporarily removed security for the /rest/* chain in Authentication and using http://host:port/geoserver/rest/jdbcexport just returns the defaultgeoserver/rest r

Re: [Geoserver-users] JDBCConfig export Catalog to XML Catalog in GEOSERVER DAT DIR

So I temporarily removed security for the /rest/* chain in Authentication and using http://host:port/geoserver/rest/jdbcexport just returns the default geoserver/rest result. Any pointers are welcome. Kind regards, Steve Omondi On Fri, Nov 24, 2017 at 10:51 AM, Steve Omondi wrote: > Hi Niels,

Re: [Geoserver-users] JDBCConfig export Catalog to XML Catalog in GEOSERVER DAT DIR

no you can remove those parts Regards Niels On 21-11-17 08:44, Steve Omondi wrote: Hi Niels, With this code, there is the section //export jdbc config to jdbc store and package org.geoserver.jdbcstore.rest; Do I have to have JDBCStore enabled as well? Currently I only have JDBCConfig ena

Re: [Geoserver-users] JDBCConfig export Catalog to XML Catalog in GEOSERVER DAT DIR

Hi Niels, With this code, there is the section //export jdbc config to jdbc store and package org.geoserver.jdbcstore.rest; Do I have to have JDBCStore enabled as well? Currently I only have JDBCConfig enaabled.

Re: [Geoserver-users] JDBCConfig export Catalog to XML Catalog in GEOSERVER DAT DIR

Great Niels, We're gonna get right on this and we'll get back to you on the progress and if we find something interesting. I appreciate it. Regards, Steve Ochieng On Nov 15, 2017 17:02, "Niels Charlier" wrote: > Steve, > > Sorry for the confusion. This was not in response to you, but Andrea a

Re: [Geoserver-users] JDBCConfig export Catalog to XML Catalog in GEOSERVER DAT DIR

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

Re: [Geoserver-users] JDBCConfig export Catalog to XML Catalog in GEOSERVER DAT DIR

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 ba

Re: [Geoserver-users] JDBCConfig export Catalog to XML Catalog in GEOSERVER DAT DIR

On 15-11-17 11:57, Andrea Aime wrote: 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. Nope, you're

Re: [Geoserver-users] JDBCConfig export Catalog to XML Catalog in GEOSERVER DAT DIR

On Wed, Nov 15, 2017 at 11:30 AM, Niels Charlier 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. > Nobody at the PSC meeti

Re: [Geoserver-users] JDBCConfig export Catalog to XML Catalog in GEOSERVER DAT DIR

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 prove

Re: [Geoserver-users] JDBCConfig export Catalog to XML Catalog in GEOSERVER DAT DIR

Hi Niels, 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,

Re: [Geoserver-users] JDBCConfig export Catalog to XML Catalog in GEOSERVER DAT DIR

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 nee

Re: [Geoserver-users] JDBCConfig export Catalog to XML Catalog in GEOSERVER DAT DIR

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 t

Re: [Geoserver-users] JDBCConfig export Catalog to XML Catalog in GEOSERVER DAT DIR

Hi Steve, not to my knowledge, I believe JDBCConfig is a one way ticket. That said, I guess you can build a script that pulls the XML files from the database and writes them out to disk in the correct location. Cheers Andrea On Thu, Nov 9, 2017 at 11:02 AM, Steve Omondi wrote: > Hi guys, > > I

[Geoserver-users] JDBCConfig export Catalog to XML Catalog in GEOSERVER DAT DIR

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