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:

• JShell
• Java
• Python

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 |
+-------+