7.2 SQLプロパティ・グラフに対するPGQL SELECT問合せの実行

oracle.pg.rdbms.pgqlパッケージのJava APIを使用して、SQLプロパティ・グラフに対してPGQL SELECT問合せを実行できます。

次の例では、PGQL SELECT問合せの実行を示します:

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