Database version and JDBC driver version displayed in the SystemOut logs
 Technote (troubleshooting)
 
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
 
 


Document Information


Product categories: Software > Application Servers > Distributed Application & Web Servers > WebSphere Application Server > DB Connections/Connection Pooling
Operating system(s): Windows
Software version: 5.0.2.9
Software edition:
Reference #: 1144210
IBM Group: Software Group
Modified date: Dec 1, 2004