Oracle Database Property Graph

https://docs.oracle.com/en/database/oracle/property-graph/26.1/spgdg/
Admin
Oracle Database Property Graph is Oracle's graph database feature that enables developers to create,...
Tokens:523,001
Snippets:3,795
Trust Score:9.7
Update:1 week ago
Show doc for...
Tokens:
Raw
### Start PGX Server Environment

Source: https://docs.oracle.com/en/database/oracle/property-graph/26.1/spgdg/using-autonomous-ai-database-graph-client-oci-data-science-notebooks.html

Starts the PGX server environment with the desired memory (8 GB in this example). Submits a job in Graph Studio for environment creation; job.get() waits for the environment to start. Verify success with client.isAttached(), which returns true if the environment is running.

```python
memory_gb = 8
job = client.start_environment(memory_gb)
job.get()
```

--------------------------------

### Start OPG4J shell to connect to graph server

Source: https://docs.oracle.com/en/database/oracle/property-graph/26.1/spgdg/oracle-graph-java-client.html

Command to start the OPG4J shell after installing the Java client. Replace <CLIENT_INSTALL_DIR>, <host>, and <graphuser> with actual values. The shell executables are typically in /opt/oracle/graph/bin after server installation or <CLIENT_INSTALL_DIR>/bin after client installation.

```bash
cd <CLIENT_INSTALL_DIR>
./bin/opg4j --base_url https://<host>:7007 --username <graphuser>
```

--------------------------------

### Example: Using PGX JDBC Driver to run graph queries

Source: https://docs.oracle.com/en/database/oracle/property-graph/26.1/spgdg/using-autonomous-ai-database-graph-client.html

Complete Java example that connects to Autonomous AI Database, starts the compute environment, loads a graph, and runs a PGQL query. Outputs the AMOUNT value.

```java
import java.sql.*;
import oracle.pgx.jdbc.*;
import oracle.pg.rdbms.*;
import oracle.pgx.api.*;

public class AdbPgxJdbc {

  public static void main(String[] args) throws Exception {

    DriverManager.registerDriver(new PgxJdbcDriver());


    try (Connection conn = DriverManager.getConnection("jdbc:oracle:pgx:@<db_TNS_name>?TNS_ADMIN=<path_to_wallet>","ADB_username","<ADB_password>")) {
      AdbGraphClient client = conn.unwrap(AdbGraphClient.class);
      if (!client.isAttached()) {
        var job = client.startEnvironment(10);
         job.get();
         System.out.println("job details: name=" + job.getName() + "type= " + job.getType() +"created_by= " + job.getCreatedBy());
        }
      PgxSession session = conn.unwrap(PgxSession.class);
      PgxGraph graph = session.readGraphByName("BANK_PGQL_GRAPH", GraphSource.PG_PGQL);
      Statement stmt = conn.createStatement();
      ResultSet rs = stmt.executeQuery("SELECT * "+
                                         "FROM GRAPH_TABLE ( BANK_PGQL_GRAPH "+
                                         "MATCH (a IS ACCOUNTS) -[e IS TRANSFERS]-> (b IS ACCOUNTS) "+
                                         "WHERE a.ID = 179 AND b.ID = 688 "+
                                         "COLUMNS (e.AMOUNT AS AMOUNT ))");
      while(rs.next()){
        System.out.println("AMOUNT = " + rs.getLong("AMOUNT"));
      }

    }
  }
}
```

```text
AMOUNT = 7562
```

--------------------------------

### Verify Python client installation

Source: https://docs.oracle.com/en/database/oracle/property-graph/26.1/spgdg/oracle-graph-python-client.html

Starts a Python 3.12.11 interactive session and imports the opg4py and pypgx modules to confirm the client is installed correctly.

```bash
$ python3
Python 3.12.11 (main, Aug 25 2025, 20:36:00) [GCC 8.5.0 20210514 (Red Hat 8.5.0-26.0.1)] on linux

Type "help", "copyright", "credits" or "license" for more information.
>>> import opg4py
>>> import pypgx
```

