DataSource Lazy-loading issue

[alius]

Hi,

I've just committed changes.
Now fields with ignore=true will not be accessed thus lazy-loaded fields will not be initialized.

You can get changes with next nightly build (2012-11-06).

Regards,
Alius

[vostapenko]

Any response is still welcome here.

[vostapenko]

Is this issue being processed?

Here's some log records.

=== 2012-11-01 16:26:03,988 [l0-6] DEBUG IDACall - Header Name:Value pair: Host:127.0.0.1:8888
=== 2012-11-01 16:26:03,988 [l0-6] DEBUG IDACall - Header Name:Value pair: User-Agent:Mozilla/5.0 (Windows NT 6.1; WOW64; rv:16.0) Gecko/20100101 Firefox/16.0
=== 2012-11-01 16:26:03,989 [l0-6] DEBUG IDACall - Header Name:Value pair: Accept:text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
=== 2012-11-01 16:26:03,989 [l0-6] DEBUG IDACall - Header Name:Value pair: Accept-Language:ru-RU,ru;q=0.8,en-US;q=0.5,en;q=0.3
=== 2012-11-01 16:26:03,989 [l0-6] DEBUG IDACall - Header Name:Value pair: Accept-Encoding:gzip, deflate
=== 2012-11-01 16:26:03,989 [l0-6] DEBUG IDACall - Header Name:Value pair: Connection:keep-alive
=== 2012-11-01 16:26:03,989 [l0-6] DEBUG IDACall - Header Name:Value pair: Referer:http://127.0.0.1:8888/etgcrm.jsp?gwt.codesvr=127.0.0.1:9997
=== 2012-11-01 16:26:03,989 [l0-6] DEBUG IDACall - Header Name:Value pair: Cookie:GLog=%7B%0D%20%20%20%20left%3A541%2C%20%0D%20%20%20%20top%3A201%2C%20%0D%20%20%20%20width%3A758%2C%20%0D%20%20%20%20height%3A780%2C%20%0D%20%20%20%20priorityDefaults%3A%7B%0D%20%20%20%20%20%20%20%20Log%3A4%0D%20%20%20%20%7D%2C%20%0D%20%20%20%20defaultPriority%3A3%2C%20%0D%20%20%20%20trackRPC%3Anull%0D%7D; JSESSIONID=1rbwsg0qea6i2
=== 2012-11-01 16:26:03,990 [l0-6] DEBUG IDACall - Header Name:Value pair: Content-Type:application/x-www-form-urlencoded; charset=UTF-8
=== 2012-11-01 16:26:03,990 [l0-6] DEBUG IDACall - Header Name:Value pair: Content-Length:1006
=== 2012-11-01 16:26:03,990 [l0-6] DEBUG IDACall - Header Name:Value pair: Pragma:no-cache
=== 2012-11-01 16:26:03,990 [l0-6] DEBUG IDACall - Header Name:Value pair: Cache-Control:no-cache
=== 2012-11-01 16:26:03,990 [l0-6] DEBUG IDACall - session exists: 1rbwsg0qea6i2
=== 2012-11-01 16:26:03,990 [l0-6] DEBUG IDACall - remote user: admin
=== 2012-11-01 16:26:03,991 [l0-6] INFO  RequestContext - URL: '/etgcrm/sc/IDACall', User-Agent: 'Mozilla/5.0 (Windows NT 6.1; WOW64; rv:16.0) Gecko/20100101 Firefox/16.0': Moz (Gecko) with Accept-Encoding header
=== 2012-11-01 16:26:03,993 [l0-6] DEBUG XML - Parsed XML from (in memory stream): 1ms
=== 2012-11-01 16:26:03,994 [l0-6] DEBUG RPCManager - Processing 1 requests.
=== 2012-11-01 16:26:04,008 [l0-6] DEBUG RPCManager - Request #1 (DSRequest) payload: {
    criteria:{
    },
    operationConfig:{
        dataSource:"users",
        operationType:"fetch",
        textMatchStyle:"substring"
    },
    startRow:0,
    endRow:75,
    componentId:"isc_ListGrid_0",
    appID:"builtinApplication",
    operation:"users_fetch",
    oldValues:{
    }
}
=== 2012-11-01 16:26:04,008 [l0-6] INFO  IDACall - Performing 1 operation(s)
=== 2012-11-01 16:26:04,008 [l0-6] DEBUG DeclarativeSecurity - Processing security checks for DataSource null, field null
=== 2012-11-01 16:26:04,009 [l0-6] DEBUG DeclarativeSecurity - DataSource users is not in the pre-checked list, processing...
=== 2012-11-01 16:26:04,013 [l0-6] DEBUG AppBase - [builtinApplication.users_fetch] No userTypes defined, allowing anyone access to all operations for this application
=== 2012-11-01 16:26:04,014 [l0-6] DEBUG AppBase - [builtinApplication.users_fetch] No public zero-argument method named '_users_fetch' found, performing generic datasource operation
=== 2012-11-01 16:26:04,014 [l0-6] INFO  HibernateDataSource - [builtinApplication.users_fetch] Performing fetch operation with
	criteria: {}	values: {}
