为了把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里去了。
[MySql]PHP存取 Mysql 数据乱码终极解决方案 [MySql]解决Table xxx is marked as crashed and should … [MySql][MySQL]快速解决"is marked as crashed and shoul… [MySql]MySQL DELETE语法用法详解 [MySql]mysql中时间日期格式化 [MySql]修改mysql导入文件大小限制 [其他]MySql常用命令大全 [Web开发]把ACCESS的数据导入到Mysql中的方法详解 [MySql]解决mysql 1040错误Too many connections的方法 [系统软件]利用crontab系统每天定时备份MySQL数据库
|