Re: [Fwd: mapping associations(1:1,1:n) seems not working with Oracle9i]

Sat, 08 May 2004 09:07:54 -0700

Hi Carla,

if you don't have problems with MySQL but with Oracle the problem may rely on the used ...broker.platforms.PlatformOracle9iImpl class. Did you try rc6? Since rc5 changes made in this class.

> Assigned to the mapping associations i.e. I get a null value because the
> n-side objects (or single object for 1:1) are not materialized.

there was a concurrency problem concerning materialisation of referenced objects - this is fixed in rc6

regards,
Armin

Hi,



I’m using OJB (db-ojb-1.0.rc5) to access Oracle9i (Windows XP) and I
have problems retrieving the data (Value Objects=VO)

Assigned to the mapping associations i.e. I get a null value because the
n-side objects (or single object for 1:1) are not materialized.



The strange thing is that the application works with MySQL, which makes
me think that OJB is not working well with Oracle.



I searched for all possible settings defining the “reference descriptor”
and “collection descriptor” elements and it did not work.

For instance set the attribute “auto-retrieve=true” and also manually
(“auto-retrieve=false”) using the
PersistenceBroker.retrieveAllReferences method.



Below I’m describing the steps I took and you also can find some pieces
of my application code and OJB configuration files.

The Model sample I describe is the following: I have a table C_LOADER
that has a 1:1 relationship with table C_INTEGRATION,

in other hand C_INTEGRATION has 1:n relationship with C_LOADER. I want
to query the table C_LOADER and also get the

integrationName assigned to the loader.

1)       I generated the VOs and the repository files using the torque
version 3.1 and I copied them (from /ojb folder) to my source folder.

2) I updated “repository.xml”:



<jdbc-connection-descriptor id="default"

jcd-alias="default"

default-connection="true"

platform="Oracle9i"

jdbc-level="2.0"

driver="oracle.jdbc.driver.OracleDriver"

protocol="jdbc"

subprotocol="oracle"

dbalias="thin:@rammstein.critical.pt:1521:dws"

username="pmdev"

password="pms"

eager-release="false"

batch-mode="false"

ignoreAutoCommitExceptions="false">

</jdbc-connection-descriptor>





3)       I changed the “repository_project.xml” and the VO java classes
to include the necessary foreign keys elements, reference and collection
descriptors. (NOTE: Torque generated the schema_project.xml describing
the tables, columns and foreign keys but it did not include the foreign
keys/fields in the VO java classes).





<class-descriptor

class="vo.CLoader"

table="C_LOADER"

>

<field-descriptor id="1"

name="loaderid"

column="LOADERID"

jdbc-type="INTEGER"

nullable="false"

primarykey="true"

/>



<field-descriptor id="2"

name="integrationid"

column="INTEGRATIONID"

jdbc-type="INTEGER"

/>

<field-descriptor id="3"

name="description"

column="DESCRIPTION"

jdbc-type="VARCHAR"

/>



<!--Relation 1:1 with table C_Integration-->

<reference-descriptor

name="loadIntegration"

class-ref="vo.CIntegration"

auto-retrieve = "true"

auto-delete = "false"

auto-update = "false"

nullieforeignkey="false">

<foreignkey field-ref="integrationid"

/>

</reference-descriptor>

</class-descriptor>



--------------------------------------------------------------------------------------------------


<class-descriptor

class="vo.CIntegration"

table="C_INTEGRATION"

>



<field-descriptor id="1"

name="integrationid"

column="INTEGRATIONID"

jdbc-type="DECIMAL"

nullable="false"

primarykey="true"

/>

<field-descriptor id="2"

name="intname"

column="INTNAME"

jdbc-type="VARCHAR"

nullable="false"

/>



<!--Relation 1:n with table C_loaders-->

<collection-descriptor

name="loadersInIntegration"

element-class-ref="vo.CLoader"

auto-retrieve="true"

auto-update="true"

auto-delete="true"

orderby="loaderid"

sort="DESC">

<inverse-foreignkey field-ref="integrationid"/>

