JDBC Query
The following Java code executes an SQL SELECT * on the MVFILE.PERSON table. In detail, the code does the following:
-
Creates a connection to Caché using java.sql.Connection.
-
Creates a Statement object and uses it to execute the query.
-
Iterates through the result set displaying the data.
-
Closes the result set and the database connection.
//Create the connection Class.forName("com.intersys.jdbc.CacheDriver"); 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 (rs.next()) { for (int i=1; i<=colnum; i++) { System.out.print(rs.getString(i) + " "); } System.out.println(); } //Close the result set and database connection rs.close(); conn.close();
Note:
The above code is contained in RunQuery.java. This file is in <cachesys>\Dev\tutorials\mv. Executing the Java Examples contains step-by-step instructions for executing this code.