DataDirect Spy Log Example
This section provides information to help you understand the content of your own DataDirect Spy logs. For example, suppose your application executes the following code and performs some operations:
Class.forName("com.ddtek.jdbc.sqlserver.SQLServerDriver"); DriverManager.getConnection("jdbc:datadirect:sqlserver:// nc-myserver\ \sqlserver2005;useServerSideUpdatableCursors=true;resultsetMetaDataOptions=1; sendStringParametersAsUnicode=true;alwaysReportTriggerResults=false; spyAttributes=(log=(file)c:\\temp\\spy.log)","test04", "test04");
The log file generated by DataDirect Spy would look similar to the following example. Notes provide explanations for the referenced text.
spy>> Connection[1].getMetaData() spy>> OK (DatabaseMetaData[1]) spy>> DatabaseMetaData[1].getURL() spy>> OK (jdbc:datadirect:sqlserver://nc-myserver\sqlserver2005:1433;CONNECTIONRETRYCOUNT=5; RECEIVESTRINGPARAMETERTYPE=nvarchar;ALTERNATESERVERS=;DATABASENAME=;PACKETSIZE=16;INITIALIZATIONSTRING=; ENABLECANCELTIMEOUT=false;BATCHPERFORMANCEWORKAROUND=false;AUTHENTICATIONMETHOD=auto; SENDSTRINGPARAMETERSASUNICODE=true;LOGINTIMEOUT=0;WSID=;SPYATTRIBUTES=(log=(file)c:\temp\spy.log); RESULTSETMETADATAOPTIONS=1;ALWAYSREPORTTRIGGERRESULTS=false;TRANSACTIONMODE=implicit; USESERVERSIDEUPDATABLECURSORS=true;SNAPSHOTSERIALIZABLE=false;JAVADOUBLETOSTRING=false; SELECTMETHOD=direct;LOADLIBRARYPATH=;CONNECTIONRETRYDELAY=1;INSENSITIVERESULTSETBUFFERSIZE=2048; MAXPOOLEDSTATEMENTS=0;DESCRIBEPARAMETERS=noDescribe;CODEPAGEOVERRIDE=;NETADDRESS=000000000000; PROGRAMNAME=;LOADBALANCING=false;HOSTPROCESS=0) spy>> DatabaseMetaData[1].getDriverName() spy>> OK (SQLServer) spy>> DatabaseMetaData[1].getDriverVersion() spy>> OK (3.60.0 (000000.000000.000000)) spy>> DatabaseMetaData[1].getDatabaseProductName() spy>> OK (Microsoft SQL Server) spy>> DatabaseMetaData[1].getDatabaseProductVersion() spy>> OK (Microsoft SQL Server Yukon - 9.00.1399) spy>> Connection Options : spy>> CONNECTIONRETRYCOUNT=5 spy>> RECEIVESTRINGPARAMETERTYPE=nvarchar spy>> ALTERNATESERVERS= spy>> DATABASENAME= spy>> PACKETSIZE=16 spy>> INITIALIZATIONSTRING= spy>> ENABLECANCELTIMEOUT=false spy>> BATCHPERFORMANCEWORKAROUND=false spy>> AUTHENTICATIONMETHOD=auto spy>> SENDSTRINGPARAMETERSASUNICODE=true spy>> LOGINTIMEOUT=0 spy>> WSID= spy>> SPYATTRIBUTES=(log=(file)c:\temp\spy.log) spy>> RESULTSETMETADATAOPTIONS=1 spy>> ALWAYSREPORTTRIGGERRESULTS=false spy>> TRANSACTIONMODE=implicit spy>> USESERVERSIDEUPDATABLECURSORS=true spy>> SNAPSHOTSERIALIZABLE=false spy>> JAVADOUBLETOSTRING=false spy>> SELECTMETHOD=direct spy>> LOADLIBRARYPATH= spy>> CONNECTIONRETRYDELAY=1 spy>> INSENSITIVERESULTSETBUFFERSIZE=2048 spy>> MAXPOOLEDSTATEMENTS=0 spy>> DESCRIBEPARAMETERS=noDescribe spy>> CODEPAGEOVERRIDE= spy>> NETADDRESS=000000000000 spy>> PROGRAMNAME= spy>> LOADBALANCING=false spy>> HOSTPROCESS=0 spy>> Driver Name = SQLServer spy>> Driver Version = 3.60.0 (000000.000000.000000) spy>> Database Name = Microsoft SQL Server spy>> Database Version = Microsoft SQL Server Yukon - 9.00.1399 spy>> Connection[1].getWarnings() spy>> OK spy>> Connection[1].createStatement spy>> OK (Statement[1]) spy>> Statement[1].executeQuery(String sql) spy>> sql = select empno,ename,job from emp where empno=7369 spy>> OK (ResultSet[1]) spy>> ResultSet[1].getMetaData() spy>> OK (ResultSetMetaData[1]) spy>> ResultSetMetaData[1].getColumnCount() spy>> OK (3) spy>> ResultSetMetaData[1].getColumnLabel(int column) spy>> column = 1 spy>> OK (EMPNO)spy>> ResultSetMetaData[1].getColumnLabel(int column) spy>> column = 2 spy>> OK (ENAME) spy>> ResultSetMetaData[1].getColumnLabel(int column) spy>> column = 3 spy>> OK (JOB)spy>> ResultSet[1].next() spy>> OK (true) spy>> ResultSet[1].getString(int columnIndex) spy>> columnIndex = 1 spy>> OK (7369) spy>> ResultSet[1].getString(int columnIndex) spy>> columnIndex = 2 spy>> OK (SMITH) spy>> ResultSet[1].getString(int columnIndex) spy>> columnIndex = 3 spy>> OK (CLERK) spy>> ResultSet[1].next() spy>> OK (false) spy>> ResultSet[1].close() spy>> OK spy>> Connection[1].close() spy>> OK