Lazy Loading losing field value

[Christopher . Mathrusse]

I'm using iBatis 2.3.0 build# 677 with JDK 1.5.11

I have the following 3 tables.

create table op_rule_drl (
   id                   numeric(18)                    identity,
   name                 varchar(32)                    not null,
   content              text                           null,
   create_date          datetime                       default getdate() not null,
   mod_date             datetime                       default getdate() not null,
   version              int                            default 0 not null
)
lock datarows
with identity_gap = 10
go

create table op_rule_dsl (
   id                   numeric(18)                    identity,
   name                 varchar(32)                    not null,
   content              text                           null,
   create_date          datetime                       default getdate() not null,
   mod_date             datetime                       default getdate() not null,
   version              int                            default 0 not null
)
lock datarows
with identity_gap = 10
go

create table op_rule_set (
   id                   varchar(32)                    not null,
   drl_id               numeric(18)                    not null,
   dsl_id               numeric(18)                    not null,
   description          varchar(200)                   null,
   create_date          datetime                       default getdate() not null,
   mod_date             datetime                       default getdate() not null,
   version              int                            default 0 not null
)
lock datarows
with identity_gap = 10
go


I have corresponding Domain & Doa objects. Everything works well when I perform operations on the RuleDSL and RuleDRL. (select, insert, update, delete)

The problem is when I lazy load these objects from my RuleSet SQLMap. The objects get loaded except one field. As detailed above, the version field is for optimistic locking. When I load them lazily from the RuleSet object all values are returned correctly but the version field is null in both the RuleDSL and RuleDRL objects. This of course prevents me from performing any update or delete operations on the objects. I don't understand why this should be occurring as I have verified the operations in both the RuleDRL and RuleDSL maps work correctly. When I perform a findByPrimaryKey in both of these SQL Maps all values are returned as expected. Only when these objects are loaded lazily do I see this issue. I've attached the SQL maps incase I have overlooked something.

Thanks for the help...



Chris Mathrusse
[EMAIL PROTECTED]
Sybase, Inc
One Sybase Drive
Dublin, CA 94568
(925) 236-5553

RuleSet.xml
Description: Binary data

RuleDRL.xml
Description: Binary data

RuleDSL.xml
Description: Binary data