JDBC 버전 알아보기

DB, JDBC드라이버 버전 알아보기를 할 수 있는 jsp입니다..

물론 java application으로 바꿔서 하실분들은 수정하시면 되겠죠...^^

<%@ page import="java.sql.*" %>
<%
StringBuffer sbError = new StringBuffer();
DatabaseMetaData dbMetaData = null;
Connection conn = null;
%>
<font size="-1"><p>
<%
DriverManager.registerDriver (new oracle.jdbc.OracleDriver());
try {
    conn = DriverManager.getConnection("jdbc:oracle:thin:@hostname:port:SID", "user", "password");
    dbMetaData = conn.getMetaData();
%>
<p>
Name of JDBC Driver: <%= dbMetaData.getDriverName() %><br>
Version: <%= dbMetaData.getDriverVersion() %><br>
Major: <%= dbMetaData.getDriverMajorVersion() %><br>
Minor: <%= dbMetaData.getDriverMinorVersion() %><br>
<p>
Database Name: <%= dbMetaData.getDatabaseProductName() %><br>
Version: <%= dbMetaData.getDatabaseProductVersion() %><br>
<%
} catch (SQLException e) {
    sbError.append(e.toString());
} finally {
    if (conn != null) {
        try {
            conn.close();
        } catch (SQLException e) {
            sbError.append(e.toString());
        }
    }
}
if (sbError.length() != 0) {
    out.println(sbError.toString());
} else {
%>
<p>No error</font>
<%
}
%>

[출처] jdbc 버전알아보기|작성자 현혜사랑