Return-Path: 
 <torque-user-return-7010-apmail-db-torque-user-archive=db.apache.org@db.apache.org>
Delivered-To: apmail-db-torque-user-archive@www.apache.org
Received: (qmail 27166 invoked from network); 18 May 2006 10:47:30 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur.apache.org with SMTP; 18 May 2006 10:47:30 -0000
Received: (qmail 96420 invoked by uid 500); 18 May 2006 10:47:29 -0000
Delivered-To: apmail-db-torque-user-archive@db.apache.org
Received: (qmail 96393 invoked by uid 500); 18 May 2006 10:47:29 -0000
Mailing-List: contact torque-user-help@db.apache.org; run by ezmlm
Precedence: bulk
List-Unsubscribe: <mailto:torque-user-unsubscribe@db.apache.org>
List-Help: <mailto:torque-user-help@db.apache.org>
List-Post: <mailto:torque-user@db.apache.org>
List-Id: "Apache Torque Users List" <torque-user.db.apache.org>
Reply-To: "Apache Torque Users List" <torque-user@db.apache.org>
Delivered-To: mailing list torque-user@db.apache.org
Received: (qmail 96382 invoked by uid 99); 18 May 2006 10:47:29 -0000
Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49)
    by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 18 May 2006 03:47:29 -0700
X-ASF-Spam-Status: No, hits=2.3 required=10.0
	tests=DNS_FROM_RFC_ABUSE,DNS_FROM_RFC_WHOIS,FORGED_YAHOO_RCVD
X-Spam-Check-By: apache.org
Received-SPF: pass (asf.osuosl.org: local policy)
Received: from [206.190.49.15] (HELO web52905.mail.yahoo.com) (206.190.49.15)
    by apache.org (qpsmtpd/0.29) with SMTP; Thu, 18 May 2006 03:47:28 -0700
Received: (qmail 80655 invoked by uid 60001); 18 May 2006 10:47:06 -0000
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
  s=s1024; d=yahoo.com;
  h=Message-ID:Date:From:Reply-To:Subject:To:MIME-Version:Content-Type;
  b=5wXXkZuGgUhXkKXPxmDqYjfQdPpK4Bu7xiiurgmZWZEmhu/pKOHez+vFlQWbRBxVMKzAA/pUKDcd2Brkw1I5l5950ytWk0rbl3mCmtgG7qFTtejuD7KixgxZYw3Ll/x62DQK+ukwhwl1SfaHxSWEaAYxOmrCn98tHL6KDZPtfPM=
  ;
Message-ID: <20060518104706.80653.qmail@web52905.mail.yahoo.com>
Date: Thu, 18 May 2006 03:47:06 -0700 (PDT)
From: Christopher Thill <cthill69@yahoo.com>
Reply-To: Christopher Thill <cthill69@yahoo.com>
Subject: Database insert attempted without anything specified to insert
To: torque-user@db.apache.org
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
X-Virus-Checked: Checked by ClamAV on apache.org
X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N

Hi,

I am using Turbine 2.3.2.  Which I believe uses torque 3.1.1.  I am attempting to add a row to the TurbineUserGroupRole table using the following code.

        int userId = data.getParameters().getInt("userId");
        ugr.setUserId( userId );
        int groupId = data.getParameters().getInt("groupId");
        ugr.setGroupId( groupId );
        int roleId = data.getParameters().getInt("roleId");
        ugr.setRoleId( roleId );
        ugr.save();

When the code executes I get the error "org.apache.torque.TorqueException: Database insert attempted without anything specified to insert".  I am using the standard turbine maven plugin generated turbine-security-schema.xml for the TurbineUserGroupRole table.  The schema is as follows

  <table name="TURBINE_USER_GROUP_ROLE">
    <column name="USER_ID" required="true" primaryKey="true" type="INTEGER"/>
    <column name="GROUP_ID" required="true" primaryKey="true" type="INTEGER"/>
    <column name="ROLE_ID" required="true" primaryKey="true" type="INTEGER"/>

    <foreign-key foreignTable="TURBINE_USER">
      <reference local="USER_ID" foreign="USER_ID"/>
    </foreign-key>

    <foreign-key foreignTable="TURBINE_GROUP">
      <reference local="GROUP_ID" foreign="GROUP_ID"/>
    </foreign-key>

    <foreign-key foreignTable="TURBINE_ROLE">
      <reference local="ROLE_ID" foreign="ROLE_ID"/>
    </foreign-key>
  </table>

Any help or pointers will be appreciated.

Regards,
Chris



---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org