How to define HSQ DB properties in Spring JPA using annoations -

How to define HSQ DB properties in Spring JPA using annoations -

i running hsql db im memory using run manger swing.i have connect hsqldb server spring jpa repository using annotations. repository class.

@repositoryrestresource public interface vehicle extends jparepository<vehicle , biginteger>{ public list<vehicle > findall(sort sort); }

service method: @service

public class locationservice { @autowired vehicletrepository vehiclerepository = null; /** * method locations repository */ public list<vehicle> getvehicless() { order order = new order(direction.asc,"vehiclecode"); sort sort = new sort(order); list<airport> airports = vehicletrepository .findall(sort); system.out.println("inside service"); homecoming vehicles; } }

anyone help accomplish spring jpa conenction hsql db using annotations.

i assume dont utilize spring boot:

you need @configuration class -(it new way configure spring applications in java ) @enablejparepositories turn spring info jpa/ spring info rest you. have specify entity manager, transaction manager , info source beans. illustration below:

@configuration @enablejparepositories("your.package.with.repositories") public class dbconfig{ @bean public jpatransactionmanager transactionmanager() { jpatransactionmanager transactionmanager = new jpatransactionmanager(); transactionmanager.setentitymanagerfactory(entitymanagerfactory().getobject()); homecoming transactionmanager; } @bean public datasource datasource() { basicdatasource datasource = new basicdatasource(); dbconfigurationcommon.configuredb(datasource, your_jdbc_url_here, db_username_here, db_password_here); homecoming datasource; } @bean public localcontainerentitymanagerfactorybean entitymanagerfactory() { localcontainerentitymanagerfactorybean entitymanagerfactorybean = new localcontainerentitymanagerfactorybean(); entitymanagerfactorybean.setdatasource(datasource()); entitymanagerfactorybean.setjpavendoradapter(new hibernatejpavendoradapter()); //you may need define new properties(); here hibernate dialect , add together entity manager mill entitymanagerfactorybean.setpackagestoscan("your_package_with_domain_classes_here"); homecoming entitymanagerfactorybean; } }

spring jpa annotations hsqldb