To make a local (non-RPC-based) JDBC connection to the SMA server, you need to connect to a SMA server using the non-standard connection property solid_shared_memory, and use a local server at a given port in the JDBC URL (connection string).
Connecting with Driver Manager
1 Set the non-standard connection property solid_shared_memory to yes.
2 Set 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);
Defining 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.