derby database source code.good for you.

				create view global_xactTable as
				select 
				    cast(global_xid as char(2)) as gxid,
				    status,
				    case when first_instant is NULL then 'NULL' else 'false' end as readOnly,
				    cast (username as char(10)) as username,
				    type 
				from new org.apache.derby.diag.TransactionTable() t;