Mailing-List: contact torque-dev-help@db.apache.org; run by ezmlm
Message-ID: 
 <8DFE1B817701524D99C2796742278722014247CC@ukldnmxcs00.office.netdecisions.co.uk>
From: Jonathan Gray <jonathan.gray@netdecisions.co.uk>
To: OJB Users List <ojb-user@db.apache.org>
Cc: torque-dev@db.apache.org
Subject: RE: Interbase/Firebird prepare-testdb problem
Date: Thu, 3 Apr 2003 16:58:05 +0100 
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"

Hi David,

The following files were missing from the torque-3.0.jar for some reason:

sql/load/interbase/row.vm
sql/load/interbase/val.vm

[TORQUE-GUYS] Is there a reason for this?

The SQL seemed pretty straight forward so I just placed slightly modified
copies of the postgres version of those files on the classpath and managed
to get past the 'project-sql-classpath' target in OJB's build.xml.

However, then in the 'project-insert-sql' target I got the error at the
bottom of this email (even though firebirdsql.jar is in the lib directory).
The code does a Class.forName() on the database driver and then calls
newInstance() on the returned class, this isn't working for some reason.

After that I tried using using the ojbcore-schema.sql to insert the default
required tables into the firebird database skipping the test torque stuff.
However, I got an error when doing that: "GDS Exception. unsuccessful
metadata update key size too big for index RDB$PRIMARY5".  After a good deal
of searching it seems that the primary key should not be greater that 256
bytes in Firebird and less than 200 if the PK is a composite.  I changed the
OJB_HL_SEQ TABLENAME column size to 128 (with FIELDNAME column with size 70)
and finally creating the table worked.  However, I don't know whether this
is going to mess up OJB's sequence manager.  Did you have any trouble with
this?

thanks,
Jon

<!-- error begin -->

project-insert-sql:
[torque-insert-sql] Our new url ->
jdbc:firebirdsql:127.0.0.1/3050:C:\Program
Files\VoiceRunner\ccpdb\ladder.gdb

BUILD FAILED
java.lang.NoClassDefFoundError: javax/resource/ResourceException
        at java.lang.Class.getDeclaredConstructors0(Native Method)
        at java.lang.Class.privateGetDeclaredConstructors(Class.java:1590)
        at java.lang.Class.getConstructor0(Class.java:1762)
        at java.lang.Class.newInstance0(Class.java:276)
        at java.lang.Class.newInstance(Class.java:259)
        at
org.apache.torque.task.TorqueSQLExec.insertDatabaseSqlFiles(TorqueSQLExec.ja
va:560)

<!-- error end -->

> 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.
> 
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
> For additional commands, e-mail: ojb-user-help@db.apache.org
>