--------------------------------

### Configure JVM on-heap memory in setup.conf

Source: https://docs.oracle.com/en/database/oracle/property-graph/26.1/spgdg/memory-management.html

Example content for the setup.conf drop-in file. Sets the initial heap size to 1GB and maximum to 2GB using JAVA_TOOL_OPTIONS. The comment lines start with #.

```ini
[Service]
# Java on-heap memory setting
Environment="JAVA_TOOL_OPTIONS=-Xms1G -Xmx2G"
```

--------------------------------

### Start HAProxy with systemctl

Source: https://docs.oracle.com/en/database/oracle/property-graph/26.1/spgdg/using-haproxy-pgx-load-balancing-and-high-availability.html

Starts the HAProxy load balancer service using systemctl. Run this command after configuring haproxy.cfg.

```bash
sudo systemctl start haproxy
```

--------------------------------

### Launch OPG4Py Shell

Source: https://docs.oracle.com/en/database/oracle/property-graph/26.1/spgdg/interactive-graph-shell-clis.html

Command to start the OPG4Py shell from the installation directory.

```bash
cd /opt/oracle/graph
./bin/opg4py
```

--------------------------------

### Install Python client with pip

Source: https://docs.oracle.com/en/database/oracle/property-graph/26.1/spgdg/oracle-graph-python-client.html

Installs the Oracle Graph Python client from the downloaded zip file. The --user flag installs it for the current user. Run this after unzipping the client package.

```bash
python3 oracle-graph-python-client-26.1.0.zip --user
```

--------------------------------

### Start PGX Environment in Java

Source: https://docs.oracle.com/en/database/oracle/property-graph/26.1/spgdg/using-autonomous-ai-database-graph-client.html

Checks if the environment is attached, starts it with 10 GB memory, and waits for completion. The output shows the job details.

```java
 if (!client.isAttached()) {
         var job = client.startEnvironment(10);
         job.get();
         System.out.println("job details: name=" + job.getName() + "type= " + job.getType() +"created_by= " + job.getCreatedBy());
      }
job details: name=Environment Creation - 16 GBstype= ENVIRONMENT_CREATIONcreated_by= ADBDEV
```

--------------------------------

### Start PGX server with systemctl

Source: https://docs.oracle.com/en/database/oracle/property-graph/26.1/spgdg/starting-and-stopping-graph-server-pgx-using-command-line.html

Use this command to start the PGX server as a daemon process. Run without sudo if you are the root user.

```bash
sudo systemctl start pgx
```

--------------------------------

### Start Tomcat

Source: https://docs.oracle.com/en/database/oracle/property-graph/26.1/spgdg/deploying-oracle-graph-server-web-server.html

Start Tomcat from the CATALINA_HOME directory. The graph server will listen on localhost:8080/pgx.

```bash
cd $CATALINA_HOME
./bin/startup.sh
```

--------------------------------

### Start PGX Environment in Python

Source: https://docs.oracle.com/en/database/oracle/property-graph/26.1/spgdg/using-autonomous-ai-database-graph-client.html

Checks if the environment is attached, starts it with 10 GB memory, and waits for completion. The output shows the job details.

```python
>>> client.is_attached()
False
>>> job = client.start_environment(10)
>>> job.get()
>>> job.get_name()
'Environment Creation - 16 GBs'
>>> job.get_created_by()
'ADBDEV'
>>> client.is_attached()
True
```

--------------------------------

### Start graph server with JDBC URL parameter

Source: https://docs.oracle.com/en/database/oracle/property-graph/26.1/spgdg/using-rpm-installation.html

Starts the graph server using the JDBC URL passed as a parameter.

```bash
./quicksetup.sh -j jdbc:oracle:thin:@<host>:<port>/<sid>
```

--------------------------------

### Set JAVA_HOME for OPG4J Shell

Source: https://docs.oracle.com/en/database/oracle/property-graph/26.1/spgdg/interactive-graph-shell-clis.html

Example of setting the JAVA_HOME environment variable to switch between multiple Java installations before starting the shell.

