Return-Path: Mailing-List: contact torque-dev-help@db.apache.org; run by ezmlm Delivered-To: mailing list torque-dev@db.apache.org Received: (qmail 3709 invoked from network); 2 Apr 2003 13:39:28 -0000 Received: from unknown (HELO mailhost.netdecisions.com) (62.190.34.71) by daedalus.apache.org with SMTP; 2 Apr 2003 13:39:28 -0000 Received: (qmail 30480 invoked by uid 506); 2 Apr 2003 12:23:03 -0000 Received: from jonathan.gray@netdecisions.co.uk by gandalf by uid 503 with qmail-scanner-1.11 (iscan: v3.1/v5.300-0130/993/44798. . Clear:. Processed in 0.155826 secs); 02 Apr 2003 12:23:03 -0000 Received: from unknown (HELO ukldnbh01.office.netdecisions.co.uk) (192.168.34.1) by 192.168.34.10 with SMTP; 2 Apr 2003 12:23:03 -0000 Received: by UKLDNBH01 with Internet Mail Service (5.5.2656.59) id <21MWN4SX>; Wed, 2 Apr 2003 14:40:01 +0100 Message-ID: <8DFE1B817701524D99C279674227872201424251@ukldnmxcs00.office.netdecisions.co.uk> From: Jonathan Gray To: ojb-user@db.apache.org, torque-user@db.apache.org Cc: ojb-dev@db.apache.org, torque-dev@db.apache.org Subject: Interbase/Firebird prepare-testdb problem Date: Wed, 2 Apr 2003 14:34:35 +0100 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2656.59) Content-Type: text/plain; charset="iso-8859-1" X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N Hi, I am trying to use OJB with the Firebird database, I have followed most of the installation instructions in trying to have all of the tables automatically created in the database using prepare-testdb. However, firstly I got the following error: [torque-sql] Database-specific properties file does not exist: D:\tmp\db-ojb-1.0.rc2\sql\base\firebird\db.props It turns out that torque is not configured for firebird, but it does have an interbase directory so I tried instead to use the interbase directory. I created an interbase.profile and set everything up appropriate except that I am using the Firebird database and the Firebird SQL 1.0.RC3 JDBC driver. I almost got through the project-sql-classpath target except I got the following error in the velocity.log: 2003-04-02 12:42:39,442 - ResourceManager : found sql/load/Control.vm with loader org.apache.velocity.runtime.resource.loader.ClasspathResourceLoader 2003-04-02 12:42:39,442 - ResourceManager : unable to find resource 'sql/load/interbase/row.vm' in any resource loader. 2003-04-02 12:42:39,452 - Method parse threw exception for reference $generator in template sql/load/Control.vm at [4,1] In the torque archive there seems to be a rom.vm for each of the other databases but not for the interbase database, is there anyway to get around this? Is this file supposed to be there and it is a bug or should one not be trying to use that in the first place? Also, because the prepare-testdb target is failing, what is the easiest way to setup the required tables for the OJB in my database, are there any individual scripts that I can run? thanks, Jon