Preparing your environment
Tutorial workflow: Plex-XML tutorial main page → Preparing your environment → Extract the tutorial from CVS → Restore the tutorial DB → Tutorial Plex → Tutorial Eclipse → Tutorial application user guide → Tutorial debug → Tutorial Log → Help text Wiki
Components you need to install in your deveopment environment before you can work with Plex-XML
For Plex-XML it is sufficient to install only the JDK. It is not necessary to install all the demos and the JRE.
- Plex-XML Community Edition Please make sure you have installed CA Plex 6.0. incl. PTF 47.012
- Plex-XML Commercial Edition Plex 6.1. incl. PTF 43.027
Tomcat 6.0 or later
We recommend to carry out local testing on your PC during development. For this purpose you will need to install a local servlet engine.
Eclipse >= 3.2 or later
Eclipse will be your IDE to maintain various Plex-XML files and to deploy your application.
Ext is an JavaScript library, for building richly interactive web applications using techniques such as AJAX, DHTML and DOM scripting. While it may not be distributed within another development tool you need to download and install it by your own. Please be sure to read the license file because there is an open source and a commercial version available.
- Plex-XML Community Edition EXT JS 2.2.1
- Plex-XML Commercial Edition EXT JS 3.3
- MySQL 5.x
MySQL is the default DB for the Plex-XML Tutorial. But you can also use another data base (see the compatibility list.
Contents |
JDBC database connection driver
General installation is to download the JDBC-Driver and put the jar-file to the ..tomcat\lib directory of your installation.
- Configuration is generally done in your .localtomcat.properties file.
- See also Obxxxsvr.properties for more infos about transaction save configuration and Fetch For Update usage.
Example:
jdbc-resourcename=jdbc/security jdbc-jndi-ref=java:comp/env/ jdbc-driver=com.mysql.jdbc.Driver jdbc-datasource=jdbc\:mysql\://localhost\:3306/FooDBName jdbc-user=FooUser jdbc-password=FooPWD dbtype=mysql
MySQL JDBC Driver
Download the MySQL JDBC driver, unpack the zip and copy mysql-connector-java-5.x.y-bin.jar to your tomcat\lib dirextory.
JDBC for MS SQL-Server
Copy the jtds-1.2.jar (JDBC-Driver JAR) or a later version to your tomcat/lib directory.
JTOpen IBM Toolbox for i5 / AS400
The IBM Toolbox for Java / JTOpen is a library of Java classes supporting the client/server and internet programming models to a system running OS/400 or i5/OS.
Copy the JDBC-Driver to your tomcat/lib directory.
- JTOpen IBM Toolbox: http://jt400.sourceforge.net/
- IBM Toolbox for Java JDBC properties: http://publib.boulder.ibm.com/infocenter/iseries/v7r1m0/index.jsp?topic=%2Frzahh%2Fjdbcproperties.htm
Example;
# Properties fuer JDBC Standard DataSource jdbc-resourcename=AS400 jdbc-driver=com.ibm.as400.access.AS400JDBCDriver jdbc-datasource=jdbc:as400://as400.domain.com;date format=iso;naming=system;true autocommit=true;transaction isolation=read committed;libraries=,FooLib1,Lib2 jdbc-user=FooUser jdbc-password=FooPWD jdbc-validation=SELECT COUNT(*) FROM S2SOFTF
Additional but optional tools
XSLT plugin for Eclipse
You do not need this plugin if you have installed Eclipse >= 3.5 Java EE edtion including the web tools for editing XML and XSLT files
- JSEclipse
JavaScript Plugin for Eclipse
A CVS-Client is already included in Eclipse
- Firebug
Firebug integrates with Firefox to put a wealth of web development tools at your fingertips while you browse. You can edit, debug, and monitor CSS, HTML, and JavaScript live in any web page.
- http://www.getfirebug.com/
- --> Firebug may slow down some sites. Look here for more infos: http://dean.edwards.name/weblog/2007/08/firebug-slow/
You should also try the YSlow tool from Yahoo! YSlow analyzes web pages and tells you why they're slow based on the...
- Firebug may slow down some sites. Look here for more infos: http://dean.edwards.name/weblog/2007/08/firebug-slow/
- IE Developer Toolbar
You can edit, debug, and monitor CSS, HTML, and JavaScript live in any web page.
Another/additional tool for IE is DebugBar.
- OpenOffice Server
Open Office installed as a service is used for exports like PDF and Excel.
