MYSQL - Jboss-Jbuilder9.0 + + MySql 3.2.1_tomcat-4.1.24.zip / MS SQL Server2K development environment configuration NotesMYSQL

Jboss-Jbuilder9.0 + + MySql 3.2.1_tomcat-4.1.24.zip / MS SQL Server2K development environment configuration Notes

Jbuilder9.0 jboss-3.2.1_tomcat-+ + MySql or 4.1.24.zip
MS SQL Server2K development environment configuration Notes

Network of JBOSS Jbuilder9.0 + 3.2 development environment-that the configuration of reference also rarely, I am here to provide a, please refer, and advice! This is my configuration of this development in a Notes environment. Below are the detailed steps:

1, the installation Jbuilder9.0 to the D: \ directory Jbuilder9

2, the installation MySQL4.0.18 C: \ directory mySQL

3, install MS SQL Server2k C: \ Program Files \ JDK.14 installed, installed after downloading directly to the C: \ j2sdk1.4.1_01 directory, and then set up the system environment variables: JAVA_HOME = C: \ j2sdk1.4.1 _01 can.

4, the installation JBOSS3.2.1_tomcat-4.1.24 to C: \ JBOSS directory.
NOTE: JBOSS installation is very simple, will be available after the document untied Add to C: \ under JBOSS can, and then set up the system environment variables: JBOSS_HOME = C: \ JBOSS can.

5, download and install mySql JDBC Driver and MS SQLServer JDBC Driver. After downloading the history of the paper are:

Mysql-connector-jdbc-3.0.10-stable.zip and SQLServer2KJDBCsetup.exe.
Installation method as follows: mysql-connector-jdbc-3.0.10-stable.zip untied to the one mysql-connector-jdbc-3.0.10-stable directory of mysql-connector-java-3.0.10-stable - bin.jar document holders Kaoru JBOSS installation directory C: \ JBOSS under c: \ jboss \ server \ default \ lib directory.
Executive SQLServer2KJDBCsetup.exe installed to C: \ Program Files \ Microsoft SQL Server 2000 Driver for JDBC directory, and its next lib directory (C: \ Program Files \ Microsoft SQL Server 2000 Driver for JDBC \ lib) Contents under msbase . jar, and msutil.jar mssqlserver.jar three documents Kaoru JBOSS installation directory C: \ JBOSS under c: \ jboss \ server \ default \ lib directory.
At the same time, the final start MS SQL Server2k server and use the query analyzer connected to the above, the Executive:
C: \ Program Files \ Microsoft SQL Server 2000 Driver for JDBC \ SQLServer JTA directory:
Instjdbc.sql script.

6, JBOSS configuration database connection pool, so that it can properly connected to MySQL, and SQL Server. As follows:

Enter JBOSS installation directory C: \ JBOSS, entered under the C: \ JBOSS \ server \ default \ deploy directory, with two new notebook paper mssql-ds.xml and mysql-ds.xml, as follows:

1, mysql-ds.xml

<? Xml version = "1.0" encoding = "UTF-8">
<datasources>
<local-tx-datasource>
<jndi-name> MySql </ jndi-name>
<connection-url> Jdbc: mysql: / / 10.0.0.18:3306 / test </ connection-url>
<driver-class> Org.gjt.mm.mysql.Driver </ driver-class>
<user-name> Root </ user-name>
<password> </ Password>
</ Local-tx-datasource>
</ Datasources>

2, mssql-ds.xml

<? Xml version = "1.0" encoding = "UTF-8">
<datasources>
<local-tx-datasource>
<jndi-name> MSSQL </ jndi-name> <connection-url> jdbc: microsoft: sqlserver: / / 10.0.0.18:1433; DatabaseName test = </ connection-url>
<driver-class> Com.microsoft.jdbc.sqlserver.SQLServerDriver </ driver-class>
<user-name> Sa </ user-name>
<password> </ Password>
</ Local-tx-datasource>
</ Datasources>

7, download JBossOpenTool-2.6alpha.zip for connecting Jbuildrer9.0 JBOSS and, after downloading, their untied will be solved after the JBossOpenTool.jar document Add Jbuilder9.0 install directory: D: \ JBuilder9 \ lib \ ext directory.

8, configuration JBuilder9, the process is as follows:

1, launched Jbulder9, select Tools-> EnterpriseSetup, in the pop-up window select DataBase Driver page, select Add, in the pop-up window, select new, and then in the next window in the Name input: MySqlJDBC; User Home Location Choice , and click Add to the JDBC driver just MySql document C: \ JBOSS \ server \ default \ lib \ mysql-connector-java-3.0.10-stable-bin.jar elected.
2, with a step, choose Tools-> EnterpriseSetup, in the pop-up window select DataBase Driver page, select Add, in the pop-up window, select new, and then in the next window in the Name input: MSSqlJDBC; choice User Location Home, and click Add MSSql Server will be just the JDBC driver of the C: \ JBOSS \ server \ default \ lib \ msbase.jar, mssqlserver.jar and msutil.jar elected to the three documents. Click OK until the end. JBuilder9 restart.
Above configuration of the two JDBC Driver, in the development of which one to use on the choice of which one.
3, launched Jbuilder9 choose: Tools-> Configure Servers, check the left side of the JBoss 3.X, the right of the selected Enable Server, press table complete information:
General page:
Home Directiry = C: \ jboss here is the installation directory JBoss
Main Class = org.jboss.Main
VM Parameters =- ms64m-mx64m-Dprogram.name = run.bat
Server Parameters =-c default
Working Directory = C: \ jboss \ bin
Custom page:
JBoss Installation Directory = C: \ jboss here is the installation directory JBoss
Tomcat 4X JBuilder Installation Directory =
D: / JBuilder9/thirdparty/jakarta-tomcat-4.0.6-LE-jdk14
Here is Jbuilder9 in Tomcat4.0.6 installation directory. Note that the installation of a Jbuilder9 also Tomcat4.1, but it appears the latest version of JbossOpenTool do not support it, so the only choice Tomcat4.0.6 Tomcat version.
JBoss Configuration to Use = default, click OK.
4, the Lib configuration Jbuilder, Jbuilder9, select Tools-> Configure Libraries, in the pop-up dialog box, UserHome Below automatic out a red JBoss3.xServlet, it requires us to configure LIB, select it, the right of the page, click Add Class, by adding JBoss installation directory C: \ JBOSS \ Server \ default \ lib directory of javax.servlet.jar and jboss-j2ee.jar file, click OK.
5, do the rest, simply restart Jbuilder9, can do J2ee developed.

Our development environment here is: Jbuilder9 + JBoss3.2 + MySQL / MS SQL Server2K