cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Biswajeet Basumatary <biswajeet.basumat...@gmail.com>
Subject Execute native SQL statements
Date Wed, 08 Apr 2020 03:21:07 GMT
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");

Mime
View raw message