```bash
export JAVA_HOME=/usr/lib/jvm/java-11-oracle
```

--------------------------------

### Add JAVA_HOME and on-heap memory settings to setup.conf

Source: https://docs.oracle.com/en/database/oracle/property-graph/26.1/spgdg/memory-management.html

Extended setup.conf example that also sets the JAVA_HOME environment variable to ensure PGX uses the appropriate JDK. Comments can be used to optionally disable specific options.

```ini
[Service]
# JAVA_HOME variable
Environment=JAVA_HOME=/usr/java/jdk-15.0.1/
# Java on-heap memory setting
Environment="JAVA_TOOL_OPTIONS=-Xms1G -Xmx2G"
```

--------------------------------

### Configure JDBC URL via prompt with quicksetup.sh

Source: https://docs.oracle.com/en/database/oracle/property-graph/26.1/spgdg/using-rpm-installation.html

Prompts for the JDBC URL to configure the graph server. The prompt output is shown.

```bash
./quicksetup.sh -u
Enter JDBC URL: jdbc:oracle:thin:@<host>:<port>/<sid>
```

--------------------------------

### cURL Example for GET /v2/user

Source: https://docs.oracle.com/en/database/oracle/property-graph/26.1/spgdg/get-current-user.html

Example cURL command to call the endpoint with an Authorization header.

```bash
curl --location --request GET 'https://localhost:7007/v2/user' \
--header 'Authorization: Bearer <token>'
```

--------------------------------

### Example output from running App1

Source: https://docs.oracle.com/en/database/oracle/property-graph/26.1/spgdg/oracle-graph-java-client.html

Sample output from the Maven exec plugin after successful processing. The actual output may vary depending on the database connect string.

```text
[INFO] --- exec-maven-plugin:3.1.0:java (default-cli) @ my-app ---
connecting to jdbc:oracle:pgql:@myhost:1521/oradb
from_acct:227
to_acct:778
amount:5279.0

from_acct:228
to_acct:458
amount:9917.0

from_acct:228
to_acct:387
amount:1993.0

from_acct:228
to_acct:126
amount:9302.0

from_acct:228
to_acct:901
amount:4339.0
```

--------------------------------

### Start Python shell in embedded mode

Source: https://docs.oracle.com/en/database/oracle/property-graph/26.1/spgdg/using-graph-server-pgx-library.html

Starts the Python shell in embedded server mode. Run from the graph server installation directory.

```bash
cd /opt/oracle/graph/
./bin/opg4py
```

--------------------------------

### Compile and run Java keystore example

Source: https://docs.oracle.com/en/database/oracle/property-graph/26.1/spgdg/user-authentication-and-authorization.html

Commands to compile and run the Java program using the Oracle Graph Client package. Assumes Main.java is created with the above contents.

```bash
cd $GRAPH_CLIENT
// create Main.java with above contents
javac -cp 'lib/*' Main.java
java -cp '.:conf:lib/*' Main http://myhost:7007 MyKeystorePassword path/to/config.json
```

--------------------------------

### Start PGX server after setting tns_admin

Source: https://docs.oracle.com/en/database/oracle/property-graph/26.1/spgdg/using-oracle-graph-autonomous-ai-database.html

Starts the PGX server after setting the tns_admin environment variable. This is part of the on-demand graph loading setup.

```bash
systemctl start pgx
```

--------------------------------

### cURL Example for GET /v2/graphs

Source: https://docs.oracle.com/en/database/oracle/property-graph/26.1/spgdg/get-graphs-v2.html

Example cURL command to call the endpoint. Replace <driver-value> with one of the supported driver values (GRAPH_SERVER_PGX, PGQL_IN_DATABASE, SQL_IN_DATABASE) and <token> with a valid bearer token.

```bash
curl --location --request GET 'https://localhost:7007/v2/graphs?driver=<driver-value>' \
--header 'Authorization: Bearer <token>'
```

--------------------------------

### Run CLOUD_INSTALLER.sql to create migration packages and tables

