| 元件 | 版本 | 下載來源 |
|---|---|---|
| JDK | 5.0 | Sun 官網 |
| JBoss | 4.0.1 SP1 | SourceForge |
| MySQL | 4.1 | MySQL 官網 |
| MySQL JDBC Driver | 3.1.7 | Connector/J |
| Ant | 1.6.2 | Apache Ant |
D:\jboss-4.0.1sp1)mysql> create database ppp character set utf8;
D:\apache-ant-1.6.2)ANT_HOME=D:\apache-ant-1.6.2JAVA_HOME=JDK安裝路徑CLASS_PATH=%JAVA_HOME%\libPATH 追加 %ANT_HOME%\bin;%JAVA_HOME%\bin;[MySQL安裝路徑]\binmysql-connector-java-3.1.7-bin.jar 複製至 [JBoss目錄]\server\default\libjboss-service.xml 部署掃描路徑:
<attribute name="URLs">
deploy/,file:/e:/dep/web/,file:/e:/dep/ejb/
</attribute>
e:/dep/web、e:/dep/ejb 為自訂部署目錄。
[JBoss目錄]\docs\examples\jca\mysql-ds.xml 至 \server\default\deploy,修改內容:
<jndi-name>MySQLDS</jndi-name>
<connection-url>jdbc:mysql://localhost:3306/ppp</connection-url>
<driver-class>com.mysql.jdbc.Driver</driver-class>
<user-name>root</user-name>
<password>你的密碼</password>
<config-property name="useUnicode">true</config-property>
<config-property name="characterEncoding">utf8</config-property>
ant 建置,輸出 yyweb.war、yyejb.jar 至 target 目錄E:\dep\web、E:\dep\ejb)mysqld)與 JBoss(run.bat),驗證 https://localhost:8080/wap/faces/admin/co/listAll.do./jdk-1_5_0_01-linux-i586.bin,安裝至 /usr/java/jdk1.5.0_01groupadd mysql
useradd -g mysql mysql
cd /usr/local
tar -xzf /path/to/mysql-standard-4.1.10-pc-linux-gnu-i686.tar.gz
ln -s mysql-standard-4.1.10-pc-linux-gnu-i686 mysql
cd mysql
scripts/mysql_install_db --user=mysql
chown -R root .
chown -R mysql data
chgrp -R mysql .
bin/mysqld_safe --user=mysql &
mysqladmin -u root password '新密碼'
mysql> create database ppp character set utf8;
~/.bash_profile 設定環境變數(注意路徑分隔符為 :):
JAVA_HOME=/usr/java/jdk1.5.0_01
ANT_HOME=/home/wubing/ev/apache-ant-1.6.2
MYSQL_HOME=/usr/local/mysql
PATH=$PATH:$HOME/bin:$JAVA_HOME/bin:$ANT_HOME/bin:$MYSQL_HOME/bin
CLASSPATH=$JAVA_HOME/lib/tools.jar:$JAVA_HOME/lib/dt.jar
export JAVA_HOME ANT_HOME MYSQL_HOME PATH CLASSPATH
執行 source ~/.bash_profile 生效,echo $PATH 驗證。
.sh 腳本(run.sh、shutdown.sh -S)。https://localhost:8080/listAll.do(Mozilla 瀏覽器)server/default/libppp 未建立MySQLDS 是否成功綁定 JNDI