Migration d'une source de données imbriquée Derby dans le profil Liberty
Vous pouvez migrer une source de données imbriquée Derby dans le profil Liberty.
Pourquoi et quand exécuter cette tâche
Exemple
Dans le profil complet :
<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>
Dans le profil Liberty, la configuration équivalente est :
<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/DefaultDerbyDatasource" 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>