Interbase/Firebird prepare-testdb problem

[Jonathan Gray <jo...@netdecisions.co.uk>]

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

Re: Interbase/Firebird prepare-testdb problem

[David Warnock <da...@sundayta.com>]

Jonathan,

 > I am trying to use OJB with the Firebird database,

We are using Firebird and OJB, I contributed the very basic Firebird 
implementation for OJB in

src/java/org/apache/ojb/broker/platforms/PlatformFirebirdImpl.java

We have not bothered with Torque yet. I took the sql scripts created by 
the default test process for HSQLDB and changed them to Firebird syntax 
and ran them manually.

I would create a firebird driver for Torque, start with postgresql, make 
changes as per the interbase driver if still required (if you can use 
dialect 3 then the changes maybe fewer than in the past with dialect 1).

Hope this helps.

Dave
-- 
David Warnock, Sundayta Ltd. http://www.sundayta.com
iDocSys for Document Management. VisibleResults for Fundraising.
Development and Hosting of Web Applications and Sites.