RE: MSSQL Insert Problem

2006-10-18 Thread Greg Monroe
-- > From: Joseph Amaya [mailto:[EMAIL PROTECTED] > Sent: Wednesday, October 18, 2006 2:46 PM > To: torque-user@db.apache.org > Subject: Re: MSSQL Insert Problem > > Hello, > > 1. My procedure is to run the jdbc Ant task > 2. Then I change my schema to autoIncrement="

Re: MSSQL Insert Problem

2006-10-18 Thread Joseph Amaya
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 TorqueE

Re: MSSQL Insert problem

2006-10-18 Thread Andras Balogh
Hello, 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 r

MSSQL Insert problem

2006-10-17 Thread Joseph Amaya
I'm getting this error whenever I try to insert into my identity table through my website. Cannot insert explicit value for identity column in table 'CONTACTS' when IDENTITY_INSERT is set to OFF. Supposedly you add: "SET IDENTITY_INSERT ON ... SET IDENTITY_INSERT OFF" around your