Mailing-List: contact torque-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Apache Torque Users List" <torque-user@db.apache.org>
Received-SPF: pass (asf.osuosl.org: local policy)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
  s=s1024; d=yahoo.com;
  h=Message-ID:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding;
  b=320SOV9En4n93S4W5AE12gVy17NkENKuCaVMcyu4GihJ14snWNxMRJL7+PDu5VTt++HuP9bb9JL0yUBRjO4io76wKoJZh7Tp46y0PQBm8zJ0GTbhN8xxFhvg6GseXBYWaN8KppASzkAyvLA4OVgEQYSR1cYmSQq/FQ35daI6do8=
  ;
Message-ID: <20061018184618.8553.qmail@web32707.mail.mud.yahoo.com>
Date: Wed, 18 Oct 2006 11:46:18 -0700 (PDT)
From: Joseph Amaya <joecool_30340@yahoo.com>
Subject: Re: MSSQL Insert Problem
To: torque-user@db.apache.org
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

Hello,

1. My procedure is to run the jdbc Ant task
2. Then I change my schema to autoIncrement="true" for
my Identity table, it already has primayKey="true"
3. Then I run the default task for build-torque
4. I don't set my identity column in my program, but
when I attempt to save I get the TorqueException

"Cannot insert explicit value for identity column in
table 'CONTACTS' when IDENTITY_INSERT is set to OFF."

Andaras Says:

    I have used torque with mssql successfully.
What is not clear to me why you want to insert in the
identity column.
Did you declare the column in the schema as
primaryKey="true" 
autoIncrement="true" ?
If yes than Torque should do the insert into your
CONTACTS table 
correctly and even read the new value
of the column after insert.

Best regards,
Andras.


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

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