Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- hibernate.dialect=org.hibernate.dialect.SQLServer2012Dialect
- hibernate.show_sql=true
- hibernate.format_sql=true
- hibernate.default_schema=dbo
- hibernate.packagesToScan=src.repositories.LMClientRepository.java
- spring.jpa.generate-ddl=true
- spring.jpa.hibernate.naming-strategy=org.hibernate.cfg.DefaultNamingStrategy
- spring.datasource.username=***
- spring.datasource.password=***
- spring.datasource.url=jdbc:sqlserver://schqvsqlaod:1433;database=dbMOBClientTemp;integratedSecurity=false;
- spring.datasource.testOnBorrow=true
- spring.datasource.validationQuery=SELECT 1
- spring.jpa.database=dbMOBClientTemp
- spring.jpa.show-sql=true
- spring.jpa.hibernate.dialect=org.hibernate.dialect.SQLServer2012Dialect
- spring.datasource.driverClassName=com.microsoft.sqlserver.jdbc.SQLServerDriver
- package testApplication;
- import java.util.ArrayList;
- import java.util.List;
- import org.slf4j.Logger;
- import org.slf4j.LoggerFactory;
- import org.springframework.boot.CommandLineRunner;
- import org.springframework.boot.SpringApplication;
- import org.springframework.boot.autoconfigure.SpringBootApplication;
- import org.springframework.boot.orm.jpa.EntityScan;
- import org.springframework.cache.annotation.EnableCaching;
- import org.springframework.context.annotation.Bean;
- import org.springframework.data.jpa.repository.config.EnableJpaRepositories;
- import fileRetrieval.InputFileParse;
- import lmDataObjects.LMClientDO;
- import lmDataObjects.LoadMethodDO;
- import repositories.LMClientRepository;
- import repositories.LoadMethodRepository;
- @SpringBootApplication
- @EnableJpaRepositories(basePackageClasses = LoadMethodRepository.class)
- @EntityScan(basePackageClasses = LoadMethodDO.class)
- @EnableCaching
- public class Application {
- private static final Logger log = LoggerFactory.getLogger(Application.class);
- public static void main(String[] args) {
- SpringApplication.run(Application.class, args);
- }
- @Bean
- public CommandLineRunner demo(LoadMethodRepository lm_repo, LMClientRepository lmc_repo) {
- return (args) -> {
- List<LMClientDO> lmlist = InputFileParse.getMultiGroupfile();
- List<String> uniqueMediaIds = new ArrayList(InputFileParse.getUniqueMediaIds());
- for (int i = 0; i < InputFileParse.getUniqueMediaIds().size(); i ++){
- lm_repo.save(new LoadMethodDO(uniqueMediaIds.get(i)));
- }
- for (int i = 0; i < lmlist.size(); i++){
- lmc_repo.save(new LMClientDO(lmlist.get(i).getClientId(), lmlist.get(i).getMediaId()));
- }
- //Here is where I would like to do stuff with data from the other database that I have not connected yet
- };
- }
- }
- spring.datasource.username=***
- spring.datasource.password=***
- spring.datasource.url=jdbc:sqlserver://SCHQVSQLCON2VSPD:1433;database=dbMTS;integratedSecurity=false;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement