免费注册 查看新帖 |

Chinaunix

  平台 论坛 博客 文库
最近访问板块 发新帖
查看: 2992 | 回复: 2
打印 上一主题 下一主题

openadaptor 加载mysql jdbc失败,在线等待 [复制链接]

论坛徽章:
0
跳转到指定楼层
1 [收藏(0)] [报告]
发表于 2007-09-18 10:16 |只看该作者 |倒序浏览
openadaptor 加载mysql jdbc失败。郁闷,请各位大侠指教

环境变量设置如下:
export JAVA_HOME=/usr/java/jdk1.5.0_10
export OPENADAPTOR_HOME=/usr/local/openadaptor/classes
export CLASSPATH=.OPENADAPTOR_HOME/openadaptor.jarOPENADAPTOR_HOME/jdk_1_4/regexp.jarOPENADAPTOR_HOME/Tidy.jar
OPENADAPTOR_HOME/axis.jarOPENADAPTOR_HOME/commons-discovery.jarOPENADAPTOR_HOME/commons-logging.jarOPENADAPTOR_H
OME/commons-net-1.2.2.jarOPENADAPTOR_HOME/dom4j-1.5.jarOPENADAPTOR_HOME/edtftpj-1.5.1.jarOPENADAPTOR_HOME/fscont
ext.jar:$OPENADAPTOR_HOME/jaas.jar:$OPENADAPTOR_HOME/jakarta-oro-2.0.8.jar:$OPENADAPTOR_HOME/jaxrpc.jar:$OPENADAPTOR_H
OME/jdom.jar:$OPENADAPTOR_HOME/jsch-0.1.19.jar:$OPENADAPTOR_HOME/junit.jar:$OPENADAPTOR_HOME/log4j-1.2.9.jar:$OPENADAP
TOR_HOME/mysql-connector-java-3.0.14-production-bin.jar:$OPENADAPTOR_HOME/providerutil.jar:$OPENADAPTOR_HOME/regexp.ja
r:$OPENADAPTOR_HOME/saaj.jar:$OPENADAPTOR_HOME/smack.jar:$OPENADAPTOR_HOME/xalan.jar:$OPENADAPTOR_HOME/xerces.jar:$OPE
NADAPTOR_HOME/xml-apis.jar:$OPENADAPTOR_HOME/xml4j.jar:$JAVA_HOME/lib/tools.jar
#export PATH=$PATH:$JAVA_HOME/bin
export CLASSPATH

MySQLParameterizedSQLSink.props 文件配置如下:

# -- INCLUDE PARAMETERS

#include CookbookParams.include

#==================================================================================
#
#                     SET TAB SIZE TO 4
#
# Extracts user information from a text file and updates the MySQL database
#
# In order to run this example you must first run the TestInstall.sql script
# against the database to create the country table and data. Also, note that
# you will have to change the database name and user details accordingly.
#
# NB: the trailing "/" on the connection URL is important ant will cause an
# exception if omitted.
#
# Here, you would notice that, we have used Parameterized SQL for the SQLSink.
#
# Adaptor A:
# ==========
#
#      C1     ->   C2
#
# (FileSource)  (SQLSink)
#
#==================================================================================


#==================================================================================
#
# Logging:
#
#==================================================================================

A.Logging.LogSetting1                        = INFO DEFAULT

A.Logging.LoggingTimeInfo                = false
A.Logging.LoggingThreadInfo                = false
A.Logging.LoggingPackageInfo        = false


#==================================================================================
#
# Components:
#
#==================================================================================

A.Component1.Name                                = C1
A.Component2.Name                                = C2


#==================================================================================
#
# Components:
#
#==================================================================================

A.C1.LinkTo1                                        = C2


#==================================================================================
#
# C1:
#
#==================================================================================

A.C1.ClassName                                        = org.openadaptor.adaptor.standard.FileSource
A.C1.DOStringReader                                = org.openadaptor.dostrings.DelimitedStringReader
A.C1.InputFileName                                = input/countries.txt
A.C1.NumAttributes                                = 6
A.C1.FieldDelimiter                                = 44
A.C1.Type1                                                = Test
A.C1.Test.AttName1                                = country
A.C1.Test.AttName2                                = language


#==================================================================================
#
# C2:
#
#==================================================================================

A.C2.ClassName                                        = org.openadaptor.adaptor.jdbc.SQLSink

#A.C2.JdbcUrl                                        = ${PARAM_JDBC_MYSQL_URL}
#A.C2.JdbcDriver                                        = ${PARAM_JDBC_MYSQL_DRIVER}
#A.C2.UserName                                        = ${PARAM_JDBC_MYSQL_USER}
#A.C2.Password                                        = ${PARAM_JDBC_MYSQL_PWD}

A.C2.JdbcUrl            = jdbc:mysql://127.0.0.1:3306/test
A.C2.JdbcDriver         = mysql-connector-java-3.0.14-production-bin.jar
A.C2.UserName           = root
A.C2.Password           = admin



A.C2.SQLStatement1                                = Insert Into test.Country (Name, Language) Values (?,?);
A.C2.SQLStatement1.ParamName1 = COUNTRY
A.C2.SQLStatement1.ParamName2 = LANGUAGE
A.C2.SQLStatement1.ParamType1 = String
A.C2.SQLStatement1.ParamType2 = String


# Must set this to true so that the "SET CHAINED OFF" commands isn't issued
# as this causes MySQL to barf
A.C2.UsingChainedTransactions        = true

错误提示:
FATAL: C2 failed to complete initialization with java.sql.SQLException: C2 failed to load jdbc driver mysql-connector-java-3.0.14-production-bin.jar with java.lang.ClassNotFoundException: mysql-connector-java-3.0.14-production-bin.jar
FATAL: RunAdaptor: Failed to construct new RunAdaptor with C2 failed to complete initialization with java.sql.SQLException: C2 failed to load jdbc driver mysql-connector-java-3.0.14-production-bin.jar with java.lang.ClassNotFoundException: mysql-connector-java-3.0.14-production-bin.jar

论坛徽章:
0
2 [报告]
发表于 2007-09-18 10:18 |只看该作者

运行以后就出错加载mysql驱动失败(急!急!急!)

[root@huang cookbook]# java org.openadaptor.adaptor.RunAdaptor MySQLParameterizedSQLSink.props A

错误提示:
FATAL: C2 failed to complete initialization with java.sql.SQLException: C2 failed to load jdbc driver mysql-connector-java-3.0.14-production-bin.jar with java.lang.ClassNotFoundException: mysql-connector-java-3.0.14-production-bin.jar
FATAL: RunAdaptor: Failed to construct new RunAdaptor with C2 failed to complete initialization with java.sql.SQLException: C2 failed to load jdbc driver mysql-connector-java-3.0.14-production-bin.jar with java.lang.ClassNotFoundException: mysql-connector-java-3.0.14-production-bin.jar

各位大侠,知道的请指教,急

论坛徽章:
0
3 [报告]
发表于 2007-09-18 13:43 |只看该作者

没有人愿意赐教啊?各位大侠

没有人愿意赐教啊?各位大侠
您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

  

北京盛拓优讯信息技术有限公司. 版权所有 京ICP备16024965号-6 北京市公安局海淀分局网监中心备案编号:11010802020122 niuxiaotong@pcpop.com 17352615567
未成年举报专区
中国互联网协会会员  联系我们:huangweiwei@itpub.net
感谢所有关心和支持过ChinaUnix的朋友们 转载本站内容请注明原作者名及出处

清除 Cookies - ChinaUnix - Archiver - WAP - TOP