Skip to main content

This is documentation for Caché & Ensemble. See the InterSystems IRIS version of this content.

For information on migrating to InterSystems IRIS, see Why Migrate to InterSystems IRIS?

Part II: Caché and JDBC

Part II of the tutorial focuses on connecting Java applications to Caché using the Caché JDBC Database Driver and SQL. After completing this part of the tutorial, you will be able to:

  • Create database connections between Java applications and Caché using java.sql.DriverManager as well as using com.intersys.objects.CacheDatabase

  • Execute SQL SELECT and INSERT commands on Caché from within a Java application

  • Execute a stored procedure defined in Caché from within a Java application

  • Use the Caché Implicit Join syntax to execute queries involving joins on Caché from within a Java application


Part II of the tutorial assumes basic knowledge of Caché as well as basic Java programming skills. To learn more about Caché complete the Caché QuickStart tutorial. To learn more about Java programming read The Java Tutorials. See especially “The JDBC Trail”.


Click here to begin.