Source: https://docs.oracle.com/en/database/oracle/property-graph/26.1/spgdg/quick-start-creating-sql-property-graph-importing-graph-data-neo4j.html

Executes the CLOUD_INSTALLER.sql script as the migneo4jrep user to create all packages and tables required for script generation. The output shows the compilation of packages and creation of tables.

```sql
@\<file_path>\CLOUD_INSTALLER.sql
```

```text
Package MIGRATION_REPOSITORY compiled

Package Body MIGRATION_REPOSITORY compiled

Table MD_GRAPH_EDGE_TABLES created.
Table MD_GRAPH_VERTEX_TABLES created.
Table MD_GRAPH_VERTEX_TABLES created.
Table VERTEX_LABELS created.
Table STAGE_NEO4J_APOC_SCHEMA created.

PL/SQL procedure successfully completed.

Package MIGRATE_NEO4J_COMMON compiled

Package Body MIGRATE_NEO4J_COMMON compiled

Package MIGRATE_NEO4J_CLOUD compiled

Package Body MIGRATE_NEO4J_CLOUD compiled
```

--------------------------------

### Run the Oracle Graph Quickstart container

Source: https://docs.oracle.com/en/database/oracle/property-graph/26.1/spgdg/running-oracle-graph-quickstart-container-image.html

Runs the Oracle Graph Quickstart container in the background. The --name flag specifies the container name, -d runs it in the background, -p maps the host port to container port 7007, and -e sets the ORACLE_PWD environment variable for the database password for GRAPHUSER and PDBADMIN user accounts.

```bash
podman run -d --name <container_name> -p <host_port>:7007 -e ORACLE_PWD=<database_password> container-registry.oracle.com/database/graph-quickstart:25.2.0
```

--------------------------------

### cURL Example for GET /v2/dbVersion

Source: https://docs.oracle.com/en/database/oracle/property-graph/26.1/spgdg/get-database-version.html

Command to call the endpoint using cURL, with the required Authorization header.

```bash
curl --location --request GET 'https://localhost:7007/v2/dbVersion' \
--header 'Authorization: Bearer <token>'
```

--------------------------------

### Use blocking convenience method createSession()

Source: https://docs.oracle.com/en/database/oracle/property-graph/26.1/spgdg/blocking-operation.html

Shows the blocking convenience method createSession() that internally calls get() on the corresponding asynchronous method. It is equivalent to the previous example using createSessionAsync() and get(), and handles the same exceptions.

```java
try {
    // block caller thread
    PgxSession session = instance.createSession("my-session");
    // do something with session
    ...
} catch (InterruptedException e) {
    // caller thread was interrupted while waiting for result
} catch (ExecutionException e) {
    // an exception was thrown during asynchronous computation
    Throwable cause = e.getCause(); // the actual exception is nested
}

```

--------------------------------

### Create sample tables and insert data for students_graph

Source: https://docs.oracle.com/en/database/oracle/property-graph/26.1/spgdg/examples-sql-property-graph-queries.html

Run this SQL script as the schema user to create the university, persons, student_of, and friends tables with sample data. The tables use identity columns and foreign key constraints. The data includes four persons, two universities, student enrollments, and friendship relationships.

