SQL Server2000连接一直无法成功,就算下载了最新的SQL Server2000 for JDBC SP3也一样。
改用MySQL,数据库生成正确。但是Track+依然无法连接MySQL,请高手指点。
Torque.properties配置如下# -------------------------------------------------------------------
# This is the configuration file for Torque for the Track+ application.
# $Id: Torque.properties,v 1.4 2004/10/29 13:38:10 friedj Exp $#
# -------------------------------------------------------------------

# This is the user name and password under which the database is
# being accessed by the Track+ application. It is not related to any 
# logon username and password which you see from the application
# logon screen. 
#
# !!! THIS USER WITH THIS PASSWORD HAS TO BE KNOWN BY YOUR DATABASE SYSTEM !!!
#
torque.dsfactory.track.connection.user = root
torque.dsfactory.track.connection.password = redmaple

#--------------------------------------------------------------------------

# 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_300.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/trackplus# 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/TrackPlus#
# 5) Oracle
# torque.database.track.adapter=oracle  
# torque.dsfactory.track.connection.driver = oracle.jdbc.driver.OracleDriver 
# torque.dsfactory.track.connection.url = jdbc:oracle:thin:@host:port:sid# Example: 
# torque.dsfactory.track.connection.url = jdbc:oracle:thin:@gandalf:1521:track 
# You find host, port and sid in TNSNAMES.ORA, or ask you db admin. #
# 6) PostgresSQL
# torque.database.track.adapter=postgresql
# torque.dsfactory.track.connection.driver = org.postgresql.Driver
# torque.dsfactory.track.connection.url = jdbc:postgresql://localhost/track#
# 7) HSQLDB (Hypersonic SQL)
# torque.database.track.adapter=hypersonic
# torque.dsfactory.track.connection.driver = org.hsqldb.jdbcDriver
# torque.dsfactory.track.connection.url = jdbc:hsqldb:hsql://localhost# Some more which might work:
# axion, cloudscape, db2, db2400, sapdb, sybase
#
#--------------------------------------------------------------------------
#
## Using the DB commons pool, it's better than Torque's old pool
#
# You can also use JNDI and server based bindings. See the pool config howto
# on the Torque site http://db.apache.org
#
torque.dsfactory.track.factory= org.apache.torque.dsfactory.SharedPoolDataSourceFactory
torque.dsfactory.track.pool.maxActive=30
#torque.dsfactory.track.pool.testOnBorrow=true
#torque.dsfactory.track.pool.validationQuery=SELECT PKEY FROM TSTATE
#--------------------------------------------------------------------------