Trang chủ Khám phá Trợ giúp
Đăng ký Đăng nhập
siwei
/
web-server
1
0
Fork 0
Các tập tin Các vấn đề 0 Yêu cầu kéo về 0 Wiki
Branch: master
Branches Tags
web-server
/
doc
/
en
/
user
/
source
/
data
/
database
/
db2.rst

db2.rst 2.5 KB
Permalink Lịch sử Raw

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061 
  1. .. _data_Db2:
    2. 

  2. 

  3. Db2
    4. 

  4. ===
    5. 

  5. 

  6. .. note:: GeoServer does not come built-in with support for Db2; it must be installed through an extension. Proceed to :ref:`Db2_install` for installation details.
    7. 

  7. 

  8. The Db2 spatial support implements the OGC specification "Simple Features for SQL using types and functions" and the ISO "SQL/MM Part 3 Spatial" standard. When installing Db2 on Linux, Unix and Windows platforms, the "custom" option must be selected and the server spatial support included.
    9. 

  9. 

  10. A free of charge copy of Db2 can be downloaded from https://www.ibm.com/analytics/db2/trials.
    11. 

  11. 

  12. 

  13. .. _Db2_install:
    14. 

  14. 

  15. Installing the Db2 extension
    16. 

  16. ----------------------------
    17. 

  17. 

  18. .. warning:: Due to licensing requirements, not all files are included with the extension.  To install Db2 support, it is necessary to download additional files.  **Just installing the Db2 extension will have no effect.**
    19. 

  19. 

  20. GeoServer files
    21. 

  21. ```````````````
    22. 

  22. 

  23. #. From the :website:`download` page locate the release of GeoServer you are running and download the Db2 extension: :download_extension:`db2`
    24. 

  24. 

  25.    .. warning:: Ensure to match plugin (example |release| above) version to the version of the GeoServer instance.
    26. 

  26. 

  27. #. Extract the contents of the archive into the :file:`WEB-INF/lib` directory of the GeoServer installation.
    28. 

  28. 

  29. Required external files
    30. 

  30. ```````````````````````
    31. 

  31. 

  32. The Db2 JDBC driver is not packaged with the GeoServer extension:  :file:`db2jcc4.jar`.  This file should be available in the :file:`java` subdirectory of your Db2 installation directory.  Copy this file to the ``WEB-INF/lib`` directory of the GeoServer installation.
    33. 

  33. 

  34. 

  35. After all GeoServer files and external files have been downloaded and copied, restart GeoServer.
    36. 

  36. 

  37. Adding a Db2 data store
    38. 

  38. -----------------------
    39. 

  39. 

  40. When properly installed, :guilabel:`Db2` will be an option in the :guilabel:`Vector Data Sources` list when creating a new data store.
    41. 

  41. 

  42. .. figure:: images/db2create.png
    43. 

  43.    :align: center
    44. 

  44. 

  45.    *Db2 in the list of raster data stores*
    46. 

  46. 

  47. Configuring a Db2 data store
    48. 

  48. ----------------------------
    49. 

  49. 

  50. .. figure:: images/db2configure.png
    51. 

  51.    :align: center
    52. 

  52. 

  53.    *Configuring a Db2 data store*
    54. 

  54. 

  55. Configuring a Db2 data store with JNDI
    56. 

  56. --------------------------------------
    57. 

  57. 

  58. Notes on usage
    59. 

  59. --------------
    60. 

  60. 

  61. Db2 schema, table, and column names are all case-sensitive when working with GeoTools/GeoServer. When working with Db2 scripts and the Db2 command window, the default is to treat these names as upper-case unless enclosed in double-quote characters but this is not the case in GeoServer.
    62.