I can pretty much assure you that the tutorial was correct at one point (I wrote it). Things may have changed since I wrote it, let me take a look at whats different in the default Torque distribution these days and I'll update it to reflect any changes (thanks for documenting the differences that you found).
In the meantime, if you are not able to get the application to work, feel free to send me your database scheme file, build properties, and your Torque run-time config. I'll test it to see if I can get it to work and post back the results to the list for those interested. Thanks! Pete On Fri, Mar 01, 2002 at 10:02:45AM -0500, Kevin Cottrell wrote: > I am a new user of Torque and have spent the last couple of days trying > to work my way through the tutorial. By following it exactly, I cannot > get very far. I can almost make it work, by doing by hand things the > tutorial claims are automatic, but am still getting an exception at > run-time - I assume due to the number of other problems I am having. I > would love to know if anyone has successfully completed the tutorial as > written to maybe get an idea what I am doing wrong. In the meantime, I > am submitting a list of problems that I had - hopefully to get some > insight into what is happening. > > I am using mysql as a database. > > Step 1: Obtaining the Torque Distribution > - I have gone through the tutorial, from scratch, with the 2.1 and > the 3.0a5 binaries with similar results. > > Step 2: Configuring Torque > Build Properties > "createDatabaseUrl" is listed as a setting in the > build.properties file that should be set to > "jdbc:mysql://127.0.0.1/mysql". > This setting is not in the delivered build.properties file and > is not referenced or documented in the build.properties file. > I added it to my build.properties file. > > Torque Database Schema > The tutorial implies that two files live in the torque/schema > directory: id-table-schema.xml and project-schema.xml. The > project-schema.xml file is the only one delivered in the distribution. > I created the id-table-schema.xml file and populated it as described, > but had several problems with it later. > > When I tried to validate the two schema xml files against > http://jakarta.apache.org/turbine/dtd/database.dtd I got failure on the > "description" tag. I copied the dtd to my machine and changed the path > in the xml file and it validated perfectly. I'm sure this is my problem > but I haven't tracked it down yet. > > Torque Run-Time Properties > The tutorial claims that there is a sample run-time properties > file (Torque.properties) in the torque/schema directory - there isn't. > I created one as described in the tutorial. > > Step 3: Invoking torque > Generating the Object Model and Associated SQL > The tutorial claims that when Ant is run it will pick up all > files in the torque/schema directory that end with -schema.xml and parse > them - this did not hold true for me. I had to run Ant twice and change > the project name in the build.properties file to match the schema name > (this is how it is documented in the build.properties file but not in > the tutorial. > > After Ant ran, the sql generated did not contain sql to create > the database. All of the table sql was there and correct. > > Creating the Database and Tables > The tutorial says to run "ant project-create-db" to create the > database and "ant project-insert-sql" to build tables. > These commands returned "Target 'project-create-db' does not > exist in this project." and "Target 'project-insert-sql' does not exist > in this project." > I created the database by hand and ran the sql by hand to > generate the database and tables. > > Compiling and Running > When I tried to compile the .java files generated by Torque, I > received a compile error because the id_table contained a column named > "TABLE_NAME" which conflicted with an internal variable also called > "TABLE_NAME". > Also, I could not get the sample program, Bookstore.java, to > compile because it would not accept the "Torque.properties" parameter to > Torque.init(). I removed "Torque.properties" from Torque.init() but now > when it runs (until it crashes) it doesn't pick up the settings in the > "Torque.properties" file (obviously ;) ). > > I get the feeling I am using out of date binaries but I can't find any > that are newer. I have been reluctant to build from source but may try > that next. > > Thanks, > > Kevin Cottrell > > > -- > To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> > For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> > -- Peter Kazmier http://www.kazmier.com PGP Fingerprint 4FE7 8DA3 D0B5 9CAA 69DC 7243 1855 BC2E 4B43 5654 -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
