Hi All,
I have a table named teacher, which is descendant of extendeduser
(turbineuser). When I call doSelectJoinExtendedUser() the part of user is
wrong. Teacher table has 8 fields. In doSelectjoin (generated by torque):
...
for (int i = 0; i < rows.size(); i++)
{
Record row = (Record) rows.get(i);
Class omClass = TeacherPeer.getOMClass();
Teacher obj1 = (Teacher) TeacherPeer
.row2Object(row, 1, omClass);
Log.debug(LOGHEADER+"row"+row.toString());
debug's result is ok:
{'1000','1030','docens','mokt','1000','b0027','123456','H
11-12','1030','balfek','balfek','Balek','Bela','[EMAIL
PROTECTED]','null','null','null','null','Źísrjava.util.Hashtableť%!Jä¸F
loadFactorI [EMAIL PROTECTED]'}
first of 8 field is teacher's field, and remaining fields is turbine_user's
fields.
omClass = ExtendedUserPeer.getOMClass();
ExtendedUser obj2 = (ExtendedUser)ExtendedUserPeer
.row2Object(row, offset, omClass);
Log.debug(LOGHEADER+"extendeduser"+obj2.getFirstName()+obj2.getLastName());
and here the debug's result is wrong: nullmokt
questions:
1. why offset is 9, when row2object idx starting from 0, and teacher has only
8 fields? But when I set it 8 it remain same wrong as before.
2. What do I do wrong?
here is environment parameters:
schema.xml:
<table name="TEACHER" idMethod="idbroker" javaName="Teacher">
<column name="T_ID" primaryKey="true" required="true" type="INTEGER"
javaType="object"/>
<column name="T_USERID" required="true" type="INTEGER" />
<column name="T_MIDDLEINITIAL" required="false" type="VARCHAR"
size="15"></column>
<column name="T_TITLE" required="false" type="VARCHAR" size="60"></column>
<column name="T_INSTITUTE" required="false" type="INTEGER" />
<column name="T_PLACE" required="false" type="VARCHAR" size="60"></column>
<column name="T_LOCALPHONE" required="false" type="VARCHAR"
size="60"></column>
<column name="T_CONSHOUR" required="false" type="VARCHAR" size="60"></column>
<foreign-key foreignTable="EXTENDED_USER">
<reference local="T_USERID" foreign="USER_ID"/>
</foreign-key>
...
<table name="EXTENDED_USER" alias="TurbineUser"
baseClass="com.zamek.vili.om.TurbineUserAdapter"
basePeer="com.zamek.vili.om.TurbineUserPeerAdapter">
<column name="USER_ID" primaryKey="true" required="true" type="INTEGER"/>
</table>
--
thx,
----------------------------------------------------
Zoltan Zidarics programmer
PTE University Pecs, Hungary
icq: 43288694
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
