Hi, Sunitha, Mike. I will definitely look at this and track it down.
Sorry if I wasn't clear about this. I do recognize how important this
is and would have the same complaints. This definitely needs to be
fixed before this is committed.
David
Sunitha Kambhampati wrote:
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.
