Re: problem doing inserts using Criteria and Peer

[Wei He]

Hi Brian,

The tables should be defined with idMethod attribute for each of the 
table you want to use
key generation.

database>
 <table name="RDF" idMethod="native">
   <column name="RDF_ID" required="true" autoIncrement="true"
primaryKey="true" type="INTEGER"/>
   <column name="TITLE" size="255" type="VARCHAR"/>
   <column name="BODY" size="255" type="VARCHAR"/>
   <column name="URL" size="255" type="VARCHAR"/>
   <column name="AUTHOR" size="255" type="VARCHAR"/>
   <column name="DEPT" size="255" type="VARCHAR"/>
 </table>
...
...
</database>
This should solve your problem.

Wei

brian wrote:

Sorry,Here it is:
<!--
==================================================================== -->
<!--
-->
<!-- T U R B I N E  P R O J E C T  S C H E M A
-->
<!--
-->
<!--
==================================================================== -->
<!-- This is an example Turbine project schema.
-->
<!--
==================================================================== -->
<database>
 <table name="RDF">
   <column name="RDF_ID" required="true" autoIncrement="true"
primaryKey="true" type="INTEGER"/>
   <column name="TITLE" size="255" type="VARCHAR"/>
   <column name="BODY" size="255" type="VARCHAR"/>
   <column name="URL" size="255" type="VARCHAR"/>
   <column name="AUTHOR" size="255" type="VARCHAR"/>
   <column name="DEPT" size="255" type="VARCHAR"/>
 </table>
 <table name="event">
   <column name="evnt_id" required="true" autoIncrement="true"
primaryKey="true" type="INTEGER"/>
   <column name="evnt_wrkq_id" size="255" type="INTEGER"/>
   <column name="evnt_evty_id" size="255" type="INTEGER"/>
   <column name="evnt_loan_id" size="255" type="INTEGER"/>
   <column name="evnt_wkfl_id" size="255" type="INTEGER"/>
 </table>
 <table name="event_type">
   <column name="evty_id" required="true" autoIncrement="false"
primaryKey="true" type="INTEGER"/>
   <column name="evty_desc" size="255" type="VARCHAR"/>
 </table>
 <table name="workflow">
   <column name="wkfl_id" required="true" autoIncrement="false"
primaryKey="true" type="INTEGER"/>
   <column name="wkfl_status" size="255" type="INTEGER"/>
   <column name="wkfl_wftp_id" size="255" type="INTEGER"/>
   <column name="wkfl_loan_id" size="255" type="INTEGER"/>
   <column name="wkfl_evnt_id" size="255" type="INTEGER"/>
 </table>
 <table name="workque">
   <column name="wrkq_id" required="true" autoIncrement="false"
primaryKey="true" type="INTEGER"/>
   <column name="wrkq_wkgp_id" size="255" type="INTEGER"/>
   <column name="wrkq_wrkr_id" size="255" type="INTEGER"/>
 </table>
 <table name="worker">
   <column name="wrkr_id" required="true" autoIncrement="false"
primaryKey="true" type="INTEGER"/>
   <column name="wrkr_desc" size="255" type="VARCHAR"/>
 </table>
 <table name="workgroup">
   <column name="wkgp_id" required="true" autoIncrement="false"
primaryKey="true" type="INTEGER"/>
   <column name="wkgp_desc" size="255" type="VARCHAR"/>
 </table>
 <table name="task">
   <column name="task_id" required="true" autoIncrement="false"
primaryKey="true" type="INTEGER"/>
   <column name="task_tktp_id" size="255" type="INTEGER"/>
   <column name="task_wrkq_id" size="255" type="INTEGER"/>
   <column name="task_wkfl_id" size="255" type="INTEGER"/>
        <column name="task_evnt_id" size="255" type="INTEGER"/>
        <column name="task_status" size="255" type="VARCHAR"/>
 </table>
 <table name="task_type">
   <column name="tktp_id" required="true" autoIncrement="false"
primaryKey="true" type="INTEGER"/>
   <column name="tktp_desc" size="255" type="VARCHAR"/>
   <column name="tktp_wkgp_id" size="255" type="INTEGER"/>
   <column name="tktp_wftp_id" size="255" type="INTEGER"/>
 </table>
 <table name="workflow_type">
   <column name="wftp_id" required="true" autoIncrement="false"
primaryKey="true" type="INTEGER"/>
   <column name="wftp_desc" size="255" type="VARCHAR"/>
 </table>
 <table name="loan">
   <column name="loan_id" required="true" autoIncrement="false"
primaryKey="true" type="INTEGER"/>
   <column name="loan_lntp_id" size="255" type="INTEGER"/>
   <column name="loan_evnt_id" size="255" type="INTEGER"/>
 </table>
 <table name="loan_type">
   <column name="lntp_id" required="true" autoIncrement="false"
primaryKey="true" type="INTEGER"/>
   <column name="lntp_desc" size="255" type="VARCHAR"/>
 </table>
</database>
-----Original Message-----
From: Scott Eade [mailto:[EMAIL PROTECTED] 
Sent: Friday, September 19, 2003 11:31 PM
To: Turbine Users List
Subject: Re: problem doing inserts using Criteria and Peer

brian wrote:

 

Here is my schema:
#
-----------------------------------------------------------------------
# RDF
#
-----------------------------------------------------------------------
drop table if exists RDF;
CREATE TABLE RDF
(
  RDF_ID INTEGER NOT NULL AUTO_INCREMENT,
  TITLE VARCHAR (255),
  BODY VARCHAR (255),
  URL VARCHAR (255),
  AUTHOR VARCHAR (255),
  DEPT VARCHAR (255),
  PRIMARY KEY(RDF_ID)
);
   

I meant your xml schema file - this is where the ID method is defined.

Scott

 



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