db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Andras Balogh <and...@reea.net>
Subject Re: IdBroker, Native and MSSQL
Date Tue, 20 Dec 2005 15:16:57 GMT
Hello,

    So you have in your schema like this:
<database name="your_db" defaultIdMethod="native">
?
Which version of Torque are You using?
Also you have in torque.properties:
torque.database.your_db.adapter=mssql
?

Best regards,
Andras.

Trey Long wrote:

> Yes, everything seems correct from my end. Here is a bit of my schema:
>
>>     <table name="underwritingApp">
>>         <column name="underwriterId" primaryKey="true" 
>> required="true" type="INTEGER" autoIncrement="true"/>
>>         <column name="companyId" type="INTEGER"/>
>>         <foreign-key foreignTable="company">
>>             <reference foreign="companyId" local="companyId"/>
>>         </foreign-key>
>>     </table>
>
> It seems that if defaultIdMethod="native" then torque shouldn't 
> attempt to insert fields like underwriterId. The only reason that I 
> have not to use the id-broker is because torque may not be the only 
> thing making inserts into the database.
>
> What I will probably end up doing is changing the id-broker increments 
> to mismatch the DB's autoenerated keys, *IF* I can get torque to 
> insert into that column, which is unlikely.
>
> -Jim
>


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


Mime
View raw message