jeewx2.1(jeecg3.4.3)从mysql数据库迁移到db2数据库

逃离我推掉我的手 2022-04-12 11:58 205阅读 0赞

从mysql迁移到db2，迁移工具IBM Migration Toolkit 2.0  
http://happyqing.iteye.com/blog/2263764

alibaba.druid的连接池连db2似乎不好用，

com.alibaba.druid.pool.DruidDataSource

可以换成c3p0的连接池

spring-mvc-hibernate.xml

<bean id="dataSource_jeecg" class="com.mchange.v2.c3p0.ComboPooledDataSource">
             
             <property name="user" value="${jdbc.username.jeecg}"/>
             
             <property name="password" value="${jdbc.password.jeecg}"/>
             <property name="driverClass" value="com.ibm.db2.jcc.DB2Driver"/>
             <property name="jdbcUrl" value="${jdbc.url.jeecg}"/>
    
               
             <property name="maxPoolSize" value="20"/>
             
             <property name="minPoolSize" value="2"/>
             
             <property name="initialPoolSize" value="2"/>
    
              
             <property name="maxIdleTime"  value="60" />
             
              
             <property name="checkoutTimeout" value="3000"/>
             
              
             <property name="acquireIncrement" value="2"/>
    
             
             <property name="acquireRetryAttempts" value="0"/>
    
              
             <property name="acquireRetryDelay" value="1000" />
    
              
             <property name="autoCommitOnClose" value="false" />
    
              
             <property name="automaticTestTable" value="Test" />
    
              
             <property name="breakAfterAcquireFailure" value="false" />
    
              
             <property name="idleConnectionTestPeriod" value="60" />
              
             <property name="maxStatements" value="100" />
              
             <property name="maxStatementsPerConnection" value="0" />
        </bean>

dbconfig.properties

#DB2 local
    hibernate.dialect=org.hibernate.dialect.DB2Dialect
    validationQuery.sqlserver=select 1 from sysibm.dual
    jdbc.url.jeecg=jdbc:db2://localhost:50000/jeewx:currentSchema=DB2ADMIN;
    jdbc.username.jeecg=db2admin
    jdbc.password.jeecg=db2admin
    jdbc.dbType=db2

jeewx2.1(jeecg3.4.3)从tomcat迁移的websphere需要修改的地方  
http://happyqing.iteye.com/blog/2264630