```sql
CREATE TABLE university (
    id NUMBER GENERATED ALWAYS AS IDENTITY (START WITH 1 INCREMENT BY 1),
    name VARCHAR2(10),
    CONSTRAINT u_pk PRIMARY KEY (id));

INSERT INTO university (name) VALUES ('ABC');
INSERT INTO university (name) VALUES ('XYZ');

CREATE TABLE persons (
     person_id NUMBER GENERATED ALWAYS AS IDENTITY (START WITH 1 INCREMENT
     BY 1),
     name VARCHAR2(10),
     birthdate DATE,
     height FLOAT DEFAULT ON NULL 0,
     hr_data JSON,
     CONSTRAINT person_pk PRIMARY KEY (person_id)
   );

INSERT INTO persons (name, height, birthdate, hr_data)
       VALUES ('John', 1.80, to_date('13/06/1963', 'DD/MM/YYYY'), '{"department":"IT","role":"Software Developer"}');

INSERT INTO persons (name, height, birthdate, hr_data)
       VALUES ('Mary', 1.65, to_date('25/09/1982', 'DD/MM/YYYY'), '{"department":"HR","role":"HR Manager"}');

INSERT INTO persons (name, height, birthdate, hr_data)
       VALUES ('Bob', 1.75, to_date('11/03/1966', 'DD/MM/YYYY'), '{"department":"IT","role":"Technical Consultant"}');

INSERT INTO persons (name, height, birthdate, hr_data)
       VALUES ('Alice', 1.70, to_date('01/02/1987', 'DD/MM/YYYY'), '{"department":"HR","role":"HR Assistant"}');

CREATE TABLE student_of (
      s_id NUMBER GENERATED ALWAYS AS IDENTITY (START WITH 1 INCREMENT BY 1),
      s_univ_id NUMBER,
      s_person_id NUMBER,
      subject VARCHAR2(10),
      CONSTRAINT stud_pk PRIMARY KEY (s_id),
      CONSTRAINT stud_fk_person FOREIGN KEY (s_person_id) REFERENCES persons(person_id),
      CONSTRAINT stud_fk_univ FOREIGN KEY (s_univ_id) REFERENCES university(id)
    );

INSERT INTO student_of(s_univ_id, s_person_id,subject) VALUES (1,1,'Arts');
INSERT INTO student_of(s_univ_id, s_person_id,subject) VALUES (1,3,'Music');
INSERT INTO student_of(s_univ_id, s_person_id,subject) VALUES (2,2,'Math');
INSERT INTO student_of(s_univ_id, s_person_id,subject) VALUES (2,4,'Science');

CREATE TABLE friends (
    friendship_id NUMBER GENERATED ALWAYS AS IDENTITY (START WITH 1 INCREMENT BY 1),
    person_a NUMBER,
    person_b NUMBER,
    meeting_date DATE,
    CONSTRAINT fk_person_a_id FOREIGN KEY (person_a) REFERENCES persons(person_id),
    CONSTRAINT fk_person_b_id FOREIGN KEY (person_b) REFERENCES persons(person_id),
    CONSTRAINT fs_pk PRIMARY KEY (friendship_id)
);

INSERT INTO friends (person_a, person_b, meeting_date) VALUES (1, 3, to_date('01/09/2000', 'DD/MM/YYYY'));
INSERT INTO friends (person_a, person_b, meeting_date) VALUES (2, 4, to_date('19/09/2000', 'DD/MM/YYYY'));
INSERT INTO friends (person_a, person_b, meeting_date) VALUES (2, 1, to_date('19/09/2000', 'DD/MM/YYYY'));
INSERT INTO friends (person_a, person_b, meeting_date) VALUES (3, 2, to_date('10/07/2001', 'DD/MM/YYYY'));
```

--------------------------------

### Create a PGX session in JShell

Source: https://docs.oracle.com/en/database/oracle/property-graph/26.1/spgdg/compiling-and-running-custom-pgx-algorithm.html

Start the opg4j shell from the Oracle Graph installation directory to create a session.

```shell
cd /opt/oracle/graph
./bin/opg4j
```

--------------------------------

### Maven command to compile and run App1

Source: https://docs.oracle.com/en/database/oracle/property-graph/26.1/spgdg/oracle-graph-java-client.html

Command to compile and run the Java example from the project directory. Passes the database connect string, username, and password as arguments to the main class.

```bash
mvn compile exec:java -Dexec.mainClass="com.mycompany.app.App1"-Dexec.arguments='<db-connect-string>,<username>,<password>'
```

--------------------------------

### Example keytool prompts and responses

Source: https://docs.oracle.com/en/database/oracle/property-graph/26.1/spgdg/using-self-signed-server-keystore.html

Example of the interactive prompts and responses when running the keytool command. Provide the requested details, including the keystore password and distinguished name fields.

