Hellu,
It's me again, busy "playing" around with the finder methods (on Orion
1.4.7).
I made a finder methods that performs a join in my Home interface.
When I use it through a JSP page, I receive the cartesian product, whereas
with me sql client I don't, that is I do get the correct result with the sql
client.
Sounds like a bug or ..... what am I doing wrong. ???
Hereunder I have
- the finder method definition
- the jsp output.
- the sql client output.
- the postgres log, performing the queries after calling this finder method.
Le me know if it is a bug, so I can report it with bugzilla.
Eddie
FInder method in my orion-ejb-jar.xml:
------------
<finder-method partial="false" query="select * from
vwractsmsmo, vwractsco where vwractsmsmo.sco_Id=vwractsco.id and
vwractsco.Act_Cod=$1 and vwractsco.Grp_Id=$2">
<method>
<ejb-name>All MO SMS</ejb-name>
<method-name>findMoSms</method-name>
<method-params>
<method-param>java.lang.String</method-param>
<method-param>int</method-param>
</method-params>
</method>
</finder-method>
------
The jsp output for $1="BLA" and $2=1:
------------------
Id: 1 Mon: 1 Year: 2001 ActCod: BLA grpId: 1
Id: 2 Mon: 1 Year: 2002 ActCod: BLA grpId: 1
Id: 3 Mon: 2 Year: 2001 ActCod: BLA grpId: 1
Id: 4 Mon: 3 Year: 2001 ActCod: BLA grpId: 1
Id: 5 Mon: 1 Year: 2001 ActCod: FLOP grpId: 1
Id: 6 Mon: 2 Year: 2001 ActCod: FLOP grpId: 1
Id: 7 Mon: 2 Year: 2002 ActCod: FLOP grpId: 1
Id: 8 Mon: 1 Year: 2001 ActCod: BLA grpId: 2
Id: 9 Mon: 1 Year: 2002 ActCod: BLA grpId: 2
Id: 10 Mon: 2 Year: 2001 ActCod: BLA grpId: 2
Id: 11 Mon: 3 Year: 2001 ActCod: BLA grpId: 2
Id: 12 Mon: 1 Year: 2001 ActCod: FLOP grpId: 2
Id: 13 Mon: 2 Year: 2001 ActCod: FLOP grpId: 2
Id: 14 Mon: 2 Year: 2002 ActCod: FLOP grpId: 2
Id: 15 Mon: 10 Year: 2002 ActCod: FLOP grpId: 2
---------------
The output of the sql client (same query ofcource):
----------------
id mon year act_cod grp_id
----------- ------ ----------- ------- -----------
1 1 2001 BLA 1
1 1 2001 BLA 1
2 1 2002 BLA 1
3 Row(s) affected
-----------------
The logging of postgres:
---------------------
010418.15:56:44.830 [12288] StartTransactionCommand
010418.15:56:44.830 [12288] query: select vwractsco.act_cod, vwracts
co.grp_id, vwractsco.mon, vwractsco.year, vwractsco.id, vwractsco.ft
e, vwractsco.scotot, vwractsco.dattimupd from vwractsco
010418.15:56:44.831 [12288] ProcessQuery
010418.15:56:44.832 [12288] CommitTransactionCommand
010418.15:56:44.853 [12288] StartTransactionCommand
010418.15:56:44.853 [12288] query: select vwractsco.id, vwractsco.ft
e, vwractsco.scotot, vwractsco.dattimupd from vwractsco where (vwrac
tsco.act_cod = 'BLA' and vwractsco.grp_id = 1 and vwractsco.mon = 1
and vwractsco.year = 2001)
010418.15:56:44.854 [12288] ProcessQuery
010418.15:56:44.855 [12288] CommitTransactionCommand
010418.15:56:44.856 [12288] StartTransactionCommand
010418.15:56:44.856 [12288] query: select vwractsco.id, vwractsco.ft
e, vwractsco.scotot, vwractsco.dattimupd from vwractsco where (vwrac
tsco.act_cod = 'BLA' and vwractsco.grp_id = 1 and vwractsco.mon = 1
and vwractsco.year = 2001)
010418.15:56:44.857 [12288] ProcessQuery
010418.15:56:44.857 [12288] CommitTransactionCommand
010418.15:56:44.859 [12288] StartTransactionCommand
010418.15:56:44.859 [12288] query: select vwractsco.id, vwractsco.ft
e, vwractsco.scotot, vwractsco.dattimupd from vwractsco where (vwrac
tsco.act_cod = 'BLA' and vwractsco.grp_id = 1 and vwractsco.mon = 1
and vwractsco.year = 2001)
010418.15:56:44.860 [12288] ProcessQuery
010418.15:56:44.860 [12288] CommitTransactionCommand
010418.15:56:44.861 [12288] StartTransactionCommand
010418.15:56:44.861 [12288] query: select vwractsco.id, vwractsco.ft
e, vwractsco.scotot, vwractsco.dattimupd from vwractsco where (vwrac
tsco.act_cod = 'BLA' and vwractsco.grp_id = 1 and vwractsco.mon = 1
and vwractsco.year = 2001)
010418.15:56:44.862 [12288] ProcessQuery
010418.15:56:44.862 [12288] CommitTransactionCommand
010418.15:56:44.864 [12288] StartTransactionCommand
010418.15:56:44.864 [12288] query: select vwractsco.id, vwractsco.ft
e, vwractsco.scotot, vwractsco.dattimupd from vwractsco where (vwrac
tsco.act_cod = 'BLA' and vwractsco.grp_id = 1 and vwractsco.mon = 1
and vwractsco.year = 2001)
010418.15:56:44.865 [12288] ProcessQuery
010418.15:56:44.865 [12288] CommitTransactionCommand
010418.15:56:44.867 [12288] StartTransactionCommand
010418.15:56:44.867 [12288] query: select vwractsco.id, vwractsco.ft
e, vwractsco.scotot, vwractsco.dattimupd from vwractsco where (vwrac
tsco.act_cod = 'BLA' and vwractsco.grp_id = 1 and vwractsco.mon = 1
and vwractsco.year = 2002)
010418.15:56:44.868 [12288] ProcessQuery
010418.15:56:44.868 [12288] CommitTransactionCommand
010418.15:56:44.869 [12288] StartTransactionCommand
010418.15:56:44.869 [12288] query: select vwractsco.id, vwractsco.ft
e, vwractsco.scotot, vwractsco.dattimupd from vwractsco where (vwrac
tsco.act_cod = 'BLA' and vwractsco.grp_id = 1 and vwractsco.mon = 1
and vwractsco.year = 2002)
010418.15:56:44.870 [12288] ProcessQuery
010418.15:56:44.870 [12288] CommitTransactionCommand
010418.15:56:44.872 [12288] StartTransactionCommand
010418.15:56:44.872 [12288] query: select vwractsco.id, vwractsco.ft
e, vwractsco.scotot, vwractsco.dattimupd from vwractsco where (vwrac
tsco.act_cod = 'BLA' and vwractsco.grp_id = 1 and vwractsco.mon = 1
and vwractsco.year = 2002)
010418.15:56:44.873 [12288] ProcessQuery
010418.15:56:44.873 [12288] CommitTransactionCommand
010418.15:56:44.874 [12288] StartTransactionCommand
010418.15:56:44.874 [12288] query: select vwractsco.id, vwractsco.ft
e, vwractsco.scotot, vwractsco.dattimupd from vwractsco where (vwrac
tsco.act_cod = 'BLA' and vwractsco.grp_id = 1 and vwractsco.mon = 1
and vwractsco.year = 2002)
010418.15:56:44.875 [12288] ProcessQuery
010418.15:56:44.876 [12288] CommitTransactionCommand
010418.15:56:44.877 [12288] StartTransactionCommand
010418.15:56:44.877 [12288] query: select vwractsco.id, vwractsco.ft
e, vwractsco.scotot, vwractsco.dattimupd from vwractsco where (vwrac
tsco.act_cod = 'BLA' and vwractsco.grp_id = 1 and vwractsco.mon = 1
and vwractsco.year = 2002)
010418.15:56:44.878 [12288] ProcessQuery
010418.15:56:44.878 [12288] CommitTransactionCommand
010418.15:56:44.896 [12288] StartTransactionCommand
010418.15:56:44.896 [12288] query: select vwractsco.id, vwractsco.ft
e, vwractsco.scotot, vwractsco.dattimupd from vwractsco where (vwrac
tsco.act_cod = 'BLA' and vwractsco.grp_id = 1 and vwractsco.mon = 2
and vwractsco.year = 2001)
010418.15:56:44.897 [12288] ProcessQuery
010418.15:56:44.897 [12288] CommitTransactionCommand
010418.15:56:44.899 [12288] StartTransactionCommand
010418.15:56:44.899 [12288] query: select vwractsco.id, vwractsco.ft
e, vwractsco.scotot, vwractsco.dattimupd from vwractsco where (vwrac
tsco.act_cod = 'BLA' and vwractsco.grp_id = 1 and vwractsco.mon = 2
and vwractsco.year = 2001)
010418.15:56:44.900 [12288] ProcessQuery
010418.15:56:44.900 [12288] CommitTransactionCommand
010418.15:56:44.902 [12288] StartTransactionCommand
010418.15:56:44.902 [12288] query: select vwractsco.id, vwractsco.ft
e, vwractsco.scotot, vwractsco.dattimupd from vwractsco where (vwrac
tsco.act_cod = 'BLA' and vwractsco.grp_id = 1 and vwractsco.mon = 2
and vwractsco.year = 2001)
010418.15:56:44.903 [12288] ProcessQuery
010418.15:56:44.903 [12288] CommitTransactionCommand
010418.15:56:44.904 [12288] StartTransactionCommand
010418.15:56:44.904 [12288] query: select vwractsco.id, vwractsco.ft
e, vwractsco.scotot, vwractsco.dattimupd from vwractsco where (vwrac
tsco.act_cod = 'BLA' and vwractsco.grp_id = 1 and vwractsco.mon = 2
and vwractsco.year = 2001)
010418.15:56:44.905 [12288] ProcessQuery
010418.15:56:44.906 [12288] CommitTransactionCommand
010418.15:56:44.907 [12288] StartTransactionCommand
010418.15:56:44.907 [12288] query: select vwractsco.id, vwractsco.ft
e, vwractsco.scotot, vwractsco.dattimupd from vwractsco where (vwrac
tsco.act_cod = 'BLA' and vwractsco.grp_id = 1 and vwractsco.mon = 2
and vwractsco.year = 2001)
010418.15:56:44.908 [12288] ProcessQuery
010418.15:56:44.908 [12288] CommitTransactionCommand
010418.15:56:44.910 [12288] StartTransactionCommand
010418.15:56:44.910 [12288] query: select vwractsco.id, vwractsco.ft
e, vwractsco.scotot, vwractsco.dattimupd from vwractsco where (vwrac
tsco.act_cod = 'BLA' and vwractsco.grp_id = 1 and vwractsco.mon = 3
and vwractsco.year = 2001)
010418.15:56:44.911 [12288] ProcessQuery
010418.15:56:44.911 [12288] CommitTransactionCommand
010418.15:56:44.912 [12288] StartTransactionCommand
010418.15:56:44.912 [12288] query: select vwractsco.id, vwractsco.ft
e, vwractsco.scotot, vwractsco.dattimupd from vwractsco where (vwrac
tsco.act_cod = 'BLA' and vwractsco.grp_id = 1 and vwractsco.mon = 3
and vwractsco.year = 2001)
010418.15:56:44.913 [12288] ProcessQuery
010418.15:56:44.914 [12288] CommitTransactionCommand
010418.15:56:44.915 [12288] StartTransactionCommand
010418.15:56:44.915 [12288] query: select vwractsco.id, vwractsco.ft
e, vwractsco.scotot, vwractsco.dattimupd from vwractsco where (vwrac
tsco.act_cod = 'BLA' and vwractsco.grp_id = 1 and vwractsco.mon = 3
and vwractsco.year = 2001)
010418.15:56:44.916 [12288] ProcessQuery
010418.15:56:44.916 [12288] CommitTransactionCommand
010418.15:56:44.918 [12288] StartTransactionCommand
010418.15:56:44.918 [12288] query: select vwractsco.id, vwractsco.ft
e, vwractsco.scotot, vwractsco.dattimupd from vwractsco where (vwrac
tsco.act_cod = 'BLA' and vwractsco.grp_id = 1 and vwractsco.mon = 3
and vwractsco.year = 2001)
010418.15:56:44.919 [12288] ProcessQuery
010418.15:56:44.919 [12288] CommitTransactionCommand
010418.15:56:44.922 [12288] StartTransactionCommand
010418.15:56:44.922 [12288] query: select vwractsco.id, vwractsco.ft
e, vwractsco.scotot, vwractsco.dattimupd from vwractsco where (vwrac
tsco.act_cod = 'BLA' and vwractsco.grp_id = 1 and vwractsco.mon = 3
and vwractsco.year = 2001)
010418.15:56:44.923 [12288] ProcessQuery
010418.15:56:44.923 [12288] CommitTransactionCommand
010418.15:56:44.924 [12288] StartTransactionCommand
010418.15:56:44.924 [12288] query: select vwractsco.id, vwractsco.ft
e, vwractsco.scotot, vwractsco.dattimupd from vwractsco where (vwrac
tsco.act_cod = 'FLOP' and vwractsco.grp_id = 1 and vwractsco.mon = 1
and vwractsco.year = 2001)
010418.15:56:44.925 [12288] ProcessQuery
010418.15:56:44.926 [12288] CommitTransactionCommand
010418.15:56:44.927 [12288] StartTransactionCommand
010418.15:56:44.927 [12288] query: select vwractsco.id, vwractsco.ft
e, vwractsco.scotot, vwractsco.dattimupd from vwractsco where (vwrac
tsco.act_cod = 'FLOP' and vwractsco.grp_id = 1 and vwractsco.mon = 1
and vwractsco.year = 2001)
010418.15:56:44.928 [12288] ProcessQuery
010418.15:56:44.928 [12288] CommitTransactionCommand
010418.15:56:44.930 [12288] StartTransactionCommand
010418.15:56:44.930 [12288] query: select vwractsco.id, vwractsco.ft
e, vwractsco.scotot, vwractsco.dattimupd from vwractsco where (vwrac
tsco.act_cod = 'FLOP' and vwractsco.grp_id = 1 and vwractsco.mon = 1
and vwractsco.year = 2001)
010418.15:56:44.931 [12288] ProcessQuery
010418.15:56:44.931 [12288] CommitTransactionCommand
010418.15:56:44.934 [12288] StartTransactionCommand
010418.15:56:44.934 [12288] query: select vwractsco.id, vwractsco.ft
e, vwractsco.scotot, vwractsco.dattimupd from vwractsco where (vwrac
tsco.act_cod = 'FLOP' and vwractsco.grp_id = 1 and vwractsco.mon = 1
and vwractsco.year = 2001)
010418.15:56:44.935 [12288] ProcessQuery
010418.15:56:44.935 [12288] CommitTransactionCommand
010418.15:56:44.936 [12288] StartTransactionCommand
010418.15:56:44.936 [12288] query: select vwractsco.id, vwractsco.ft
e, vwractsco.scotot, vwractsco.dattimupd from vwractsco where (vwrac
tsco.act_cod = 'FLOP' and vwractsco.grp_id = 1 and vwractsco.mon = 1
and vwractsco.year = 2001)
010418.15:56:44.937 [12288] ProcessQuery
010418.15:56:44.938 [12288] CommitTransactionCommand
010418.15:56:44.966 [12288] StartTransactionCommand
010418.15:56:44.967 [12288] query: select vwractsco.id, vwractsco.ft
e, vwractsco.scotot, vwractsco.dattimupd from vwractsco where (vwrac
tsco.act_cod = 'FLOP' and vwractsco.grp_id = 1 and vwractsco.mon = 2
and vwractsco.year = 2001)
010418.15:56:44.967 [12288] ProcessQuery
010418.15:56:44.968 [12288] CommitTransactionCommand
010418.15:56:44.969 [12288] StartTransactionCommand
010418.15:56:44.969 [12288] query: select vwractsco.id, vwractsco.ft
e, vwractsco.scotot, vwractsco.dattimupd from vwractsco where (vwrac
tsco.act_cod = 'FLOP' and vwractsco.grp_id = 1 and vwractsco.mon = 2
and vwractsco.year = 2001)
010418.15:56:44.970 [12288] ProcessQuery
010418.15:56:44.971 [12288] CommitTransactionCommand
010418.15:56:44.972 [12288] StartTransactionCommand
010418.15:56:44.972 [12288] query: select vwractsco.id, vwractsco.ft
e, vwractsco.scotot, vwractsco.dattimupd from vwractsco where (vwrac
tsco.act_cod = 'FLOP' and vwractsco.grp_id = 1 and vwractsco.mon = 2
and vwractsco.year = 2001)
010418.15:56:44.973 [12288] ProcessQuery
010418.15:56:44.973 [12288] CommitTransactionCommand
010418.15:56:44.975 [12288] StartTransactionCommand
010418.15:56:44.975 [12288] query: select vwractsco.id, vwractsco.ft
e, vwractsco.scotot, vwractsco.dattimupd from vwractsco where (vwrac
tsco.act_cod = 'FLOP' and vwractsco.grp_id = 1 and vwractsco.mon = 2
and vwractsco.year = 2001)
010418.15:56:44.976 [12288] ProcessQuery
010418.15:56:44.976 [12288] CommitTransactionCommand
010418.15:56:44.977 [12288] StartTransactionCommand
010418.15:56:44.977 [12288] query: select vwractsco.id, vwractsco.ft
e, vwractsco.scotot, vwractsco.dattimupd from vwractsco where (vwrac
tsco.act_cod = 'FLOP' and vwractsco.grp_id = 1 and vwractsco.mon = 2
and vwractsco.year = 2001)
010418.15:56:44.978 [12288] ProcessQuery
010418.15:56:44.978 [12288] CommitTransactionCommand
010418.15:56:44.980 [12288] StartTransactionCommand
010418.15:56:44.980 [12288] query: select vwractsco.id, vwractsco.ft
e, vwractsco.scotot, vwractsco.dattimupd from vwractsco where (vwrac
tsco.act_cod = 'FLOP' and vwractsco.grp_id = 1 and vwractsco.mon = 2
and vwractsco.year = 2002)
010418.15:56:44.981 [12288] ProcessQuery
010418.15:56:44.981 [12288] CommitTransactionCommand
010418.15:56:44.982 [12288] StartTransactionCommand
010418.15:56:44.982 [12288] query: select vwractsco.id, vwractsco.ft
e, vwractsco.scotot, vwractsco.dattimupd from vwractsco where (vwrac
tsco.act_cod = 'FLOP' and vwractsco.grp_id = 1 and vwractsco.mon = 2
and vwractsco.year = 2002)
010418.15:56:44.983 [12288] ProcessQuery
010418.15:56:44.984 [12288] CommitTransactionCommand
010418.15:56:44.985 [12288] StartTransactionCommand
010418.15:56:44.985 [12288] query: select vwractsco.id, vwractsco.ft
e, vwractsco.scotot, vwractsco.dattimupd from vwractsco where (vwrac
tsco.act_cod = 'FLOP' and vwractsco.grp_id = 1 and vwractsco.mon = 2
and vwractsco.year = 2002)
010418.15:56:44.986 [12288] ProcessQuery
010418.15:56:44.986 [12288] CommitTransactionCommand
010418.15:56:44.987 [12288] StartTransactionCommand
010418.15:56:44.987 [12288] query: select vwractsco.id, vwractsco.ft
e, vwractsco.scotot, vwractsco.dattimupd from vwractsco where (vwrac
tsco.act_cod = 'FLOP' and vwractsco.grp_id = 1 and vwractsco.mon = 2
and vwractsco.year = 2002)
010418.15:56:44.988 [12288] ProcessQuery
010418.15:56:44.989 [12288] CommitTransactionCommand
010418.15:56:44.990 [12288] StartTransactionCommand
010418.15:56:44.990 [12288] query: select vwractsco.id, vwractsco.ft
e, vwractsco.scotot, vwractsco.dattimupd from vwractsco where (vwrac
tsco.act_cod = 'FLOP' and vwractsco.grp_id = 1 and vwractsco.mon = 2
and vwractsco.year = 2002)
010418.15:56:44.991 [12288] ProcessQuery
010418.15:56:44.991 [12288] CommitTransactionCommand
010418.15:56:44.993 [12288] StartTransactionCommand
010418.15:56:44.993 [12288] query: select vwractsco.id, vwractsco.ft
e, vwractsco.scotot, vwractsco.dattimupd from vwractsco where (vwrac
tsco.act_cod = 'BLA' and vwractsco.grp_id = 2 and vwractsco.mon = 1
and vwractsco.year = 2001)
010418.15:56:44.994 [12288] ProcessQuery
010418.15:56:44.994 [12288] CommitTransactionCommand
010418.15:56:44.995 [12288] StartTransactionCommand
010418.15:56:44.995 [12288] query: select vwractsco.id, vwractsco.ft
e, vwractsco.scotot, vwractsco.dattimupd from vwractsco where (vwrac
tsco.act_cod = 'BLA' and vwractsco.grp_id = 2 and vwractsco.mon = 1
and vwractsco.year = 2001)
010418.15:56:44.996 [12288] ProcessQuery
010418.15:56:44.996 [12288] CommitTransactionCommand
010418.15:56:44.998 [12288] StartTransactionCommand
010418.15:56:44.998 [12288] query: select vwractsco.id, vwractsco.ft
e, vwractsco.scotot, vwractsco.dattimupd from vwractsco where (vwrac
tsco.act_cod = 'BLA' and vwractsco.grp_id = 2 and vwractsco.mon = 1
and vwractsco.year = 2001)
010418.15:56:44.999 [12288] ProcessQuery
010418.15:56:44.999 [12288] CommitTransactionCommand
010418.15:56:45.000 [12288] StartTransactionCommand
010418.15:56:45.000 [12288] query: select vwractsco.id, vwractsco.ft
e, vwractsco.scotot, vwractsco.dattimupd from vwractsco where (vwrac
tsco.act_cod = 'BLA' and vwractsco.grp_id = 2 and vwractsco.mon = 1
and vwractsco.year = 2001)
010418.15:56:45.001 [12288] ProcessQuery
010418.15:56:45.001 [12288] CommitTransactionCommand
010418.15:56:45.003 [12288] StartTransactionCommand
010418.15:56:45.003 [12288] query: select vwractsco.id, vwractsco.ft
e, vwractsco.scotot, vwractsco.dattimupd from vwractsco where (vwrac
tsco.act_cod = 'BLA' and vwractsco.grp_id = 2 and vwractsco.mon = 1
and vwractsco.year = 2001)
010418.15:56:45.004 [12288] ProcessQuery
010418.15:56:45.004 [12288] CommitTransactionCommand
010418.15:56:45.005 [12288] StartTransactionCommand
010418.15:56:45.005 [12288] query: select vwractsco.id, vwractsco.ft
e, vwractsco.scotot, vwractsco.dattimupd from vwractsco where (vwrac
tsco.act_cod = 'BLA' and vwractsco.grp_id = 2 and vwractsco.mon = 1
and vwractsco.year = 2002)
010418.15:56:45.006 [12288] ProcessQuery
010418.15:56:45.007 [12288] CommitTransactionCommand
010418.15:56:45.008 [12288] StartTransactionCommand
010418.15:56:45.008 [12288] query: select vwractsco.id, vwractsco.ft
e, vwractsco.scotot, vwractsco.dattimupd from vwractsco where (vwrac
tsco.act_cod = 'BLA' and vwractsco.grp_id = 2 and vwractsco.mon = 1
and vwractsco.year = 2002)
010418.15:56:45.009 [12288] ProcessQuery
010418.15:56:45.009 [12288] CommitTransactionCommand
010418.15:56:45.010 [12288] StartTransactionCommand
010418.15:56:45.011 [12288] query: select vwractsco.id, vwractsco.ft
e, vwractsco.scotot, vwractsco.dattimupd from vwractsco where (vwrac
tsco.act_cod = 'BLA' and vwractsco.grp_id = 2 and vwractsco.mon = 1
and vwractsco.year = 2002)
010418.15:56:45.011 [12288] ProcessQuery
010418.15:56:45.012 [12288] CommitTransactionCommand
010418.15:56:45.013 [12288] StartTransactionCommand
010418.15:56:45.013 [12288] query: select vwractsco.id, vwractsco.ft
e, vwractsco.scotot, vwractsco.dattimupd from vwractsco where (vwrac
tsco.act_cod = 'BLA' and vwractsco.grp_id = 2 and vwractsco.mon = 1
and vwractsco.year = 2002)
010418.15:56:45.014 [12288] ProcessQuery
010418.15:56:45.014 [12288] CommitTransactionCommand
010418.15:56:45.016 [12288] StartTransactionCommand
010418.15:56:45.016 [12288] query: select vwractsco.id, vwractsco.ft
e, vwractsco.scotot, vwractsco.dattimupd from vwractsco where (vwrac
tsco.act_cod = 'BLA' and vwractsco.grp_id = 2 and vwractsco.mon = 1
and vwractsco.year = 2002)
010418.15:56:45.017 [12288] ProcessQuery
010418.15:56:45.017 [12288] CommitTransactionCommand
010418.15:56:45.018 [12288] StartTransactionCommand
010418.15:56:45.018 [12288] query: select vwractsco.id, vwractsco.ft
e, vwractsco.scotot, vwractsco.dattimupd from vwractsco where (vwrac
tsco.act_cod = 'BLA' and vwractsco.grp_id = 2 and vwractsco.mon = 2
and vwractsco.year = 2001)
010418.15:56:45.019 [12288] ProcessQuery
010418.15:56:45.019 [12288] CommitTransactionCommand
010418.15:56:45.021 [12288] StartTransactionCommand
010418.15:56:45.021 [12288] query: select vwractsco.id, vwractsco.ft
e, vwractsco.scotot, vwractsco.dattimupd from vwractsco where (vwrac
tsco.act_cod = 'BLA' and vwractsco.grp_id = 2 and vwractsco.mon = 2
and vwractsco.year = 2001)
010418.15:56:45.022 [12288] ProcessQuery
010418.15:56:45.022 [12288] CommitTransactionCommand
010418.15:56:45.023 [12288] StartTransactionCommand
010418.15:56:45.023 [12288] query: select vwractsco.id, vwractsco.ft
e, vwractsco.scotot, vwractsco.dattimupd from vwractsco where (vwrac
tsco.act_cod = 'BLA' and vwractsco.grp_id = 2 and vwractsco.mon = 2
and vwractsco.year = 2001)
010418.15:56:45.024 [12288] ProcessQuery
010418.15:56:45.024 [12288] CommitTransactionCommand
010418.15:56:45.026 [12288] StartTransactionCommand
010418.15:56:45.026 [12288] query: select vwractsco.id, vwractsco.ft
e, vwractsco.scotot, vwractsco.dattimupd from vwractsco where (vwrac
tsco.act_cod = 'BLA' and vwractsco.grp_id = 2 and vwractsco.mon = 2
and vwractsco.year = 2001)
010418.15:56:45.027 [12288] ProcessQuery
010418.15:56:45.027 [12288] CommitTransactionCommand
010418.15:56:45.028 [12288] StartTransactionCommand
010418.15:56:45.028 [12288] query: select vwractsco.id, vwractsco.ft
e, vwractsco.scotot, vwractsco.dattimupd from vwractsco where (vwrac
tsco.act_cod = 'BLA' and vwractsco.grp_id = 2 and vwractsco.mon = 2
and vwractsco.year = 2001)
010418.15:56:45.029 [12288] ProcessQuery
010418.15:56:45.030 [12288] CommitTransactionCommand
010418.15:56:45.031 [12288] StartTransactionCommand
010418.15:56:45.031 [12288] query: select vwractsco.id, vwractsco.ft
e, vwractsco.scotot, vwractsco.dattimupd from vwractsco where (vwrac
tsco.act_cod = 'BLA' and vwractsco.grp_id = 2 and vwractsco.mon = 3
and vwractsco.year = 2001)
010418.15:56:45.032 [12288] ProcessQuery
010418.15:56:45.032 [12288] CommitTransactionCommand
010418.15:56:45.036 [12288] StartTransactionCommand
010418.15:56:45.037 [12288] query: select vwractsco.id, vwractsco.ft
e, vwractsco.scotot, vwractsco.dattimupd from vwractsco where (vwrac
tsco.act_cod = 'BLA' and vwractsco.grp_id = 2 and vwractsco.mon = 3
and vwractsco.year = 2001)
010418.15:56:45.037 [12288] ProcessQuery
010418.15:56:45.038 [12288] CommitTransactionCommand
010418.15:56:45.039 [12288] StartTransactionCommand
010418.15:56:45.039 [12288] query: select vwractsco.id, vwractsco.ft
e, vwractsco.scotot, vwractsco.dattimupd from vwractsco where (vwrac
tsco.act_cod = 'BLA' and vwractsco.grp_id = 2 and vwractsco.mon = 3
and vwractsco.year = 2001)
010418.15:56:45.040 [12288] ProcessQuery
010418.15:56:45.040 [12288] CommitTransactionCommand
010418.15:56:45.042 [12288] StartTransactionCommand
010418.15:56:45.042 [12288] query: select vwractsco.id, vwractsco.ft
e, vwractsco.scotot, vwractsco.dattimupd from vwractsco where (vwrac
tsco.act_cod = 'BLA' and vwractsco.grp_id = 2 and vwractsco.mon = 3
and vwractsco.year = 2001)
010418.15:56:45.043 [12288] ProcessQuery
010418.15:56:45.043 [12288] CommitTransactionCommand
010418.15:56:45.044 [12288] StartTransactionCommand
010418.15:56:45.044 [12288] query: select vwractsco.id, vwractsco.ft
e, vwractsco.scotot, vwractsco.dattimupd from vwractsco where (vwrac
tsco.act_cod = 'BLA' and vwractsco.grp_id = 2 and vwractsco.mon = 3
and vwractsco.year = 2001)
010418.15:56:45.045 [12288] ProcessQuery
010418.15:56:45.045 [12288] CommitTransactionCommand
010418.15:56:45.047 [12288] StartTransactionCommand
010418.15:56:45.047 [12288] query: select vwractsco.id, vwractsco.ft
e, vwractsco.scotot, vwractsco.dattimupd from vwractsco where (vwrac
tsco.act_cod = 'FLOP' and vwractsco.grp_id = 2 and vwractsco.mon = 1
and vwractsco.year = 2001)
010418.15:56:45.048 [12288] ProcessQuery
010418.15:56:45.048 [12288] CommitTransactionCommand
010418.15:56:45.049 [12288] StartTransactionCommand
010418.15:56:45.049 [12288] query: select vwractsco.id, vwractsco.ft
e, vwractsco.scotot, vwractsco.dattimupd from vwractsco where (vwrac
tsco.act_cod = 'FLOP' and vwractsco.grp_id = 2 and vwractsco.mon = 1
and vwractsco.year = 2001)
010418.15:56:45.050 [12288] ProcessQuery
010418.15:56:45.051 [12288] CommitTransactionCommand
010418.15:56:45.053 [12288] StartTransactionCommand
010418.15:56:45.053 [12288] query: select vwractsco.id, vwractsco.ft
e, vwractsco.scotot, vwractsco.dattimupd from vwractsco where (vwrac
tsco.act_cod = 'FLOP' and vwractsco.grp_id = 2 and vwractsco.mon = 1
and vwractsco.year = 2001)
010418.15:56:45.054 [12288] ProcessQuery
010418.15:56:45.055 [12288] CommitTransactionCommand
010418.15:56:45.056 [12288] StartTransactionCommand
010418.15:56:45.056 [12288] query: select vwractsco.id, vwractsco.ft
e, vwractsco.scotot, vwractsco.dattimupd from vwractsco where (vwrac
tsco.act_cod = 'FLOP' and vwractsco.grp_id = 2 and vwractsco.mon = 1
and vwractsco.year = 2001)
010418.15:56:45.057 [12288] ProcessQuery
010418.15:56:45.057 [12288] CommitTransactionCommand
010418.15:56:45.059 [12288] StartTransactionCommand
010418.15:56:45.059 [12288] query: select vwractsco.id, vwractsco.ft
e, vwractsco.scotot, vwractsco.dattimupd from vwractsco where (vwrac
tsco.act_cod = 'FLOP' and vwractsco.grp_id = 2 and vwractsco.mon = 1
and vwractsco.year = 2001)
010418.15:56:45.060 [12288] ProcessQuery
010418.15:56:45.060 [12288] CommitTransactionCommand
010418.15:56:45.061 [12288] StartTransactionCommand
010418.15:56:45.061 [12288] query: select vwractsco.id, vwractsco.ft
e, vwractsco.scotot, vwractsco.dattimupd from vwractsco where (vwrac
tsco.act_cod = 'FLOP' and vwractsco.grp_id = 2 and vwractsco.mon = 2
and vwractsco.year = 2001)
010418.15:56:45.062 [12288] ProcessQuery
010418.15:56:45.062 [12288] CommitTransactionCommand
010418.15:56:45.064 [12288] StartTransactionCommand
010418.15:56:45.064 [12288] query: select vwractsco.id, vwractsco.ft
e, vwractsco.scotot, vwractsco.dattimupd from vwractsco where (vwrac
tsco.act_cod = 'FLOP' and vwractsco.grp_id = 2 and vwractsco.mon = 2
and vwractsco.year = 2001)
010418.15:56:45.065 [12288] ProcessQuery
010418.15:56:45.065 [12288] CommitTransactionCommand
010418.15:56:45.066 [12288] StartTransactionCommand
010418.15:56:45.066 [12288] query: select vwractsco.id, vwractsco.ft
e, vwractsco.scotot, vwractsco.dattimupd from vwractsco where (vwrac
tsco.act_cod = 'FLOP' and vwractsco.grp_id = 2 and vwractsco.mon = 2
and vwractsco.year = 2001)
010418.15:56:45.067 [12288] ProcessQuery
010418.15:56:45.068 [12288] CommitTransactionCommand
010418.15:56:45.069 [12288] StartTransactionCommand
010418.15:56:45.069 [12288] query: select vwractsco.id, vwractsco.ft
e, vwractsco.scotot, vwractsco.dattimupd from vwractsco where (vwrac
tsco.act_cod = 'FLOP' and vwractsco.grp_id = 2 and vwractsco.mon = 2
and vwractsco.year = 2001)
010418.15:56:45.070 [12288] ProcessQuery
010418.15:56:45.070 [12288] CommitTransactionCommand
010418.15:56:45.071 [12288] StartTransactionCommand
010418.15:56:45.071 [12288] query: select vwractsco.id, vwractsco.ft
e, vwractsco.scotot, vwractsco.dattimupd from vwractsco where (vwrac
tsco.act_cod = 'FLOP' and vwractsco.grp_id = 2 and vwractsco.mon = 2
and vwractsco.year = 2001)
010418.15:56:45.072 [12288] ProcessQuery
010418.15:56:45.073 [12288] CommitTransactionCommand
010418.15:56:45.075 [12288] StartTransactionCommand
010418.15:56:45.075 [12288] query: select vwractsco.id, vwractsco.ft
e, vwractsco.scotot, vwractsco.dattimupd from vwractsco where (vwrac
tsco.act_cod = 'FLOP' and vwractsco.grp_id = 2 and vwractsco.mon = 2
and vwractsco.year = 2002)
010418.15:56:45.076 [12288] ProcessQuery
010418.15:56:45.076 [12288] CommitTransactionCommand
010418.15:56:45.080 [12288] StartTransactionCommand
-------------------
