Preparing your environment

From Plex-XML
Jump to: navigation, search

Tutorial workflow: Plex-XML tutorial main pagePreparing your environmentExtract the tutorial from CVSRestore the tutorial DBTutorial PlexTutorial EclipseTutorial application user guideTutorial debugTutorial LogHelp text Wiki



Components you need to install in your development environment before you can work with Plex-XML


Java JDK >= 6.0

For Plex-XML it is sufficient to install only the JDK. It is not necessary to install all the demos and the JRE.

http://java.sun.com/javase/downloads/index.jsp


Plex


Tomcat 7.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.

http://tomcat.apache.org/index.html


Eclipse >= 3.7 or later

Eclipse will be your IDE to maintain various Plex-XML files and to deploy your application.

http://www.eclipse.org/


Ext JS

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.


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.


HINT: Plex7 and Tomcat7 require a JDBC 4 complaint driver.

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.

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.

http://www.mysql.com/products/connector


JDBC for MS SQL-Server

Copy the sqljdbc4.jar (JDBC-Driver JAR) or a later version to your tomcat/lib directory.

http://msdn.microsoft.com/en-us/sqlserver/aa937724.aspx

Example:

jdbc-resourcename=jdbc/security
jdbc-jndi-ref=java:comp/env/
jdbc-driver=com.microsoft.sqlserver.jdbc.SQLServerDriver
jdbc-datasource=jdbc:sqlserver://mydbserver.example.com:1433;databasename=myDB
jdbc-user=FooUser
jdbc-password=FooPWD
dbtype=mssql

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

CVS (Concurrent Versions System)

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/
IE Developer Toolbar

You can edit, debug, and monitor CSS, HTML, and JavaScript live in any web page.

http://www.microsoft.com/downloads/details.aspx?familyid=e59c3964-672d-4511-bb3e-2d5e1db91038&displaylang=en

Another/additional tool for IE is DebugBar.

http://www.debugbar.com/?langage=en


OpenOffice Server

Open Office installed as a service is used for exports like PDF and Excel.

Personal tools