You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@turbine.apache.org by Kevin Cottrell <kc...@triad.rr.com> on 2002/03/01 16:02:45 UTC
Has anyone run the Torque Tutorial end-to-end successfully?
Hi!
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: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
Re: Has anyone run the Torque Tutorial end-to-end successfully?
Posted by Martin Poeschl <mp...@marmot.at>.
Kevin Cottrell wrote:
> Hi!
>
> 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.
the turorial is based on the current version in CVS ...
i'll make available a tdk and torque snapshot later today ...
martin
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
Re: Has anyone run the Torque Tutorial end-to-end successfully?
Posted by Pete Kazmier <pe...@kazmier.com>.
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: <ma...@jakarta.apache.org>
> For additional commands, e-mail: <ma...@jakarta.apache.org>
>
--
Peter Kazmier http://www.kazmier.com
PGP Fingerprint 4FE7 8DA3 D0B5 9CAA 69DC 7243 1855 BC2E 4B43 5654
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>