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.
>>
>>
>
|