Skip to end of metadata
Go to start of metadata



Overview 

This document provides a guide for integrating GeoServer with Altibase.

This document is based on the following versions:

  • Altibase 7.1.0 or higher

  • GeoServer 2.16.2 or higher

 

 

GeoServer 

GeoServer is an open-source GIS software server developed in Java that allows sharing and editing of geospatial data.

As a community-based project, GeoServer is developed, tested, and supported by diverse groups of individuals and organizations worldwide.

GeoServer serves as a reference implementation not only for Web Map Service (WMS) but also for Open Geospatial Consortium (OGC) standards such as Web Feature Service (WFS), Web Coverage Service (WCS), and Web Processing Service (WPS).

GeoServer forms a core component of the Geospatial Web.


GeoServer Installation and Setup 

This document is based on installing GeoServer on Windows 10.

 

1. To install GeoServer, JRE (Java Runtime Environment) must be installed:

  • JRE version 8 or higher is recommended.

  • You can download and install it from OpenJDK or Oracle JRE.

  • After installation, verify the JAVA environment settings.

2. Installing GeoServer:

  • Download the stable version from the GeoServer download site.
    This document uses version 2.16.2 as the reference.

  • Extract the downloaded Zip file to the installation path and configure the environment.
    Here, GeoServer is installed at C:\Program Files\GeoServer.
    Set the environment variables as follows:

    • GEOSERVER_HOME = C:\Program Files\GeoServer

    • GEOSERVER_DATA_DIR = C:\Program Files\GeoServer\data_dir


3. To integrate with Altibase, additional libraries need to be installed.
     Copy the required libraries to C:\Program Files\GeoServer\webapps\geoserver\WEB-INF\lib:

  • Altibase-specific spatial DBMS driver:
    gt-jdbc-altibase-21-SNAPSHOT.jar

  • JTS Topology Suite:
    jts-1.14.jar

  • Altibase JDBC driver:
    The Altibase.jar file can be found in the lib directory of your Altibase installation folder.

4. Altibase Spatial module installation and coordinate system setup:

  • The spatial module is not installed by default during Altibase installation. Use the following commands to install the spatial module.

 

 

 

  • Insert the coordinate system to be used when creating layers into the spatial_ref_sys table.

     * More coordinate system information can be found here.

 

5. Starting GeoServer

  • Run the startup.bat file located in the GEOSERVER_HOME directory to start GeoServer.

 

Integrating GeoServer with Altibase

1. Accessing GeoServer



 

2. Adding a Store

  • Add Altibase as a data store.






- The required input fields are as follows:

ItemDescription
WorkspaceTo publish or register a layer, you must add a workspace. Here, the default workspace "cite" was selected.
Data Store NameEnter the name of the data store.
dbtypeSet to "altibase".
hostEnter the address of the Altibase server.
portEnter the service port configured in Altibase. The default value is 20300.
databaseEnter the database name configured in Altibase. The default value is "mydb".
schemaAltibase does not manage schemas.
userEnter the Altibase DB account name.
passwordEnter the Altibase DB account password.
preparedStatementsOptional. Not checked for Altibase.



 

3. Registering a Layer

  • Register a layer in the data store.

  • The registered layer is managed as a Table in Altibase.

  • Select a layer from the left tree and click “Add New Layer.”




  • Select the data store where the layer will be created. Here, the data store called ALTIBASE_SPATIAL in the workspace cite was selected.



  • Click "Create New Feature Type" to create the layer.



  • Enter the type name. This name will be used as the table name.

  • Click "Add New Attribute Field" to add attribute fields. These attribute fields are defined as columns.



  • Enter the name. This will be the column name.

  • Enter the type. This will be the data type of the column.

  • If the data type requires a length, specify the size.

  • For geometry types, specify the coordinate system and click the save button.



  • Review the attribute information and enter the layer’s minimum bounding area.
    Clicking "Calculate from Data," "Calculate from SRS Extent," or "Calculate from Source Extent" will automatically fill it in.

  • Click "Save" to save.


Spatial Data Import

You can import a layer using a shapefile.

1. Install the extension plug-in
    Download the importer plug-in, unzip it, and copy it to
    C:\Program Files\GeoServer\webapps\geoserver\WEB-INF\lib
    You need to restart GeoServer for it to take effect.

2. When you access GeoServer, the "Import Data" option will be added.



3. Select the spatial file from the data source to import.
    Currently, Altibase only supports importing spatial files.
    Click the browse button to select the spatial file.


4. Select the directory where the spatial file is located.



  • Select the workspace and data store, then click the Next button.



  • Select the spatial data file to import, then click the Import button to complete the import.



Check the registered layer.

The registered layer can be viewed in the layer preview.

  • 레이어 미리보기를 클릭하여 확인할 레이어에서 OpenLayers를 클릭한다. 




  • In Altibase, it can be verified as follows.

    Icon
    • At Atlibase, table names and column names are case-sensitive.
      When querying table and column names that contain lowercase letters, use double quotes ("").

Reference materials

Altibase Manual

Open Geospatial

 

 



  • No labels