JDBC Type 2 Driver Programmer's Reference for SQL/MX Release 3.2.1 (H06.26+, J06.15+)

T2QueryExecuteLogFile Property
You can use the T2QueryExecuteLogFile property to set the name of the log file. You must
set the T2QueryExecuteLogFile property on a DataSource object,
ConnectionPoolDataSource object, or a DriverManager object.
You must consider the following settings while configuring the T2QueryExecuteLogFile property:
• Data type — string
• File name — OSS file name. You can assign either the full path of the log file or only the name
of the log file. The following are examples of the log file names:
◦ -Djdbcmx.T2QueryExecuteLogFile=/home/t2query.log
◦ -Djdbcmx.T2QueryExecuteLogFile=t2query.log
• Default log file name — t2sqlmxQueryExecuteTime.log
• File location — The log file will be created in the specified location. If the full path is not
specified, the log file will be created in the current working directory. For example, if the
current working directory is /home/usr and the value of the
-Djdbcmx.T2QueryExecuteLogFile property is t2query.log, then the t2query.log
file will be created at /home/usr. However, if the value of the
-Djdbcmx.T2QueryExecuteLogFile property is /home/t2query.log, then the
t2query.log file will be created at /home irrespective of the current working directory.
If you configure a log file, it is overwritten each time a FileHandler is established using that
filename.
For more information on setting properties, see “Setting Properties in the Command Line” (page
31).
The following are sample contents of the T2QueryExecuteLogFile:
jdbcTrace:[05/02/12 01:05:24]:TRACING JDBC/MX VERSION: T1275R32_30AUG2012_JDBCMX_1209
STMT1:select c2 from tab1: TIME TAKEN 9 ms
STMT2:select c2 from tab1: TIME TAKEN 4 ms
STMT3:select * from tab1: TIME TAKEN 15 ms
NOTE: Parameter values of the execution do not appear.
Setting Properties in the Command Line
JDBC/MX driver property names used on the command line in the java -D option must include
the prefix:
jdbcmx.
This notation, which includes the period (.), ensures that all the JDBC/MX driver property names
are unique for a Java application. For example: the maxStatements property becomes
jdbcmx.maxStatements
Table 5 JDBC/MX Driver Properties Allowed in the Command Line
DescriptionProperty NameJDBC/MX Prefix
Communicates with JDBC driver to continue the remaining
jobs in the batch even after any BatchUpdateExceptions.
See “contBatchOnError property” (page 39).
contBatchOnErrorjdbcmx.
Allows the user to enable atomicity of SQL statements at
statement level. See “stmtatomicity property” (page 40).
stmtatomicityjdbcmx.
JDBC/MX Properties 31