Re: Cayenne And SpringBoot

Here’s what I did - but it’s a year + old…



Please note that it also integrates Hikari for connection pools.

With the above done, all you should have to do is:

	@Autowired
	ICayenneService cayenneService;

Again, I probably can’t answer questions too quickly, but hopefully this helps!

Ken


> On Aug 13, 2019, at 2:16 PM, John Huss <[email protected]> wrote:
> 
> You don't want to construct multiple ServerRuntimes, especially not one per
> context. You just need one runtime and you can create many contexts from it.
> 
> On Tue, Aug 13, 2019 at 1:09 PM Emerson Castañeda <[email protected]> wrote:
> 
>> I got this working using this approach:
>> 
>> *dependencies:*
>> 
>> //for persistency
>> compile 'org.apache.cayenne:cayenne-server:X.Y'
>> compile 'org.apache.cayenne:cayenne-java8:X.Y'
>> compile 'com.oracle:ojdbc.x.y.b'
>> 
>> 
>> *application.yml*
>> 
>> spring:
>>    application:
>>        name: app-api
>>        evnpath:
>>        cayenne_datasource:
>>            fpa:
>>                username: user
>>                password: pwd
>>                url: jdbc:oracle:thin:@server.org:1521/DEV.org
>>                driver: oracle.jdbc.driver.OracleDriver
>> 
>> 
>> *Configuration class:*
>> 
>> @Component
>> public class DataProviderService {
>> private static final Logger logger =
>> LoggerFactory.getLogger(DataProviderService.class);
>> List<ObjectContext> cayenneContexts = null;
>> @Autowired
>> private MyBeanPropertyReader myBeanPropertyReader;
>> 
>> private  ObjectContext cayenneContext(String user, String password,String
>> url, String driver) {
>> ServerRuntimeBuilder b = ServerRuntime.builder();
>> b = b.url(url);
>> b = b.jdbcDriver(driver);
>> b = b.user(user);
>> b = b.password(password);
>> b = b.addConfigs("cayenne-ExistentFacultyPortfolio.xml");
>> ServerRuntime cayenneRuntime = b.build();
>> return cayenneRuntime.newContext();
>> }
>> 
>> 
>> @PostConstruct
>> private void init(){
>> cayenneContexts =
>> 
>> Arrays.asList(cayenneContext(myBeanPropertyReader.getUser(),myBeanPropertyReader.getPassword(),
>> myBeanPropertyReader.getUrl(),myBeanPropertyReader.getDriver()));
>> 
>> logger.debug("DataProviderService init APPLICATION");
>> 
>> cayenneContexts.forEach(
>> oc -> oc.getEntityResolver()
>> .getDataMaps()
>> .forEach(dm -> logger.debug("DATAMAP : "+dm.getName())));
>> }
>> 
>> //any other method using the context
>> }
>> 
>> *Usage:*
>> 
>> @Autowired
>> private DataProviderService dataProviderService;
>> 
>> 
>> *Note:*
>> 
>> datanode and datamap are located in the usual place: src/main/resourcesMy
>> 
>> On Tue, Aug 13, 2019 at 12:29 PM Tony Giaccone <[email protected]> wrote:
>> 
>>> I want to look into using Cayenne with SpringBoot.  I was able to get a
>>> basic cayenne stack up and running by implementing a ContextListener  and
>>> on the create event starting up a Cayenne Runtime.  I was using an in
>>> memory database and I had problems getting the ;create=true working.  My
>>> hack was to set the strategy on the DataNode after the runtime after it
>>> was  spun up.
>>> 
>>> Has anyone done this before?  Are there any  suggestions  on what I
>> should
>>> be certain to do or avoid? Should I just spin up the standard Cayenne web
>>> filter?  Are there other choices?
>>> 
>>> Thanks for any help you can provide.
>>> 
>>> 
>>> Tony
>>> 
>>