Hi,

I corrected those errors. And I was unable to work with Torque 3.1 to I
downloaded and tried 3.0.

Now I am able to run ant -f build-torque.xml 
And it says "BUILD SUCCESSFUL'

It generates the stuff in the sql folder. But it doesn't generate any java
source in the java folder under src. Under the java folder I only get an
empty file name report.pitchers.om.generation.

Also I'm able to create my mysql database by running ant -f build-torque.xml
create-db.

But I can't get the java classes in src\java . 
Any ideas ?

Thanks


Vikas

-----Original Message-----
From: Cloves Carneiro Jr. [mailto:[EMAIL PROTECTED] 
Sent: Thursday, November 13, 2003 11:34 AM
To: Apache Torque Users List
Subject: RE: newbie's questions help pls

Hi Vikas,

You twice set ";INTEGER" as a type in your XML:

<column name="OUTS_RECORDED" required="true" type=";INTEGER"/>
<column name="STRIKE_OUTS" type=";INTEGER"/>

This might be causing an error.


Cloves Carneiro Jr

-----Original Message-----
From: Vikas Phonsa [mailto:[EMAIL PROTECTED]
Sent: Thursday, November 13, 2003 2:09 PM
To: 'Apache Torque Users List'
Subject: RE: newbie's questions help pls


Thanks for ur reply.

I made the schema manually. Infact just copied from a tutorial. I don't know
yet how to generate it my torque. And what I understand from a schema is the
database schema definition in id-project-schema.xml and I'm including it
below. When we say schema in torque, is that what we are referring or is
there something else also.

I downloaded two zip files torque-3.1.zip and torque-gen-3.1.zip from torque
download site.

But the tutorials that I found on the site and the article specified on
torque website don't refer to these two different entities.

So they all are probably referring to an older version of torque. And then
names of the atleast some files in 3.1 are different than mentioned in those
tutorials at some places.

So should I go back and just use an older version only? I mean what is
recommended.

Here is the schema:


<?xml version="1.0" encoding="ISO-8859-1" standalone="no" ?>
<!DOCTYPE database SYSTEM 
          "http://jakarta.apache.org/turbine/dtd/database.dtd";>

<!-- ====================================================================
-->
<!--
-->
<!-- I D  B R O K E R  S C H E M A
-->
<!--
-->
<!-- ====================================================================
-->
<!-- This is the XML schema use by Torque to generate the SQL for
-->
<!-- ID_TABLE table used by the id broker mechanism in Torque.
-->
<!-- ====================================================================
-->
<!-- @author: <a href="mailto:[EMAIL PROTECTED]">Jason van Zyl</a>
-->
<!-- @version $Id: id-table-schema.xml,v 1.2 2003/07/24 12:40:41 mpoeschl
Exp $ -->
<!-- ====================================================================
-->

<database name="pitchers" defaultIdMethod="native"> 

 <table name="PITCHER">
<column name="PITCHER_ID" required="true" autoIncrement="true"
        primaryKey="true" type="INTEGER"/>
<column name="LAST_NAME" required="true" size="30" type="VARCHAR"/>
<column name="FIRST_NAME" required="true" size="30" type="VARCHAR"/>
<column name="TEAM_ID" required="true" type="INTEGER"/>
<foreign-key foreignTable="TEAM">
<reference local="TEAM_ID" foreign="TEAM_ID"/>
</foreign-key>
</table>

  <table name="TEAM" idMethod="none">
<column name="TEAM_ID" required="true" primaryKey="true"
        type="INTEGER"/>
<column name="TEAM_NAME" required="true" size="30" type="VARCHAR"/>
</table>



<table name="GAME" idMethod="none">
<column name="PITCHER_ID" required="true" type="INTEGER"/>
<column name="PLAYING_FOR" required="true" type="INTEGER"/>
<column name="AGAINST_TEAM" required="true" type="INTEGER"/>
<column name="OUTS_RECORDED" required="true" type=";INTEGER"/>
<column name="HITS" type="INTEGER"/>
<column name="RUNS" type="INTEGER"/>
<column name="WALKS" type="INTEGER"/>
<column name="STRIKE_OUTS" type=";INTEGER"/>
<foreign-key foreignTable="PITCHER">
<reference local="PITCHER_ID" foreign="PITCHER_ID"/>
</foreign-key>
<foreign-key foreignTable="TEAM">
<reference local="PLAYING_FOR" foreign="TEAM_ID"/>
</foreign-key>
<foreign-key foreignTable="TEAM">
<reference local="AGAINST_TEAM" foreign="TEAM_ID"/>
</foreign-key>
</table>



</database>



-----Original Message-----
From: Ramesh Sabeti [mailto:[EMAIL PROTECTED] 
Sent: Thursday, November 13, 2003 11:01 AM
To: 'Apache Torque Users List'
Subject: RE: newbie's questions help pls

How did you come up with the schema?  Manually or generated by Torque?  

> -----Original Message-----
> From: Vikas Phonsa [mailto:[EMAIL PROTECTED]
> Sent: Thursday, November 13, 2003 10:26 AM
> To: 'Apache Torque Users List'
> Subject: RE: newbie's questions help pls
> 
> Yeah I have a schema definition. And now when I run ant ant -f
> build-torque.xml
> 
> I get the following exception:
> 
> I was following the instructions given in an article given on Torque
site.
> 
> Come on guys, is there no place where someone can learn to use the
Torque
> 3.1
> 
> All tutorials and even that article
> (http://www.developer.com/java/article.php/10922_1457081_2) refers to
> earlier versions of torque
> 
> 
> 
> BUILD FAILED
> file:C:/Downloads/TorqueGen/torque-gen-3.1/build-torque.xml:207:
Exception
> thrown by 'generator.parse'. For more information consult the velocity
> log,
> or invoke ant with the -debug flag.
>       at
> org.apache.velocity.texen.ant.TexenTask.execute(TexenTask.java:564)
>       at org.apache.tools.ant.Task.perform(Task.java:341)
>       at org.apache.tools.ant.Target.execute(Target.java:309)
>       at org.apache.tools.ant.Target.performTasks(Target.java:336)
>       at org.apache.tools.ant.Project.executeTarget(Project.java:1339)
>       at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:397)
>       at
> org.apache.tools.ant.taskdefs.CallTarget.execute(CallTarget.java:143)
>       at org.apache.tools.ant.Task.perform(Task.java:341)
>       at org.apache.tools.ant.Target.execute(Target.java:309)
>       at org.apache.tools.ant.Target.performTasks(Target.java:336)
>       at org.apache.tools.ant.Project.executeTarget(Project.java:1339)
>       at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:397)
>       at
> org.apache.tools.ant.taskdefs.CallTarget.execute(CallTarget.java:143)
>       at org.apache.tools.ant.Task.perform(Task.java:341)
>       at org.apache.tools.ant.Target.execute(Target.java:309)
>       at org.apache.tools.ant.Target.performTasks(Target.java:336)
>       at org.apache.tools.ant.Project.executeTarget(Project.java:1339)
>       at
org.apache.tools.ant.Project.executeTargets(Project.java:1255)
>       at org.apache.tools.ant.Main.runBuild(Main.java:609)
>       at org.apache.tools.ant.Main.start(Main.java:196)
>       at org.apache.tools.ant.Main.main(Main.java:235)
> Caused by: org.apache.velocity.exception.MethodInvocationException:
> Invocation of method 'parse' in  class
org.apache.velocity.texen.Generator
> threw exception class
> org.apache.velocity.exception.MethodInvocationException : Invocation
of
> method 'get' in  class java.util.Properties threw exception class
> java.lang.NullPointerException : null
>       at
>
org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java
:3
> 09
> )
>       at
>
org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReferenc
e.
> ja
> va:207)
>       at
>
org.apache.velocity.runtime.parser.node.ASTReference.value(ASTReference.
ja
> va
> :357)
>       at
>
org.apache.velocity.runtime.parser.node.ASTSetDirective.render(ASTSetDir
ec
> ti
> ve.java:135)
>       at
>
org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.jav
a:
> 27
> 1)
>       at org.apache.velocity.Template.merge(Template.java:296)
>       at org.apache.velocity.texen.Generator.parse(Generator.java:425)
>       at org.apache.velocity.texen.Generator.parse(Generator.java:361)
>       at sun.reflect.GeneratedMethodAccessor18.invoke(Unknown Source)
>       at
>
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor
Im
> pl
> .java:25)
>       at java.lang.reflect.Method.invoke(Method.java:324)
>       at
>
org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java
:2
> 60
> )
>       at
>
org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReferenc
e.
> ja
> va:207)
>       at
>
org.apache.velocity.runtime.parser.node.ASTReference.render(ASTReference
.j
> av
> a:250)
>       at
>
org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:94
)
>       at
>
org.apache.velocity.runtime.parser.node.ASTIfStatement.render(ASTIfState
me
> nt
> .java:109)
>       at
>
org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:94
)
>       at
> org.apache.velocity.runtime.directive.Foreach.render(Foreach.java:344)
>       at
>
org.apache.velocity.runtime.parser.node.ASTDirective.render(ASTDirective
.j
> av
> a:153)
>       at
>
org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:94
)
>       at
> org.apache.velocity.runtime.directive.Foreach.render(Foreach.java:344)
>       at
>
org.apache.velocity.runtime.parser.node.ASTDirective.render(ASTDirective
.j
> av
> a:153)
>       at
>
org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.jav
a:
> 27
> 1)
>       at org.apache.velocity.Template.merge(Template.java:296)
>       at org.apache.velocity.texen.Generator.parse(Generator.java:451)
>       at
> org.apache.velocity.texen.ant.TexenTask.execute(TexenTask.java:552)
>       ... 20 more
> --- Nested Exception ---
> org.apache.velocity.exception.MethodInvocationException: Invocation of
> method 'parse' in  class org.apache.velocity.texen.Generator threw
> exception
> class org.apache.velocity.exception.MethodInvocationException :
Invocation
> of method 'get' in  class java.util.Properties threw exception class
> java.lang.NullPointerException : null
>       at
>
org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java
:3
> 09
> )
>       at
>
org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReferenc
e.
> ja
> va:207)
>       at
>
org.apache.velocity.runtime.parser.node.ASTReference.value(ASTReference.
ja
> va
> :357)
>       at
>
org.apache.velocity.runtime.parser.node.ASTSetDirective.render(ASTSetDir
ec
> ti
> ve.java:135)
>       at
>
org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.jav
a:
> 27
> 1)
>       at org.apache.velocity.Template.merge(Template.java:296)
>       at org.apache.velocity.texen.Generator.parse(Generator.java:425)
>       at org.apache.velocity.texen.Generator.parse(Generator.java:361)
>       at sun.reflect.GeneratedMethodAccessor18.invoke(Unknown Source)
>       at
>
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor
Im
> pl
> .java:25)
>       at java.lang.reflect.Method.invoke(Method.java:324)
>       at
>
org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java
:2
> 60
> )
>       at
>
org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReferenc
e.
> ja
> va:207)
>       at
>
org.apache.velocity.runtime.parser.node.ASTReference.render(ASTReference
.j
> av
> a:250)
>       at
>
org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:94
)
>       at
>
org.apache.velocity.runtime.parser.node.ASTIfStatement.render(ASTIfState
me
> nt
> .java:109)
>       at
>
org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:94
)
>       at
> org.apache.velocity.runtime.directive.Foreach.render(Foreach.java:344)
>       at
>
org.apache.velocity.runtime.parser.node.ASTDirective.render(ASTDirective
.j
> av
> a:153)
>       at
>
org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:94
)
>       at
> org.apache.velocity.runtime.directive.Foreach.render(Foreach.java:344)
>       at
>
org.apache.velocity.runtime.parser.node.ASTDirective.render(ASTDirective
.j
> av
> a:153)
>       at
>
org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.jav
a:
> 27
> 1)
>       at org.apache.velocity.Template.merge(Template.java:296)
>       at org.apache.velocity.texen.Generator.parse(Generator.java:451)
>       at
> org.apache.velocity.texen.ant.TexenTask.execute(TexenTask.java:552)
>       at org.apache.tools.ant.Task.perform(Task.java:341)
>       at org.apache.tools.ant.Target.execute(Target.java:309)
>       at org.apache.tools.ant.Target.performTasks(Target.java:336)
>       at org.apache.tools.ant.Project.executeTarget(Project.java:1339)
>       at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:397)
>       at
> org.apache.tools.ant.taskdefs.CallTarget.execute(CallTarget.java:143)
>       at org.apache.tools.ant.Task.perform(Task.java:341)
>       at org.apache.tools.ant.Target.execute(Target.java:309)
>       at org.apache.tools.ant.Target.performTasks(Target.java:336)
>       at org.apache.tools.ant.Project.executeTarget(Project.java:1339)
>       at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:397)
>       at
> org.apache.tools.ant.taskdefs.CallTarget.execute(CallTarget.java:143)
>       at org.apache.tools.ant.Task.perform(Task.java:341)
>       at org.apache.tools.ant.Target.execute(Target.java:309)
>       at org.apache.tools.ant.Target.performTasks(Target.java:336)
>       at org.apache.tools.ant.Project.executeTarget(Project.java:1339)
>       at
org.apache.tools.ant.Project.executeTargets(Project.java:1255)
>       at org.apache.tools.ant.Main.runBuild(Main.java:609)
>       at org.apache.tools.ant.Main.start(Main.java:196)
>       at org.apache.tools.ant.Main.main(Main.java:235)
> 
> 
> 
> -----Original Message-----
> From: Engelhardt, ITS BetrWi AE2, FD
> [mailto:[EMAIL PROTECTED]
> Sent: Thursday, November 13, 2003 1:21 AM
> To: 'Apache Torque Users List'
> Subject: AW: newbie's questions regarding tutorials
> 
> Vikas,
> did youe create any schema definition?
> 
> Dieter
> 
> -----Ursprüngliche Nachricht-----
> Von: Vikas Phonsa [mailto:[EMAIL PROTECTED]
> Gesendet: Mittwoch, 12. November 2003 23:04
> An: 'Apache Torque Users List'
> Betreff: RE: newbie's questions regarding tutorials
> 
> 
> Hi Cloves,
> Thanks for your reply. Here's what is going on with me. I modified the
> build.properties and ran the ant -f build-torque.xml and it did
generate
> some sql stuff but didn't generate any java classes. All I got in the
> src/java folder is a file named "report.bookstore.om.generation"
> 
> I just copied the stuff for build.properties given in the examples on
> apache
> and modified that to put my database information.
> 
> But I got no java classes and Ant console gives no errors.
> 
> Any ideas ?
> 
> Thanks
> 
> Vikas
> 
> -----Original Message-----
> From: Cloves Carneiro Jr. [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, November 12, 2003 11:50 AM
> To: Apache Torque Users List
> Subject: RE: newbie's questions regarding tutorials
> 
> Hi Vikas
> 
> I assume the recommended distribution of Torque is the 3.1 release.
I've
> downloaded both torque-3.1.zip and torque-gen-3.1.zip. The tutorial
you
> mentioned seems to be a bit outdated. Extract torque-gen-3.1.zip to a
> folder, edit build.properties to point to your database and create the
db
> schema definition XML in the schema folder. Run 'ant -f
build-torque.xml'
> and your classes will be generated.
> Then, extract torque-3.1.zip, and use the JARs on the /lib folder to
run
> an
> example using the classes you generated.
> 
> 
> Cloves
> 
> -----Original Message-----
> From: Vikas Phonsa [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, November 12, 2003 2:32 PM
> To: '[EMAIL PROTECTED]'
> Subject: newbie's questions regarding tutorials
> 
> 
> Hi Everybody,
> 
> This is my first hr into torque and I was trying to go thru the
tutorials
> on
> the website. I would appreciate a little guidance regarding the
following:
> 
> 1. At http://db.apache.org/torque/tutorial/step1.html they tell you to
get
> a
> distribution of torque. I need to know which version of torque is
> recommended.
> 
> 2. On the same page they say " After you have obtained your copy of
the
> Torque, you can either unpack the jar-----". I downloaded the torque-
> 3.1.zip
> and its lib directory it does have torque jar but no source in it. So
do I
> have to download the zip with the source and build it in my IDE and
> proceed
> or what ? unjarring to get class files doesn't make much sense. So
what do
> those instructions imply when they say that unjar and obtain a
specified
> directory structure.
> 
> Maybe I'm asking some stupid question but I'm kinda confused how to
> proceed.
> 
> Please guide
> 
> Thanks
> 
> Vikas
> 
> 
> 
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]



---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to