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.autorest.AutoRESTDriver");
DriverManager.getConnection("jdbc:datadirect:autorest:config=D:\\work\\temp\\countries.rest;
spyAttributes=(log=(file)D:\\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:autorest:;JDBCBEHAVIOR=1;APPLICATIONNAME=;KEYPASSWORD=;WSFETCHSIZE=10000;
STRINGTRUNCATIONMETHOD=truncate;PROXYHOST=;CATALOGOPTIONS=2;WSPOOLSIZE=1;CREATEMAP=Session;
ACCESSTOKEN=;DECIMALROUNDINGMETHOD=round;BULKLOADBATCHSIZE=10000;DATABASENAME=;
STMTCALLLIMIT=0;CONNECTIONRETRYDELAY=1;REFRESHTOKEN=;READONLY=false;CLIENTUSER=;
TIMELITERALDEFAULTTIMEZONE=local;WORKAROUNDS=0;BINARYTRUNCATIONMETHOD=keep;CONVERTNULL=1;
RECORDRESTEVENTS=false;CONNECTIONRETRYCOUNT=5;READAHEAD=0;
CONFIG=file:D:\\work\\temp\\countries.rest;TRUSTSTORE=;STMTCALLLIMITBEHAVIOR=ErrorAlways;
SCOPE=;LOADLIBRARYPATH=;MAXPOOLEDSTATEMENTS=0;CLIENTID=;CRYPTOPROTOCOLVERSION=;
QUERYTIMEOUT=0;PROXYPASSWORD=;TRANSACTIONMODE=NoTransactions;WSRETRYCOUNT=5;PROGRAMID=;
PROXYPORT=0;SECURERANDOMALGORITHM=;DEBUGPLAYBACK=;REGISTERSTATEMENTPOOLMONITORMBEAN=false;
IMPORTSTATEMENTPOOL=;SERVERPATH=;LOADBALANCING=false;KEYSTOREPASSWORD=;LOGINTIMEOUT=0;
AUTHPARAM=;WSTIMEOUT=120;RANDOMGENERATOR=SECURERANDOM;PROXYUSER=;FAILOVERGRANULARITY=nonAtomic
;ACCOUNTINGINFO=;LOGCONFIGFILE=ddlogging.properties;ENCRYPTIONMETHOD=SSL;SCHEMAVIEW=both;
OAUTHCODE=;FAILOVERMODE=connect;_USERHASH=;INITIALIZATIONSTRING=;
BATCHPERFORMANCEWORKAROUND=false;JAVADOUBLETOSTRING=false;DEBUGRECORD=;
AUTHENTICATIONMETHOD=None;CLIENTHOSTNAME=;CONFIGOPTIONS=CONFIG=file:D:\\work\\temp\\countries.rest;
AUTHHEADER=;REFRESHSCHEMA=false;FAILOVERPRECONNECT=false;RESULTSETMETADATAOPTIONS=0;
D2CDATASTOREID=0;SPYATTRIBUTES=(log=(file)D:\\work\\temp\\spy.log);
INSENSITIVERESULTSETBUFFERSIZE=2048;FETCHSIZE=100;SECURITYTOKEN=;SCHEMAMAP=;CLIENTSECRET=;
ALTERNATESERVERS=;TRUSTSTOREPASSWORD=;REFRESHDIRTYCACHE=true;KEYSTORE=)1

spy>> DatabaseMetaData[1].getDriverName()
spy>> OK (AutoREST)

spy>> DatabaseMetaData[1].getDriverVersion()
spy>> OK (6.0.0.0000 (C0000.F000000.U000000))

spy>> DatabaseMetaData[1].getDatabaseProductName()
spy>> OK (AutoREST)

spy>> DatabaseMetaData[1].getDatabaseProductVersion()
spy>> OK (41.0)

spy>> Connection Options :2
spy>> JDBCBEHAVIOR=1
spy>> APPLICATIONNAME=
spy>> KEYPASSWORD=
spy>> WSFETCHSIZE=10000
spy>> STRINGTRUNCATIONMETHOD=truncate
spy>> ...
spy>> DECIMALROUNDINGMETHOD=round
spy>> BULKLOADBATCHSIZE=10000
spy>> DATABASENAME=
spy>> STMTCALLLIMIT=0
spy>> CONNECTIONRETRYDELAY=1
spy>> ...
spy>> CLIENTSECRET=
spy>> ALTERNATESERVERS=
spy>> TRUSTSTOREPASSWORD=
spy>> REFRESHDIRTYCACHE=true
spy>> KEYSTORE=
spy>> Driver Name = AutoREST3
spy>> Driver Version = 6.0.0.0000 (C0000.F000000.U000000))4
spy>> Database Name = AutoREST5
spy>> Database Version = 1.06
spy>> Connection[1].getMetaData()
spy>> OK (DatabaseMetaData[2])7
spy>> DatabaseMetaData[2].getURL()
spy>> OK (jdbc:datadirect:autorest:;JDBCBEHAVIOR=1;APPLICATIONNAME=;KEYPASSWORD=;
WSFETCHSIZE=10000; … )
spy>> OK (1)
spy>> Connection[1].createStatement
spy>> OK (Statement[1])
spy>> Statement[1].executeQuery(String sql)
spy>> sql = SELECT * FROM WEEKLYTIMESERIES
spy>> OK (ResultSet[1])8
spy>> ResultSet[1].getMetaData()
spy>> OK (ResultSetMetaData[1])9
spy>> ResultSetMetaData[1].getColumnCount()
spy>> OK (7)10
spy>> ResultSetMetaData[1].getColumnLabel(int column)
spy>> column = 1
spy>> OK (COUNTRIES_METADATA_1INFORMATION)11
spy>> ResultSetMetaData[1].getColumnLabel(int column)
spy>> column = 2
spy>> OK (KEY)12
spy>> ResultSet[1].next()
spy>> OK (true)13
spy>> ResultSet[1].getString(int columnIndex)
spy>> columnIndex = 1
spy>> OK (Weekly Prices)14
spy>> ResultSet[1].getString(int columnIndex)
spy>> columnIndex = 2
spy>> OK (1982-11-09)15
spy>> ResultSet[1].getString(int columnIndex)
spy>> columnIndex = 2
spy>> OK (CLERK)16
spy>> ResultSet[1].next()
spy>> OK (false)17
spy>> ResultSet[1].close()
spy>> OK18
spy>> Statement[1].close()
spy>> OK19
spy>> Connection[1].close()
spy>> OK20
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.

7 The application checks to see if there are any warnings. In this example, no warnings are present.

8 The SELECT statement is executed.

9 Some metadata is requested.

10 Some metadata is requested.

11 Some metadata is requested.

12 Some metadata is requested.

13 The first row is retrieved and the application retrieves the result values.

14 The first row is retrieved and the application retrieves the result values.

15 The first row is retrieved and the application retrieves the result values.

16 The first row is retrieved and the application retrieves the result values.

17 The application attempts to retrieve the next row, but only one row was returned for this query.

18 After the application has completed retrieving result values, the result set is closed.

19 After the application is done using a statement, resources associated with the statement are released.

20 The application finishes and disconnects.