```text
Enter keystore password:
Re-enter new password:
What is your first and last name?
  [Unknown]:  localhost
What is the name of your organizational unit?
  [Unknown]:  OU
What is the name of your organization?
  [Unknown]:  MyOrganization
What is the name of your City or Locality?
  [Unknown]:  MyTown
What is the name of your State or Province?
  [Unknown]:  MyState
What is the two-letter country code for this unit?
  [Unknown]:  US
Is CN=localhost, OU=OU, O=MyOrganization, L=MyTown, ST=MyState, C=US correct?
  [no]:  yes
```

--------------------------------

### Get JDBC Connection for OPG4J or Java

Source: https://docs.oracle.com/en/database/oracle/property-graph/26.1/spgdg/quick-start-working-pgql-property-graphs.html

Obtain a JDBC database connection for OPG4J shell or a Java program. The JShell example shows the expected output for the connection object. The Java example includes the required imports and sets auto-commit to false.

```jshell
opg4j> var jdbcUrl="jdbc:oracle:thin:@<host>:<port>/<sid>"
jdbcUrl ==> "jdbc:oracle:thin:@localhost:1521/orclpdb"
opg4j> var conn = DriverManager.getConnection(jdbcUrl,"<username>","<password>")
conn ==> oracle.jdbc.driver.T4CConnection@7d463c9f
opg4j> conn.setAutoCommit(false);
```

```java
import java.sql.DriverManager;
import java.sql.Connection;
import java.sql.Statement;
oracle.pg.rdbms.pgql.PgqlConnection;
oracle.pg.rdbms.pgql.PgqlStatement;
oracle.pg.rdbms.pgql.PgqlResultSet;
oracle.pgx.api.*;
oracle.pg.rdbms.GraphServer;

// Get a jdbc connection
String jdbcUrl="jdbc:oracle:thin:@"+<host>+":"+<port>+"/"+<service>;
conn = DriverManager.getConnection(jdbcUrl, <username>, <password>);
conn.setAutoCommit(false);
```

--------------------------------

### Restart graph server with quicksetup.sh

Source: https://docs.oracle.com/en/database/oracle/property-graph/26.1/spgdg/using-rpm-installation.html

Restarts the graph server (PGX).

```bash
./quicksetup.sh -x
```

--------------------------------

### Get session ID in opg4j

Source: https://docs.oracle.com/en/database/oracle/property-graph/26.1/spgdg/user-authentication-and-authorization.html

Retrieves the session ID using the PgxSession API in opg4j. The output shows an example session ID.

```opg4j
opg4j> session.getId();
$2 ==> "898bdbc3-af80-49b7-9a5e-10ace6c9071c"  //session id
```

--------------------------------

### Register keystore in Java application using PgxSession.registerKeystore()

Source: https://docs.oracle.com/en/database/oracle/property-graph/26.1/spgdg/user-authentication-and-authorization.html

Java example showing how to register a keystore and read a graph with properties. Requires Oracle Graph Client package.

```java
import oracle.pgx.api.*;

class Main {

  public static void main(String[] args) throws Exception {
    String baseUrl = args[0];
    String keystorePath = "/etc/my-secrets/keystore.p12";
    char[] keystorePassword = args[1].toCharArray();
    String graphConfigPath = args[2];
    ServerInstance instance = Pgx.getInstance(baseUrl);
    try (PgxSession session = instance.createSession("my-session")) {
      session.registerKeystore(keystorePath, keystorePassword);
      PgxGraph graph = session.readGraphWithProperties(graphConfigPath);
      System.out.println("N = " + graph.getNumVertices() + " E = " + graph.getNumEdges());
    }
  }
}
```

--------------------------------

### Get AlgorithmProgress for PageRank in Java

Source: https://docs.oracle.com/en/database/oracle/property-graph/26.1/spgdg/getting-progress-running-algorithm.html

Java code that reads a graph, starts PageRank asynchronously, and obtains an Optional<AlgorithmProgress> via FutureProgress.asAlgorithmExecutionProgress().

