You are viewing a plain text version of this content. The canonical link for it is here.
Posted to torque-user@db.apache.org by ma...@gmx.com on 2003/08/18 10:41:07 UTC

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.generation

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(ResourceManagerImpl.java:501)
    



at
org.apache.velocity.runtime.resource.ResourceManagerImpl.getResource(ResourceManagerImpl.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(RuntimeSingleton.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(ResourceManagerImpl.java:501)
    



at
org.apache.velocity.runtime.resource.ResourceManagerImpl.getResource(ResourceManagerImpl.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(RuntimeSingleton.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

RE: What is ${SQLControlTemplate}

Posted by ma...@gmx.com.
> 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
> 
 Yes, this are the *.vm templates from velocity. But have I point to one or
to the folder where they are in? Or will the be taken from the torque.jar? If
yes, I will have a problem with my classpath.

Regards,

Markus


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

RE: What is ${SQLControlTemplate}

Posted by Cameron Hickey <ca...@panoramatos.com>.
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