无法将IBMi计算机与Spring Data和JPA连接

p4rjhz4m  于 2023-10-20  发布在  Spring
关注(0)|答案(3)|浏览(180)

尝试使用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似乎没有提供最简单的方法。
我的项目类是:

  1. 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();
        }
    }
  1. 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);
        }
    }
  1. 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数据库。

dsekswqp

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中这样设置它:

@Bean
@ConfigurationProperties(prefix = "spring.datasource")
public DataSource as400DataSource() {
    HikariDataSource dataSource = (HikariDataSource) DataSourceBuilder.create().build();
    dataSource.setConnectionTestQuery("values 1");
    return dataSource;
}

现在一切正常

ddrv8njm

ddrv8njm2#

尝试在@SpringBootApplication下面添加@EnableJpaRepositories注解

txu3uszq

txu3uszq3#

我没有(在我的特定情况下)使用Spring Data和JPA,只是使用Maven和jt 400版本9.5,并得到了相同的错误(isValid未实现)。我升级到jt 400-jdk 8版本11.1,解决了这个问题。

相关问题