Create axon tables in oracle

Axon Framework
, ,
#1

Hi I want to use axon framework with oracle.For that reason I manually created tables in oracle like myschema.TOKEN_ENTRY,myschema.SAGA_ENTRY etc

For some reason I cant use spring autoconfigure database option,How can I establish relation between axon jpa and entities,should I create manuelly SAGA_ENTRY entity in my code or something else
Myconfiguration like that in spring code

@Configuration
@EnableTransactionManagement
@EnableJpaRepositories(
entityManagerFactoryRef = “myEntityManagerFactory”,
transactionManagerRef = “myTransactionManager”,
basePackages = {
“org.axonframework.eventsourcing.eventstore.jpa”,
“org.axonframework.eventhandling.tokenstore.jpa”,
“org.axonframework.modelling.saga.repository.jpa”
}
)
public class MyDBConfiguration {

@Bean(name = "myEntityManagerFactory")
@Primary
public LocalContainerEntityManagerFactoryBean

myManagerFactory(EntityManagerFactoryBuilder builder) {
LocalContainerEntityManagerFactoryBean em = builder
.dataSource(myDBDataSource())
.packages(

                         "com.myproject.mydemo.model.jpa.axon"
#2

Hi @Bilgehanyildiz,

Are you using Spring Boot? I would assume so.
In that case, you can probably just configure it on your application.yml (or properties).

I haven’t tried myself but something like this should work!

hibernate.dialect=org.hibernate.dialect.Oracle12cDialect
spring.jpa.hibernate.ddl-auto=create #or update or any other option
spring.jpa.generate-ddl=true
spring.datasource.url=
spring.datasource.username=
spring.datasource.password=
spring.datasource.driver.class=oracle.jdbc.driver.OracleDriver

KR,

#3

Hi Lucas ,You are right it works when you like that but due to some reason,I cant work like that.
I have to manually configure datasource and I have to add axon tables to specific schemas.How can I achive that ?

1 Like
#4

Hi, the following works for developing on development system. But need to take this to production environment were mentioning auto create isn’t going to work. Is there a workaround?

#5

Hi Lucas can you give us more detail?to specify schema

#6

Schema is spicific to Oracle. Something I’ve done in the past for a similar issue, is to have an Oracle instance locally, and then copy the schema.

#7

can you give more detail?please gerard

how can you specify schema?

#8

If you can run it locally, with an auto created schema, you can than copy that schema for other instances. At least that’s how I worked around something similar earlier.