mrc logo mrc logo
  • m-Power m-Power
    What is m-Power?
    Overview Demos Build Process Case Studies Specs Pricing Trial
    m-Power Resources
    Overview How-To Videos Webinars & Podcasts White Papers Fact Sheets
  • Solutions Solutions
    What does m-Power build?
    Overview Data Exploration Reporting Business Intelligence Dashboards Mobile Apps ERP Enhancements Modernization Spreadsheets to the web B2B/Web Portals Scheduling Embedded Analytics Web Forms Workflow Database Front-Ends
    Solutions by Industry
    Overview Manufacturing Government Foodservice Software Vendors Logistics & Supply Chain Software Consultants Healthcare
  • Services Services
    Overview Training Project Consulting Staff Consulting Mentoring
  • About About
    Overview Partners Press Releases Careers Events Contact Blog
  • Support Support
    Support Home FAQ Documentation Customer Portal Enhancements Updates Roadmap Techblog
Try m-Power

m-Power Manual

Browse:

  • Home
  • m-Power Administration
  • Setting Up m-Power Applications to Handle Development & Production Data
Back to Manual

Setting Up m-Power Applications to Handle Development & Production Data

 
Click here to access the legacy version of this documentation.

After developing applications, it makes good sense to promote these applications to a production environment. There are many documents that explain how to do that on this site. For example, Set up a production instance. However, this document covers something very different from just having a development and production instance. What this document will cover is what if you want to have your development instance run over Test data, and your production instance run over live data.

For this to be successful, the table structure between your test and production libraries must be identical.

Develop, test, and paint your application as you normally would. By default, your applications will use, at run time, the same library your table resided in at development time. Essentially, the library name is hard coded. However, we can change that option by doing the following:

Click the "Admin Menu". Then click "Dictionary Configuration", and click "Runtime Application Settings."

Your screen will now resemble this:

Change the "tablename_fmt" value from "Include library/schema name" to "Table name only".

Click "OK". Then click the Save button.

Now, at run time, your applications will not use the library you used at development time, but you must still specify a list of libraries for the application to attempt to use. This information can be found by clicking Admin, then click "Data Sources" under Global Settings.

 

If you are using the remote connection, be sure to make the following changes to the "AS400 DB2 Remote" portion of the text. Likewise, if you are running locally, be sure to change to the "AS400 DB2 local" connection.

Since we told the SQL statement to no longer use the library used at development, we must specify libraries to try to use. The library list works left to right, and if your table is not found in the first library, it will continue on the list until it finds the correct library.

To specify your library list:

For Local connections:

After the *LOCAL ; add libraries=LIBNAME1, LIBNAME2, LIBNAME3;

For Remote connections:

After the libraries=, add LIBNAME1, LIBNAME2, LIBNAME3

Where LIBNAME1, LIBNAME2, LIBNAME3, etc. is your list of TEST libraries.

Ex. jdbc:as400://101.10.101.010;naming=system;libraries=LIBRARY1,LIBRARY2,LIBRARY3

Click the Accept button. Restart Tomcat.

Now that we have your development environment set up, simply copy over all the necessary components to your production environment, making sure to change your libraries list to now reference production libraries.

Note: MS SQL users will need to use the word "databaseName" rather than "libraries" as syntax is set by each database vendor.
Note: AS/400 customers should also have the JDBC connection property 'naming=system' in their database URL, as shown in the example above.

Click here to access the legacy version of this documentation.:

Created: April 29, 2008 | Modified: October 15, 2020

Search


Browse By Category

Build Process (14)
Starting with m-Power (8)
Retrievals (10)
Reports (14)
Summaries (4)
Maintainers (18)
Graphs (8)
m-Power Data Explorer (4)
General (21)
Calculations (5)
Utilities (8)
m-Power Administration (20)
Security (11)
Freemarker (6)
m-Painter (27)
Form Validation (5)
External Objects & UDFs (11)
Deprecated Documentation (33)
Bootstrap Templates (7)

Popular Tags

Retrievals DB2 Record Selections Form Validation Reports UDF Advanced Admin Dropdowns Summaries Tomcat Graphing SQL Graph Properties Retrieval m-Power Bootstrap Templates Administration m-Painter Java Bar Graphs Security Maintainers Compiling External Objects Popular Dates Prompt Screens Database Calculations Production mrc-Productivity Series Email Video App Properties Data Dictionary Parameters Graphs Application Properties Freemarker Maintainer RPG Getting Started Excel Report

See all tags »

michaels, ross & cole, ltd. (mrc)
Privacy Settings Privacy Policy Cookie Policy Employee Intranet
© 2018 mrc. All rights reserved.
mrc (US)

2001 Midwest Road
Suite 310
Oak Brook, IL 60523
630-916-0662

mrc (UK)

Mortlake Business Centre
20 Mortlake High Street
London, SW14 8JN
+44-20-335-59566