To make a local (non-RPC-based) JDBC connection to the SMA server, you must connect to a SMA server by using the non-standard connection property solid_shared_memory, and use a local server at a given port in the JDBC URL (connection string).
Use one of the following methods:
▪ Connect with driver manager
Set the non-standard connection property solid_shared_memory to yes and the connection string to use a local server (localhost) and define an available port number.
For example:
Properties props = new Properties(); // enable the direct access property props.put("solid_shared_memory", "yes"); // get connection Connection c = DriverManager.getConnection ("jdbc:solid://localhost:1315", props);
▪ Define a connection property in the connect string
Include the connection property solid_shared_memory=yes in the connect string, and use a local server (localhost), defining an available port number.
For example:
Connection c = DriverManager.getConnection ("jdbc:solid://localhost:1315?solid_shared_memory=yes");
Note In addition to the DriverManager class, a similar syntax is available for classes SolidDataSource and SolidConnectionPoolDataSource.