為了把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里去了。
新聞熱點
疑難解答