Database connection validation results sample

The following sample log output details the information that is retrieved, tested, and validated by the database connection validation utility. This sample output is for a IBM WebSphere Commerce Developer environment that runs on the Windows operating system with an Apache Derby database.

The following code is a snippet of a sample wcsDbValidation.log file that is generated when the database connection validation utility is run separate from any other utility or process.


   W:\WCDE_installdir\bin>wcsDbValidation.bat
   DBValidationDriver version 8.0 (20151015)

   Validate:
   [WcsDbValidation] WcsDbValidation version 8.0 (20151015)
   [WcsDbValidation] ***************************************************************
   [WcsDbValidation] Start time = 2015-11-05 09:54:05.877
   [WcsDbValidation] >>>>>>>>>> System <<<<<<<<<<
1[WcsDbValidation] OS:
   [WcsDbValidation]   name = Windows 7
   [WcsDbValidation]   version = 6.1
   [WcsDbValidation]   architecture = amd64
   [WcsDbValidation]
2[WcsDbValidation] Java:
   [WcsDbValidation]   vendor = IBM Corporation
   [WcsDbValidation]   version = 1.7.0
   [WcsDbValidation]   specification version = 1.7
   [WcsDbValidation]   home = WAS_installdir\JAVA_1~1.7_6\jre
   [WcsDbValidation]   class version = 51.0
   [WcsDbValidation]
3[WcsDbValidation] User:
   [WcsDbValidation]   name = build
   [WcsDbValidation]   home = C:\Users\build
   [WcsDbValidation]   directory = WCDE_installdir\bin
   [WcsDbValidation]   language = en
   [WcsDbValidation]   timezone = America/New_York
   [WcsDbValidation]
4[WcsDbValidation] Heap:
   [WcsDbValidation]   maximum allocation =     512.00 megabytes
   [WcsDbValidation]   current allocation =      13.38 megabytes
   [WcsDbValidation]
5[WcsDbValidation] WebSphere Commerce:
   [WcsDbValidation]   WCUserInstallDir = WCDE_installdir (project) (readable)
   [WcsDbValidation]   instanceName = demo
   [WcsDbValidation]   instanceName directory = WCDE_installdir\workspace\WC (readable)
   [WcsDbValidation]   loggerconfigfile = WCDE_installdir/xml/loader/WCALoggerConfig.xml (project) (readable)
   [WcsDbValidation]   errordirectory = WCDE_installdir/logs (project) (readable)
   [WcsDbValidation] >>>>>>>>>> System <<<<<<<<<<
   [WcsDbValidation] >>>>>>>>>> Database <<<<<<<<<<
6[WcsDbValidation] Properties:
   [WcsDbValidation]   dbType = cloudscape (project)
   [WcsDbValidation]   dbHostname =  (project)
   [WcsDbValidation]   dbName = WCDE_installdir\db\mall (project)
   [WcsDbValidation]   portnumber missing.
   [WcsDbValidation]   dbUserName = APP (project)
   [WcsDbValidation]   dbUserPassword = ***** (project)
   [WcsDbValidation]   dbaName = APP (project)
   [WcsDbValidation]   dbaPassword = ***** (project)
   [WcsDbValidation]   schemaName = APP (project)
   [WcsDbValidation]   jdbcDriver = org.apache.derby.jdbc.EmbeddedDriver (project)
   [WcsDbValidation]   jdbcURL = jdbc:derby:WCDE_installdir\db\mall (project)
   [WcsDbValidation]
   [WcsDbValidation] Checking for minimum-required properties to test database connections: [jdbcURL], [jdbcDriver], [dbUserName], [dbUserPassword] ...
   [WcsDbValidation]   ... found
   [WcsDbValidation]
