springboot-load-a-h2-table-from-an-oracle-database

[Deepak Gunasekaran]

Hello All,

In a spring boot application startup, i would like to populate a table in the in memory H2 database from a table in oracle database.

Is there an out of the box way to do this ? I am going over configuring multiple data bases with spring : Spring Boot Configure and Use Two DataSources

but all i need is one time load from oracle table into H2 table. So is there a cleaner way to do this? 

Apart from initialisation, i don't need oracle table any further. 

Thank you! 

-Deepak 

[Evgenij Ryazanov]

Hello.

You can register a linked table

https://h2database.com/html/commands.html#create_linked_table

and create its copy as a normal table with

CREATE TABLE tableName AS TABLE linkedTableName

After that the linked table may be dropped.

Indexes and constraints will not be copied, so if they're needed, you need to create them separately.

[Deepak Gunasekaran]

Thank you , is there an example for this usage in spring , where do i configure the linked table in spring boot.