[Geoserver-devel] Configuration through Database

GeoServer GeoServer Developer
1

Hi,

The current implementation stores the configuration parameters such as Datastores,layers,styles etc in XML files.Can the configuration
be stored in Database tables rather than XML ?

Any ideas ?

–
Thanks and Warm Regards
Debasish Sahu

2

Hi Debasish,

it can of course be done, but I do not think anyone is currently planning on doing it. Putting the configuration into a database creates a lot of overhead, especially upgrade scripts, and where to you store the database connection configuration.

I would be interested to know why you need it though?

-Arne

Debasish Sahu wrote:

Hi,

The current implementation stores the configuration parameters such as Datastores,layers,styles etc in XML files.Can the configuration
be stored in Database tables rather than XML ?

Any ideas ?

--
Thanks and Warm Regards
Debasish Sahu
------------------------------------------------------------------------

------------------------------------------------------------------------------
This SF.net email is sponsored by:
High Quality Requirements in a Collaborative Environment.
Download a free trial of Rational Requirements Composer Now!
http://p.sf.net/sfu/www-ibm-com
------------------------------------------------------------------------

_______________________________________________
Geoserver-devel mailing list
Geoserver-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-devel
  
--
Arne Kepp
OpenGeo - http://opengeo.org
Expert service straight from the developers

3

Hi,

I was planning to create a database based configuration module for GeoServer.
Can you point me to the java classes that’s needs to be implemented/extended to
implement the same ?

Thanks
Debasish

On Mon, Apr 13, 2009 at 12:29 PM, Arne Kepp <ak@anonymised.com> wrote:

Hi Debasish,

it can of course be done, but I do not think anyone is currently planning on doing it. Putting the configuration into a database creates a lot of overhead, especially upgrade scripts, and where to you store the database connection configuration.

I would be interested to know why you need it though?

-Arne

Debasish Sahu wrote:

Hi,

The current implementation stores the configuration parameters such as Datastores,layers,styles etc in XML files.Can the configuration
be stored in Database tables rather than XML ?

Any ideas ?

–
Thanks and Warm Regards
Debasish Sahu

This SF.net email is sponsored by:
High Quality Requirements in a Collaborative Environment.
Download a free trial of Rational Requirements Composer Now!
http://p.sf.net/sfu/www-ibm-com

Geoserver-devel mailing list
Geoserver-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-devel

–
Arne Kepp
OpenGeo - http://opengeo.org
Expert service straight from the developers

–
Thanks and Warm Regards
Debasish Sahu

4

Hi Debasish,

Actually this is something that we have been trying to move toward for a long time, but no easy task. The way our current persistence works is that everything is stored in memory. Are you simply wanting to replace the XML storage format for a database, continuing to load all data into memory? or are you wanting to have configuration driven from the database?

The latter has been experimented with on a branch. You can check out this GeoServer spike:

http://svn.codehaus.org/geoserver/spike/configuration/

However, if you simply want to replace the xml files with a database the class you should check out these two classes:

http://svn.codehaus.org/geoserver/trunk/src/main/src/main/java/org/geoserver/config/GeoServerPersister.java
http://svn.codehaus.org/geoserver/trunk/src/main/src/main/java/org/geoserver/config/GeoServerLoader.java

I would suggest that you work against trunk where the configuration persistence is a bit cleaner than it is on 1.7.x.

-Justin

Debasish Sahu wrote:

Hi,

I was planning to create a database based configuration module for GeoServer.
Can you point me to the java classes that's needs to be implemented/extended to
implement the same ?

Thanks
Debasish

On Mon, Apr 13, 2009 at 12:29 PM, Arne Kepp <ak@anonymised.com <mailto:ak@anonymised.com>> wrote:

    Hi Debasish,

    it can of course be done, but I do not think anyone is currently
    planning on doing it. Putting the configuration into a database
    creates a lot of overhead, especially upgrade scripts, and where to
    you store the database connection configuration.

    I would be interested to know why you need it though?

    -Arne

    Debasish Sahu wrote:

        Hi,

        The current implementation stores the configuration parameters
        such as Datastores,layers,styles etc in XML files.Can the
        configuration
        be stored in Database tables rather than XML ?

        Any ideas ?

        -- Thanks and Warm Regards
        Debasish Sahu
        ------------------------------------------------------------------------

        ------------------------------------------------------------------------------
        This SF.net email is sponsored by:
        High Quality Requirements in a Collaborative Environment.
        Download a free trial of Rational Requirements Composer Now!
        http://p.sf.net/sfu/www-ibm-com
        ------------------------------------------------------------------------

        _______________________________________________
        Geoserver-devel mailing list
        Geoserver-devel@lists.sourceforge.net
        <mailto:Geoserver-devel@lists.sourceforge.net>
        https://lists.sourceforge.net/lists/listinfo/geoserver-devel
         
    -- Arne Kepp
    OpenGeo - http://opengeo.org
    Expert service straight from the developers

--
Thanks and Warm Regards
Debasish Sahu

------------------------------------------------------------------------

------------------------------------------------------------------------------
This SF.net email is sponsored by:
High Quality Requirements in a Collaborative Environment.
Download a free trial of Rational Requirements Composer Now!
http://p.sf.net/sfu/www-ibm-com

------------------------------------------------------------------------

_______________________________________________
Geoserver-devel mailing list
Geoserver-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-devel

--
Justin Deoliveira
OpenGeo - http://opengeo.org
Enterprise support for open source geospatial.

5

Debasish Sahu ha scritto:

Hi,

I was planning to create a database based configuration module for GeoServer.
Can you point me to the java classes that's needs to be implemented/extended to
implement the same ?

As far as I know Simone and Alessio are playing with a Hibernate
based catalog backend in one of these two branches:

http://svn.codehaus.org/geoserver/branches/1.7.x_WCS10EMF_ND/geoserver/
http://svn.codehaus.org/geoserver/branches/1.7.x_WCS10_EMF/

I don't know about their status, or when they plan to start pushing
for a merge back, but there you'll find at least part of the
work already done. I've cc'ed them, but not sure they will answer
before tomorrow (today is holiday in Italy).

Cheers
Andrea