Well, I have tracked the probelem my sqldb.map file had these entries:
bookstore-schema.sql=bookstore bookstore-schema-idtable-init.sql=bookstore id-table-schema.sql=default the TorqueSQLExec task makes sure that *schema.sql files are executed first, to make sure that tables are created before initialization WITHIN A DATABASE! so since the id-table-schema.sql was assigned to default adn the bookstore-schema-idtable-init.sql was assigned to bookstore, and bookstore comes before default...... Problem boils down to not setting the "name" attribute for the database in the id-table-schema.xml - my bad! This is especially embarrasing as it is mentioned specifically in the tutorial to change this. I post this as a "lesson learned" for the next person to make the same mistake! Russell > -----Original Message----- > From: Rick Ross [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, August 28, 2002 10:59 AM > To: Turbine Torque Users List > Subject: Re: problem with bookstore sample > > > Right.. well the hotshots are gonna have to take a look at that. > > ----- Original Message ----- > From: "Russell Smyth" <[EMAIL PROTECTED]> > To: "'Turbine Torque Users List'" > <[EMAIL PROTECTED]> > Sent: Wednesday, August 28, 2002 10:48 AM > Subject: RE: problem with bookstore sample > > > > create-db only creates the database, not the tables. And with my db > (sapdb) > > create-db actually does nothing (the generated sql script is > > all comments, and wouldnt work anyway - sapdb doesnt allow creating > > databases via sql) > > > > insert-sql is where the tables are created. > > > > > -----Original Message----- > > > From: Rick Ross [mailto:[EMAIL PROTECTED]] > > > Sent: Wednesday, August 28, 2002 10:44 AM > > > To: Turbine Torque Users List > > > Subject: Re: problem with bookstore sample > > > > > > > > > You need to run the create-db target first. > > > > > > ----- Original Message ----- > > > From: "Russell Smyth" <[EMAIL PROTECTED]> > > > To: "Turbine-Torque-User (E-mail)" > > > <[EMAIL PROTECTED]> > > > Sent: Wednesday, August 28, 2002 10:41 AM > > > Subject: problem with bookstore sample > > > > > > > > > > I am trying to get the bookstore sample working "as > > > advertised" - I have > > > > gotten it working by hand tweeking or hand running sql, but > > > I would like > > > to > > > > get to the point where all that should be automated is - > > > this is very > > > > relevant for the real project in which we are > considering Torque. > > > > > > > > the problem I am having is when I run > > > > > > > > ant -f build-torque.xml insert-sql > > > > > > > > the id_table population is attempted BEFORE the id_table is > > > created, which > > > > of course fails. > > > > > > > > Is this a known problem? is there a fix/workaround? (other > > > than running > > > the > > > > id_table population seperately. > > > > > > > > -- > > > > To unsubscribe, e-mail: > > > <mailto:[EMAIL PROTECTED]> > > > > For additional commands, e-mail: > > > <mailto:[EMAIL PROTECTED]> > > > > > > > > > > > > > -- > > > To unsubscribe, e-mail: > > > <mailto:[EMAIL PROTECTED]> > > > For additional commands, e-mail: > > > <mailto:[EMAIL PROTECTED]> > > > > > > > -- > > To unsubscribe, e-mail: > <mailto:[EMAIL PROTECTED]> > > For additional commands, e-mail: > <mailto:[EMAIL PROTECTED]> > > > > > > > -- > To unsubscribe, e-mail: > <mailto:[EMAIL PROTECTED]> > For additional commands, e-mail: > <mailto:[EMAIL PROTECTED]> > -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
