The processing of queries is optimized by using an in-built statement cache, see Statement cache. You can control the number of statements held in the cache by using the following connection property:
// create a Solid JDBC driver instance Class.forName("solid.jdbc.SolidDriver");
// create a new Properties instance and insert a value for // StatementCache property java.util.Properties props = new java.util.Properties(); props.put("StatementCache","32");
// define the connection string to be used String sCon="jdbc:solid://localhost:1315/uname1/pwd1";
// get the Connection object with a statement cache of 32 java.sql.Connection conn = java.sql.DriverManager.getConnection(sCon, props);