When the Transformation map (prepared as Java executable file) runs, it will use JDBC to establish the connection to the Firebird database on your network. This connection is initiated from the server computer on which the transformation map executes.
LANSA Composer prepares the JDBC connection according to the Database Configuration that you provide as a parameter to the Transformation Map. You must define the Database Configuration with the correct details necessary to establish the particular database connection to be used.
The following sample values assume that you are using the JayBird JDBC driver for Firebird to connect to the Firebird database:
Database driver class | Following is the class name used with the JayBird JDBC driver: org.firebirdsql.jdbc.FBDriver |
|---|---|
Database connection string | Following is a sample JDBC connection string to connect to the Firebird database EMPLOYEE.FDB at the specified path through the Firebird instance running on the server MYSERVER: jdbc:firebirdsql://MYSERVER:3050/C:\Program Files (x86)\Firebird\Firebird_2_5\examples\empbuild\EMPLOYEE.FDB |
Refer also to:
Additional information and resources for Firebird