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.
Integrate Apache Derby with these 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