```java
PgxGraph graph = session.readGraphByName("BANK_TXN_GRAPH", GraphSource.PG_PGQL);
PgxFuture<?> future = analyst.pagerank.runAsync(graph);
FutureProgress futureProgress = future.getProgress();
Optional<AlgorithmProgress> algorithmProgress = futureProgress.asAlgorithmExecutionProgress();

```

--------------------------------

### cURL Example for GET /v2/runQueryAsync

Source: https://docs.oracle.com/en/database/oracle/property-graph/26.1/spgdg/retrieve-asynchronous-query-result-v2.html

Shows how to call the endpoint using cURL. Requires an Authorization Bearer token and the result ID from the asynchronous query execution.

```bash
curl --location --request GET 'https://localhost:7007/v2/runQueryAsync/<result-id>' \
--header 'Authorization: Bearer <token>'
```

--------------------------------

### Get model description from model store (JShell, Java, Python)

Source: https://docs.oracle.com/en/database/oracle/property-graph/26.1/spgdg/database-backed-model-repository.html

Retrieves the description of a stored model. The JShell example shows the output "DeepWalk: model desc" for the model name DeepWalkModel. The Java and Python examples call the corresponding getModelDescription or get_model_description method.

```JShell
opg4j> mr.getModelDescription(modelstore,modelName)
$14 ==> "DeepWalk: model desc"
```

```Java
mr.getModelDescription(modelstore,modelName);
```

```Python
>>> mr.get_model_description("modelstore","DeepWalkModel")
'DeepWalk model description'
```

--------------------------------

### Get AlgorithmProgress for PageRank in JShell

Source: https://docs.oracle.com/en/database/oracle/property-graph/26.1/spgdg/getting-progress-running-algorithm.html

JShell session that reads a graph, starts PageRank asynchronously, and obtains the AlgorithmProgress object via FutureProgress.asAlgorithmExecutionProgress(). The output shows the graph and future objects.

```java
opg4j> var graph = session.readGraphByName("BANK_TXN_GRAPH", GraphSource.PG_PGQL)
g ==> PgxGraph[name=BANK_TXN_GRAPH,N=1000,E=4993,created=1712307339271]
opg4j>  var future = analyst.pagerankAsync(graph)
future ==> oracle.pgx.api.PgxFuture@1dfe5dd1[Not completed]
opg4j> var futureProgress = future.getProgress()
futureProgress ==> oracle.pgx.api.DefaultFutureProgress@6d7bb5cc
opg4j> var algorithmProgress = futureProgress.asAlgorithmExecutionProgress()

```

--------------------------------

### Start SQLcl with database credentials

Source: https://docs.oracle.com/en/database/oracle/property-graph/26.1/spgdg/additional-client-tools-querying-pgql-property-graphs.html

Connects to SQLcl as a database user. Replace graphuser, password, and tns_alias with your credentials.

```sql
sql graphuser/<password_for_graphuser>@<tns_alias>

SQLcl: Release 21.2 Production on Sun Jan 30 04:30:09 2022
Copyright (c) 1982, 2022, Oracle.  All rights reserved.
Connected to:
Oracle Database 21c Enterprise Edition Release 21.0.0.0.0 - Production
Version 21.3.0.0.0
```

--------------------------------

### Run operations on a session-bound map

Source: https://docs.oracle.com/en/database/oracle/property-graph/26.1/spgdg/session-bound-maps.html

Demonstrates core map operations: put, get, size, containsKey, remove, and destroy. Shows that get returns null for missing keys, remove on a non-existent key does nothing, and put returns the previous value when replacing an existing key. The Java example contains a typo (inToDouble.size()) as in the source.

```groovy
intToDouble.put(0, 0.314)
intToDouble.put(1, 3.14)
intToDouble.put(2, 31.4)
intToDouble.put(3, 314)

println intToDouble.size()           // 4
println intToDouble.get(1)
println intToDouble.get(3)
println intToDouble.get(10)          // null

println intToDouble.containsKey(0)   // `true`
intToDouble.remove(0)
println intToDouble.containsKey(0)   // `false`
println intToDouble.containsKey(10)  // `false`
intToDouble.remove(10)
println intToDouble.containsKey(10)  // `false`

println intToDouble.put(1, 999)      //  previous mapped value (`3.14`) is replaced by `999`
intToDouble.destroy()
```

