ODE内嵌数据库Derby，同时支持其他诸如MySQL数据库等。

为支持MySQL数据库，首先将MySQL JDBC驱动放置于$CATALINA_HOME/lib 目录；然后下载最新版本的bitronix，并将文档同样拷贝到lib目录，包括：

btm-2.1.4.jar
btm-tomcat55-lifecycle-2.1.4.jar
geronimo-jta_1.1_spec-1.1.1.jar
slf4j-api-1.6.4.jar
slf4j-jdk14-1.6.4.jar

配置数据源$CATALINA_HOME/conf/resources.properties

resource.ds2.className=bitronix.tm.resource.jdbc.lrc.LrcXADataSource
resource.ds2.uniqueName=jdbc/ode
resource.ds2.minPoolSize=10
resource.ds2.maxPoolSize=50
resource.ds2.driverProperties.driverClassName=com.mysql.jdbc.Driver
resource.ds2.driverProperties.url=jdbc:mysql://localhost:3306/ode
resource.ds2.driverProperties.user=
resource.ds2.driverProperties.password=
resource.ds2.allowLocalTransactions=true
resource.ds2.shareTransactionConnections=true

在$CATALINA_HOME/conf/Catalina/localhost 目录创建ode.xml

<Context reloadable="true" crossContext="true">    
   <Resource   
       name="jdbc/ode"   
       auth="Container" type="javax.sql.DataSource"   
       factory="bitronix.tm.resource.ResourceObjectFactory"   
       uniqueName="jdbc/ode" />  
</Context>

在ode/WEB-INF/web.xml 添加资源引用

<resource-ref>  
    <res-ref-name>jdbc/ode</res-ref-name>  
    <res-type>javax.sql.DataSource</res-type>  
    <res-auth>Container</res-auth>  
    <res-sharing-scope>Shareable</res-sharing-scope>  
</resource-ref>

在ode/WEB-INF/conf/lib目录删除geronimo-jta_1.1_spec-1.1.jar

在ode/WEB-INF/conf/ode-axis2.properties增加配置

ode-axis2.tx.factory.class=org.apache.ode.axis2.util.TomcatFactory
ode-axis2.db.mode=EXTERNAL
ode-axis2.db.ext.dataSource=java:comp/env/jdbc/ode

下载ode-1.3.4-jpa-mysql55.sql ，并导入数据库

$ mysql -u root
mysql> create database ode;
mysql> exit
$ mysql -u root ode < ode-1.3.4-jpa-mysql55.sql

Mysql

results matching ""

No results matching ""