=== 2012-11-01 16:26:04,020 [l0-6] DEBUG HibernateTransaction - [builtinApplication.users_fetch] Started new transaction "328369962"
=== 2012-11-01 16:26:04,021 [l0-6] INFO  HibernateDataSource - [builtinApplication.users_fetch] Query string: select _User, department1 from ru.eurotechnologygroup.etgcrm.server.model.User _User left outer join _User.department department1
=== 2012-11-01 16:26:04,028 [l0-6] DEBUG SQL - select count(*) as col_0_0_ from suser user0_
=== 2012-11-01 16:26:04,036 [l0-6] DEBUG SQL - select top 75 user0_.USERID as USERID0_0_, department1_.DID as DID2_1_, user0_.USERBLOCKED as USERBLOC2_0_0_, user0_.USERDATEBIRTH as USERDATE3_0_0_, user0_.DID as DID0_0_, user0_.USEREMAIL as USEREMAIL0_0_, user0_.USERFIRSNAME as USERFIRS5_0_0_, user0_.USERLASTNAME as USERLAST6_0_0_, user0_.USERLOGIN as USERLOGIN0_0_, user0_.USERMASKIP as USERMASKIP0_0_, user0_.USERPASSWORD as USERPASS9_0_0_, user0_.USERPHONE as USERPHONE0_0_, user0_.USERPATRONYMIC as USERPAT11_0_0_, department1_.DNAME as DNAME2_1_ from suser user0_ left outer join department department1_ on user0_.DID=department1_.DID
=== 2012-11-01 16:26:04,056 [l0-6] INFO  DSResponse - [builtinApplication.users_fetch] DSResponse: List with 75 items
=== 2012-11-01 16:26:04,056 [l0-6] INFO  HibernateTransaction - [builtinApplication.users_fetch] Attempting to commit 0 database update(s)
=== 2012-11-01 16:26:04,056 [l0-6] DEBUG HibernateTransaction - [builtinApplication.users_fetch] Committing transaction "328369962"
=== 2012-11-01 16:26:04,069 [l0-6] DEBUG RPCManager - Content type for RPC transaction: text/plain; charset=UTF-8
=== 2012-11-01 16:26:04,075 [l0-6] DEBUG RPCManager - non-DMI response, dropExtraFields: false
=== 2012-11-01 16:26:04,121 [l0-6] DEBUG SQL - select roles0_.UserID as UserID0_1_, roles0_.URID as URID1_, role1_.urid as urid1_0_, role1_.roledesc as roledesc1_0_, role1_.urname as urname1_0_ from userrole roles0_ inner join srole role1_ on roles0_.URID=role1_.urid where roles0_.UserID=?
=== 2012-11-01 16:26:04,129 [l0-6] DEBUG SQL - select roles0_.UserID as UserID0_1_, roles0_.URID as URID1_, role1_.urid as urid1_0_, role1_.roledesc as roledesc1_0_, role1_.urname as urname1_0_ from userrole roles0_ inner join srole role1_ on roles0_.URID=role1_.urid where roles0_.UserID=?
=== 2012-11-01 16:26:04,135 [l0-6] DEBUG SQL - select roles0_.UserID as UserID0_1_, roles0_.URID as URID1_, role1_.urid as urid1_0_, role1_.roledesc as roledesc1_0_, role1_.urname as urname1_0_ from userrole roles0_ inner join srole role1_ on roles0_.URID=role1_.urid where roles0_.UserID=?
=== 2012-11-01 16:26:04,140 [l0-6] DEBUG SQL - select roles0_.UserID as UserID0_1_, roles0_.URID as URID1_, role1_.urid as urid1_0_, role1_.roledesc as roledesc1_0_, role1_.urname as urname1_0_ from userrole roles0_ inner join srole role1_ on roles0_.URID=role1_.urid where roles0_.UserID=?
=== 2012-11-01 16:26:04,144 [l0-6] DEBUG SQL - select roles0_.UserID as UserID0_1_, roles0_.URID as URID1_, role1_.urid as urid1_0_, role1_.roledesc as roledesc1_0_, role1_.urname as urname1_0_ from userrole roles0_ inner join srole role1_ on roles0_.URID=role1_.urid where roles0_.UserID=?
=== 2012-11-01 16:26:04,148 [l0-6] DEBUG SQL - select roles0_.UserID as UserID0_1_, roles0_.URID as URID1_, role1_.urid as urid1_0_, role1_.roledesc as roledesc1_0_, role1_.urname as urname1_0_ from userrole roles0_ inner join srole role1_ on roles0_.URID=role1_.urid where roles0_.UserID=?
=== 2012-11-01 16:26:04,152 [l0-6] DEBUG SQL - select roles0_.UserID as UserID0_1_, roles0_.URID as URID1_, role1_.urid as urid1_0_, role1_.roledesc as roledesc1_0_, role1_.urname as urname1_0_ from userrole roles0_ inner join srole role1_ on roles0_.URID=role1_.urid where roles0_.UserID=?
=== 2012-11-01 16:26:04,157 [l0-6] DEBUG SQL - select roles0_.UserID as UserID0_1_, roles0_.URID as URID1_, role1_.urid as urid1_0_, role1_.roledesc as roledesc1_0_, role1_.urname as urname1_0_ from userrole roles0_ inner join srole role1_ on roles0_.URID=role1_.urid where roles0_.UserID=?
=== 2012-11-01 16:26:04,161 [l0-6] DEBUG SQL - select roles0_.UserID as UserID0_1_, roles0_.URID as URID1_, role1_.urid as urid1_0_, role1_.roledesc as roledesc1_0_, role1_.urname as urname1_0_ from userrole roles0_ inner join srole role1_ on roles0_.URID=role1_.urid where roles0_.UserID=?
=== 2012-11-01 16:26:04,165 [l0-6] DEBUG SQL - select roles0_.UserID as UserID0_1_, roles0_.URID as URID1_, role1_.urid as urid1_0_, role1_.roledesc as roledesc1_0_, role1_.urname as urname1_0_ from userrole roles0_ inner join srole role1_ on roles0_.URID=role1_.urid where roles0_.UserID=?
=== 2012-11-01 16:26:04,169 [l0-6] DEBUG SQL - select roles0_.UserID as UserID0_1_, roles0_.URID as URID1_, role1_.urid as urid1_0_, role1_.roledesc as roledesc1_0_, role1_.urname as urname1_0_ from userrole roles0_ inner join srole role1_ on roles0_.URID=role1_.urid where roles0_.UserID=?
=== 2012-11-01 16:26:04,174 [l0-6] DEBUG SQL - select roles0_.UserID as UserID0_1_, roles0_.URID as URID1_, role1_.urid as urid1_0_, role1_.roledesc as roledesc1_0_, role1_.urname as urname1_0_ from userrole roles0_ inner join srole role1_ on roles0_.URID=role1_.urid where roles0_.UserID=?
=== 2012-11-01 16:26:04,178 [l0-6] DEBUG SQL - select roles0_.UserID as UserID0_1_, roles0_.URID as URID1_, role1_.urid as urid1_0_, role1_.roledesc as roledesc1_0_, role1_.urname as urname1_0_ from userrole roles0_ inner join srole role1_ on roles0_.URID=role1_.urid where roles0_.UserID=?
=== 2012-11-01 16:26:04,183 [l0-6] DEBUG SQL - select roles0_.UserID as UserID0_1_, roles0_.URID as URID1_, role1_.urid as urid1_0_, role1_.roledesc as roledesc1_0_, role1_.urname as urname1_0_ from userrole roles0_ inner join srole role1_ on roles0_.URID=role1_.urid where roles0_.UserID=?
=== 2012-11-01 16:26:04,187 [l0-6] DEBUG SQL - select roles0_.UserID as UserID0_1_, roles0_.URID as URID1_, role1_.urid as urid1_0_, role1_.roledesc as roledesc1_0_, role1_.urname as urname1_0_ from userrole roles0_ inner join srole role1_ on roles0_.URID=role1_.urid where roles0_.UserID=?
=== 2012-11-01 16:26:04,193 [l0-6] DEBUG SQL - select roles0_.UserID as UserID0_1_, roles0_.URID as URID1_, role1_.urid as urid1_0_, role1_.roledesc as roledesc1_0_, role1_.urname as urname1_0_ from userrole roles0_ inner join srole role1_ on roles0_.URID=role1_.urid where roles0_.UserID=?
=== 2012-11-01 16:26:04,198 [l0-6] DEBUG SQL - select roles0_.UserID as UserID0_1_, roles0_.URID as URID1_, role1_.urid as urid1_0_, role1_.roledesc as roledesc1_0_, role1_.urname as urname1_0_ from userrole roles0_ inner join srole role1_ on roles0_.URID=role1_.urid where roles0_.UserID=?
=== 2012-11-01 16:26:04,203 [l0-6] DEBUG SQL - select roles0_.UserID as UserID0_1_, roles0_.URID as URID1_, role1_.urid as urid1_0_, role1_.roledesc as roledesc1_0_, role1_.urname as urname1_0_ from userrole roles0_ inner join srole role1_ on roles0_.URID=role1_.urid where roles0_.UserID=?
=== 2012-11-01 16:26:04,207 [l0-6] DEBUG SQL - select roles0_.UserID as UserID0_1_, roles0_.URID as URID1_, role1_.urid as urid1_0_, role1_.roledesc as roledesc1_0_, role1_.urname as urname1_0_ from userrole roles0_ inner join srole role1_ on roles0_.URID=role1_.urid where roles0_.UserID=?
=== 2012-11-01 16:26:04,211 [l0-6] DEBUG SQL - select roles0_.UserID as UserID0_1_, roles0_.URID as URID1_, role1_.urid as urid1_0_, role1_.roledesc as roledesc1_0_, role1_.urname as urname1_0_ from userrole roles0_ inner join srole role1_ on roles0_.URID=role1_.urid where roles0_.UserID=?
=== 2012-11-01 16:26:04,215 [l0-6] DEBUG SQL - select roles0_.UserID as UserID0_1_, roles0_.URID as URID1_, role1_.urid as urid1_0_, role1_.roledesc as roledesc1_0_, role1_.urname as urname1_0_ from userrole roles0_ inner join srole role1_ on roles0_.URID=role1_.urid where roles0_.UserID=?
=== 2012-11-01 16:26:04,220 [l0-6] DEBUG SQL - select roles0_.UserID as UserID0_1_, roles0_.URID as URID1_, role1_.urid as urid1_0_, role1_.roledesc as roledesc1_0_, role1_.urname as urname1_0_ from userrole roles0_ inner join srole role1_ on roles0_.URID=role1_.urid where roles0_.UserID=?
=== 2012-11-01 16:26:04,224 [l0-6] DEBUG SQL - select roles0_.UserID as UserID0_1_, roles0_.URID as URID1_, role1_.urid as urid1_0_, role1_.roledesc as roledesc1_0_, role1_.urname as urname1_0_ from userrole roles0_ inner join srole role1_ on roles0_.URID=role1_.urid where roles0_.UserID=?
=== 2012-11-01 16:26:04,230 [l0-6] DEBUG SQL - select roles0_.UserID as UserID0_1_, roles0_.URID as URID1_, role1_.urid as urid1_0_, role1_.roledesc as roledesc1_0_, role1_.urname as urname1_0_ from userrole roles0_ inner join srole role1_ on roles0_.URID=role1_.urid where roles0_.UserID=?
=== 2012-11-01 16:26:04,235 [l0-6] DEBUG SQL - select roles0_.UserID as UserID0_1_, roles0_.URID as URID1_, role1_.urid as urid1_0_, role1_.roledesc as roledesc1_0_, role1_.urname as urname1_0_ from userrole roles0_ inner join srole role1_ on roles0_.URID=role1_.urid where roles0_.UserID=?
=== 2012-11-01 16:26:04,239 [l0-6] DEBUG SQL - select roles0_.UserID as UserID0_1_, roles0_.URID as URID1_, role1_.urid as urid1_0_, role1_.roledesc as roledesc1_0_, role1_.urname as urname1_0_ from userrole roles0_ inner join srole role1_ on roles0_.URID=role1_.urid where roles0_.UserID=?
=== 2012-11-01 16:26:04,244 [l0-6] DEBUG SQL - select roles0_.UserID as UserID0_1_, roles0_.URID as URID1_, role1_.urid as urid1_0_, role1_.roledesc as roledesc1_0_, role1_.urname as urname1_0_ from userrole roles0_ inner join srole role1_ on roles0_.URID=role1_.urid where roles0_.UserID=?
=== 2012-11-01 16:26:04,248 [l0-6] DEBUG SQL - select roles0_.UserID as UserID0_1_, roles0_.URID as URID1_, role1_.urid as urid1_0_, role1_.roledesc as roledesc1_0_, role1_.urname as urname1_0_ from userrole roles0_ inner join srole role1_ on roles0_.URID=role1_.urid where roles0_.UserID=?
=== 2012-11-01 16:26:04,253 [l0-6] DEBUG SQL - select roles0_.UserID as UserID0_1_, roles0_.URID as URID1_, role1_.urid as urid1_0_, role1_.roledesc as roledesc1_0_, role1_.urname as urname1_0_ from userrole roles0_ inner join srole role1_ on roles0_.URID=role1_.urid where roles0_.UserID=?
=== 2012-11-01 16:26:04,257 [l0-6] DEBUG SQL - select roles0_.UserID as UserID0_1_, roles0_.URID as URID1_, role1_.urid as urid1_0_, role1_.roledesc as roledesc1_0_, role1_.urname as urname1_0_ from userrole roles0_ inner join srole role1_ on roles0_.URID=role1_.urid where roles0_.UserID=?
=== 2012-11-01 16:26:04,262 [l0-6] DEBUG SQL - select roles0_.UserID as UserID0_1_, roles0_.URID as URID1_, role1_.urid as urid1_0_, role1_.roledesc as roledesc1_0_, role1_.urname as urname1_0_ from userrole roles0_ inner join srole role1_ on roles0_.URID=role1_.urid where roles0_.UserID=?
=== 2012-11-01 16:26:04,266 [l0-6] DEBUG SQL - select roles0_.UserID as UserID0_1_, roles0_.URID as URID1_, role1_.urid as urid1_0_, role1_.roledesc as roledesc1_0_, role1_.urname as urname1_0_ from userrole roles0_ inner join srole role1_ on roles0_.URID=role1_.urid where roles0_.UserID=?
=== 2012-11-01 16:26:04,271 [l0-6] DEBUG SQL - select roles0_.UserID as UserID0_1_, roles0_.URID as URID1_, role1_.urid as urid1_0_, role1_.roledesc as roledesc1_0_, role1_.urname as urname1_0_ from userrole roles0_ inner join srole role1_ on roles0_.URID=role1_.urid where roles0_.UserID=?
=== 2012-11-01 16:26:04,276 [l0-6] DEBUG SQL - select roles0_.UserID as UserID0_1_, roles0_.URID as URID1_, role1_.urid as urid1_0_, role1_.roledesc as roledesc1_0_, role1_.urname as urname1_0_ from userrole roles0_ inner join srole role1_ on roles0_.URID=role1_.urid where roles0_.UserID=?
=== 2012-11-01 16:26:04,280 [l0-6] DEBUG SQL - select roles0_.UserID as UserID0_1_, roles0_.URID as URID1_, role1_.urid as urid1_0_, role1_.roledesc as roledesc1_0_, role1_.urname as urname1_0_ from userrole roles0_ inner join srole role1_ on roles0_.URID=role1_.urid where roles0_.UserID=?
=== 2012-11-01 16:26:04,285 [l0-6] DEBUG SQL - select roles0_.UserID as UserID0_1_, roles0_.URID as URID1_, role1_.urid as urid1_0_, role1_.roledesc as roledesc1_0_, role1_.urname as urname1_0_ from userrole roles0_ inner join srole role1_ on roles0_.URID=role1_.urid where roles0_.UserID=?
=== 2012-11-01 16:26:04,290 [l0-6] DEBUG SQL - select roles0_.UserID as UserID0_1_, roles0_.URID as URID1_, role1_.urid as urid1_0_, role1_.roledesc as roledesc1_0_, role1_.urname as urname1_0_ from userrole roles0_ inner join srole role1_ on roles0_.URID=role1_.urid where roles0_.UserID=?
=== 2012-11-01 16:26:04,294 [l0-6] DEBUG SQL - select roles0_.UserID as UserID0_1_, roles0_.URID as URID1_, role1_.urid as urid1_0_, role1_.roledesc as roledesc1_0_, role1_.urname as urname1_0_ from userrole roles0_ inner join srole role1_ on roles0_.URID=role1_.urid where roles0_.UserID=?
=== 2012-11-01 16:26:04,298 [l0-6] DEBUG SQL - select roles0_.UserID as UserID0_1_, roles0_.URID as URID1_, role1_.urid as urid1_0_, role1_.roledesc as roledesc1_0_, role1_.urname as urname1_0_ from userrole roles0_ inner join srole role1_ on roles0_.URID=role1_.urid where roles0_.UserID=?
=== 2012-11-01 16:26:04,303 [l0-6] DEBUG SQL - select roles0_.UserID as UserID0_1_, roles0_.URID as URID1_, role1_.urid as urid1_0_, role1_.roledesc as roledesc1_0_, role1_.urname as urname1_0_ from userrole roles0_ inner join srole role1_ on roles0_.URID=role1_.urid where roles0_.UserID=?
=== 2012-11-01 16:26:04,307 [l0-6] DEBUG SQL - select roles0_.UserID as UserID0_1_, roles0_.URID as URID1_, role1_.urid as urid1_0_, role1_.roledesc as roledesc1_0_, role1_.urname as urname1_0_ from userrole roles0_ inner join srole role1_ on roles0_.URID=role1_.urid where roles0_.UserID=?
=== 2012-11-01 16:26:04,311 [l0-6] DEBUG SQL - select roles0_.UserID as UserID0_1_, roles0_.URID as URID1_, role1_.urid as urid1_0_, role1_.roledesc as roledesc1_0_, role1_.urname as urname1_0_ from userrole roles0_ inner join srole role1_ on roles0_.URID=role1_.urid where roles0_.UserID=?
=== 2012-11-01 16:26:04,316 [l0-6] DEBUG SQL - select roles0_.UserID as UserID0_1_, roles0_.URID as URID1_, role1_.urid as urid1_0_, role1_.roledesc as roledesc1_0_, role1_.urname as urname1_0_ from userrole roles0_ inner join srole role1_ on roles0_.URID=role1_.urid where roles0_.UserID=?
=== 2012-11-01 16:26:04,320 [l0-6] DEBUG SQL - select roles0_.UserID as UserID0_1_, roles0_.URID as URID1_, role1_.urid as urid1_0_, role1_.roledesc as roledesc1_0_, role1_.urname as urname1_0_ from userrole roles0_ inner join srole role1_ on roles0_.URID=role1_.urid where roles0_.UserID=?
=== 2012-11-01 16:26:04,324 [l0-6] DEBUG SQL - select roles0_.UserID as UserID0_1_, roles0_.URID as URID1_, role1_.urid as urid1_0_, role1_.roledesc as roledesc1_0_, role1_.urname as urname1_0_ from userrole roles0_ inner join srole role1_ on roles0_.URID=role1_.urid where roles0_.UserID=?
=== 2012-11-01 16:26:04,329 [l0-6] DEBUG SQL - select roles0_.UserID as UserID0_1_, roles0_.URID as URID1_, role1_.urid as urid1_0_, role1_.roledesc as roledesc1_0_, role1_.urname as urname1_0_ from userrole roles0_ inner join srole role1_ on roles0_.URID=role1_.urid where roles0_.UserID=?
=== 2012-11-01 16:26:04,334 [l0-6] DEBUG SQL - select roles0_.UserID as UserID0_1_, roles0_.URID as URID1_, role1_.urid as urid1_0_, role1_.roledesc as roledesc1_0_, role1_.urname as urname1_0_ from userrole roles0_ inner join srole role1_ on roles0_.URID=role1_.urid where roles0_.UserID=?
=== 2012-11-01 16:26:04,338 [l0-6] DEBUG SQL - select roles0_.UserID as UserID0_1_, roles0_.URID as URID1_, role1_.urid as urid1_0_, role1_.roledesc as roledesc1_0_, role1_.urname as urname1_0_ from userrole roles0_ inner join srole role1_ on roles0_.URID=role1_.urid where roles0_.UserID=?
=== 2012-11-01 16:26:04,342 [l0-6] DEBUG SQL - select roles0_.UserID as UserID0_1_, roles0_.URID as URID1_, role1_.urid as urid1_0_, role1_.roledesc as roledesc1_0_, role1_.urname as urname1_0_ from userrole roles0_ inner join srole role1_ on roles0_.URID=role1_.urid where roles0_.UserID=?
=== 2012-11-01 16:26:04,347 [l0-6] DEBUG SQL - select roles0_.UserID as UserID0_1_, roles0_.URID as URID1_, role1_.urid as urid1_0_, role1_.roledesc as roledesc1_0_, role1_.urname as urname1_0_ from userrole roles0_ inner join srole role1_ on roles0_.URID=role1_.urid where roles0_.UserID=?
=== 2012-11-01 16:26:04,352 [l0-6] DEBUG SQL - select roles0_.UserID as UserID0_1_, roles0_.URID as URID1_, role1_.urid as urid1_0_, role1_.roledesc as roledesc1_0_, role1_.urname as urname1_0_ from userrole roles0_ inner join srole role1_ on roles0_.URID=role1_.urid where roles0_.UserID=?
=== 2012-11-01 16:26:04,356 [l0-6] DEBUG SQL - select roles0_.UserID as UserID0_1_, roles0_.URID as URID1_, role1_.urid as urid1_0_, role1_.roledesc as roledesc1_0_, role1_.urname as urname1_0_ from userrole roles0_ inner join srole role1_ on roles0_.URID=role1_.urid where roles0_.UserID=?
=== 2012-11-01 16:26:04,360 [l0-6] DEBUG SQL - select roles0_.UserID as UserID0_1_, roles0_.URID as URID1_, role1_.urid as urid1_0_, role1_.roledesc as roledesc1_0_, role1_.urname as urname1_0_ from userrole roles0_ inner join srole role1_ on roles0_.URID=role1_.urid where roles0_.UserID=?
=== 2012-11-01 16:26:04,364 [l0-6] DEBUG SQL - select roles0_.UserID as UserID0_1_, roles0_.URID as URID1_, role1_.urid as urid1_0_, role1_.roledesc as roledesc1_0_, role1_.urname as urname1_0_ from userrole roles0_ inner join srole role1_ on roles0_.URID=role1_.urid where roles0_.UserID=?
=== 2012-11-01 16:26:04,369 [l0-6] DEBUG SQL - select roles0_.UserID as UserID0_1_, roles0_.URID as URID1_, role1_.urid as urid1_0_, role1_.roledesc as roledesc1_0_, role1_.urname as urname1_0_ from userrole roles0_ inner join srole role1_ on roles0_.URID=role1_.urid where roles0_.UserID=?
=== 2012-11-01 16:26:04,373 [l0-6] DEBUG SQL - select roles0_.UserID as UserID0_1_, roles0_.URID as URID1_, role1_.urid as urid1_0_, role1_.roledesc as roledesc1_0_, role1_.urname as urname1_0_ from userrole roles0_ inner join srole role1_ on roles0_.URID=role1_.urid where roles0_.UserID=?
=== 2012-11-01 16:26:04,378 [l0-6] DEBUG SQL - select roles0_.UserID as UserID0_1_, roles0_.URID as URID1_, role1_.urid as urid1_0_, role1_.roledesc as roledesc1_0_, role1_.urname as urname1_0_ from userrole roles0_ inner join srole role1_ on roles0_.URID=role1_.urid where roles0_.UserID=?
=== 2012-11-01 16:26:04,382 [l0-6] DEBUG SQL - select roles0_.UserID as UserID0_1_, roles0_.URID as URID1_, role1_.urid as urid1_0_, role1_.roledesc as roledesc1_0_, role1_.urname as urname1_0_ from userrole roles0_ inner join srole role1_ on roles0_.URID=role1_.urid where roles0_.UserID=?
=== 2012-11-01 16:26:04,387 [l0-6] DEBUG SQL - select roles0_.UserID as UserID0_1_, roles0_.URID as URID1_, role1_.urid as urid1_0_, role1_.roledesc as roledesc1_0_, role1_.urname as urname1_0_ from userrole roles0_ inner join srole role1_ on roles0_.URID=role1_.urid where roles0_.UserID=?
=== 2012-11-01 16:26:04,392 [l0-6] DEBUG SQL - select roles0_.UserID as UserID0_1_, roles0_.URID as URID1_, role1_.urid as urid1_0_, role1_.roledesc as roledesc1_0_, role1_.urname as urname1_0_ from userrole roles0_ inner join srole role1_ on roles0_.URID=role1_.urid where roles0_.UserID=?
=== 2012-11-01 16:26:04,396 [l0-6] DEBUG SQL - select roles0_.UserID as UserID0_1_, roles0_.URID as URID1_, role1_.urid as urid1_0_, role1_.roledesc as roledesc1_0_, role1_.urname as urname1_0_ from userrole roles0_ inner join srole role1_ on roles0_.URID=role1_.urid where roles0_.UserID=?
=== 2012-11-01 16:26:04,401 [l0-6] DEBUG SQL - select roles0_.UserID as UserID0_1_, roles0_.URID as URID1_, role1_.urid as urid1_0_, role1_.roledesc as roledesc1_0_, role1_.urname as urname1_0_ from userrole roles0_ inner join srole role1_ on roles0_.URID=role1_.urid where roles0_.UserID=?
=== 2012-11-01 16:26:04,405 [l0-6] DEBUG SQL - select roles0_.UserID as UserID0_1_, roles0_.URID as URID1_, role1_.urid as urid1_0_, role1_.roledesc as roledesc1_0_, role1_.urname as urname1_0_ from userrole roles0_ inner join srole role1_ on roles0_.URID=role1_.urid where roles0_.UserID=?
=== 2012-11-01 16:26:04,410 [l0-6] DEBUG SQL - select roles0_.UserID as UserID0_1_, roles0_.URID as URID1_, role1_.urid as urid1_0_, role1_.roledesc as roledesc1_0_, role1_.urname as urname1_0_ from userrole roles0_ inner join srole role1_ on roles0_.URID=role1_.urid where roles0_.UserID=?
=== 2012-11-01 16:26:04,414 [l0-6] DEBUG SQL - select roles0_.UserID as UserID0_1_, roles0_.URID as URID1_, role1_.urid as urid1_0_, role1_.roledesc as roledesc1_0_, role1_.urname as urname1_0_ from userrole roles0_ inner join srole role1_ on roles0_.URID=role1_.urid where roles0_.UserID=?
=== 2012-11-01 16:26:04,419 [l0-6] DEBUG SQL - select roles0_.UserID as UserID0_1_, roles0_.URID as URID1_, role1_.urid as urid1_0_, role1_.roledesc as roledesc1_0_, role1_.urname as urname1_0_ from userrole roles0_ inner join srole role1_ on roles0_.URID=role1_.urid where roles0_.UserID=?
=== 2012-11-01 16:26:04,423 [l0-6] DEBUG SQL - select roles0_.UserID as UserID0_1_, roles0_.URID as URID1_, role1_.urid as urid1_0_, role1_.roledesc as roledesc1_0_, role1_.urname as urname1_0_ from userrole roles0_ inner join srole role1_ on roles0_.URID=role1_.urid where roles0_.UserID=?
=== 2012-11-01 16:26:04,428 [l0-6] DEBUG SQL - select roles0_.UserID as UserID0_1_, roles0_.URID as URID1_, role1_.urid as urid1_0_, role1_.roledesc as roledesc1_0_, role1_.urname as urname1_0_ from userrole roles0_ inner join srole role1_ on roles0_.URID=role1_.urid where roles0_.UserID=?
=== 2012-11-01 16:26:04,433 [l0-6] DEBUG SQL - select roles0_.UserID as UserID0_1_, roles0_.URID as URID1_, role1_.urid as urid1_0_, role1_.roledesc as roledesc1_0_, role1_.urname as urname1_0_ from userrole roles0_ inner join srole role1_ on roles0_.URID=role1_.urid where roles0_.UserID=?
=== 2012-11-01 16:26:04,437 [l0-6] DEBUG SQL - select roles0_.UserID as UserID0_1_, roles0_.URID as URID1_, role1_.urid as urid1_0_, role1_.roledesc as roledesc1_0_, role1_.urname as urname1_0_ from userrole roles0_ inner join srole role1_ on roles0_.URID=role1_.urid where roles0_.UserID=?
=== 2012-11-01 16:26:04,441 [l0-6] DEBUG SQL - select roles0_.UserID as UserID0_1_, roles0_.URID as URID1_, role1_.urid as urid1_0_, role1_.roledesc as roledesc1_0_, role1_.urname as urname1_0_ from userrole roles0_ inner join srole role1_ on roles0_.URID=role1_.urid where roles0_.UserID=?
=== 2012-11-01 16:26:04,447 [l0-6] DEBUG SQL - select roles0_.UserID as UserID0_1_, roles0_.URID as URID1_, role1_.urid as urid1_0_, role1_.roledesc as roledesc1_0_, role1_.urname as urname1_0_ from userrole roles0_ inner join srole role1_ on roles0_.URID=role1_.urid where roles0_.UserID=?
=== 2012-11-01 16:26:04,453 [l0-6] DEBUG SQL - select roles0_.UserID as UserID0_1_, roles0_.URID as URID1_, role1_.urid as urid1_0_, role1_.roledesc as roledesc1_0_, role1_.urname as urname1_0_ from userrole roles0_ inner join srole role1_ on roles0_.URID=role1_.urid where roles0_.UserID=?
=== 2012-11-01 16:26:04,457 [l0-6] DEBUG SQL - select roles0_.UserID as UserID0_1_, roles0_.URID as URID1_, role1_.urid as urid1_0_, role1_.roledesc as roledesc1_0_, role1_.urname as urname1_0_ from userrole roles0_ inner join srole role1_ on roles0_.URID=role1_.urid where roles0_.UserID=?
=== 2012-11-01 16:26:04,461 [l0-6] DEBUG SQL - select roles0_.UserID as UserID0_1_, roles0_.URID as URID1_, role1_.urid as urid1_0_, role1_.roledesc as roledesc1_0_, role1_.urname as urname1_0_ from userrole roles0_ inner join srole role1_ on roles0_.URID=role1_.urid where roles0_.UserID=?
=== 2012-11-01 16:26:04,467 [l0-6] DEBUG HibernateTransaction - Closing session "328369962"
=== 2012-11-01 16:26:04,467 [l0-6] DEBUG HibernateTransaction - Removed transaction "328369962"