```java
import java.util.Arrays;
import oracle.pgx.api.*;

...

intToDouble.put(0, 0.314);
intToDouble.put(1, 3.14);
intToDouble.put(2, 31.4);
intToDouble.put(3, 314);

System.out.println(inToDouble.size());            // 4
System.out.println(intToDouble.get(1));
System.out.println(intToDouble.get(3));
System.out.println(intToDouble.get(10));          // null

System.out.println(intToDouble.containsKey(0));   // `true`
intToDouble.remove(0);
System.out.println(intToDouble.containsKey(0));   // `false`
System.out.println(intToDouble.containsKey(10));  // `false`
intToDouble.remove(10);
System.out.println(intToDouble.containsKey(10));  // `false`

System.out.println(intToDouble.put(1, 999));      //  previous mapped value (`3.14`) is replaced by `999`
intToDouble.destroy();
```

--------------------------------

### Run LOCALFS_INSTALLER.sql

Source: https://docs.oracle.com/en/database/oracle/property-graph/26.1/spgdg/quick-start-creating-sql-property-graph-importing-graph-data-neo4j.html

Runs the LOCALFS_INSTALLER.sql script as the migneo4jrep user to create all packages and tables required for script generation.

```sql
@\<file_path>\LOCALFS_INSTALLER.sql
```

--------------------------------

### Create Instance and Session in Java

Source: https://docs.oracle.com/en/database/oracle/property-graph/26.1/spgdg/using-autonomous-ai-database-graph-client.html

Creates a ServerInstance and a PgxSession named 'AdbGraphSession'.

```java
ServerInstance instance = client.getPgxInstance();
PgxSession session = instance.createSession("AdbGraphSession");
```

--------------------------------

### BELLMAN-FORD Query Output (First 5 Rows)

Source: https://docs.oracle.com/en/database/oracle/property-graph/26.1/spgdg/graph-algorithm-functions-supported-dbms_oga.html

Shows the first five rows returned by the example BELLMAN-FORD query. The output lists the vertex ID and the computed cost (shortest distance) from the start vertex.

```text
"ID"     "COST"
 101	  0
 418	  1751
 207	  3065
 261	  3888
 794	  5046
```

--------------------------------

### Create Instance and Session in Python

Source: https://docs.oracle.com/en/database/oracle/property-graph/26.1/spgdg/using-autonomous-ai-database-graph-client.html

Creates a ServerInstance and a PgxSession named 'adb-session'.

```python
>>> instance = client.get_pgx_instance()
>>> session = instance.create_session("adb-session")
```

--------------------------------

### Disable TLS and set JDBC URL with quicksetup.sh

Source: https://docs.oracle.com/en/database/oracle/property-graph/26.1/spgdg/using-rpm-installation.html

Disables TLS and configures the JDBC URL through a parameter.

```bash
./quicksetup.sh -j jdbc:oracle:thin:@<host>:<port>/<sid> -d
```

--------------------------------

### Install python3-devel with yum

Source: https://docs.oracle.com/en/database/oracle/property-graph/26.1/spgdg/oracle-graph-python-client.html

Run this command to ensure that python3-devel is installed on your system, a prerequisite for installing the Python client from the Graph Server and Client downloads.

```bash
sudo yum install python3-devel
```

--------------------------------

### Connect to PGX with Java using getInstance()

Source: https://docs.oracle.com/en/database/oracle/property-graph/26.1/spgdg/connecting-graph-server-pgx.html

Creates a ServerInstance by passing the base URL, username, and password to GraphServer.getInstance(). Then creates a PgxSession with createSession().

```java
import oracle.pgx.api.*;
import oracle.pg.rdbms.*;
ServerInstance instance = GraphServer.getInstance("https://<hostname>:<port>","<username>","<password>".toCharArray());
PgxSession session = instance.createSession("my-session");
```
Tokens:
Raw