Re: [jira] Updated: (DERBY-243) connection toString should uniquely identify the connection

[Sunitha Kambhampati]

I get the feeling the following  point may have been missed, so resending. I found one issue that on a commit or rollback statement the UUID is not used but instead it displays just integers.  So in the log below it is hard to know on which connection, the commit was issued.  It is important to be able to match the commit and abort statements right.  And in the simple log below I dont see the UUID tied right with the commit statement.  David - do you know why.  I think it needs to be fixed too. Thanks, Sunitha. Sunitha Kambhampati wrote: Although I havent looked at the diffs yet, but I applied the patch in Derby-243 to see how the derby.log would look with derby.language.logStatementText=true I notice now the output is a little hard to read with all the numbers and letters to look at, but I guess thats OK since thats what we decided on. I tried  some simple cases  in ij with different connections and the SESSIONID generated is unique and it works fine, but I found one issue that on a commit or rollback statement the UUID is not used but instead it displays just integers.    David - do you know why ? Sample - derby.log after applying the patch. --------------------------------------------------- Database Class Loader started - derby.database.classpath='' 2005-06-03 20:57:12.430 GMT Thread[main,5,main] (XID = 115), (SESSIONID = a816c00e-0104-43fe-09d2-0000000c2d90), (DATABASE = tmd), (DRDAID = null), Begin compiling prepared statement: insert into t1 values(5) :End prepared statement 2005-06-03 20:57:13.481 GMT Thread[main,5,main] (XID = 115), (SESSIONID = a816c00e-0104-43fe-09d2-0000000c2d90), (DATABASE = tmd), (DRDAID = null), End compiling prepared statement: insert into t1 values(5) :End prepared statement 2005-06-03 20:57:13.701 GMT Thread[main,5,main] (XID = 115), (SESSIONID = a816c00e-0104-43fe-09d2-0000000c2d90), (DATABASE = tmd), (DRDAID = null), Executing prepared statement: insert into t1 values(5) :End prepared statement 2005-06-03 20:57:16.646 GMT Thread[main,5,main] (XID = 115), (SESSIONID = 0), (DATABASE = tmd), (DRDAID = null), Committing Thanks, Sunitha.