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]