Runtime components : Channels components : Key features : Concepts : Channel management : Channel data model : Configuring the channel data model
  
Configuring the channel data model
The UNICOM® Digital Transformation Toolkit (UDTT™) Channel Data Model follows the JPA standards to persist channel data. Before deploying, you should follow the JPA standards to configure the JDBC Connections. The following steps introduce how to configure:
1 Specify the file bttchanneldata.jar in your class path. This JAR file is located at ${btt_root}/lib/bttchanneldata.jar.
2 Specify the file com.ibm.ws.jpa.thinclient.0.jar standalone Java archive (JAR) in your class path. This standalone JAR file is available from the client and server installation images. The location of this file on the client install image is ${app_client_root}/runtimes/com.ibm.ws.jpa.thinclient.0.jar. The location of this file on the server install image is ${app_server_root}/runtimes/com.ibm.ws.jpa.thinclient.0.jar.
3 Specify the database connection driver jar in your class path. For DB2 v9 or v9.5 or v9.7, the driver JAR files are db2jcc.jar and db2jcc_license_cisuz.jar; For Oracle 11, the driver JAR file is ojdbc14.jar; For SQL Server 2005, the driver JAR file is sqljdbc.jar.
4 Create database, and then run the DDL files accordingly to the database type to generate or update the tables. The DDL files are available from the file bttchanneldata.jar. For DB2, the DDL file is channelManagement.DDL; For Oracle, the DDL file is channelManagement_oracle.DDL; For SQL Server, the DDL file is channelManagement_sqlserver.DDL.
5 In the persistence.xml, specify your database configuration options.
If you want to connect to DB in URL mode, specify as following:
For DB2, specify as following configuration:
<property name="openjpa.ConnectionDriverName" value="com.ibm.db2.jcc.DB2Driver" />
<property name="openjpa.ConnectionURL" value="jdbc:db2://SERVER_NAME:50000/DB_NAME" />
<property name="openjpa.ConnectionUserName" value="USER_NAME" />
<property name="openjpa.ConnectionPassword" value="USER_PASSWORD" />
</properties>
For Oracle, specify as following configuration:
<property name="openjpa.ConnectionDriverName" value="oracle.jdbc.driver.OracleDriver" />
<property name="openjpa.ConnectionURL" value="jdbc:oracle:thin:SERVER_NAME:1521:DB_NAME" />
<property name="openjpa.ConnectionUserName" value="USER_NAME" />
<property name="openjpa.ConnectionPassword" value="USER_PASSWORD" />
</properties>
For SQL Server, specify as following configuration:
<property name="openjpa.ConnectionDriverName" value=" com.microsoft.sqlserver.jdbc.SQLServerDriver " />
<property name="openjpa.ConnectionURL" value=" jdbc:sqlserver://SERVER_NAME:1433;DatabaseName=DB_NAME/>
<property name="openjpa.ConnectionUserName" value="USER_NAME" />
<property name="openjpa.ConnectionPassword" value="USER_PASSWORD" />
</properties>
If you want to connect to DB in DataSource mode, specify as following:
<jta-data-source>JNDI_of_DataSource</jta-data-source>
<properties>
<property name="openjpa.jdbc.Schema" value="schema_NAME" />
</properties>
Note If you use SQL Server, the DataSource mode is not commended.
Go up to
Channel data model