</collection-descriptor>



</class-descriptor>





4) The VO java classe C_LOADER and C_INTEGRATION



public class CLoader

{

private Integer loaderid;

private Integer integrationid;

private CIntegration loadIntegration;





public Integer getLoaderid()

{

return loaderid;

}



public void setLoaderid(Integer v)

{

this.loaderid = v;

}



public Integer getIntegrationid()

{

return integrationid;

}



public void setIntegrationid(Integer v)

{

this.integrationid = v;

}



public CIntegration getLoadIntegration()

{

return loadIntegration;

}



public void setLoadIntegration(CIntegration v)

{

this.loadIntegration = v;

}

}

----------------------------------------------------------------------------------------------------------


public class CIntegration

{

private BigDecimal integrationid;

private String intname;

private Collection loadersInIntegration;





public BigDecimal getIntegrationid()

{

return integrationid;

}



public void setIntegrationid(BigDecimal v)

{

this.integrationid = v;

}



public String getIntname()

{

return intname;

}



public void setIntname(String v)

{

this.intname = v;

}



public Collection getLoadersInIntegration(){

return loadersInIntegration;

}



public boolean hasLoaders()

{

return (this.getLoadersInIntegration().size() > 0)?true:false;

}



}



5)       Application source and the invocation of the VO Cloader (1:1
relation with CIntegration).

      It prints out  the LOADERID and  “DID Not Work!!”  when it tries
to access to the associated Cintegration VO L



