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: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
