JDBC Client Connections

Java Database Connectivity (JDBC) is an API standard that allows Java client applications to connect to a relational database and issue SQL queries using a standard interface. This section explains how to connect to AtScale from JDBC-compliant client applications.

To applications that send SQL queries, AtScale uses the same protocols and drivers as a remote PostgreSQL instance.

Connecting to AtScale from a Java client is the same as connecting to PostgreSQL, however you connect to the AtScale engine. The JDBC connection URL points to a particular AtScale project, for example:

jdbc:postgresql://localhost:15432/name

To issue an SQL query to AtScale, the SQL table name is the name of the model and the column names are the model attribute's unique naxmes. For example (notice the back-ticks to escape table and column names containing spaces):

SELECT \`Internet Sales\`.Order Month,  
  SUM(Internet Sales.orderquantity) AS
\`Order Quantity\`  
FROM \`Sales Insights\`.\`Internet Sales\`  
GROUP BY \`Internet Sales\`.\`Order Month\`