{"action":"created","comment":{"url":"https://api.github.com/repos/apache/incubator-trafodion/pulls/comments/61689858","id":61689858,"diff_hunk":"@@ -0,0 +1,195 @@\n+////\n+/**\n+ *@@@ START COPYRIGHT @@@\n+ * Licensed to the Apache Software Foundation (ASF) under one\n+ * or more contributor license agreements. See the NOTICE file\n+ * distributed with this work for additional information\n+ * regarding copyright ownership.  The ASF licenses this file\n+ * to you under the Apache License, Version 2.0 (the\n+ * \"License\"); you may not use this file except in compliance\n+ * with the License.  You may obtain a copy of the License at\n+ *\n+ *     http://www.apache.org/licenses/LICENSE-2.0\n+ *\n+ * Unless required by applicable law or agreed to in writing, software\n+ * distributed under the License is distributed on an \"AS IS\" BASIS,\n+ * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.\n+ * See the License for the specific language governing permissions and\n+ * limitations under the License.\n+ * @@@ END COPYRIGHT @@@\n+ */\n+////\n+\n+[[tracing-and-logging-facilities]]\n+= Tracing and Logging Facilities\n+\n+The Type 4 driver provides two tracing and logging facilities:\n+\n+* Standard JDBC tracing and logging functionality as defined by the JDBC standard\n+* Type 4 driver logging facility\n+\n+Server-side tracing (logging) is enabled by configuring DCS.\n+\n+[[standard-jdbc-tracing-and-logging-facility]]\n+== Standard JDBC Tracing and Logging Facility\n+\n+The JDBC standard provides a logging and tracing facility, which allows\n+tracing JDBC method calls by setting the log writer. To set the log\n+writer, either call the `setLogWriter()` method on the `DriverManager` class\n+or call the `setLogWriter()` method on the `DataSource` class\n+(or `ConnectionPoolDataSource` class).\n+\n+* A `DriverManager` log writer is a character output stream to which all\n+logging and tracing messages for all connections made through the\n+`DriverManager` are printed. This stream includes messages printed by the\n+methods of this connection, messages printed by methods of other objects\n+manufactured by the connection, and so on. The `DriverManager` log writer\n+is initially null, that is, the default is for logging to be disabled.\n+\n+For information about using the setLogWriter method, see the\n+https://docs.oracle.com/javase/7/docs/api/java/sql/DriverManager.html[DriverManager class API].\n+\n+* A `DataSource` log writer is a character output stream to which all\n+logging and tracing messages for this data source are printed. This\n+stream includes messages printed by the methods of this object, messages\n+printed by methods of other objects manufactured by this object, and so\n+on. Messages printed to a data-source-specific log writer are not\n+printed to the log writer associated with the `java.sql.DriverManager`\n+class. When a `DataSource` object is created, the log writer is initially\n+null; that is, the default is for logging to be disabled.\n+\n+For information about using the setLogWriter method, see the\n+https://docs.oracle.com/cd/E16338_01/appdev.112/e13995/oracle/jdbc/pool/OracleDataSource.html[DriverSource interface API].\n+\n+<<<\n+[[the-type-4-driver-logging-facility]]\n+== The Type 4 Driver Logging Facility\n+\n+\n+The Type 4 driver Logging facility allows you to retrieve internal\n+tracing information, which you can use in debugging the driver. It also\n+allows you to capture error and warning messages.\n+\n+In addition to the standard JDBC tracing and logging facility, the Type\n+4 driver provides an independent logging facility (Type 4 Driver\n+Logging). The Type 4 Driver Logging provides the same level of logging\n+and tracing as the standard JDBC tracing and logging facility with the\n+following additional information:\n+\n+* More detail about the internals of the Type 4 driver and internal tracing information\n+* Type 4 driver performance-tuning information\n+* Finer control over the amount and type of logging information\n+* Error and warning messages\n+\n+[[accessing-the-type-4-driver-logging-facility]]\n+=== Accessing the Type 4 Driver Logging Facility\n+\n+The Type 4 Driver Logging facility is based on the `java.util.logging`\n+package. The Type 4 driver instantiates a `java.util.logging.Logger` class\n+and names the logger `org.trafodion.jdbc.t4.logger`.\n+\n+Your JDBC program can access the Type 4 driver logger directly by\n+calling the `java.util.logging.Logger` static method `getLogger(String)`.\n+\n+*example*\n+\n+[source, java]\n+----\n+String t4Logger =\n+   java.util.logging.Logger.getLogger( \"org.trafodion.jdbc.t4.logger\" ) ;\n+----\n+\n+<<<\n+[[controlling-type-4-driver-logging-output]]\n+=== Controlling Type 4 Driver Logging Output\n+\n+The Type 4 driver provides two properties that you can use to control logging output.\n+\n+* `T4LogLevel`: Specifies the level of logging. For information about using this property, see <<t4loglevel-property, T4LogLevel Property>>.\n+* `T4LogFile`: Specifies the file to which the driver is to write logging information. For information about using this property,\n+see <<t4logfile-property, T4LogFile Property>>.\n+\n+If the application sets several property values, see\n+<<precedence-of-property-specifications, Precedence of Property Specifications>> to determine which setting applies.\n+\n+*Example*\n+\n+These properties file entries set the logging level to SEVERE and specify a log file name:\n+\n+```\n+T4LogLevel= SEVERE\n+\n+T4LogFile=c:/T4logfile1.log\n+```\n+<<<\n+[[message-format]]\n+=== Message Format\n+\n+The format of the trace output is\n+\n+```\n+sequence-number ~ time-stamp ~ thread-id\n+~ [connection-id] ~ [server-id] ~ [dialogue-id]\n+~ [class].[method][(parameters)] ~ [text]\n+```\n+\n+\n+[cols=\"30%,70%\",options=\"header\" ]\n+|===\n+| Identifier | Provides\n+| `sequence-number` | A unique sequence number in increasing order.\n+| `time-stamp`      | The time of the message, for example 10/17/2004 12:48:23.\n+| `thread-id`       | The thread identifier within the Java VM.\n+| `connection-id`   | If applicable, a unique ID for the connection associated with the message.\n+| `server-id`       | If applicable, information about the connectivity server associated with the message. The _server-id_ is of the form: +\n+ +\n+`TCP:node-name.server-name/port-number:HPODBC` +","path":"docs/jdbct4ref_guide/src/asciidoc/_chapters/tracing_logging.adoc","position":146,"original_position":146,"commit_id":"c5543bd82d2ba7edca79b988423a1e4c1effafb6","original_commit_id":"c5543bd82d2ba7edca79b988423a1e4c1effafb6","user":{"login":"gtapper","id":13549394,"avatar_url":"https://avatars.githubusercontent.com/u/13549394?v=3","gravatar_id":"","url":"https://api.github.com/users/gtapper","html_url":"https://github.com/gtapper","followers_url":"https://api.github.com/users/gtapper/followers","following_url":"https://api.github.com/users/gtapper/following{/other_user}","gists_url":"https://api.github.com/users/gtapper/gists{/gist_id}","starred_url":"https://api.github.com/users/gtapper/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/gtapper/subscriptions","organizations_url":"https://api.github.com/users/gtapper/orgs","repos_url":"https://api.github.com/users/gtapper/repos","events_url":"https://api.github.com/users/gtapper/events{/privacy}","received_events_url":"https://api.github.com/users/gtapper/received_events","type":"User","site_admin":false},"body":"Changed.","created_at":"2016-05-01T17:12:26Z","updated_at":"2016-05-01T17:12:26Z","html_url":"https://github.com/apache/incubator-trafodion/pull/457#discussion_r61689858","pull_request_url":"https://api.github.com/repos/apache/incubator-trafodion/pulls/457","_links":{"self":{"href":"https://api.github.com/repos/apache/incubator-trafodion/pulls/comments/61689858"},"html":{"href":"https://github.com/apache/incubator-trafodion/pull/457#discussion_r61689858"},"pull_request":{"href":"https://api.github.com/repos/apache/incubator-trafodion/pulls/457"}}},"pull_request":{"url":"https://api.github.com/repos/apache/incubator-trafodion/pulls/457","id":68328893,"html_url":"https://github.com/apache/incubator-trafodion/pull/457","diff_url":"https://github.com/apache/incubator-trafodion/pull/457.diff","patch_url":"https://github.com/apache/incubator-trafodion/pull/457.patch","issue_url":"https://api.github.com/repos/apache/incubator-trafodion/issues/457","number":457,"state":"open","locked":false,"title":"Trafodion 1949: New JDBC Type 4 Programmer's Reference Guide","user":{"login":"gtapper","id":13549394,"avatar_url":"https://avatars.githubusercontent.com/u/13549394?v=3","gravatar_id":"","url":"https://api.github.com/users/gtapper","html_url":"https://github.com/gtapper","followers_url":"https://api.github.com/users/gtapper/followers","following_url":"https://api.github.com/users/gtapper/following{/other_user}","gists_url":"https://api.github.com/users/gtapper/gists{/gist_id}","starred_url":"https://api.github.com/users/gtapper/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/gtapper/subscriptions","organizations_url":"https://api.github.com/users/gtapper/orgs","repos_url":"https://api.github.com/users/gtapper/repos","events_url":"https://api.github.com/users/gtapper/events{/privacy}","received_events_url":"https://api.github.com/users/gtapper/received_events","type":"User","site_admin":false},"body":"For review. This guide isn't visible externally yet. Chapters/information related to blob/clob are commented out but part of the checkin.\r\n\r\nAlso changed the location of the Apache incubator logo from 300px to 200px right indent.\r\n\r\nAdded a missing source file for the SPJ Guide.","created_at":"2016-04-29T06:20:24Z","updated_at":"2016-05-01T17:12:26Z","closed_at":null,"merged_at":null,"merge_commit_sha":"17e3cac88d6bd5f146460e095a6556d6d83e9297","assignee":null,"milestone":null,"commits_url":"https://api.github.com/repos/apache/incubator-trafodion/pulls/457/commits","review_comments_url":"https://api.github.com/repos/apache/incubator-trafodion/pulls/457/comments","review_comment_url":"https://api.github.com/repos/apache/incubator-trafodion/pulls/comments{/number}","comments_url":"https://api.github.com/repos/apache/incubator-trafodion/issues/457/comments","statuses_url":"https://api.github.com/repos/apache/incubator-trafodion/statuses/c5543bd82d2ba7edca79b988423a1e4c1effafb6","head":{"label":"gtapper:TRAFODION-1949","ref":"TRAFODION-1949","sha":"c5543bd82d2ba7edca79b988423a1e4c1effafb6","user":{"login":"gtapper","id":13549394,"avatar_url":"https://avatars.githubusercontent.com/u/13549394?v=3","gravatar_id":"","url":"https://api.github.com/users/gtapper","html_url":"https://github.com/gtapper","followers_url":"https://api.github.com/users/gtapper/followers","following_url":"https://api.github.com/users/gtapper/following{/other_user}","gists_url":"https://api.github.com/users/gtapper/gists{/gist_id}","starred_url":"https://api.github.com/users/gtapper/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/gtapper/subscriptions","organizations_url":"https://api.github.com/users/gtapper/orgs","repos_url":"https://api.github.com/users/gtapper/repos","events_url":"https://api.github.com/users/gtapper/events{/privacy}","received_events_url":"https://api.github.com/users/gtapper/received_events","type":"User","site_admin":false},"repo":{"id":52939930,"name":"incubator-trafodion","full_name":"gtapper/incubator-trafodion","owner":{"login":"gtapper","id":13549394,"avatar_url":"https://avatars.githubusercontent.com/u/13549394?v=3","gravatar_id":"","url":"https://api.github.com/users/gtapper","html_url":"https://github.com/gtapper","followers_url":"https://api.github.com/users/gtapper/followers","following_url":"https://api.github.com/users/gtapper/following{/other_user}","gists_url":"https://api.github.com/users/gtapper/gists{/gist_id}","starred_url":"https://api.github.com/users/gtapper/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/gtapper/subscriptions","organizations_url":"https://api.github.com/users/gtapper/orgs","repos_url":"https://api.github.com/users/gtapper/repos","events_url":"https://api.github.com/users/gtapper/events{/privacy}","received_events_url":"https://api.github.com/users/gtapper/received_events","type":"User","site_admin":false},"private":false,"html_url":"https://github.com/gtapper/incubator-trafodion","description":"Mirror of Apache Trafodion (Incubating)","fork":true,"url":"https://api.github.com/repos/gtapper/incubator-trafodion","forks_url":"https://api.github.com/repos/gtapper/incubator-trafodion/forks","keys_url":"https://api.github.com/repos/gtapper/incubator-trafodion/keys{/key_id}","collaborators_url":"https://api.github.com/repos/gtapper/incubator-trafodion/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/gtapper/incubator-trafodion/teams","hooks_url":"https://api.github.com/repos/gtapper/incubator-trafodion/hooks","issue_events_url":"https://api.github.com/repos/gtapper/incubator-trafodion/issues/events{/number}","events_url":"https://api.github.com/repos/gtapper/incubator-trafodion/events","assignees_url":"https://api.github.com/repos/gtapper/incubator-trafodion/assignees{/user}","branches_url":"https://api.github.com/repos/gtapper/incubator-trafodion/branches{/branch}","tags_url":"https://api.github.com/repos/gtapper/incubator-trafodion/tags","blobs_url":"https://api.github.com/repos/gtapper/incubator-trafodion/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/gtapper/incubator-trafodion/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/gtapper/incubator-trafodion/git/refs{/sha}","trees_url":"https://api.github.com/repos/gtapper/incubator-trafodion/git/trees{/sha}","statuses_url":"https://api.github.com/repos/gtapper/incubator-trafodion/statuses/{sha}","languages_url":"https://api.github.com/repos/gtapper/incubator-trafodion/languages","stargazers_url":"https://api.github.com/repos/gtapper/incubator-trafodion/stargazers","contributors_url":"https://api.github.com/repos/gtapper/incubator-trafodion/contributors","subscribers_url":"https://api.github.com/repos/gtapper/incubator-trafodion/subscribers","subscription_url":"https://api.github.com/repos/gtapper/incubator-trafodion/subscription","commits_url":"https://api.github.com/repos/gtapper/incubator-trafodion/commits{/sha}","git_commits_url":"https://api.github.com/repos/gtapper/incubator-trafodion/git/commits{/sha}","comments_url":"https://api.github.com/repos/gtapper/incubator-trafodion/comments{/number}","issue_comment_url":"https://api.github.com/repos/gtapper/incubator-trafodion/issues/comments{/number}","contents_url":"https://api.github.com/repos/gtapper/incubator-trafodion/contents/{+path}","compare_url":"https://api.github.com/repos/gtapper/incubator-trafodion/compare/{base}...{head}","merges_url":"https://api.github.com/repos/gtapper/incubator-trafodion/merges","archive_url":"https://api.github.com/repos/gtapper/incubator-trafodion/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/gtapper/incubator-trafodion/downloads","issues_url":"https://api.github.com/repos/gtapper/incubator-trafodion/issues{/number}","pulls_url":"https://api.github.com/repos/gtapper/incubator-trafodion/pulls{/number}","milestones_url":"https://api.github.com/repos/gtapper/incubator-trafodion/milestones{/number}","notifications_url":"https://api.github.com/repos/gtapper/incubator-trafodion/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/gtapper/incubator-trafodion/labels{/name}","releases_url":"https://api.github.com/repos/gtapper/incubator-trafodion/releases{/id}","deployments_url":"https://api.github.com/repos/gtapper/incubator-trafodion/deployments","created_at":"2016-03-02T06:34:32Z","updated_at":"2016-03-02T06:35:12Z","pushed_at":"2016-04-30T18:54:15Z","git_url":"git://github.com/gtapper/incubator-trafodion.git","ssh_url":"git@github.com:gtapper/incubator-trafodion.git","clone_url":"https://github.com/gtapper/incubator-trafodion.git","svn_url":"https://github.com/gtapper/incubator-trafodion","homepage":null,"size":70608,"stargazers_count":0,"watchers_count":0,"language":"C++","has_issues":false,"has_downloads":true,"has_wiki":false,"has_pages":false,"forks_count":0,"mirror_url":null,"open_issues_count":0,"forks":0,"open_issues":0,"watchers":0,"default_branch":"master"}},"base":{"label":"apache:master","ref":"master","sha":"64a68cf7a89b32bbc5a6d06688774cdd1aca54a0","user":{"login":"apache","id":47359,"avatar_url":"https://avatars.githubusercontent.com/u/47359?v=3","gravatar_id":"","url":"https://api.github.com/users/apache","html_url":"https://github.com/apache","followers_url":"https://api.github.com/users/apache/followers","following_url":"https://api.github.com/users/apache/following{/other_user}","gists_url":"https://api.github.com/users/apache/gists{/gist_id}","starred_url":"https://api.github.com/users/apache/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/apache/subscriptions","organizations_url":"https://api.github.com/users/apache/orgs","repos_url":"https://api.github.com/users/apache/repos","events_url":"https://api.github.com/users/apache/events{/privacy}","received_events_url":"https://api.github.com/users/apache/received_events","type":"Organization","site_admin":false},"repo":{"id":36349344,"name":"incubator-trafodion","full_name":"apache/incubator-trafodion","owner":{"login":"apache","id":47359,"avatar_url":"https://avatars.githubusercontent.com/u/47359?v=3","gravatar_id":"","url":"https://api.github.com/users/apache","html_url":"https://github.com/apache","followers_url":"https://api.github.com/users/apache/followers","following_url":"https://api.github.com/users/apache/following{/other_user}","gists_url":"https://api.github.com/users/apache/gists{/gist_id}","starred_url":"https://api.github.com/users/apache/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/apache/subscriptions","organizations_url":"https://api.github.com/users/apache/orgs","repos_url":"https://api.github.com/users/apache/repos","events_url":"https://api.github.com/users/apache/events{/privacy}","received_events_url":"https://api.github.com/users/apache/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/apache/incubator-trafodion","description":"Mirror of Apache Trafodion (Incubating)","fork":false,"url":"https://api.github.com/repos/apache/incubator-trafodion","forks_url":"https://api.github.com/repos/apache/incubator-trafodion/forks","keys_url":"https://api.github.com/repos/apache/incubator-trafodion/keys{/key_id}","collaborators_url":"https://api.github.com/repos/apache/incubator-trafodion/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/apache/incubator-trafodion/teams","hooks_url":"https://api.github.com/repos/apache/incubator-trafodion/hooks","issue_events_url":"https://api.github.com/repos/apache/incubator-trafodion/issues/events{/number}","events_url":"https://api.github.com/repos/apache/incubator-trafodion/events","assignees_url":"https://api.github.com/repos/apache/incubator-trafodion/assignees{/user}","branches_url":"https://api.github.com/repos/apache/incubator-trafodion/branches{/branch}","tags_url":"https://api.github.com/repos/apache/incubator-trafodion/tags","blobs_url":"https://api.github.com/repos/apache/incubator-trafodion/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/apache/incubator-trafodion/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/apache/incubator-trafodion/git/refs{/sha}","trees_url":"https://api.github.com/repos/apache/incubator-trafodion/git/trees{/sha}","statuses_url":"https://api.github.com/repos/apache/incubator-trafodion/statuses/{sha}","languages_url":"https://api.github.com/repos/apache/incubator-trafodion/languages","stargazers_url":"https://api.github.com/repos/apache/incubator-trafodion/stargazers","contributors_url":"https://api.github.com/repos/apache/incubator-trafodion/contributors","subscribers_url":"https://api.github.com/repos/apache/incubator-trafodion/subscribers","subscription_url":"https://api.github.com/repos/apache/incubator-trafodion/subscription","commits_url":"https://api.github.com/repos/apache/incubator-trafodion/commits{/sha}","git_commits_url":"https://api.github.com/repos/apache/incubator-trafodion/git/commits{/sha}","comments_url":"https://api.github.com/repos/apache/incubator-trafodion/comments{/number}","issue_comment_url":"https://api.github.com/repos/apache/incubator-trafodion/issues/comments{/number}","contents_url":"https://api.github.com/repos/apache/incubator-trafodion/contents/{+path}","compare_url":"https://api.github.com/repos/apache/incubator-trafodion/compare/{base}...{head}","merges_url":"https://api.github.com/repos/apache/incubator-trafodion/merges","archive_url":"https://api.github.com/repos/apache/incubator-trafodion/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/apache/incubator-trafodion/downloads","issues_url":"https://api.github.com/repos/apache/incubator-trafodion/issues{/number}","pulls_url":"https://api.github.com/repos/apache/incubator-trafodion/pulls{/number}","milestones_url":"https://api.github.com/repos/apache/incubator-trafodion/milestones{/number}","notifications_url":"https://api.github.com/repos/apache/incubator-trafodion/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/apache/incubator-trafodion/labels{/name}","releases_url":"https://api.github.com/repos/apache/incubator-trafodion/releases{/id}","deployments_url":"https://api.github.com/repos/apache/incubator-trafodion/deployments","created_at":"2015-05-27T07:00:05Z","updated_at":"2016-04-27T02:18:50Z","pushed_at":"2016-05-01T10:03:31Z","git_url":"git://github.com/apache/incubator-trafodion.git","ssh_url":"git@github.com:apache/incubator-trafodion.git","clone_url":"https://github.com/apache/incubator-trafodion.git","svn_url":"https://github.com/apache/incubator-trafodion","homepage":null,"size":73326,"stargazers_count":34,"watchers_count":34,"language":"C++","has_issues":false,"has_downloads":true,"has_wiki":false,"has_pages":false,"forks_count":63,"mirror_url":"git://git.apache.org/incubator-trafodion.git","open_issues_count":10,"forks":63,"open_issues":10,"watchers":34,"default_branch":"master"}},"_links":{"self":{"href":"https://api.github.com/repos/apache/incubator-trafodion/pulls/457"},"html":{"href":"https://github.com/apache/incubator-trafodion/pull/457"},"issue":{"href":"https://api.github.com/repos/apache/incubator-trafodion/issues/457"},"comments":{"href":"https://api.github.com/repos/apache/incubator-trafodion/issues/457/comments"},"review_comments":{"href":"https://api.github.com/repos/apache/incubator-trafodion/pulls/457/comments"},"review_comment":{"href":"https://api.github.com/repos/apache/incubator-trafodion/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/apache/incubator-trafodion/pulls/457/commits"},"statuses":{"href":"https://api.github.com/repos/apache/incubator-trafodion/statuses/c5543bd82d2ba7edca79b988423a1e4c1effafb6"}}}}