[vostapenko]

v8.3d_2012-10-22/Pro Deployment (built 2012-10-22)

I'll try to describe as simple as i can.

I have:

1. Hibernate bean describing the following LAZY field:

@ManyToMany(targetEntity = Role.class, fetch = FetchType.LAZY)
    @JoinTable(name = "userrole", joinColumns = @JoinColumn(name = "UserID"),
            inverseJoinColumns = @JoinColumn(name = "URID"))
    public List<Role> getRoles()
    {
        return roles;
    }

    public void setRoles(List<Role> roles)
    {
        this.roles = roles;
    }

2. Datasource XML-definition with ignore flag

<DataSource ID="users" serverType="hibernate" beanClassName="com.myPackage.etgcrm.server.model.User"
       schemaBean="com.myPackage.etgcrm.server.model.User">
    <fields>

...
<field name="roles" ignore="true"/>

...

</fields>
</DataSource>

3. Standard list grid

DataSource ds = DataSource.get("users");
ListGrid listGrid = new ListGrid();
listGrid.setDataSource(ds);
listGrid.setAutoFetchData(true);

Everything is working fine, except the thing that LAZY field "roles" is initialized during ListGrid fetch operation: i can see multiple sql queries in the log.

I've tried ignore=true, as shown in example, but without any success.

Is there a way to make SmartGwt respect Lazy attribute and not initialize the fields not shown in ListGrid?