Thanks! "Paix, Manfred" wrote:
> Hi Dirk, > > your key-generator attribute should be part of the class element and not part of the >field element. Example: > > <class name="ShippingLine" identity="id" key-generator="identity"> > ... > > Best regards > Manfred > > -----Ursprüngliche Nachricht----- > Von: Dirk Kunert [mailto:dirk.kunert@;gmx.net] > Gesendet: Do 17.10.2002 16:43 > An: [EMAIL PROTECTED] > Cc: > Betreff: [castor-dev] problems with castor jdo and ms sql server identity >flag > > > > i am having a problem with castor jdo and ms sql server: > i create a table > shipping_line(int id, name varchar(80)) > and set the identity flag of "id" to "yes". i also create a java class: > pubic class ShippingLine { > private int id; > private String name; > public ShippingLine() {} > public ShippingLine(String name) { this.name = name; } > public setId(int id) { this.id = id; } > public setName(String name) { this.name = name; } > public int getId() { return id; } > public String getName() { return name; } > } > > and a config file > <database name="jdo" engine="sql-server"> > <driver class-name="weblogic.jdbc.mssqlserver4.Driver" > url="jdbc:weblogic:mssqlserver:localhost:1433"> > <param name="user" value="aUser"/> > <param name="password" value="aPassword"/> > </driver> > <mapping> > <class name="ShippingLine" identity="id"> > <map-to table="shipping_line"/> > <field name="id" type="integer" > key-generator="identity"> > <sql name="id" type="integer"/> > </field> > <field name="name" type="string" > required="true"> > <sql name="name" type="string"/> > </field> > </class> > </mapping> > <key-generator name="IDENTITY" alias="identity"/> > </database> > > when i instanciate the shipping line whith > ShippingLine shippingLine = new ShippingLine("myLine"); > and perform > database.create(shippingLine) > within an transaction i get the error > "java.SQL.Exception: Cannot insert explicit value for identity column in > table 'shippin_line' when IDENTITY_INSERT is set OFF. ..." > how can correct this error? > > thank you > > -- > +++ GMX - Mail, Messaging & more http://www.gmx.net +++ > NEU: Mit GMX ins Internet. Rund um die Uhr für 1 ct/ Min. surfen! > > ----------------------------------------------------------- > If you wish to unsubscribe from this mailing, send mail to > [EMAIL PROTECTED] with a subject of: > unsubscribe castor-dev > > > > ----------------------------------------------------------- > If you wish to unsubscribe from this mailing, send mail to > [EMAIL PROTECTED] with a subject of: > unsubscribe castor-dev
begin:vcard n:Hoebel;John tel;pager:303-240-7810 tel;work:303-763-1639/303-541-5049 x-mozilla-html:FALSE adr:;;;;;; version:2.1 email;internet:[EMAIL PROTECTED] fn:John Hoebel end:vcard
