seo-kw commented on issue #76:
URL: https://github.com/apache/incubator-age/issues/76#issuecomment-850390215
>
>
> Did you execute `LOAD 'age';` and `SET search_path = ag_catalog, "$user",
public;` on your connection before executing the query above?
>
> Probably something like this (again, I haven't tried this and I am not
familiar with JDBC):
>
> ```
> Connection conn = connectionHelper.createConnection();
>
> Statement loadStatement = conn.createStatement();
> statement.execute("LOAD 'age'");
> statement.execute("SET search_path = ag_catalog, \"$user\", public;");
>
> PreparedStatement pstmt = conn.prepareStatement(
> "select * from cypher('a', $$ "+
> "match (a) where a.id = $id return properties(a)" +
> "$$, ?) as (a agtype););");
> pstmt.setString(1, "{\"id\": 281474976710667}");
> ResultSet resultset = pstmt.executeQuery();
> conn.close();
> ```
----
Hello again. Wow, thanks for the fast reply! I got dinner so am quite late
lol.
Then, sure. It's a kind of basic process to using age.
I did that process in another class. and like this.
```
Statement statement = connection.createStatement();
statement.execute("CREATE EXTENSION IF NOT EXISTS age;");
statement.execute("LOAD 'age';");
statement.execute("set search_path = a, ag_catalog, \"$user\",
public");
```
And also created graph using `SELECT create_graph('a')` function.
You're not familiar with jdbc but you've done this for me. Thanks a lot. But
I supposed to it's kind of AGE's core architectural algorithm problem.
No offense, If I am something wrong, feel free to tell me then, I would be
happy.
It's almost the weekend, have a nice week guys.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
[email protected]
