JBUILDER9.0 + JBOSS-3.2 + MS Server2000 configuration method

Select BLOG from Abnerchai because I want to use CMP, so add the configuration method of using MS Server under JBoss. There are very few references to the JBuilder9.0 JBoss-3.2 development environment, I have organized one here, this is an incision I am in configuring this development environment. The following is the detailed steps: 1. Install the JBuilder9.0 to D: / jbuilder9 directory

2, install mysql4.0.18 to c: / mysql directory

3, install MS SQL Server2K to C: / Program Files / Under installation JDK.14, then install it directly to C: /J2SDK1.4.1_01 directory, then set in system environment variables: java_home = C: /J2SDK1.4.1 _01 can be.

4, install the JBoss3.2.1_tomcat-4.1.24 to the C: / JBoss directory. Note: JBoss installation is very simple, put the downloaded file until you go Next, then set in the system environment variable: jboss_home = C: / JBoss.

5, download and install MySQL JDBC Driver and MS SQLServer JDBC Driver. The history of the document after download is:

MySQL-CONNECTOR-JDBC-3.0.10-STable.zip and SQLServer2kjdbcSetup.exe. The installation method is as follows: Unlock mysql-connector-jdbc-3.0.10-stable.zip, mysql-connector-java-3.0.10-stable under the MySQL-Connector-JDBC-3.0.10-Stable directory " Bin.jar files are copied into the JBoss installation directory C: / jboss / server / default / lib directory under the C: / Lib directory. Execute SQLServer2kjdbcSetup.exe installation to the C: / Program Files / Microsoft SQL Server 2000 Driver for JDBC directory, and put it under the lib directory (ie, C: / Program Files / Microsoft SQL Server 2000 Driver for JDBC / LIB) MSBase .jar, mssqlserver.jar and msutil.jar three files are copied into the JBoss installation directory C: / jboss / server / default / lib directory under the C: / Lib Directory under the C: / jboss. At the same time, the MS SQL Server2k server is started and connected to the above, execute: C: / Program Files / Microsoft SQL Server 2000 Driver for JDBC / SQL Server JTA directory: instjdbc.sql script.

6. Configure the JBoss database connection pool so that it can be connected to Mysql and SQL Server. Methods as below:

Enter the JBoss Installation Directory C: / JBoss, enter the C: / JBoss / Server / Default / Deploy directory under this C: / jboss / server / default / deploy, use Notepad to create two files MSSQL-DS.XML and MySQL-DS.XML, the content is as follows:

1, mysql-ds.xml

mysql jdbc: mysql: // 10.0.0.18:3306/test.com/connection-ur g< uSer-name "Root Password> 2, MSSQL-DS.XML

MSSQL JDBC: Microsoft: SQLServer: //10.0.0.18:1433; DatabaseName=test com.microsoft.jdbc.sqlser.sqlserverdriver sa < Password>

3. Configuring the CMP Data Type Mapping Configuration JBoss uses the MS SQL Server connection pool as the default data source, you can choose one of the following methods: Create a jaws.xml file or overload Standardjaws in your application's meta-infirectory The default settings shown below. XML (MS SQL Server CMP Data Type Mapping) Java: / mssqlds ms sqlserver false MS SQLServer

Change the default setting in the StandardJaws.xml file in the% jboss_home% / conf directory To change the default data source and data type mapping, please pay for Standardjaws. The XML file is modified as follows java: / mssqlds ms sqlserver * Note: In addition to MS SQLServer 2000, other versions use MS SQLServer. If you use SQL Server2000, change the above MS SQLServer to MS SQLServer2000. Then you need to set the and elements of StandardJaws.xml or Jaws.xml files:

java: / mssqlds ms sqlserver

Also need to set the and element of StandardJbusScmp-jdbc.xml or jbosscmp-jdbc.xml file:

java: / mssqlds ms sqlserver

Finally, modify the login-config.xml file to use MS SQLSERVER:

sa sa kjt jboss.jca : service = localtxcm, Name = mssqlds

Modified MSSQL-DS.XML, Standardjaws.xml, StandardJbosscmp-JDBC.XML, and Login-Config.xml files can be used on JBOSS SQLServer. 7, download jbossopentool-2.6alpha.zip, used to connect JBoss and JBuildrer9.0, after downloading, put it, put the jbossopentool.jar file generated after unwrapping: d: / JBuilder9 / lib / ext directory.

8. Configure JBuilder9, the process is as follows: