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.sforce.SForceDriver");
DriverManager.getConnection("jdbc:datadirect:sforce://login.salesforce.com;
User=abc@defcorp.com;Password=secret;SecurityToken=XaBARTsLZReM4Px47qPLOS;
spyAttributes=(log=(file)c:\\temp\\spy.log)");
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:sforce:;MAXSOQLLENGTH=20000;JDBCBEHAVIOR=1;LOGINHOST=;APPLICATIONNAME=;
WSFETCHSIZE=2000;PROXYHOST=;CATALOGOPTIONS=2;BULKLOADCONCURRENCYMODE=PARALLEL;LOGSOAP=false;
WSPOOLSIZE=1;BULKLOADBATCHSIZE=10000;ENABLEBULKLOAD=false;STMTCALLLIMIT=0;
CONNECTIONRETRYDELAY=1;READONLY=false;CLIENTUSER=;BULKLOADTHRESHOLD=4000;WORKAROUNDS=0;
CONVERTNULL=1;RECORDRESTEVENTS=false;CONNECTIONRETRYCOUNT=5;READAHEAD=0;CUSTOMSUFFIX=strip;
TOKEN=;STMTCALLLIMITBEHAVIOR=ErrorAlways;LOADLIBRARYPATH=;ENABLEHTTPCHUNKING=true;
MAXPOOLEDSTATEMENTS=0;CRYPTOPROTOCOLVERSION=;QUERYTIMEOUT=0;PROXYPASSWORD=;
SERIALIZECREATECOLUMNS=false;TRANSACTIONMODE=NoTransactions;WSRETRYCOUNT=0;PROGRAMID=;
PROXYPORT=0;WSCOMPRESSDATA=Compress;SECURERANDOMALGORITHM=;DEBUGPLAYBACK=;
REGISTERSTATEMENTPOOLMONITORMBEAN=false;BULKLOADPOLLINTERVAL=10;IMPORTSTATEMENTPOOL=;SERVERPATH=;
LOADBALANCING=false;LOGINTIMEOUT=0;WSTIMEOUT=120;RANDOMGENERATOR=SECURERANDOM;PROXYUSER=;
FAILOVERGRANULARITY=nonAtomic;ACCOUNTINGINFO=;LOGCONFIGFILE=ddlogging.properties;
ENCRYPTIONMETHOD=noEncryption;FAILOVERMODE=connect;INITIALIZATIONSTRING=;
BATCHPERFORMANCEWORKAROUND=false;JAVADOUBLETOSTRING=false;ENABLETESTPROCS=false;DEBUGRECORD=;
AUTHENTICATIONMETHOD=none;CLIENTHOSTNAME=;CONFIGOPTIONS=;CREATEDB=NotExist;REFRESHSCHEMA=false;
RESULTSETMETADATAOPTIONS=0;FAILOVERPRECONNECT=false;D2CDATASTOREID=0;
SPYATTRIBUTES=(log=(file)c:\temp\spy.log);MAXDESCRIBEOBJECTS=100;INSENSITIVERESULTSETBUFFERSIZE=2048;
FETCHSIZE=100;SECURITYTOKEN=89mqiEVzSigEXmr7vQqCoOuN2;SCHEMAMAP=;ENABLEREPORTPARAMETERS=false;
ALTERNATESERVERS=;BULKLOADASYNC=false)
spy>> DatabaseMetaData[1].getDriverName()
spy>> OK (SForce)
spy>> DatabaseMetaData[1].getDriverVersion()
spy>> OK (6.0.0.0000 (C0000.F000000.U000000))
spy>> DatabaseMetaData[1].getDatabaseProductName()
spy>> OK (Salesforce)
spy>> DatabaseMetaData[1].getDatabaseProductVersion()
spy>> OK (41.0)
spy>> Connection Options :
spy>> MAXSOQLLENGTH=20000
spy>> JDBCBEHAVIOR=1
spy>> LOGINHOST=
spy>> APPLICATIONNAME=
spy>> WSFETCHSIZE=2000
spy>> ...
spy>> LOGINTIMEOUT=0
spy>> WSTIMEOUT=120
spy>> RANDOMGENERATOR=SECURERANDOM
spy>> PROXYUSER=
spy>> FAILOVERGRANULARITY=nonAtomic
spy>> ...
spy>> SCHEMAMAP=
spy>> ENABLEREPORTPARAMETERS=false
spy>> ALTERNATESERVERS=
spy>> BULKLOADASYNC=false
spy>> Driver Name = SForce
spy>> Driver Version = 6.0.0.0000 (C0000.F000000.U000000))
spy>> Database Name = Salesforce
spy>> Database Version = 41.0
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
