Re: Cayenne And SpringBoot

Lovely…. I guess the list doesn’t support attachments…

CayenneService.java:

package com.theproductlab.cayenne;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.beans.factory.annotation.Value;
import org.springframework.core.env.Environment;
import org.springframework.stereotype.Service;
import org.apache.commons.logging.LogFactory;

import javax.annotation.PostConstruct;
import javax.annotation.PreDestroy;

import org.apache.cayenne.ObjectContext;
import org.apache.cayenne.configuration.server.ServerRuntime;
import org.apache.commons.logging.Log;

import com.zaxxer.hikari.HikariConfig;
import com.zaxxer.hikari.HikariDataSource;


@Service(value="com.theproductlab.cayenne.ICayenneService")

public class CayenneService implements ICayenneService {

	private static final Log LOGGER = LogFactory.getLog(CayenneService.class);

	private ObjectContext sharedContext;
	private ServerRuntime cayenneRuntime;

	@Value("#{systemProperties['cayenne.project.context']}")
	private String config;

	@Autowired
	private Environment environment;

	@PostConstruct
	void init() {
		
	//	String conf = config == null ? environment.getProperty("cayenne.project.context") : config ;
		
		HikariConfig confix = new HikariConfig();
		confix.setJdbcUrl(environment.getProperty("cayenne.jdbc.url"));
		confix.setUsername(environment.getProperty("cayenne.jdbc.username"));
		confix.setPassword(environment.getProperty("cayenne.jdbc.password"));
		confix.setMaximumPoolSize(Integer.valueOf( environment.getProperty("cayenne.jdbc.max_connections")));
		confix.setDriverClassName(environment.getProperty("cayenne.jdbc.driver"));
		confix.setConnectionTestQuery("SELECT 1");
		
		confix.addDataSourceProperty("socketTimeout", 1);
		confix.setMinimumIdle(0);
		confix.setIdleTimeout(1000);
		
		confix.setConnectionTimeout(20000);
		confix.setLeakDetectionThreshold(300000); //5 mins.
		HikariDataSource ds = new HikariDataSource(confix);

        cayenneRuntime = ServerRuntime.builder()
                .addConfig("cayenne-project.xml")
                .dataSource(ds)
                .build();
        
		sharedContext = cayenneRuntime.newContext();

		Runtime.getRuntime().addShutdownHook(new Thread( new Runnable() {
			
			@Override
			public void run() {
				if (cayenneRuntime != null) {
					cayenneRuntime.shutdown();
				}
			}
		}));
		
		LOGGER.info("Cayenne setup done");
		LOGGER.info(this);
	}

	@Override
	public ObjectContext sharedContext() {
		return sharedContext;
	}

	@Override
	public ObjectContext newObjectContext() {
		return cayenneRuntime.newContext();
	}
	
	@PreDestroy
	public void shutdown(){
		if (cayenneRuntime != null)
			cayenneRuntime.shutdown();
	}
}

ICayenneService.java:

package com.theproductlab.cayenne;

import org.apache.cayenne.ObjectContext;

public interface ICayenneService {

	ObjectContext sharedContext();
	ObjectContext newObjectContext();

}

My Application:

package com.theproductlab.vorjou;

import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;

import com.theproductlab.cayenne.CayenneService;
import com.theproductlab.cayenne.ICayenneService;

import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;

@Configuration
@SpringBootApplication
public class VorjouApplication {

	public static void main(String[] args) {
		SpringApplication.run(VorjouApplication.class, args);
	}


    @Bean
    public ICayenneService cayenneService() {
    	return new CayenneService();
    }
}


> On Aug 13, 2019, at 3:08 PM, Ken Anderson <[email protected]> wrote:
> 
> 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
>>>> 
>>> 
>