Mllp v2 and the sample projects, Creating and configuring the mllp v2.0 database, To create and connect to the database – Sun Microsystems Sun Adapter IP HL 7 User Manual
Page 140
MLLP V2 and the Sample Projects
Minimal Lower Layer Protocol Release 2 (MLLP V2.0) is a message transport protocol, and is
required for all message transport protocols used to transport HL7 Version 3 content. This
protocol wraps the HL7 message to indicate the beginning and end of each message.
The following topics provide instruction on how to set up the MLLP database, and describe
MLLP V2.0 and the MLLP V2.0 sample Project provided with the TCP/IP HL7 Adapter:
■
“Creating and Configuring the MLLP V2.0 Database” on page 140
■
“MLLP V2 Content Exchange Model” on page 144
■
“Standard Inbound HL7 V2 Collaboration Overview over MLLPV2” on page 146
Creating and Configuring the MLLP V2.0 Database
Using the HL7 Adapter with MLLP V2.0 transport scenarios requires an MLLP database. This
topic describes the steps to connect to Sun's Java Database (based on the Apache Derby
database) and run the MLLP V2.0 database scripts.
The TCP/IP HL7 Adapter supports the following database platforms for the MLLP database:
■
DB2
■
Java DB (Derby)
■
Oracle
■
Microsoft SQL Server
■
Sybase
Perform the following steps in the order given to set up the MLLP database:
■
“To Create and Connect to the Database” on page 140
■
“To Run the MLLP V2.0 Database Scripts” on page 142
■
“To Create the Connection Pool and JDBC Resource” on page 144
■
“Associating the MLLP Database With the Adapter” on page 144
▼
To Create and Connect to the Database
Create a database instance using your database platform tools. If you are using a Java DB
database, perform the following steps to create the database:
a. On the NetBeans Services window, expand Databases.
b. Right-click Java DB, and then click Create Database.
The Create Java DB Database dialog box appears.
c. Enter a name for the database, along with a login user name and password.
1
MLLP V2 and the Sample Projects
Sun Adapter for TCP/IP HL7 User's Guide • October 2009
140