MySQL

From Plex-XML
Jump to: navigation, search

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

MySQL DataTypes


Using MySQL for Plex-XML

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

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


Exernal links

Personal tools