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>> OKspy>> 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