尝试使用Spring Data和JPA连接IBMi机器,但它生成错误:
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'entityManagerFactory' defined in class path resource [HibernateJpaConfiguration.class]: Bean instantiation via factory method failed;
nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean]: Factory method 'entityManagerFactory' threw exception; nested exception is java.lang.AbstractMethodError: Receiver class com.ibm.as400.access.AS400JDBCConnectionImpl does not define or inherit an implementation of the resolved method 'abstract boolean isValid(int)' of interface java.sql.Connection.
at org.springframework.beans.factory.support.ConstructorResolver.instantiate(ConstructorResolver.java:658) ~[spring-beans-5.3.8.jar:5.3.8]
at spring.security.as400.SpringSecurityDemoApplication2.main(SpringSecurityDemoApplication2.java:10) ~[classes/:na]
Caused by: org.springframework.beans.BeanInstantiationException: Failed to instantiate [org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean]: Factory method 'entityManagerFactory' threw exception; nested exception is java.lang.AbstractMethodError: Receiver class com.ibm.as400.access.AS400JDBCConnectionImpl does not define or inherit an implementation of the resolved method 'abstract boolean isValid(int)' of interface java.sql.Connection.
at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:185) ~[spring-beans-5.3.8.jar:5.3.8]
Caused by: java.lang.AbstractMethodError: Receiver class com.ibm.as400.access.AS400JDBCConnectionImpl does not define or inherit an implementation of the resolved method 'abstract boolean isValid(int)' of interface java.sql.Connection.
at com.zaxxer.hikari.pool.PoolBase.checkValidationSupport(PoolBase.java:458) ~[HikariCP-3.4.5.jar:na]
该项目是学习Spring Data的入门项目,使用JPA连接IBMi机器,但Spring Data似乎没有提供最简单的方法。
我的项目类是:
- pom.xml
<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd">
<modelVersion>4.0.0</modelVersion>
<parent>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-parent</artifactId>
<version>2.4.7</version>
<relativePath/> <!-- lookup parent from repository -->
</parent>
<groupId>Spring-Security-JT400</groupId>
<artifactId>Security-JT400</artifactId>
<version>0.0.1-SNAPSHOT</version>
<name>Security-JT400</name>
<description>Demo project for Spring Boot</description>
<properties>
<java.version>1.8</java.version>
</properties>
<dependencies>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-data-jpa</artifactId>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-security</artifactId>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<scope>runtime</scope>
</dependency>
<dependency>
<groupId>net.sf.jt400</groupId>
<artifactId>jt400</artifactId>
<version>10.6</version>
<scope>runtime</scope>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-test</artifactId>
<scope>test</scope>
</dependency>
<dependency>
<groupId>org.springframework.security</groupId>
<artifactId>spring-security-test</artifactId>
<scope>test</scope>
</dependency>
</dependencies>
<build>
<plugins>
<plugin>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-maven-plugin</artifactId>
</plugin>
</plugins>
</build>
</project>
1.配置
@Configuration
@EnableWebSecurity
public class WebSecurityConfiguration extends WebSecurityConfigurerAdapter
{
@Autowired
CustomUserDetailsService customUserDetailsService;
@Bean
AuthenticationProvider authenticationProvider()
{
DaoAuthenticationProvider provider = new DaoAuthenticationProvider();
provider.setUserDetailsService(customUserDetailsService);
provider.setPasswordEncoder(new BCryptPasswordEncoder());
return provider;
}
@Override
protected void configure(HttpSecurity http) throws Exception
{
http.authorizeRequests()
.antMatchers("/").permitAll()
.antMatchers("/home").hasAuthority("USER")
.antMatchers("/admin").hasAuthority("ADMIN")
.anyRequest().authenticated()
.and()
.httpBasic();
}
}
- CustomUserDetailsService
@Service
public class CustomUserDetailsService implements UserDetailsService
{
@Autowired
private UserRepository userRepository;
@Override
public UserDetails loadUserByUsername(String username) throws UsernameNotFoundException
{
User user = userRepository.findByUsername(username);
if (user == null)
{
throw new UsernameNotFoundException("User not found.");
}
return new CustomUserDetails(user);
}
}
@Repository
public interface UserRepository extends JpaRepository<User, Integer>
{
public User findByUsername(String username);
}
@RestController
public class HomeController
{
@GetMapping("/home")
public String home()
{
return "This is Home Page.";
}
@GetMapping("/admin")
public String admin()
{
return "This is Admin Page.";
}
}
public class CustomUserDetails implements UserDetails
{
private User user;
public CustomUserDetails(User user)
{
super();
this.user = user;
}
private static final long serialVersionUID = -228521734196009612L;
@Override
public Collection<? extends GrantedAuthority> getAuthorities()
{
return Collections.singleton(new SimpleGrantedAuthority(user.getRole()));
}
@Override
public String getPassword()
{
return user.getPassword();
}
@Override
public String getUsername()
{
return user.getUsername();
}
@Override
public boolean isAccountNonExpired()
{
return true;
}
@Override
public boolean isAccountNonLocked()
{
return true;
}
@Override
public boolean isCredentialsNonExpired()
{
return true;
}
@Override
public boolean isEnabled()
{
return true;
}
}
@Entity
public class User
{
@Id
private int id;
private String username;
private String password;
private String role;
}
@SpringBootApplication
public class SpringSecurityDemoApplication2 {
public static void main(String[] args) {
SpringApplication.run(SpringSecurityDemoApplication2.class, args);
}
}
- application.properties
spring.datasource.url=jdbc:as400://192.168.xx.xxx/;translate binary=true;prompt=false
spring.datasource.username=USERNAME
spring.datasource.password=PASSWORD
spring.datasource.driver-class-name=com.ibm.as400.access.AS400JDBCDriver
spring.jpa.database-platform=org.hibernate.dialect.DB2400Dialect
注意:使用相同的类,并在application.properties中进行修改,可以连接MYSQL数据库。
3条答案
按热度按时间dsekswqp1#
我也有同样的问题。问题是似乎方法
abstract boolean isValid(int)
没有实现,或者不能正确工作(我不确定)。基本上,它检查到DB的连接是否健康。幸运的是,您可以将其更改为您自己的。在spring Boot 中,只需添加到application.properties即可:spring.datasource.hikari.connection-test-query: values 1
对于我来说,值1起作用(我使用的是AS400 DB2),但对于其他DB,您可能需要使用不同的值check this answer
我有多个Datasheet,不幸的是,将它们添加到application.properties是不够的,我不得不在Persistancestrator中这样设置它:
现在一切正常
ddrv8njm2#
尝试在@SpringBootApplication下面添加@EnableJpaRepositories注解
txu3uszq3#
我没有(在我的特定情况下)使用Spring Data和JPA,只是使用Maven和jt 400版本9.5,并得到了相同的错误(isValid未实现)。我升级到jt 400-jdk 8版本11.1,解决了这个问题。