java jdbc 跨表复制,database - 使用Java Spring在两个jdbc数据库之间进行复制 - 堆栈内存溢出...

我需要在两个数据库(pg＆vertica)之间复制数据，并找到类似的解决方案并将其稍作更改。

@Configuration

public class PersistanceConfig {

@Autowired

private JpaVendorAdapter jpaVendorAdapter;

@Value("${spring.datasource.sourceDatabaseUrl}")

private String sourceDatabaseUrl;

@Value("${sping.datasource.targetDatabaseUrl")

private String targetDatabaseUrl;

@Value("${spring.datasource.sourceUsername}")

private String sourceUsername;

@Value("${spring.datasource.targetUsername}")

private String targetUsername;

@Value("${spring.datasource.sourcePassword}")

private String sourcePassword;

@Value("${spring.datasource.targetPassword}")

private String targetPassword;

@Bean

public EntityManager sourceEntityManager() {

return sourceEntityManagerFactory().createEntityManager();

}

- -豆子 - -

@Bean

public PlatformTransactionManager targetTransactionManager() {

return new JpaTransactionManager(targetEntityManagerFactory());

}

/* @Bean

public JpaVendorAdapter jpaVendorAdapter() {

HibernateJpaVendorAdapter hibernateJpaVendorAdapter = new HibernateJpaVendorAdapter();

return hibernateJpaVendorAdapter;

}*/

private EntityManagerFactory createEntityManagerFactory(final String persistenceUnitName,

final String databaseUrl, final String dbuser, final String dbpass) {

final LocalContainerEntityManagerFactoryBean entityManagerFactory = new LocalContainerEntityManagerFactoryBean();

final DriverManagerDataSource dataSource = new DriverManagerDataSource(databaseUrl, dbuser, dbpass);

//dataSource.setDriverClassName(driverClassName);

entityManagerFactory.setDataSource(dataSource);

entityManagerFactory.setJpaVendorAdapter(jpaVendorAdapter);

entityManagerFactory.setPackagesToScan("com.example.model");

entityManagerFactory.setPersistenceUnitName(persistenceUnitName);

final Properties properties = new Properties();

//properties.setProperty("hibernate.dialect", dialect);

//properties.setProperty("hibernate.hbm2ddl.auto", ddlAuto);

entityManagerFactory.setJpaProperties(properties);

entityManagerFactory.afterPropertiesSet();

return entityManagerFactory.getObject();

}

}

但是当我把mvn包清理干净时-有错误。

Field jpaVendorAdapter in xxx.PersistanceConfig required a bean of type 'org.springframework.orm.jpa.JpaVendorAdapter' that could not be found.

我的问题在哪里？

当我使用jpaVendorAdapter创建bean时，程序包失败并出现类似错误。

或完成我的有关在数据库之间复制数据的任务的其他建议。