將 Derby 內嵌資料來源移轉至 Liberty

您可以將 Derby 內嵌資料來源移轉至 Liberty

關於這項作業

關於WebSphere® Application Server 傳統版Liberty 中的 Derby 內嵌資料來源配置,請參閱下列程式碼範例。

範例

WebSphere Application Server 傳統版中:

<resources.jdbc:JDBCProvider xmi:id="JDBCProvider_1183122153343" 
          providerType="Derby JDBC Provider"
          implementationClassName="org.apache.derby.jdbc.EmbeddedConnectionPoolDataSource"
          xa="false">
   <classpath>${DERBY_JDBC_DRIVER_PATH}/derby.jar</classpath>
   <factories xmi:type="resources.jdbc:DataSource" xmi:id="DataSource_1183122153625"
          name="DefaultDerbyDatasource" jndiName="jdbc/DefaultDatasource"
          providerType="Derby JDBC Provider" authMechanismPreference="BASIC_PASSWORD"
          relationalResourceAdapter="builtin_rra" statementCacheSize="10"
          datasourceHelperClassname="com.ibm.websphere.rsadapter.DerbyDataStoreHelper">
      <propertySet xmi:id="J2EEResourcePropertySet_1183122153625">
         <resourceProperties xmi:id="J2EEResourceProperty_1183122153625" name="databaseName"
          type="java.lang.String" value="C:/myDerby/DefaultDB" required="true"/>
         <resourceProperties xmi:id="J2EEResourceProperty_1183122153626" name="shutdownDatabase"
          type="java.lang.String" value="false" required="false"/>
         <resourceProperties xmi:id="J2EEResourceProperty_1183122153629" name="connectionAttributes"
          type="java.lang.String" value="upgrade=true" required="false"/>
         <resourceProperties xmi:id="J2EEResourceProperty_1183122153630" name="createDatabase"
          type="java.lang.String" value="create" required="false"/>
      </propertySet>
      <connectionPool xmi:id="ConnectionPool_1183122153625" connectionTimeout="180"
          maxConnections="10" minConnections="1" reapTime="180" unusedTimeout="1800"
          agedTimeout="7200" purgePolicy="EntirePool"/>
   </factories>
</resources.jdbc:JDBCProvider>

Liberty 中,對等的配置如下:

<variable name="DERBY_JDBC_DRIVER_PATH" value="C:/Drivers/derby" />
<library id="derbyLib">
   <fileset dir="${DERBY_JDBC_DRIVER_PATH}" includes="derby.jar" />
</library>
<dataSource id="DefaultDerbyDatasource" jndiName="jdbc/DefaultDatasource" 
       statementCacheSize="10">
   <jdbcDriver libraryRef="derbyLib"
       javax.sql.ConnectionPoolDataSource="org.apache.derby.jdbc.EmbeddedConnectionPoolDataSource"/>
   <properties.derby.embedded
       databaseName="C:/myDerby/DefaultDB"
       shutdownDatabase="false"
       connectionAttributes="upgrade=true"
       createDatabase="create"
   />
   <connectionManager connectionTimeout="180" maxPoolSize="10" minPoolSize="1" reapTime="180"
       maxIdleTime="1800" agedTimeout="7200" purgePolicy="EntirePool" />
</dataSource>

指示主題類型的圖示 作業主題

檔名:twlp_migrate_ds_derby.html