Execute native SQL statements
Biswajeet Basumatary <[email protected]>
| Newsgroups | gmane.comp.java.cayenne.user |
|---|---|
| Message-ID | <pony-4677e96974363e75f25ee910716bb13e8061787f-a52f6c0913aef9ee5284d0d46d963c873c4b5fbc@user.cayenne.apache.org> |
Hi ,
How to execute the following statements in Cayenne. Trying to access Oracle schema using different account having select permission.
SET ROLE browse_japan;
ALTER SESSION SET CURRENT_SCHEMA = JAPAN;
Regards,
basu
Note in JDBC I can execute the following it works
.
Connection connection = dataSource.getConnection();
connection.createStatement().execute("SET ROLE browse_japan");
connection.createStatement().execute("ALTER SESSION SET CURRENT_SCHEMA = JAPAN");