skip to main content
Troubleshooting : Troubleshooting your application : DataDirect Spy log example
  

Try DataDirect Drivers Now

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.oracle.OracleDriver");
DriverManager.getConnection("jdbc:datadirect:oracle://nc-myserver:1521;
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[2].getMetaData()
spy>> OK (DatabaseMetaData[2])

spy>> DatabaseMetaData[2].getURL()
spy>> OK
(jdbc:datadirect:oracle://nc-myserver:1521;JDBCBEHAVIOR=1;APPLICATIONNAME=;KEYPASSWORD=;
ENCRYPTIONTYPES=(AES128,AES192,AES256,DES,3DES112,3DES168,RC4_40,RC4_56,RC4_128,RC4_256);
BATCHMECHANISM=;SUPPORTLINKS=false;CATALOGOPTIONS=2;REFCURSORSUPPORT=true;
INITIALCOLUMNBUFFERSIZE=-1;SOCKETDEFAULTSENDBUFFERSIZE=0;BULKLOADBATCHSIZE=1000;
ENABLEBULKLOAD=false;DATABASENAME=SQLDT;CONNECTIONRETRYDELAY=1;CLIENTUSER=;SID=;
WORKAROUNDS=0;VALIDATESERVERCERTIFICATE=true;CONVERTNULL=1;DATAINTEGRITYLEVEL=Accepted;
CONNECTIONRETRYCOUNT=5;ACTION=;TRUSTSTORE=;STRINGPARAMSMUSTMATCHCHARCOLUMNS=true;
LOADLIBRARYPATH=;EDITIONNAME=;MAXPOOLEDSTATEMENTS=0;CLIENTID=oracle.OASAccepted_ConTerminate;
SENDFLOATPARAMETERSASSTRING=false;CRYPTOPROTOCOLVERSION=;SYSLOGINROLE=;SERVICENAME=;
QUERYTIMEOUT=0;DATAINTEGRITYTYPES=(MD5,SHA1,SHA256,SHA384,SHA512);PROGRAMID=;
SOCKETDEFAULTRECEIVEBUFFERSIZE=65536;SECURERANDOMALGORITHM=;
REGISTERSTATEMENTPOOLMONITORMBEAN=false;MODULE=oracle.OASAccepted_ConTerminate;
IMPORTSTATEMENTPOOL=;LOADBALANCING=false;KEYSTOREPASSWORD=;SERVERTYPE=;LOGINTIMEOUT=0;
RANDOMGENERATOR=SECURERANDOM;FAILOVERGRANULARITY=nonAtomic;ACCOUNTINGINFO=;
REPORTRECYCLEBIN=true;ENCRYPTIONMETHOD=NoEncryption;WIREPROTOCOLMODE=2;FAILOVERMODE=connect;
ENABLESERVERRESULTCACHE=false;SDUSIZE=16384;SUPPORTBINARYXML=false;INITIALIZATIONSTRING=;
BATCHPERFORMANCEWORKAROUND=false;JAVADOUBLETOSTRING=false;CODEPAGEOVERRIDE=;
AUTHENTICATIONMETHOD=auto;CLIENTHOSTNAME=;TNSSERVERNAME=;COMMITBEHAVIOR=serverDefault;
DDTDBG.PROTOCOLTRACELOCATION=Snoop.;RESULTSETMETADATAOPTIONS=0;FAILOVERPRECONNECT=false;
SPYATTRIBUTES=(log=(file)c:\props\spy\spy_bulkLoad.log);DDTDBG.PROTOCOLTRACEMAXLINE=16;
INSENSITIVERESULTSETBUFFERSIZE=2048;TNSNAMESFILE=;ENABLECANCELTIMEOUT=false;
ENCRYPTIONLEVEL=Accepted;HOSTNAMEINCERTIFICATE=;FETCHTSWTZASTIMESTAMP=false;ALTERNATESERVERS=;
LOBPREFETCHSIZE=4000;BULKLOADOPTIONS=0;TRUSTSTOREPASSWORD=;DDTDBG.PROTOCOLTRACEENABLE=true;
KEYSTORE=)1
spy>> DatabaseMetaData[2].getDriverName()
spy>> OK (Oracle)

spy>> DatabaseMetaData[2].getDriverVersion()
spy>> OK (6.0.0.000500 (F000891.U000351)

spy>> DatabaseMetaData[2].getDatabaseProductName()
spy>> OK (Oracle)

spy>> DatabaseMetaData[2].getDatabaseProductVersion()
spy>> OK (12.1.0.1.0)

spy>> Connection Options :2
spy>> JDBCBEHAVIOR=1
spy>> APPLICATIONNAME=
spy>> KEYPASSWORD=
spy>> ENCRYPTIONTYPES=(AES128,AES192,AES256,DES,3DES112,3DES168,RC4_40,RC4_56,RC4_128,RC4_256)
spy>> BATCHMECHANISM=
spy>> SUPPORTLINKS=false
spy>> CATALOGOPTIONS=2
spy>> REFCURSORSUPPORT=true
spy>> INITIALCOLUMNBUFFERSIZE=-1
spy>> SOCKETDEFAULTSENDBUFFERSIZE=0
spy>> BULKLOADBATCHSIZE=1000
spy>> ENABLEBULKLOAD=false
spy>> DATABASENAME=SQLDT
spy>> CONNECTIONRETRYDELAY=1
spy>> CLIENTUSER=
spy>> SID=
spy>> WORKAROUNDS=0
spy>> VALIDATESERVERCERTIFICATE=true
spy>> CONVERTNULL=1
spy>> DATAINTEGRITYLEVEL=Accepted
spy>> CONNECTIONRETRYCOUNT=5
spy>> ACTION=
spy>> TRUSTSTORE=
spy>> STRINGPARAMSMUSTMATCHCHARCOLUMNS=true
spy>> LOADLIBRARYPATH=
spy>> EDITIONNAME=
spy>> MAXPOOLEDSTATEMENTS=0
spy>> CLIENTID=oracle.OASAccepted_ConTerminate
spy>> SENDFLOATPARAMETERSASSTRING=false
spy>> CRYPTOPROTOCOLVERSION=
spy>> SYSLOGINROLE=
spy>> SERVICENAME=
spy>> QUERYTIMEOUT=0
spy>> DATAINTEGRITYTYPES=(MD5,SHA1,SHA256,SHA384,SHA512)
spy>> PROGRAMID=
spy>> SOCKETDEFAULTRECEIVEBUFFERSIZE=65536
spy>> SECURERANDOMALGORITHM=
spy>> REGISTERSTATEMENTPOOLMONITORMBEAN=false
spy>> MODULE=oracle.OASAccepted_ConTerminate
spy>> IMPORTSTATEMENTPOOL=
spy>> LOADBALANCING=false
spy>> KEYSTOREPASSWORD=
spy>> SERVERTYPE=
spy>> LOGINTIMEOUT=0
spy>> RANDOMGENERATOR=SECURERANDOM
spy>> FAILOVERGRANULARITY=nonAtomic
spy>> ACCOUNTINGINFO=
spy>> REPORTRECYCLEBIN=true
spy>> ENCRYPTIONMETHOD=NoEncryption
spy>> WIREPROTOCOLMODE=2
spy>> FAILOVERMODE=connect
spy>> ENABLESERVERRESULTCACHE=false
spy>> SDUSIZE=16384
spy>> SUPPORTBINARYXML=false
spy>> INITIALIZATIONSTRING=
spy>> BATCHPERFORMANCEWORKAROUND=false
spy>> JAVADOUBLETOSTRING=false
spy>> CODEPAGEOVERRIDE=
spy>> AUTHENTICATIONMETHOD=auto
spy>> CLIENTHOSTNAME=
spy>> TNSSERVERNAME=
spy>> COMMITBEHAVIOR=serverDefault
spy>> DDTDBG.PROTOCOLTRACELOCATION=Snoop.
spy>> RESULTSETMETADATAOPTIONS=0
spy>> FAILOVERPRECONNECT=false
spy>> SPYATTRIBUTES=(log=(file)c:\props\spy\spy_bulkLoad.log)
spy>> DDTDBG.PROTOCOLTRACEMAXLINE=16
spy>> INSENSITIVERESULTSETBUFFERSIZE=2048
spy>> TNSNAMESFILE=
spy>> ENABLECANCELTIMEOUT=false
spy>> ENCRYPTIONLEVEL=Accepted
spy>> HOSTNAMEINCERTIFICATE=
spy>> FETCHTSWTZASTIMESTAMP=false
spy>> ALTERNATESERVERS=
spy>> LOBPREFETCHSIZE=4000
spy>> BULKLOADOPTIONS=0
spy>> TRUSTSTOREPASSWORD=
spy>> DDTDBG.PROTOCOLTRACEENABLE=true
spy>> KEYSTORE=

spy>> Driver Name = Oracle3
spy>> Driver Version = 6.0.0.000500 (F000891.U000351)4
spy>> Database Name = Oracle5
spy>> Database Version = 12.1.0.1.06
spy>> Connection[2].isClosed()
spy>> OK (false)
1 The combination of the URL specified by the application and the default values of all connection properties not specified.

2 The combination of the connection properties specified by the application and the default values of all connection properties not specified.

3 The name of the driver.

4 The version of the driver.

5 The name of the database server to which the driver connects.

6 The version of the database to which the driver connects.