From torque-user-return-2930-apmail-db-torque-user-archive=db.apache.org@db.apache.org Mon Aug 18 11:04:51 2003 Return-Path: Delivered-To: apmail-db-torque-user-archive@db.apache.org Received: (qmail 85903 invoked by uid 500); 18 Aug 2003 11:04:50 -0000 Mailing-List: contact torque-user-help@db.apache.org; run by ezmlm Precedence: bulk List-Unsubscribe: List-Subscribe: List-Help: List-Post: List-Id: "Apache Torque Users List" Reply-To: "Apache Torque Users List" Delivered-To: mailing list torque-user@db.apache.org Received: (qmail 85862 invoked from network); 18 Aug 2003 11:04:49 -0000 Received: from relay.pair.com (209.68.1.20) by daedalus.apache.org with SMTP; 18 Aug 2003 11:04:49 -0000 Received: (qmail 73416 invoked from network); 18 Aug 2003 11:04:46 -0000 Received: from d41.kif3.nas.panafonet.gr (HELO compaq) (213.249.2.41) by relay.pair.com with SMTP; 18 Aug 2003 11:04:46 -0000 X-pair-Authenticated: 213.249.2.41 From: "Cameron Hickey" To: "'Apache Torque Users List'" Subject: RE: What is ${SQLControlTemplate} Date: Mon, 18 Aug 2003 14:04:31 +0300 Message-ID: <001301c36578$830c2d00$0100a8c0@compaq> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.2616 In-Reply-To: <25524.1061196067@www54.gmx.net> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 Importance: Normal X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N 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