spring-boot-multi-hsql

A Spring-Boot-Example with an unlimted an easy to configure HSQL file based permanent database

Yeah, my intro to GitHub :-)

Description

From time to time I need more than one independet und permanent databases to

see whats going on in my tables during first steps of a new project
try out my XA-Transactions
do some rapid prototyping with permanent data

Spring-Boot Autoconfigure just provide only one database out of the box, if that is enough for you, stop reading.. to all the others ... feel free

Usage

Just clone the source
Edit FileDatabaseConfig and add your DataBaseServer with different ConfigurationProperties

    @ConfigurationProperties(prefix = "cool.database")
    @Bean 
    public HSQLFileDatabaseServer coolDataBase() {
	     return new HSQLFileDatabaseServerImpl(); // thats all, instantiate and starts the server
    }
  
    @ConfigurationProperties(prefix = "foo.database")
    @Bean 
    public HSQLFileDatabaseServer fooDataBase() {
	     return new HSQLFileDatabaseServerImpl(); // thats all, instantiate and starts the server
    }

edit the application.properties and add the values

# Cool-Database
cool.database.db-name=COOL_DB
cool.database.server-port=5000
cool.database.db-number=1
cool.database.drop-and-create=true
cool.database.create-script=createTableDest.sql
cool.database.fill-script=createRowsSrc.sql
# Foo Database
cool.database.db-name=FOO_DB
cool.database.server-port=6000
cool.database.db-number=3
......

put the sql-scripts in your classpath (main\resources)
Start the Spring-Boot Application an take a closer look at the log-File, the connection-String is there

 Your JDBC-Connection-String:  jdbc:hsqldb:hsql://mydomain:4000/COOL_DB

so start your favorite database tool, cut&paste the jdbc-connection String and see whats happens or use the DataSource-Bean in your code.

Need more ?

Take a closer look at the JUnit-Tests to see how to get the Datasource bind to your configured HSQLDatabaseServer

Thanks

...to the real cool employees of https://www.codecentric.de/

Springjunky/spring-boot-multi-hsql

ErrorLooks like something went wrong!

About

Topics

Resources

Uh oh!

Stars

Watchers

Forks

Releases

Packages 0

Uh oh!

Languages

Error
Looks like something went wrong!

Packages