7[WcsDbValidation] Connection Testing:
   [WcsDbValidation]   Test with supplied jdbcDriver
   [WcsDbValidation]   jdbcDriver = org.apache.derby.jdbc.EmbeddedDriver found.
   [WcsDbValidation]     Location = file:/WCDE_installdir/lib/derby.jar!/org/apache/derby/jdbc/EmbeddedDriver.class
   [WcsDbValidation]
   [WcsDbValidation]   Further diagnosing DB type: [cloudscape]
   [WcsDbValidation]     DB type indicated by JDBC URL: [derby]
   [WcsDbValidation]     DB type indicated by JDBC Driver: [derby]
   [WcsDbValidation]     DB type set to: [derby]
   [WcsDbValidation]
   [WcsDbValidation]   Test connection with supplied jdbcURL using dbUserName and dbUserPassword.
   [WcsDbValidation]   [AllDBConnector]
   [WcsDbValidation]   Connection successful with following parameters:
   [WcsDbValidation]     jdbcURL = jdbc:derby:WCDE_installdir\db\mall
   [WcsDbValidation]     dbType = derby; dbUserName = APP; dbUserPassword = *****
   [WcsDbValidation]       Connection class name = org.apache.derby.impl.jdbc.EmbedConnection40
   [WcsDbValidation]       Database product name = Apache Derby
   [WcsDbValidation]       Database product version = 10.10.2.1 - (1643489)
   [WcsDbValidation]       Database major version = 10
   [WcsDbValidation]       Database minor version = 10
   [WcsDbValidation]       Database driver name = Apache Derby Embedded JDBC Driver
   [WcsDbValidation]       Database driver version = 10.10.2.1 - (1643489)
   [WcsDbValidation]       Database driver major version = 10
   [WcsDbValidation]       Database driver minor version = 10
   [WcsDbValidation]     WebSphere Commerce features:
   [WcsDbValidation]       Feature name = BASE. VRMF = 8.0.0.0
   [WcsDbValidation]
   [WcsDbValidation]   [DriverManager]
   [WcsDbValidation]   Connection successful with following parameters:
   [WcsDbValidation]     jdbcURL = jdbc:derby:WCDE_installdir\db\mall
   [WcsDbValidation]     dbType = derby; dbUserName = APP; dbUserPassword = *****
   [WcsDbValidation]       Connection class name = org.apache.derby.impl.jdbc.EmbedConnection40
   [WcsDbValidation]       Database product name = Apache Derby
   [WcsDbValidation]       Database product version = 10.10.2.1 - (1643489)
   [WcsDbValidation]       Database major version = 10
   [WcsDbValidation]       Database minor version = 10
   [WcsDbValidation]       Database driver name = Apache Derby Embedded JDBC Driver
   [WcsDbValidation]       Database driver version = 10.10.2.1 - (1643489)
   [WcsDbValidation]       Database driver major version = 10
   [WcsDbValidation]       Database driver minor version = 10
   [WcsDbValidation]
8[WcsDbValidation]   Test other possible drivers and connections
   [WcsDbValidation] >>>>>>>>>> Database <<<<<<<<<<
   [WcsDbValidation] End time = 2015-11-05 09:54:10.085
   [WcsDbValidation] ***************************************************************
   
   BUILD SUCCESSFUL
   Total time: 7 seconds

Where

System related information

1 - OS information: Information about the operating system. This information includes the name, version, and architecture of the operating system.
2 - Java information: Information about the Java Runtime Environment. The Java version must be 1.7.0.
3 - User information: Information about the WebSphere Commerce user that is running the database connection validation utility.
4 - heap information: The allocated memory. Ensure that sufficient memory is allocated for the utility to complete successfully.
5 - WebSphere Commerce information: Information about the WebSphere Commerce instance, including the instance name, installation directory, and logging configuration file.

Database connection information

6 - Properties: The input parameters for the WebSphere Commerce database that are used to complete database-related processes for WebSphere Commerce utilities.
7 - Connection testing: Information about the JDBC driver and class are output in this section. If a successful database connection is established, the parameters that were used to establish the connection are included in this section.
8 - Test other possible drivers and connections: Information about alternate JDBC drivers that are tested and validated by the database connection validation utility. In this sample, no alternate JDBC driver and class are found.