{"id":16862,"date":"2022-01-13T16:48:39","date_gmt":"2022-01-13T15:48:39","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-drivers-for-hsqldb\/"},"modified":"2025-10-24T09:38:41","modified_gmt":"2025-10-24T07:38:41","slug":"installing-the-odbc-drivers-for-hsqldb","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-drivers-for-hsqldb\/","title":{"rendered":"Installing the ODBC drivers for HSQLDB"},"content":{"rendered":"<p>This article is part of a series that includes SQLite, Postgresql, Firebird, Oracle RDBMS, Microsoft SQL Server, MariaDB, MongoDB, and Excel. The goal is to set up a self-standing environment for testing an ODBC extension for gawk presented here <em>to be completed<\/em>. Refer to <a href=\"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-drivers-manager-with-sqlite-on-linux\">SQLite<\/a> for installing the required ODBC Driver Manager.<br \/>\nThe test system is a debian v11 (bullseye).<br \/>\nAs user debian, follow the documentation <a href=\"http:\/\/hsqldb.org\/doc\/2.0\/guide\/guide.html\">here<\/a> and <a href=\"http:\/\/hsqldb.org\/doc\/2.0\/guide\/odbc-chapt.html\">here<\/a> to get and install hsqldb for Linux. Here are the needed steps:<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1; highlight: [3]\">\n$ export workdir=~\/odbc4gawk\n$ mkdir $workdir\n$ cd $workdir\n$ wget https:\/\/sourceforge.net\/projects\/hsqldb\/files\/hsqldb\/hsqldb_2_6\/hsqldb-2.6.0.zip\/download\n$ mv download hsqldb-2.6.0.zip\n$ unzip hsqldb-2.6.0.zip\n<\/pre>\n<p>As root, install a system-wide JDK from the official packages repository:<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1; highlight: [1]\">\n# apt install openjdk-17-jdk\n# java -version\nopenjdk version \"17-ea\" 2021-09-14\nOpenJDK Runtime Environment (build 17-ea+19-Debian-1)\nOpenJDK 64-Bit Server VM (build 17-ea+19-Debian-1, mixed mode, sharing)\n<\/pre>\n<p>No special action is needed for the ODBC drivers because hsqldb starting in v2.0 can use the PostgreSQL ones, a clever decision; why reinventing the wheel when a few modifications are enough to make HSQLDB compatible with mainstream ODBC drivers ? Moreover, the choice of those drivers make sense as PostgreSQL is here to stay. If needed, please refer to the article <a href=\"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-drivers-for-postgresql\">Installing the ODBC drivers for PostgreSQL<\/a> for step by step instructions. Later, we will only have to create a DSN for the hsqldb database.<br \/>\nAs debian, start the database server process and send it to the background:<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1; highlight: [2]\">\n$ cd $workdir\/hsqldb-2.6.0\/hsqldb\/lib\n$ java -cp ..\/lib\/hsqldb.jar org.hsqldb.server.Server --database.0 file:sampledb --dbname.0 xdb &amp;\n<\/pre>\n<p>Connect to the local hsqldb service using the hsqldb&#8217;s provided administration application:<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1; highlight: [1]\">\n$ java -jar ..\/lib\/sqltool.jar --inlineRc=url=jdbc:hsqldb:localhost\/runtime,user=sa\n<\/pre>\n<p>Note that the tool uses JDBC for the connection, the java counterpart to ODBC. From that tool, create the tables for hsqldb using the Oracle script <a href=\"https:\/\/www.sqltutorial.org\/wp-content\/uploads\/2020\/04\/oracle.txt\">here<\/a>; save it into the text file create_tables_hsqldb.sql, edit it and change occurrences of NUMBER to INT and occurrences of VARCHAR2 to VARCHAR using your favorite text editor. Finally, execute it:<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1; highlight: [1]\">\ni \/home\/debian\/odbc4gawk\/create_tables_hsqldb.sql\n<\/pre>\n<p>Populate the tables for hsqldb using the Oracle script <a href=\"https:\/\/www.sqltutorial.org\/wp-content\/uploads\/2020\/04\/oracle-data.txt\">here<\/a>; save it into the text file populate_tables_hsqldb.sql and execute it unchanged.<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1; highlight: [1]\">\ni \/home\/debian\/odbc4gawk\/populate_tables_hsqldb.sql\n<\/pre>\n<p>Check the data:<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1; highlight: [1]\">\nsql&gt; SELECT\n        c.country_name,\n        c.country_id,\n        l.country_id,\n        l.street_address,\n        l.city\nFROM\n        countries c\nLEFT JOIN locations l ON l.country_id = c.country_id\nWHERE\n        c.country_id IN ('US', 'UK', 'CN');\nOutput:\nCOUNTRY_NAME              COUNTRY_ID  COUNTRY_ID  STREET_ADDRESS                            CITY\n------------------------  ----------  ----------  ----------------------------------------  -------------------\nChina                     CN                      [null]                                    [null]\nUnited Kingdom            UK          UK          8204 Arthur St                            London\nUnited Kingdom            UK          UK          Magdalen Centre, The Oxford Science Park  Oxford\nUnited States of America  US          US          2014 Jabberwocky Rd                       Southlake\nUnited States of America  US          US          2011 Interiors Blvd                       South San Francisco\nUnited States of America  US          US          2004 Charade Rd                           Seattle\n\nFetched 6 rows.\n<\/pre>\n<p>The data are OK.<br \/>\nConfigure an ODBC DSN by editing the user\u2019s DSN file:<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1; highlight: [1,5]\">\n$ vi ~\/.odbc.ini\n...\n[myhsqldb]\nDescription=My Postgresql sample database\nDriver=PostgreSQL Unicode\nDatabase=sampledb\n<\/pre>\n<p>On line 4, we have specified that the PostgreSQL ODBC driver is to be used.<br \/>\nCheck the DSN:<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1; highlight: [1,5]\">\n$ odbcinst -q -s\n...\n[myhsqldb]\n\n$ odbcinst -q -s -n myhsqldb\n...\n[myhsqldb]\nDescription=My Postgresql sample database\nDriver=PostgreSQL Unicode\nDatabase=sampledb\n<\/pre>\n<p>Try a hsqldb connection to the hsqldb database via ODBC using the native administrative tool isql:<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1; highlight: [1,10]\">\nisql -v myhsqldb\n+---------------------------------------+\n| Connected!                            |\n|                                       |\n| sql-statement                         |\n| help [tablename]                      |\n| quit                                  |\n|                                       |\n+---------------------------------------+\nSQL&gt; SELECT c.country_name, c.country_id, l.country_id, l.street_address, l.city FROM countries c LEFT JOIN locations l ON l.country_id = c.country_id WHERE c.country_id IN ('US', 'UK', 'CN');\nOutput:\n+-----------------------------------------+-----------+-----------+-----------------------------------------+---------------+\n| country_name                            | country_id| country_id| street_address                          | city          |\n+-----------------------------------------+-----------+-----------+-----------------------------------------+---------------+\n| United States of America                | US        | US        | 2014 Jabberwocky Rd                     | Southlake     |\n| United States of America                | US        | US        | 2011 Interiors Blvd                     | South San Francisco           |\n| United States of America                | US        | US        | 2004 Charade Rd                         | Seattle       |\n| United Kingdom                          | UK        | UK        | 8204 Arthur St                          | London        |\n| United Kingdom                          | UK        | UK        | Magdalen Centre, The Oxford Science Park| Oxford        |\n| China                                   | CN        |           |                                         |               |\n+-----------------------------------------+-----------+-----------+-----------------------------------------+---------------+\nSQLRowCount returns 6\n6 rows fetched\n<\/pre>\n<p>It looks good. Test now the DSN from a python script using the pyodbc module:<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1; highlight: [1]\">\n$ python3\nimport pyodbc \ncnxn = pyodbc.connect(DSN='myhsqldb')\ncursor = cnxn.cursor()\t\ncursor.execute(\"\"\"SELECT\n        c.country_name,\n        c.country_id,\n        l.country_id,\n        l.street_address,\n        l.city\nFROM\n        countries c\nLEFT JOIN locations l ON l.country_id = c.country_id\nWHERE\n        c.country_id IN ('US', 'UK', 'CN')\"\"\")\nrow = cursor.fetchone() \nwhile row:\n    print (row) \n    row = cursor.fetchone()\nOutput:\n('United States of America', 'US', 'US', '2014 Jabberwocky Rd', 'Southlake')\n('United States of America', 'US', 'US', '2011 Interiors Blvd', 'South San Francisco')\n('United States of America', 'US', 'US', '2004 Charade Rd', 'Seattle')\n('United Kingdom', 'UK', 'UK', '8204 Arthur St', 'London')\n('United Kingdom', 'UK', 'UK', 'Magdalen Centre, The Oxford Science Park', 'Oxford')\n('China', 'CN', None, None, None)\n<\/pre>\n<p>Everything is OK. hsqldb is now fully accessible from ODBC under the debian account.<br \/>\nInstructions for the other data sources can be accessed through the following links:<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-drivers-manager-with-sqlite-on-linux\">SQLite<\/a><br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-drivers-for-firebird\">Firebird<\/a><br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-drivers-for-mariadb\">MariaDB<\/a><br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-drivers-for-postgresql\">PostgreSQL<\/a><br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-drivers-for-oracle-rdbms\">Oracle<\/a><br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-drivers-for-microsoft-sqlserver-for-linux\">Microsoft SQLServer for Linux<\/a><br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-drivers-for-mongodb\">MongoDB<\/a><br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/installing-the-cdata-odbc-drivers-for-excel\/\">Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>This article is part of a series that includes SQLite, Postgresql, Firebird, Oracle RDBMS, Microsoft SQL Server, MariaDB, MongoDB, and Excel. The goal is to set up a self-standing environment for testing an ODBC extension for gawk presented here to be completed. Refer to SQLite for installing the required ODBC Driver Manager. The test system [&hellip;]<\/p>\n","protected":false},"author":40,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229],"tags":[],"type_dbi":[],"class_list":["post-16862","post","type-post","status-publish","format-standard","hentry","category-database-administration-monitoring"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.2) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Installing the ODBC drivers for HSQLDB - dbi Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-drivers-for-hsqldb\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Installing the ODBC drivers for HSQLDB\" \/>\n<meta property=\"og:description\" content=\"This article is part of a series that includes SQLite, Postgresql, Firebird, Oracle RDBMS, Microsoft SQL Server, MariaDB, MongoDB, and Excel. The goal is to set up a self-standing environment for testing an ODBC extension for gawk presented here to be completed. Refer to SQLite for installing the required ODBC Driver Manager. The test system [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-drivers-for-hsqldb\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2022-01-13T15:48:39+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-10-24T07:38:41+00:00\" \/>\n<meta name=\"author\" content=\"Middleware Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Middleware Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-drivers-for-hsqldb\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-drivers-for-hsqldb\/\"},\"author\":{\"name\":\"Middleware Team\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d8563acfc6e604cce6507f45bac0ea1\"},\"headline\":\"Installing the ODBC drivers for HSQLDB\",\"datePublished\":\"2022-01-13T15:48:39+00:00\",\"dateModified\":\"2025-10-24T07:38:41+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-drivers-for-hsqldb\/\"},\"wordCount\":397,\"commentCount\":0,\"articleSection\":[\"Database Administration &amp; Monitoring\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-drivers-for-hsqldb\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-drivers-for-hsqldb\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-drivers-for-hsqldb\/\",\"name\":\"Installing the ODBC drivers for HSQLDB - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"datePublished\":\"2022-01-13T15:48:39+00:00\",\"dateModified\":\"2025-10-24T07:38:41+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d8563acfc6e604cce6507f45bac0ea1\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-drivers-for-hsqldb\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-drivers-for-hsqldb\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-drivers-for-hsqldb\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Installing the ODBC drivers for HSQLDB\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d8563acfc6e604cce6507f45bac0ea1\",\"name\":\"Middleware Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/ddcae7ba0f9d1a0e7ae707f0e689e4a9c95bb48ec49c8e6d9cc86d43f4121cb6?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/ddcae7ba0f9d1a0e7ae707f0e689e4a9c95bb48ec49c8e6d9cc86d43f4121cb6?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/ddcae7ba0f9d1a0e7ae707f0e689e4a9c95bb48ec49c8e6d9cc86d43f4121cb6?s=96&d=mm&r=g\",\"caption\":\"Middleware Team\"},\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/middleware-team\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Installing the ODBC drivers for HSQLDB - dbi Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-drivers-for-hsqldb\/","og_locale":"en_US","og_type":"article","og_title":"Installing the ODBC drivers for HSQLDB","og_description":"This article is part of a series that includes SQLite, Postgresql, Firebird, Oracle RDBMS, Microsoft SQL Server, MariaDB, MongoDB, and Excel. The goal is to set up a self-standing environment for testing an ODBC extension for gawk presented here to be completed. Refer to SQLite for installing the required ODBC Driver Manager. The test system [&hellip;]","og_url":"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-drivers-for-hsqldb\/","og_site_name":"dbi Blog","article_published_time":"2022-01-13T15:48:39+00:00","article_modified_time":"2025-10-24T07:38:41+00:00","author":"Middleware Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Middleware Team","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-drivers-for-hsqldb\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-drivers-for-hsqldb\/"},"author":{"name":"Middleware Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d8563acfc6e604cce6507f45bac0ea1"},"headline":"Installing the ODBC drivers for HSQLDB","datePublished":"2022-01-13T15:48:39+00:00","dateModified":"2025-10-24T07:38:41+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-drivers-for-hsqldb\/"},"wordCount":397,"commentCount":0,"articleSection":["Database Administration &amp; Monitoring"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-drivers-for-hsqldb\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-drivers-for-hsqldb\/","url":"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-drivers-for-hsqldb\/","name":"Installing the ODBC drivers for HSQLDB - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2022-01-13T15:48:39+00:00","dateModified":"2025-10-24T07:38:41+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d8563acfc6e604cce6507f45bac0ea1"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-drivers-for-hsqldb\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-drivers-for-hsqldb\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-drivers-for-hsqldb\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Installing the ODBC drivers for HSQLDB"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d8563acfc6e604cce6507f45bac0ea1","name":"Middleware Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/ddcae7ba0f9d1a0e7ae707f0e689e4a9c95bb48ec49c8e6d9cc86d43f4121cb6?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/ddcae7ba0f9d1a0e7ae707f0e689e4a9c95bb48ec49c8e6d9cc86d43f4121cb6?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ddcae7ba0f9d1a0e7ae707f0e689e4a9c95bb48ec49c8e6d9cc86d43f4121cb6?s=96&d=mm&r=g","caption":"Middleware Team"},"url":"https:\/\/www.dbi-services.com\/blog\/author\/middleware-team\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/16862","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/40"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=16862"}],"version-history":[{"count":1,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/16862\/revisions"}],"predecessor-version":[{"id":41198,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/16862\/revisions\/41198"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=16862"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=16862"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=16862"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=16862"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}