trackplus是一个免费的开放源代码的基于web的缺陷管理工具,使用现在流行的Struts+Torque开发(Struts大家应该知道, Torque是apache的一个持久化工具,详细信息见http://db.apache.org/torque/), trackplus的主页在www.trackplus.de 可以很方便的下载到有关的源代码,Web Application(一个war文件),实用说明(一个pdf文件,使用说明很详细).

自动发送email,实用方便

一个好的缺陷管理工具应该是那种可以在出现于你有关的问题的时候自动通知你的, 用户完全不必主动的定时上去看是否有和自己相关的问题。举例说,如果我是开发人员, 我希望在出现与我相关的bug的时候能够主动email我,在我修改完了bug以后能够给 相应bug的提交人员主动发送通知邮件进行测试.这样即省去了每次上去查找的麻烦, 又能使bug得到及时的修改。

易于和其他系统集成

运行trackplus需要一个支持Jsp的应用服务器和一个数据库.trackplus采用标准的Struts框架所以可以运行在几乎所有 主要的支持Jsp的应用服务器上,比如tomcat,resin,weblogic等.trackplus采用了Torque的持久层,所以支持所有主流的数据库, 比如mysql,sqlserver,oracle等.对于已经有这些环境的公司,只需要为trackplus创建数据库的schema和发布trackplus的 web application就可以了。

维护和定制简单

trackplus的代码量并不大,采用流行的java技术进行开发,所以很容易进行修改以满足特定的应用.另外希望学习Struts的开发者 也可以把他当作一个学习的例子

倒入数据表

从网上下载trackplus的war文件,解开这个war包,在包里有一个dbase的目录,下面有很多目录,分别对应track支持的各种数据库, 运行和你的数据库类型一致的目录下的脚本创建数据库对象,等数据库对象都创建成功以后,再运行dbase下的populate.sql脚本, 为系统产生初始化数据.

安装web application

首先找一个适合你的数据的jdbc驱动程序,放到解开的war包下的/WEB-INF/lib目录下 然后修改配置文件Torque.properties(在/WEB-INF/目录下),主要修改下面几行: 修改对应的数据库连接的用户名和密码. # It is not recommended to change the username. You should change the # password here and in your database management system for this user! # torque.dsfactory.track.connection.user = friedj torque.dsfactory.track.connection.password = tissi 选择你使用的数据库类型,配置对应的Jdbc Driver和URL. # # In this section the driver for your database management system needs to # be enabled. This depends on what kind of RDBMS (Interbase, MySQL, etc.) # you have and possibly on what kind of operating system the database # server is running. Of course, ONLY ONE DRIVER CAN BE BE ENABLED AT A TIME!! # # # 1) Interbase or Firebird on Windows 32 # torque.database.track.adapter=interbase # torque.dsfactory.track.connection.driver = interbase.interclient.Driver # torque.dsfactory.track.connection.url = # jdbc:interbase://localhost/D:/Daten/trackdata/track_test.gdb # # 2) Interbase or Firebird on Linux/Unix # torque.database.track.adapter=interbase # torque.dsfactory.track.connection.driver = interbase.interclient.Driver # torque.dsfactory.track.connection.url = jdbc:interbase://localhost//opt/db/track.gdb # # 3) MySQL # torque.database.track.adapter=mysql # torque.dsfactory.track.connection.driver = org.gjt.mm.mysql.Driver # torque.dsfactory.track.connection.url = jdbc:mysql://localhost:3306/track # and some hint for Japanese: # torque.dsfactory.track.connection.url = # jdbc:mysql://localhost:3306/track?useUnicode=true&characterEncoding=EUC_JP # # 4) Microsoft SQLServer # torque.database.track.adapter=mssql # torque.dsfactory.track.connection.driver = net.sourceforge.jtds.jdbc.Driver # torque.dsfactory.track.connection.url = jdbc:jtds:sqlserver://localhost/track # # Notes: # If using encrypted transmission driver the port number # will be 1434 instead of 1433 # SelectMethod must be cursor or Track+ will not connect # Remember to copy the lib folder contents from the MS # jdbc driver install point to WEB-INF/lib # # 5) Oracle #torque.database.track.adapter=oracle #torque.dsfactory.track.connection.driver = oracle.jdbc.driver.OracleDriver #torque.dsfactory.track.connection.url = jdbc:oracle:thin:@ip:port:sid # # Notes: # Remember to copy the Oracle JDBC driver (can be downloaded from the # Oracle site) to WEB-INF/lib # # You find host, port and sid in TNSNAMES.ORA, or ask you db admin. # 6) PostgresSQL # torque.database.track.driver = org.postgresql.Driver # torque.database.track.url = jdbc:postgresql://10.0.0.1:5432/prj?charSet=latin1 修改/WEB-INF/下的web.xml中的关于邮件发送的内容 <!-- ============================================================ --> <!-- Set your Track+ administrators email here. --> <!-- ============================================================ --> <init-param> <param-name>sendFrom</param-name> <param-value>[email protected]</param-value> </init-param> <!-- ============================================================ --> <!-- Your SMTP servers (mail servers) name. --> <!-- ============================================================ --> <init-param> <param-name>SMTPServername</param-name> <param-value>192.168.1.1</param-value> </init-param> <init-param> <param-name>SMTPPort</param-name> <param-value>25</param-value> </init-param> <!-- ============================================================ --> <!-- Specify the character encoding to be used in emails. --> <!-- Use MIME name for character set. --> <!-- Examples: --> <!-- UTF-8 koi8-r ISO-8859-1 --> <!-- ============================================================ --> <init-param> <param-name>mailEncoding</param-name> <param-value>ISO-8859-1</param-value> </init-param> <!-- ============================================================ --> <!-- If your SMTP server need authentication (RFC-2554) --> <!-- uncomment and use next parameters --> <!-- ============================================================ --> <!-- <init-param> <param-name>SMTPUser</param-name> <param-value>smtp_user</param-value> </init-param> <init-param> <param-name>SMTPPassword</param-name> <param-value>smtp_password</param-value> </init-param> --> <!-- ============================================================ --> <!-- If your SMTP server need POP-before-SMTP authentication --> <!-- uncomment and use next parameters --> <!-- ============================================================ --> <!-- <init-param> <param-name>POPServername</param-name> <param-value>yourPOPServer.com</param-value> </init-param> <init-param> <param-name>POPPort</param-name> <param-value>110</param-value> </init-param> <init-param> <param-name>POPUser</param-name> <param-value>yourPOPUser</param-value> </init-param> <init-param> <param-name>POPPassword</param-name> <param-value>YourPassword</param-value> </init-param> --> 修改/WEB-INF/下的web.xml中的关于注册用户限制的内容,主要是对注册用户的email进行限制, 只有特定的域名的email才能注册.放在公网的时候比较有用. <!-- ============================================================ --> <!-- The allowed email pattern in Perl5 regular expression --> <!-- syntax. Enter your organizations email pattern(s) here. --> <!-- ============================================================ --> <init-param> <param-name>AllowedEmailPattern</param-name> <param-value>[^@ \t]@neodragon\.com|[^@ \t]@cstsc\.com</param-value> </init-param> 然后发布这个web application,通过浏览器就应该可以看到登陆界面,可以使用admin(默认口令是tissi)用户进行系统管理