[2013-10-28 15.25.08.628] Configuration file loaded
from jar: 'datamapnz.properties'(482)
java.lang.ClassNotFoundException:
com.microsoft.sqlserver.jdbc.SQLServerDriver
at java.net.URLClassLoader$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Unknown Source)
at ibm.DBData.getConnection(DBData.java:289)
at
ibm.GenerateExtract.initDBSources(GenerateExtract.java:1065)
at ibm.GenerateExtract.(GenerateExtract.java:1104)
at ibm.GenerateExtract.main(GenerateExtract.java:13327)
根据错误提示,找到不到相应的类,可能的错误
1.sqljdbc.jar损坏,导致类无法加载
2.引入的sqljdbc.jar的路径有问题,导致找不到类
我在网上下载了好久个sqljdbc.jar,IBMDataMovementTool中连接都没问题,那就说明不是jar包的损坏问题。
那么就只能是jar包存储路径有问题,因为我之前的jar包的路径是:D:数据库软件\sql2005jdbc_chssql2005Driversql2005Driversqljdbc.jar,
我尝试将sql2005jdbc_chssql2005Driversql2005Driversqljdbc.jar拷贝到D盘根目录下,试了一下成功了。
看来很多软件对中文的支持不是很好,以致于DB2创建数据库时,如果你不指定字符集,默认就是UTF-8。
[2013-10-28 15.56.59.678] JDBC driver
Microsoft SQL Server 2005 JDBC Driver Version = 1.1.1501.101
[2013-10-28 15.56.59.679] Database Major Version :9
[2013-10-28 15.56.59.679] Database Minor Version :0
[2013-10-28 15.56.59.717] Driver
com.microsoft.sqlserver.jdbc.SQLServerDriver loaded
[2013-10-28 15.56.59.727] Database Product Name :Microsoft SQL
Server
[2013-10-28 15.56.59.727] Database Product Version :9.00.1399
[2013-10-28 15.56.59.728] JDBC driver Microsoft SQL Server 2005
JDBC Driver Version = 1.1.1501.101
[2013-10-28 15.56.59.735] Database Major Version :9
[2013-10-28 15.56.59.735] Database Minor Version :0
[2013-10-28 15.56.59.735] fetchSize:100
[2013-10-28 15.56.59.737] Timezone = Asia/Shanghai Offset=8:0
[2013-10-28 15.56.59.767] Driver
com.microsoft.sqlserver.jdbc.SQLServerDriver loaded
[2013-10-28 15.56.59.773] Database Product Name :Microsoft SQL
Server
[2013-10-28 15.56.59.774] Database Product Version :9.00.1399
[2013-10-28 15.56.59.774] JDBC driver Microsoft SQL Server 2005
JDBC Driver Version = 1.1.1501.101
[2013-10-28 15.56.59.777] Database Major Version :9
[2013-10-28 15.56.59.777] Database Minor Version :0
[2013-10-28 15.56.59.783] Version = Microsoft SQL Server 2005 -
9.00.1399.06 (X64)
