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");
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.