Hi, an evergreen problem with oracle (asked and answered several times here): you can only have on LONG or LONG RAW column in one table with oracle, unfortunately OJB_DMAP_ENTRIES is defined with two such fields. We changed the datatype for column VALUE_OID to VARCHAR2(2048) (in the repository and in the database) and it works (so far). Don't know a better way to get it working and don't know of potential side effects yet.
Max > -----Ursprüngliche Nachricht----- > Von: Julio Barros [mailto:[EMAIL PROTECTED] > Gesendet: Donnerstag, 3. April 2003 20:17 > An: [EMAIL PROTECTED] > Betreff: OJB RC2 with Oracle 9i2 OS X Beta > > > Hi, > > I'm trying to set up OJB RC2 to work with my Oracle 9i OS X > Beta. I've > modified my build.properties to use oracle oracle.properties > to specify > the connection url but when trying to execute a prepare-tutorials to > test out the system I get the following error: > > [torque-insert-sql] Failed to execute: CREATE TABLE > OJB_DMAP_ENTRIES ( > ID NUMBER NOT NULL, DMAP_ID NUMBER NOT NULL, KEY_OID LONG RAW, > VALUE_OID LONG RAW ) > [torque-insert-sql] java.sql.SQLException: ORA-01754: a table may > contain only one column of type LONG > > Any ideas? > > Thanks, > > Julio > > > --------------------------------------------------------------------- > 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]
