Apache Derby Connector

The high-performance Apache Derby Connector provides read/write capabilities within your application, allowing you to perform numerous Apache Derby operations with minimal coding or even no-coding at all. Integrate Apache Derby data into applications such as SSIS, SQL Server, any ODBC-compatible application, or even directly within a programming language using this connector.

Download

Integrate Apache Derby with these applications

All
Data Integration
Database
BI & Reporting
Productivity
Programming Languages
Automation & Scripting
ODBC applications

SQL examples for Apache Derby Connector

Use these example Apache Derby SQL queries within SSIS, SQL Server or any ODBC-compatible application:

Get orders

This example query shows how to access the data by specifying the schema and table name.

SELECT * FROM "APP"."ORDERS"

Get order lines

This example query shows how to access to do a simple join on two tables.

SELECT o.ID, ol.*
FROM "APP"."ORDERS" AS o
JOIN "APP"."ORDER_LINES" AS ol 
  ON o.ID = ol.ORDER_ID

Get product quantities for a specific order

This example query retrieves the product name and quantity for each line item belonging to order ID 12345.

SELECT
    ol.ORDER_ID,
    p.NAME AS Product,
    ol.QUANTITY
FROM "APP"."ORDER_LINES" AS ol
JOIN "APP"."PRODUCTS" AS p ON ol.PRODUCT_ID = p.ID
WHERE ol.ORDER_ID = 12345

Download