7.2 Executing PGQL SELECT Queries on a SQL Property Graph
You can execute PGQL SELECT
queries, on a SQL property graph, using
the Java API in the oracle.pg.rdbms.pgql
package.
The following example shows a PGQL SELECT
query
execution:
opg4j> var jdbcUrl="jdbc:oracle:thin:@<host_name>:<port>/<db_service>"
opg4j> var conn = DriverManager.getConnection(jdbcUrl,"<username>","<password>")
opg4j> conn.setAutoCommit(false)
opg4j> var pgqlConn = PgqlConnection.getConnection(conn)
opg4j> var pgqlStmt = pgqlConn.createStatement()
opg4j> String query = "SELECT n.name FROM MATCH (n:person) ON STUDENTS_GRAPH"
opg4j> var rs = pgqlStmt.executeQuery(query)
opg4j> rs.print()
+-------+
| NAME |
+-------+
| John |
| Mary |
| Bob |
| Alice |
+-------+
Connection conn = DriverManager.getConnection("<jdbcUrl>","<username>","<password>");
conn.setAutoCommit(false);
PgqlConnection pgqlConn = PgqlConnection.getConnection(conn);
PgqlStatement pgqlStmt = pgqlConn.createStatement();
String query = "SELECT n.name FROM MATCH (n:person) ON STUDENTS_GRAPH";
PgqlResultSet rs = pgqlStmt.executeQuery(query);
rs.print();
>>> pgql_conn = opg4py.pgql.get_connection("<username>","<password>", "<jdbcUrl>")
>>> pgql_statement = pgql_conn.create_statement()
>>> query = "SELECT n.name FROM MATCH (n:person) ON STUDENTS_GRAPH"
>>> rs = pgql_statement.execute_query(query)
>>> rs.print()
+-------+
| NAME |
+-------+
| John |
| Mary |
| Bob |
| Alice |
+-------+
Parent topic: Executing PGQL Queries Against SQL Property Graphs