Connect a JDBC Client to Streambased
Java Database Connectivity (JDBC) is a Java API that allows applications to connect to databases. It enables Java based applications to execute queries and retrieve data. Let's real-time it up!
Last updated
Java Database Connectivity (JDBC) is a Java API that allows applications to connect to databases. It enables Java based applications to execute queries and retrieve data. Let's real-time it up!
Last updated
A running Streambased instance, for instructions see
A JDBC supporting client/library
Streambased is 100% compatible with the Trino JDBC driver, you can obtain it from . Store this in a place that is easily accesible by your client application.
Select New Driver
.
Enter the following information in each field:
Name
Streambased
Example URL
jdbc:trino://host:port?SSL=true
Website URL
https://streambased.io
Select the Extra Class Path
tab, Click Add
and navigate to the JDBC driver .jar you downloaded in Step 2.
Click List Drivers
and Set the Class Name to io.trino.jdbc.TrinoDriver
.
Click OK
.
Select New Alias
Enter the following information in each field:
Name
Streambased (or other meaningful name)
Driver
The one created in Step 3
Url
jdbc:trino://[server host]:[server port]/kafka
Clicking Connect
will bring up a SQL editor, happy querying!