ドライバ名を com.ibm.db2.jcc.DB2Driver → COM.ibm.db2.jdbc.app.DB2Driver に修正したら、とりあえず検索できるようになった。Type 2のドライバはこっちなのか?
package db2sample;import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.sql.Timestamp;
import java.text.SimpleDateFormat;public class Hoge {
public static void main(String[] args) {
try {
exec();
} catch (Exception e) {
e.printStackTrace();
}
}private static void exec() throws ClassNotFoundException, SQLException {
Class.forName("COM.ibm.db2.jdbc.app.DB2Driver");
Connection conn = null;try {
String url = "jdbc:db2:sample";
//String url = "jdbc:db2://localhost:50000/sample";
conn = DriverManager.getConnection(url, "db2admin", "db2admin");
Statement stmt = conn.createStatement();
ResultSet rs = stmt
.executeQuery("SELECT current timestamp FROM sysibm.sysdummy1");rs.next();
Timestamp ts = rs.getTimestamp(1);rs.close();
stmt.close();SimpleDateFormat format = new SimpleDateFormat(
"yyyy-MM-dd HH:mm:ss");
System.out.println(format.format(ts));
} finally {
if (conn != null)
conn.close();
}}
}
検索結果。
2005-02-14 02:07:21
Type 4での接続には失敗。