ODBC tutorial: How to read Apache Derby data in ODBC

Tutorials ODBC Tutorials
,
1

Introduction

In this article, you will learn how to quickly and efficiently integrate Apache Derby data using ODBC, without writing any custom code. We will use the high-performance Apache Derby Connector in the ZappySys ODBC PowerPack to connect to Apache Derby and access its data via ODBC.

This approach allows you to query Apache Derby databases using standard SQL and integrate the data with ODBC-based tools and workflows.

Prerequisites

Steps

Step 1: Create a New ODBC Driver

  1. Open ODBC Data Sources by typing “ODBC” in the Windows search box and launching ODBC Data Sources (64-bit).

    Open ODBC Data Source
    Open ODBC Data Source342×436 23.8 KB

  2. Go to System DSN (recommended) and click Add.

    ZappySys ODBC Driver - Open UI
    ZappySys ODBC Driver - Open UI596×423 16.1 KB

  3. From the driver list, select ZappySys JDBC Bridge Driver, then click Continue.

    Select Google JDBC Bridge Driver
    Select Google JDBC Bridge Driver605×507 62.2 KB

Step 2: Configure the Apache Derby Data Source

  1. Enter the connection settings and configure the required parameters.

  2. For a Client/Server environment, use the following values:

    • Connection string:
      jdbc:derby://hostname:1527/mydatabase
    • Driver class:
      org.apache.derby.jdbc.ClientDriver
    • JDBC driver file(s):
      D:\Apache\derby\lib\derbyclient.jar
    • User name:
      admin
    • User password:
      **************
    • Connection parameters:
      []

  3. For an Embedded environment, use the following values:

    • Connection string:
      jdbc:derby:c:\apache\derby\databases\mydatabase
    • Driver class:
      org.apache.derby.jdbc.EmbeddedDriver
    • JDBC driver file(s):
      D:\Apache\derby\lib\derby.jar

  4. Click Test Connection to validate the configuration.

    JDBC Bridge Driver
    JDBC Bridge Driver644×561 75.6 KB

  5. Go to the Preview tab and run a sample SQL query to confirm access to the Apache Derby data. For more SQL examples, see the JDBC Bridge documentation.

SELECT * FROM "APP"."ORDERS"
  1. Verify that data is returned successfully, then click OK to save the configuration.
    Preview Data
    Preview Data644×561 75.6 KB

Conclusion

By integrating Apache Derby using the ZappySys ODBC JDBC Driver, you can efficiently query Apache Derby databases using SQL and integrate the data into ODBC-based workflows. This solution provides a flexible and powerful way to read Apache Derby data and automate data extraction.

Explore our ODBC PowerPack for more information and download and install it to start building smarter, faster, and more scalable solutions.

References

Contact us

If you encounter any issues or have specific questions, reach out to our support team via live chat or support ticket using our email support@zappysys.com.