jdbc event store not automatically creating tables ?

360 views
Skip to first unread message

jorgheymans

unread,
Jun 17, 2016, 6:42:11 AM6/17/16
to Axon Framework Users
Hi,

Following up on the quickstart guide i was looking to swap out the filesystem store with a jdbc store pointing to an Oracle database.

<axon:jdbc-event-store id="eventStore" data-source="dataSource" sql-schema="eventSqlSchema" force-utc-timestamp="true"/>

But when i then execute again the ToDoItemRunner i get an error 

Caused by: java.sql.SQLException: ORA-00942: table or view does not exist

Since the GenericEventSqlStore has methods to create the necessary tables i thought axon would take care of executing the necessary DDL. Not a big problem though, i can take care of creating the tables myself, and most people probably should to take full advantage of any database vendor specific features. But for this purpose it would be nice to document the "ansi92" DDL somewhere more visible, currently seems to be hidden only in GenericEventSqlSchema.

Thanks for this very interesting framework btw, looking forward to dig deeper into it !

Jorg

Allard Buijze

unread,
Jun 21, 2016, 5:58:25 AM6/21/16
to Axon Framework Users
Hi Jorg,

you're right. The tables currently aren't automatically created, primarily because of the vendor specific settings. 
We'll have a look at providing a bit more documentation around that option.

Thanks for the heads-up!
Cheers,

Allard

--
You received this message because you are subscribed to the Google Groups "Axon Framework Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to axonframewor...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
Reply all
Reply to author
Forward
0 new messages