MySQL
Contents |
General Description
MySQL is a multithreaded, multi-user SQL database management system (DBMS) which has, according to MySQL AB, more than 10 million installations. MySQL is owned and sponsored by a single for-profit firm, the Swedish company MySQL AB. MySQL is popular for web applications and acts as the database for the popular WordPress blogging platform and Wikipedia.General description continues at WikiPedia...
Using MySQL for Plex-XML
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
