为了把db换为mysql的,我执行了如下步骤:
1.修改configure.properties文件中的
# database vendor, pick one of:
# db2, hsql, informix, msql, mysql, oracle, postgresql, sybase
db_loader_job=mysql
# user credentials for db access
db_user=root
db_passwd=
2.copy mysql的jdbc driver jar文件到lib/contrib/下。
3.在mysql中建立名为shark的database。
4:运行conigure.bat出现以下错误
buildfile: configure.xml
init:
_copynfilter:
[copy] copying 35 files to c:/shark-1.0
_winfileseparator:
[replace] replaced 19 occurrences in 2 files.
[delete] deleting 11 files from c:/shark-1.0
_linfileseparator:
_recreatedb:
[delete] deleting directory c:/shark-1.0/db/hsql
[delete] deleting directory c:/shark-1.0/repository/internal/history
[delete] deleting directory c:/shark-1.0/repository/internal
[mkdir] created dir: c:/shark-1.0/db/hsql
[mkdir] created dir: c:/shark-1.0/repository/internal/history
[java] default (standard) logger is load.
[java] application is started.
[java] loader loads xml file : conf/sql/mysql/loaderjob.olj
[java] xml document is valid.
[java] import job no. 1 is started.
build failed
file:c:/shark-1.0/configure.xml:124: java returned: 1
total time: 9 seconds
6:将configure.bat 中mysql_connection_url=jdbc:mysql://localhost/shark
改成mysql_connection_url=jdbc:mysql://localhost:3306/shark
还是出现一样的错误
7:将configure.xml第157行改为
<filter token="db_url" value="${db_url}"/>
还是出现一样的错误
后来感觉应该是驱动有问题,于是到http://dev.mysql.com/get/downloads/connector-j/mysql-connector-java-3.0.15-ga.zip/from/pick 去重新下载一个解开,将其中的mysql-connector-java-3.0.15-ga-bin.jar放进lib/contrib目录下
再次运行configure.bat 。这次运行成功。
错误原因:粗心将mysql 的 mm.mysql.jdbc-2.0pre5 里面驱动放进去lib里去了。
闽公网安备 35060202000074号