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?

JDBC Query

The following Java code executes an SQL SELECT * on the MVFILE.PERSON table. In detail, the code does the following:

  1. Creates a connection to Caché using java.sql.Connection.

  2. Creates a Statement object and uses it to execute the query.

  3. Iterates through the result set displaying the data.

  4. Closes the result set and the database connection.

 //Create the connection
String url="jdbc:Cache://localhost:1972/MYACCOUNT";
Connection conn = DriverManager.getConnection(url);

//Execute the query
String query = "Select * from MVFile.Person";
Statement stmt = conn.createStatement();
java.sql.ResultSet rs = stmt.executeQuery(query);

//Retrieve and display the results
ResultSetMetaData rsmd = rs.getMetaData();
int colnum = rsmd.getColumnCount();
while ( {
   for (int i=1; i<=colnum; i++) {
     System.out.print(rs.getString(i) + "  ");

//Close the result set and database connection

The above code is contained in This file is in <cachesys>\Dev\tutorials\mv. Executing the Java Examples contains step-by-step instructions for executing this code.