无法将Spring Boot应用程序连接到IBM Informix数据库

Question

我无法将我的Spring Boot应用程序连接到IBM Informix数据库。我已经在application.yml文件中添加了informix数据源。

我使用的弹簧4

我碰到下面的错误。

类com.informix.jdbcx.IfxXADataSource

spring.profiles.active: db_dummy 


spring.mvc.view: 
    prefix: /WEB-INF/jsp/ 
    suffix: .jsp 


spring.messages.basename: static/resources/messages/pjMessageResource, static/resources/messages/pymacMessageResource, static/resources/messages/messageResource, static/resources/messages/base 


spring.datasource: 
    url: jdbc:informix-sqli://x.x.x.x:9093/testdb:informixserver=myserver; 
    driverClassName: com.informix.jdbc.IfxDriver 
    username: informix 
    password: sss 
    xa: 
     dataSourceClassName: com.informix.jdbcx.IfxXADataSource 


#---------------------------------------------------------- 


security.basic.enabled: false 

spring.jackson.serialization.INDENT_OUTPUT: true 


server.error.whitelabel.enabled: false 


management: 
    context-path: /_mep 
    security.enabled: false 
    #security.role: SUPERUSER 


multipart.maxFileSize: 10Mb 

spring: 
    jpa: 
     openInView: true 
     show-sql: false 
     properties: 
      hibernate: 
       connection.charSet: UTF-8 
       format_sql: true 
       use_sql_comments: true 
       jdbc: 
        batch_size: 30 
        fetch_size: 100 
      jadira: 
       usertype: 

        autoRegisterUserTypes: true 
        javaZone: jvm 
        databaseZone: jvm 





--- 

#---------------------------------------------------------------- 
# development 
#---------------------------------------------------------------- 
spring.profiles: development 


secondary.datasource: 
    url: jdbc:h2:mem:testdb;DB_CLOSE_DELAY=-1;DB_CLOSE_ON_EXIT=FALSE 
    driverClassName: org.h2.Driver 
    username: sa 
    password: 
    xa: 
     dataSourceClassName: org.h2.jdbcx.JdbcDataSource 
#---------------------------------------------------------- 



--- 
#---------------------------------------------------------------- 
# staging or production 
#---------------------------------------------------------------- 
spring.profiles: staging,production 


spring.jpa.database_platform: org.hibernate.dialect.InformixDialect 




--- 
#---------------------------------------------------------------- 
# psql 
#---------------------------------------------------------------- 
spring.profiles: informix 

spring.datasource: 
    url: jdbc:informix-sqli://x.x.x.x:9093/aaa:informixserver=test; 
    driverClassName: com.informix.jdbc.IfxDriver 
    username: informix 
    password: 
    xa: 
     dataSourceClassName: com.informix.jdbcx.IfxXADataSource 




--- 
#---------------------------------------------------------------- 
# h2 
#---------------------------------------------------------------- 
spring.profiles: h2 

spring.datasource: 
    url: jdbc:h2:mem:test;DB_CLOSE_DELAY=-1;DB_CLOSE_ON_EXIT=FALSE 
    driverClassName: org.h2.Driver 
    username: sa 
    password: 
    xa: 
     dataSourceClassName: org.h2.jdbcx.JdbcDataSource 

Answer 1

没有可写的属性 'URL' 有你在内）ifxjdbc & 2）ifxjdbcx罐名为1的罐子。