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
Privacy Policy

  




 

 

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