I found the blog post to bypass the use of OID and rather store inline: https://blog.trifork.com/2017/10/09/axon-postgresql-without-toast/
Problem is, I am seeing the following error when I try to follow the documentation from the site:
Caused by: org.springframework.beans.factory.BeanCurrentlyInCreationException: Error creating bean with name ‘axonEntityManagerFactory’: Requested bean is currently in creation: Is there an unresolvable circular reference?
I am setting my dialect within my application.properties as so: spring.jpa.properties.hibernate.dialect = com.ge.energy.markets.bids.demand.eventsourcing.db.AxonPostgreSQLDialect
This is how I am creating my axonEntityManagerFactory bean (the only difference is that I pass in the JpaVendorAdapter, as I figure this is preconfigured by Spring?):
@Bean(name = “axonEntityManagerFactory”)
@Primary
@Lazy
public LocalContainerEntityManagerFactoryBean axonEntityManagerFactory(
DataSource dataSource,
@Qualifier(“jpaProperties”) Properties jpaProperties,
JpaVendorAdapter jpaVendorAdapter) {
final LocalContainerEntityManagerFactoryBean em = new LocalContainerEntityManagerFactoryBean();
em.setDataSource(dataSource);
em.setPackagesToScan(
“org.axonframework.eventsourcing.eventstore.jpa”,
“org.axonframework.eventhandling.saga.repository.jpa”,
“org.axonframework.eventhandling.tokenstore.jpa”);
em.setJpaVendorAdapter(jpaVendorAdapter);
em.setJpaProperties(jpaProperties);
em.setMappingResources("/orm.xml");
return em;
}
Please help, as I seem to be unable to read any events, seeing as these objects are stored as LOB objects and I never seem to be able to pull them down. I am going through this trouble as I just want to pull down all events, from my PostgreSQL DB, based on mrid…