db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Cameron Hickey" <...@panoramatos.com>
Subject RE: What is ${SQLControlTemplate}
Date Mon, 18 Aug 2003 11:04:31 GMT
The templates used to generate the SQL for building the database are
located in a folder called "templates" which is in the root of the
torque installation package.  These files need to be located in the
right place for the SQL generation to work.  How you have your project
configured will determine where this should be, but for most things I
have done, this is the same location you put your "schema" and "om"
folders, in my app I call it "torque".

Hope this helps

Cameron

-----Original Message-----
From: majoko@gmx.com [mailto:majoko@gmx.com] 
Sent: Monday, August 18, 2003 11:41 AM
To: torque-user@db.apache.org
Subject: What is ${SQLControlTemplate}

Hi, 
have a problem with torque.
I've generated with ojbdoclet my project_schema.xml. Now I will generate
the
DDL.
I've edited the build.properties.
First it could not find my torque.project and torque.database. But it
works
with project=myproject and database=mysql

I always I get the error:
project-sql-classpath:
     [echo] +------------------------------------------+
     [echo] |                                          |
     [echo] | Generating SQL for OJB Testsuite!        |
     [echo] | enJoy!                                   |
     [echo] |                                          |
     [echo] +------------------------------------------+
[torque-sql] Using contextProperties file:
D:\JAVA_E~1\cvs_home\testojb\buildtorque.properties
Property ${SQLControlTemplate} has not been set
[torque-sql] Using
classpath
[torque-sql]
Generating
to
file
D:\Java_Entwicklung\cvs_home\testojb\build\db\sql\report.testojb.sql.gen
eration

BUILD FAILED
file:D:/JAVA_E~1/cvs_home/testojb/build-torque.xml:449: Resource not
found.
For more information consult the velocity lo
g, or invoke ant with the -debug flag.
        at
org.apache.velocity.texen.ant.TexenTask.execute(TexenTask.java:575)
        at
org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:193)
        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.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.ResourceNotFoundException:
Unable
to find resource '${SQLControlTemplate}'
    



at
org.apache.velocity.runtime.resource.ResourceManagerImpl.loadResource(Re
sourceManagerImpl.java:501)
    



at
org.apache.velocity.runtime.resource.ResourceManagerImpl.getResource(Res
ourceManagerImpl.java:384)
    



at
org.apache.velocity.runtime.RuntimeInstance.getTemplate(RuntimeInstance.
java:814)
    



at
org.apache.velocity.runtime.RuntimeInstance.getTemplate(RuntimeInstance.
java:796)
    



at
org.apache.velocity.runtime.RuntimeSingleton.getTemplate(RuntimeSingleto
n.java:337)
        at
org.apache.velocity.app.Velocity.getTemplate(Velocity.java:512)
        at
org.apache.velocity.texen.Generator.getTemplate(Generator.java:321)
        at org.apache.velocity.texen.Generator.parse(Generator.java:449)
        at
org.apache.velocity.texen.ant.TexenTask.execute(TexenTask.java:552)
        ... 14 more
--- Nested Exception ---
org.apache.velocity.exception.ResourceNotFoundException: Unable to find
resource '${SQLControlTemplate}'
    



at
org.apache.velocity.runtime.resource.ResourceManagerImpl.loadResource(Re
sourceManagerImpl.java:501)
    



at
org.apache.velocity.runtime.resource.ResourceManagerImpl.getResource(Res
ourceManagerImpl.java:384)
    



at
org.apache.velocity.runtime.RuntimeInstance.getTemplate(RuntimeInstance.
java:814)
    



at
org.apache.velocity.runtime.RuntimeInstance.getTemplate(RuntimeInstance.
java:796)
    



at
org.apache.velocity.runtime.RuntimeSingleton.getTemplate(RuntimeSingleto
n.java:337)
        at
org.apache.velocity.app.Velocity.getTemplate(Velocity.java:512)
        at
org.apache.velocity.texen.Generator.getTemplate(Generator.java:321)
        at org.apache.velocity.texen.Generator.parse(Generator.java:449)
        at
org.apache.velocity.texen.ant.TexenTask.execute(TexenTask.java:552)
        at
org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:193)
        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.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)

It seems it looks for ${SQLControlTemplate}, but if I edit it in the
build.properties I should know for which file it should be and how I
could
edit it.

Kind regards,

Markus










---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org


Mime
View raw message