|
Problem(Abstract) |
How does WebSphere Application Server v5.0.x retrieve
information from the database in order to display the database version and
JDBC driver version in the logs?
For example, this output from MS SQL Server:
[25/09/03 14:11:16:107 GMT+10:00] 68f815e0 WSRdbDataSour u Database
version is
Microsoft SQL Server 2000 - 8.00.534 (Intel X86) Nov 19 2001 13:23:50
Copyright (c) 1988-2000 Microsoft Corporation
Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 2)
[25/09/03 14:11:17:278 GMT+10:00] 68f815e0 WSRdbDataSour u JDBC Driver
version is
3.2.006907003404004416 |
|
|
|
Resolving the
problem |
WebSphere Application Server obtains this information from
the meta data of the connection. This information is retrieved by doing
the following:
java.sql.DatabaseMetaData mData = conn.getMetaData();
System.out.println("Database version is" +
mData.getDatabaseProductVersion());
System.out.println("JDBC Driver version is" +
ata.getDriverVersion()); |
|
|
|
|
Cross Reference information |
Segment |
Product |
Component |
Platform |
Version |
Edition |
Application Servers |
Runtimes for Java Technology |
Java SDK |
|
|
|
|
|
|