服务热线:13616026886

技术文档 欢迎使用技术文档,我们为你提供从新手到专业开发者的所有资源,你也可以通过它日益精进

位置:首页 > 技术文档 > JAVA > 新手入门 > 基础入门 > 查看文档

配置shark与mysql的连接

为了把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里去了

扫描关注微信公众号