Exasol Java tutorial

January 16, 2024 ยท View on GitHub

Build Status

Quality Gate Status

Security Rating Reliability Rating Maintainability Rating Technical Debt

Code Smells Coverage Duplicated Lines (%) Lines of Code

If you are a Java developer and you are thinking about extending Exasol with new functionality, this tutorial takes you on a tour around Exasol's interfaces and the libraries we provide.

Not only do you learn how to implement User Defined Functions (UDF) in Java, but you also will see how to run automated integration tests.

Topics we are touching in the tutorials:

  • Scalar Script UDF (a script with a single input)
  • Java code inlined into SQL code
  • Java UDFs provided as JAR archives
  • Exasol Scripting API for Java
  • How to get an Exasol instance you can test against in automated tests
  • How to set up tests and prepare test data
  • How to check the results from SQL queries in a compact and readable way

Tutorials

Hello World!

Start your journey with the obligatory hello world tutorial to learn the basics of defining an inline Java extension that can be called from SQL.

Markdown Statistics as User Defined Function

Up your game with a full-blown automated integration test that exercises a more complex Java extension that gets statistics from Markdown text stored in an Exasol table. Learn to package the installation in a JAR archive in the course of this tutorial.

TLS Tutorial

Setting up TLS is all but trivial in some scenarios, so a series of articles and some software examples guide you through the process.

  1. Introduction to TLS
  2. TLS with Exasol (theoretical part)
  3. Using Your Own Certificates to run IMPORT from MySQL into Exasol
  4. TLS in User Defined Functions (UDFs)

Java Testing Tutorial

Additional Information