public Collection getLoaderList() {

// List all the rows from table C_Loaders

PersistenceBroker broker = null;

try {

broker = PersistenceBrokerFactory.defaultPersistenceBroker();

CLoader loader = new CLoader();



// Query all the rows without criteria

QueryByCriteria query = new QueryByCriteria(loader);

Collection loaderListCol = broker.getCollectionByQuery(query);



Iterator it = loaderListCol.iterator();

while (it.hasNext()) {

CLoader loaderField = (CLoader) it.next();



// get loaderid

                               System.out.println("LOADERID: " +
loaderField.getLoaderid().toString() );



// get integartion name

                               CIntegration integrationVO =
loaderField.getLoadIntegration();



if (integrationVO == null){

                                               System.out.println("DID
not Work!!");

}

else {


System.out.println("INTNAME: " + integrationVO.getIntname() );

}

return loaderListCol;

} finally {

if (broker != null) {

broker.close();

}

}

}





I would really appreciate any help.

Thanks in advance and kind regards,



Carla Avelans
























------------------------------------------------------------------------



<!--
==============================================================
            TABLE c_group
==============================================================

-->
<class-descriptor
class="com.criticalsoftware.vodafone.pmsloaderadmin.vo.CGroup"
table="c_group"
>
<!--
COLUMN GROUPID
..............................................

-->
<field-descriptor id="1"
name="groupid"
column="GROUPID"
jdbc-type="DECIMAL"
nullable="false" primarykey="true" />

<!--
COLUMN INTEGRATIONID
..............................................

-->
<field-descriptor id="2"
name="integrationid"
column="INTEGRATIONID"
jdbc-type="DECIMAL"
nullable="false" />

<!--
COLUMN GROUPNAME
..............................................

-->
<field-descriptor id="3"
name="groupname"
column="GROUPNAME"
jdbc-type="VARCHAR"
/>

<!--
COLUMN RELEASE
..............................................

-->
<field-descriptor id="4"
name="release"
column="RELEASE"
jdbc-type="VARCHAR"
/>

<!--
COLUMN LONGNAME
..............................................

-->
<field-descriptor id="5"
name="longname"
column="LONGNAME"
jdbc-type="VARCHAR"
/>

<!--
COLUMN GROUPDBID
..............................................

-->
<field-descriptor id="6"
name="groupdbid"
column="GROUPDBID"
jdbc-type="DECIMAL"
nullable="false" />

<!--
COLUMN POS_PROCEDURE
..............................................

-->
<field-descriptor id="7"
name="posProcedure"
column="POS_PROCEDURE"
jdbc-type="VARCHAR"
/>

<!--
COLUMN VAL_PROCEDURE
..............................................

-->
<field-descriptor id="8"
name="valProcedure"
column="VAL_PROCEDURE"
jdbc-type="VARCHAR"
/>

<!--
COLUMN STATUS
..............................................

-->
<field-descriptor id="9"
name="status"
column="STATUS"
jdbc-type="DECIMAL"
/>

<!--
COLUMN STATUSLASTDATE
..............................................

-->
<field-descriptor id="10"
name="statuslastdate"
column="STATUSLASTDATE"
jdbc-type="TIMESTAMP"
/>

</class-descriptor>

<!--
==============================================================
            TABLE c_groupitemdb
==============================================================

-->
<class-descriptor
class="com.criticalsoftware.vodafone.pmsloaderadmin.vo.CGroupitemdb"
table="c_groupitemdb"
>
<!--
COLUMN ITEMDBID
..............................................

-->
<field-descriptor id="1"
name="itemdbid"
column="ITEMDBID"
jdbc-type="DECIMAL"
nullable="false" primarykey="true" />

<!--
COLUMN GROUPDBID
..............................................

-->
<field-descriptor id="2"
name="groupdbid"
column="GROUPDBID"
jdbc-type="DECIMAL"
nullable="false" />

<!--
COLUMN ITEMNAME
..............................................

-->
<field-descriptor id="3"
name="itemname"
column="ITEMNAME"
jdbc-type="VARCHAR"
/>

<!--
COLUMN LONGNAME
..............................................

-->
<field-descriptor id="4"
name="longname"
column="LONGNAME"
jdbc-type="VARCHAR"
/>

<!--
COLUMN ITEMUNIT
..............................................

-->
<field-descriptor id="5"
name="itemunit"
column="ITEMUNIT"
jdbc-type="VARCHAR"
/>

<!--
COLUMN ITEMTYPE
..............................................

-->
<field-descriptor id="6"
name="itemtype"
column="ITEMTYPE"
jdbc-type="CHAR"
/>

<!--
COLUMN ITEMDATATYPE
..............................................

-->
<field-descriptor id="7"
name="itemdatatype"
column="ITEMDATATYPE"
jdbc-type="VARCHAR"
/>

<!--
COLUMN ITEMKEY
..............................................

-->
<field-descriptor id="8"
name="itemkey"
column="ITEMKEY"
jdbc-type="DECIMAL"
/>

<!--
COLUMN ITEMORDER
..............................................

-->
<field-descriptor id="9"
name="itemorder"
column="ITEMORDER"
jdbc-type="DECIMAL"
/>

<!--
COLUMN DESCRIPTION
..............................................

-->
<field-descriptor id="10"
name="description"
column="DESCRIPTION"
jdbc-type="LONGVARCHAR"
/>

<!--
COLUMN STATUS
..............................................

-->
<field-descriptor id="11"
name="status"
column="STATUS"
jdbc-type="DECIMAL"
/>

<!--
COLUMN STATUSLASTDATE
..............................................

-->
<field-descriptor id="12"
name="statuslastdate"
column="STATUSLASTDATE"
jdbc-type="TIMESTAMP"
/>

</class-descriptor>

<!--
==============================================================
            TABLE c_groupitemmap
==============================================================

-->
<class-descriptor
class="com.criticalsoftware.vodafone.pmsloaderadmin.vo.CGroupitemmap"
table="c_groupitemmap"
>
<!--
COLUMN ITEMDBID
..............................................

-->
<field-descriptor id="1"
name="itemdbid"
column="ITEMDBID"
jdbc-type="DECIMAL"
nullable="false" />

<!--
COLUMN GROUPID
..............................................

-->
<field-descriptor id="2"
name="groupid"
column="GROUPID"
jdbc-type="DECIMAL"
nullable="false" />

<!--
COLUMN EXPRESSION
..............................................

-->
<field-descriptor id="3"
name="expression"
column="EXPRESSION"
jdbc-type="LONGVARCHAR"
/>

<!--
COLUMN DEFAULTVALUE
..............................................

-->
<field-descriptor id="4"
name="defaultvalue"
column="DEFAULTVALUE"
jdbc-type="DECIMAL"
/>

<!--
COLUMN MAPTYPE
..............................................

-->
<field-descriptor id="5"
name="maptype"
column="MAPTYPE"
jdbc-type="CHAR"
/>

<!--
COLUMN STATUS
..............................................

-->
<field-descriptor id="6"
name="status"
column="STATUS"
jdbc-type="DECIMAL"
/>

<!--
COLUMN STATUSLASTDATE
..............................................

-->
<field-descriptor id="7"
name="statuslastdate"
column="STATUSLASTDATE"
jdbc-type="TIMESTAMP"
/>

<!--
COLUMN MAPPING
..............................................

-->
<field-descriptor id="8"
name="mapping"
column="MAPPING"
jdbc-type="LONGVARCHAR"
/>

</class-descriptor>

<!--
==============================================================
            TABLE c_integration
==============================================================

-->
<class-descriptor
class="com.criticalsoftware.vodafone.pmsloaderadmin.vo.CIntegration"
table="c_integration"
>
<!--
COLUMN integrationid
..............................................

-->
<field-descriptor id="1"
name="integrationid"
column="integrationid"
jdbc-type="DECIMAL"
nullable="false" primarykey="true" />

<!--
COLUMN intname
..............................................

-->
<field-descriptor id="2"
name="intname"
column="intname"
jdbc-type="VARCHAR"
nullable="false" />

<!--
COLUMN intype
..............................................

-->
<field-descriptor id="3"
name="intype"
column="intype"
jdbc-type="VARCHAR"
nullable="false" />

<!--
COLUMN domain
..............................................

-->
<field-descriptor id="4"
name="domain"
column="domain"
jdbc-type="VARCHAR"
/>

<!--
COLUMN supportedby
..............................................

-->
<field-descriptor id="5"
name="supportedby"
column="supportedby"
jdbc-type="VARCHAR"
/>

<!--
COLUMN description
..............................................

-->
<field-descriptor id="6"
name="description"
column="description"
jdbc-type="VARCHAR"
/>

<!--
COLUMN homedirectory
..............................................

-->
<field-descriptor id="7"
name="homedirectory"
column="homedirectory"
jdbc-type="VARCHAR"
/>

<!--
COLUMN owners
..............................................

-->
<field-descriptor id="8"
name="owners"
column="owners"
jdbc-type="VARCHAR"
/>

<!--
COLUMN mailinglist
..............................................

-->
<field-descriptor id="9"
name="mailinglist"
column="mailinglist"
jdbc-type="VARCHAR"
/>

<!--
COLUMN intgroup
..............................................

-->
<field-descriptor id="10"
name="intgroup"
column="intgroup"
jdbc-type="VARCHAR"
/>

<!--
COLUMN status
..............................................

-->
<field-descriptor id="11"
name="status"
column="status"
jdbc-type="DECIMAL"
nullable="false" />

<!--
COLUMN statuslastdate
..............................................

-->
<field-descriptor id="12"
name="statuslastdate"
column="statuslastdate"
jdbc-type="DATE"
nullable="false" />

</class-descriptor>

<!--
==============================================================
            TABLE c_loader
==============================================================

-->
<class-descriptor
class="com.criticalsoftware.vodafone.pmsloaderadmin.vo.CLoader"
table="c_loader"
>
<!--
COLUMN LOADERID
..............................................

-->
<field-descriptor id="1"
name="loaderid"
column="LOADERID"
jdbc-type="DECIMAL"
nullable="false" primarykey="true" />

<!--
COLUMN INTEGRATIONID
..............................................

-->
<field-descriptor id="2"
name="integrationid"
column="INTEGRATIONID"
jdbc-type="DECIMAL"
nullable="false" />

<!--
COLUMN DESCRIPTION
..............................................

-->
<field-descriptor id="3"
name="description"
column="DESCRIPTION"
jdbc-type="VARCHAR"
/>

<!--
COLUMN FREQUENCY
..............................................

-->
<field-descriptor id="4"
name="frequency"
column="FREQUENCY"
jdbc-type="VARCHAR"
/>

<!--
COLUMN EXECUTE
..............................................

-->
<field-descriptor id="5"
name="execute"
column="EXECUTE"
jdbc-type="LONGVARCHAR"
/>

<!--
COLUMN LOADERDIR
..............................................

-->
<field-descriptor id="6"
name="loaderdir"
column="LOADERDIR"
jdbc-type="LONGVARCHAR"
/>

<!--
COLUMN LOGLEVEL
..............................................

-->
<field-descriptor id="7"
name="loglevel"
column="LOGLEVEL"
jdbc-type="DECIMAL"
/>

<!--
COLUMN LOGFILE
..............................................

-->
<field-descriptor id="8"
name="logfile"
column="LOGFILE"
jdbc-type="VARCHAR"
/>

<!--
COLUMN ACTIVE
..............................................

-->
<field-descriptor id="9"
name="active"
column="ACTIVE"
jdbc-type="DECIMAL"
/>

</class-descriptor>


------------------------------------------------------------------------



<!--
==============================================================
            TABLE c_group
==============================================================

-->
<class-descriptor
class="com.criticalsoftware.vodafone.pmsloaderadmin.vo.CGroup"
table="c_group"
>
<!--
COLUMN GROUPID
..............................................

-->
<field-descriptor id="1"
name="groupid"
column="GROUPID"
jdbc-type="DECIMAL"
nullable="false" primarykey="true" />

<!--
COLUMN INTEGRATIONID
..............................................

-->
<field-descriptor id="2"
name="integrationid"
column="INTEGRATIONID"
jdbc-type="DECIMAL"
nullable="false" />

<!--
COLUMN GROUPNAME
..............................................

-->
<field-descriptor id="3"
name="groupname"
column="GROUPNAME"
jdbc-type="VARCHAR"
/>

<!--
COLUMN RELEASE
..............................................

-->
<field-descriptor id="4"
name="release"
column="RELEASE"
jdbc-type="VARCHAR"
/>

<!--
COLUMN LONGNAME
..............................................

-->
<field-descriptor id="5"
name="longname"
column="LONGNAME"
jdbc-type="VARCHAR"
/>

<!--
COLUMN GROUPDBID
..............................................

-->
<field-descriptor id="6"
name="groupdbid"
column="GROUPDBID"
jdbc-type="DECIMAL"
nullable="false" />

<!--
COLUMN POS_PROCEDURE
..............................................

-->
<field-descriptor id="7"
name="posProcedure"
column="POS_PROCEDURE"
jdbc-type="VARCHAR"
/>

<!--
COLUMN VAL_PROCEDURE
..............................................

-->
<field-descriptor id="8"
name="valProcedure"
column="VAL_PROCEDURE"
jdbc-type="VARCHAR"
/>

<!--
COLUMN STATUS
..............................................

-->
<field-descriptor id="9"
name="status"
column="STATUS"
jdbc-type="DECIMAL"
/>

<!--
COLUMN STATUSLASTDATE
..............................................

-->
<field-descriptor id="10"
name="statuslastdate"
column="STATUSLASTDATE"
jdbc-type="TIMESTAMP"
/>

</class-descriptor>

<!--
==============================================================
            TABLE c_groupitemdb
==============================================================

-->
<class-descriptor
class="com.criticalsoftware.vodafone.pmsloaderadmin.vo.CGroupitemdb"
table="c_groupitemdb"
>
<!--
COLUMN ITEMDBID
..............................................

-->
<field-descriptor id="1"
name="itemdbid"
column="ITEMDBID"
jdbc-type="DECIMAL"
nullable="false" primarykey="true" />

<!--
COLUMN GROUPDBID
..............................................

-->
<field-descriptor id="2"
name="groupdbid"
column="GROUPDBID"
jdbc-type="DECIMAL"
nullable="false" />

<!--
COLUMN ITEMNAME
..............................................

-->
<field-descriptor id="3"
name="itemname"
column="ITEMNAME"
jdbc-type="VARCHAR"
/>

<!--
COLUMN LONGNAME
..............................................

-->
<field-descriptor id="4"
name="longname"
column="LONGNAME"
jdbc-type="VARCHAR"
/>

<!--
COLUMN ITEMUNIT
..............................................

-->
<field-descriptor id="5"
name="itemunit"
column="ITEMUNIT"
jdbc-type="VARCHAR"
/>

<!--
COLUMN ITEMTYPE
..............................................

-->
<field-descriptor id="6"
name="itemtype"
column="ITEMTYPE"
jdbc-type="CHAR"
/>

<!--
COLUMN ITEMDATATYPE
..............................................

-->
<field-descriptor id="7"
name="itemdatatype"
column="ITEMDATATYPE"
jdbc-type="VARCHAR"
/>

<!--
COLUMN ITEMKEY
..............................................

-->
<field-descriptor id="8"
name="itemkey"
column="ITEMKEY"
jdbc-type="DECIMAL"
/>

<!--
COLUMN ITEMORDER
..............................................

-->
<field-descriptor id="9"
name="itemorder"
column="ITEMORDER"
jdbc-type="DECIMAL"
/>

<!--
COLUMN DESCRIPTION
..............................................

-->
<field-descriptor id="10"
name="description"
column="DESCRIPTION"
jdbc-type="LONGVARCHAR"
/>

<!--
COLUMN STATUS
..............................................

-->
<field-descriptor id="11"
name="status"
column="STATUS"
jdbc-type="DECIMAL"
/>

<!--
COLUMN STATUSLASTDATE
..............................................

-->
<field-descriptor id="12"
name="statuslastdate"
column="STATUSLASTDATE"
jdbc-type="TIMESTAMP"
/>

</class-descriptor>

<!--
==============================================================
            TABLE c_groupitemmap
==============================================================

-->
<class-descriptor
class="com.criticalsoftware.vodafone.pmsloaderadmin.vo.CGroupitemmap"
table="c_groupitemmap"
>
<!--
COLUMN ITEMDBID
..............................................

-->
<field-descriptor id="1"
name="itemdbid"
column="ITEMDBID"
jdbc-type="DECIMAL"
nullable="false" />

<!--
COLUMN GROUPID
..............................................

-->
<field-descriptor id="2"
name="groupid"
column="GROUPID"
jdbc-type="DECIMAL"
nullable="false" />

<!--
COLUMN EXPRESSION
..............................................

-->
<field-descriptor id="3"
name="expression"
column="EXPRESSION"
jdbc-type="LONGVARCHAR"
/>

<!--
COLUMN DEFAULTVALUE
..............................................

-->
<field-descriptor id="4"
name="defaultvalue"
column="DEFAULTVALUE"
jdbc-type="DECIMAL"
/>

<!--
COLUMN MAPTYPE
..............................................

-->
<field-descriptor id="5"
name="maptype"
column="MAPTYPE"
jdbc-type="CHAR"
/>

<!--
COLUMN STATUS
..............................................

-->
<field-descriptor id="6"
name="status"
column="STATUS"
jdbc-type="DECIMAL"
/>

<!--
COLUMN STATUSLASTDATE
..............................................

-->
<field-descriptor id="7"
name="statuslastdate"
column="STATUSLASTDATE"
jdbc-type="TIMESTAMP"
/>

<!--
COLUMN MAPPING
..............................................

-->
<field-descriptor id="8"
name="mapping"
column="MAPPING"
jdbc-type="LONGVARCHAR"
/>

</class-descriptor>

<!--
==============================================================
            TABLE c_integration
==============================================================

-->
<class-descriptor
class="com.criticalsoftware.vodafone.pmsloaderadmin.vo.CIntegration"
table="c_integration"
>
<!--
COLUMN integrationid
..............................................

-->
<field-descriptor id="1"
name="integrationid"
column="integrationid"
jdbc-type="DECIMAL"
nullable="false" primarykey="true" />

<!--
COLUMN intname
..............................................

-->
<field-descriptor id="2"
name="intname"
column="intname"
jdbc-type="VARCHAR"
nullable="false" />

<!--
COLUMN intype
..............................................

-->
<field-descriptor id="3"
name="intype"
column="intype"
jdbc-type="VARCHAR"
nullable="false" />

<!--
COLUMN domain
..............................................

-->
<field-descriptor id="4"
name="domain"
column="domain"
jdbc-type="VARCHAR"
/>

<!--
COLUMN supportedby
..............................................

-->
<field-descriptor id="5"
name="supportedby"
column="supportedby"
jdbc-type="VARCHAR"
/>

<!--
COLUMN description
..............................................

-->
<field-descriptor id="6"
name="description"
column="description"
jdbc-type="VARCHAR"
/>

<!--
COLUMN homedirectory
..............................................

-->
<field-descriptor id="7"
name="homedirectory"
column="homedirectory"
jdbc-type="VARCHAR"
/>

<!--
COLUMN owners
..............................................

-->
<field-descriptor id="8"
name="owners"
column="owners"
jdbc-type="VARCHAR"
/>

<!--
COLUMN mailinglist
..............................................

-->
<field-descriptor id="9"
name="mailinglist"
column="mailinglist"
jdbc-type="VARCHAR"
/>

<!--
COLUMN intgroup
..............................................

-->
<field-descriptor id="10"
name="intgroup"
column="intgroup"
jdbc-type="VARCHAR"
/>

<!--
COLUMN status
..............................................

-->
<field-descriptor id="11"
name="status"
column="status"
jdbc-type="DECIMAL"
nullable="false" />

<!--
COLUMN statuslastdate
..............................................

-->
<field-descriptor id="12"
name="statuslastdate"
column="statuslastdate"
jdbc-type="DATE"
nullable="false" />

</class-descriptor>

<!--
==============================================================
            TABLE c_loader
==============================================================

-->
<class-descriptor
class="com.criticalsoftware.vodafone.pmsloaderadmin.vo.CLoader"
table="c_loader"
>
<!--
COLUMN LOADERID
..............................................

-->
<field-descriptor id="1"
name="loaderid"
column="LOADERID"
jdbc-type="DECIMAL"
nullable="false" primarykey="true" />

<!--
COLUMN INTEGRATIONID
..............................................

-->
<field-descriptor id="2"
name="integrationid"
column="INTEGRATIONID"
jdbc-type="DECIMAL"
nullable="false" />

<!--
COLUMN DESCRIPTION
..............................................

-->
<field-descriptor id="3"
name="description"
column="DESCRIPTION"
jdbc-type="VARCHAR"
/>

<!--
COLUMN FREQUENCY
..............................................

-->
<field-descriptor id="4"
name="frequency"
column="FREQUENCY"
jdbc-type="VARCHAR"
/>

<!--
COLUMN EXECUTE
..............................................

-->
<field-descriptor id="5"
name="execute"
column="EXECUTE"
jdbc-type="LONGVARCHAR"
/>

<!--
COLUMN LOADERDIR
..............................................

-->
<field-descriptor id="6"
name="loaderdir"
column="LOADERDIR"
jdbc-type="LONGVARCHAR"
/>

<!--
COLUMN LOGLEVEL
..............................................

-->
<field-descriptor id="7"
name="loglevel"
column="LOGLEVEL"
jdbc-type="DECIMAL"
/>

<!--
COLUMN LOGFILE
..............................................

-->
<field-descriptor id="8"
name="logfile"
column="LOGFILE"
jdbc-type="VARCHAR"
/>

<!--
COLUMN ACTIVE
..............................................

-->
<field-descriptor id="9"
name="active"
column="ACTIVE"
jdbc-type="DECIMAL"
/>

</class-descriptor>



------------------------------------------------------------------------

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to