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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, August 18, 2003 11:41 AM To: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
