Follow Techotopia on Twitter

On-line Guides
All Guides
eBook Store
iOS / Android
Linux for Beginners
Office Productivity
Linux Installation
Linux Security
Linux Utilities
Linux Virtualization
Linux Kernel
System/Network Admin
Programming
Scripting Languages
Development Tools
Web Development
GUI Toolkits/Desktop
Databases
Mail Systems
openSolaris
Eclipse Documentation
Techotopia.com
Virtuatopia.com

How To Guides
Virtualization
General System Admin
Linux Security
Linux Filesystems
Web Servers
Graphics & Desktop
PC Hardware
Windows
Problem Solutions

  




 

 

26.4.10. Installation

If you've worked through the above sections, you've arleady performed these steps. But we list them here for quick reference.

Driver Launched:

  1. Download and unzip Connector/MXJ, add connector-mxj.jar to the CLASSPATH

  2. To the JDBC connection string add the following parameter: "socketFactory=" + ServerLauncherSocketFactory.class.getName()

JBoss:

  1. Download Connector/MXJ copy the connector-mxj.jar file to the $JBOSS_HOME/server/default/lib diretory.

  2. Download Connector/J copy the connector-mxj.jar file to the $JBOSS_HOME/server/default/lib diretory.

  3. Create an MBean service xml file in the $JBOSS_HOME/server/default/deploy directory with any attributes set, for instance the datadir and autostart.

  4. Set the JDBC parameters of your web application to use: String driver = "com.mysql.jdbc.Driver"; String url = "jdbc:mysql:///test?propertiesTransform="+ "com.mysql.management.jmx.ConnectorMXJPropertiesTransform"; String user = "root"; String password = ""; Class.forName(driver); Connection conn = DriverManager.getConnection(url, user, password);

You may wish to create a separate users and database table spaces for each application, rather than using "root and test".

We highly suggest having a routine backup procedure for backing up the database files in the datadir.


 
 
  Published under the terms of the GNU General Public License Design by Interspire