- 论坛徽章:
- 0
|
我以前测试写的一段代码,是可以连接上的,我也用WSAD5.0, AS400是V5R3. 当时好像是同时连接sql server和db2.
核心代码如下:
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class DbInput
{
Connection src=null;
Connection dest=null;
Connection connformax=null;
ConnPara srcPara;
ConnPara destPara;
public DbInput(){}
public void dbInit()
{
DbXmlParser xmlparser=new DbXmlParser("dbs.xml");
srcPara=xmlparser.getSource();
destPara=xmlparser.getDest();
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver" );
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
Class.forName("com.ibm.as400.access.AS400JDBCDriver");//2004-8-28 DB2/AS400
src = DriverManager.getConnection( srcPara.getUrl(), srcPara.getUsername(),srcPara.getPassword());
dest =DriverManager.getConnection( destPara.getUrl(), destPara.getUsername(),destPara.getPassword());
connformax= DriverManager.getConnection( destPara.getUrl(), destPara.getUsername(),destPara.getPassword());
}
//捕获加载驱动程序异常
catch ( ClassNotFoundException cnfex ) {
System.err.println( "装载 JDBC/ODBC 驱动程序失败。" );
cnfex.printStackTrace();
System.exit( 1 ); // terminate program
} catch ( SQLException ex )
{
System.err.println( "连接失败" );
ex.printStackTrace();
System.exit( 1 ); // terminate program
}
}
}
我的XML文件配置如下:
<?xml version="1.0" encoding="GBK"?>
<dbcopy>
<source>
<class>com.microsoft.jdbc.sqlserver.SQLServerDriver</class>
<url>jdbc:microsoft:sqlserver://SqlServerName:port;DatabaseName=dataname;SelectMethod=cursor</url>
<user>username</user>
<password>password</password>
</source>
<dest>
<class>com.ibm.as400.access.AS400JDBCConnectionPoolDataSource</class>
<url>jdbc:as400://as400name;naming=system</url>
<user>User name</user>
<password>password</password>
</dest>
</dbcopy> |
|