Found the answer once I was able to access the archives. For reference:
In src/schema/ojbcore-schema.xml
Change:
< <column name="KEY_OID" type="LONGVARBINARY"/>
< <column name="VALUE_OID" type="LONGVARBINARY"/>
to:
> <column name="KEY_OID" type="VARBINARY"/>
> <column name="VALUE_OID" type="VARBINARY"/>
Peter
[EMAIL PROTECTED]
06/12/2003 01:20 PM
Please respond to "OJB Users List"
To: "OJB Users List" <[EMAIL PROTECTED]>
cc:
Subject: Install failed with Oracle 8i - java.sql.SQLException:
ORA-01754: a table
may contain only one column of type LONG
Anyone seen this before? I can't imagine that I am the first one to try
and use this platform on Oracle 8.1.7?
[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
[torque-insert-sql] Failed to execute: ALTER TABLE OJB_DMAP_ENTRIES ADD
CONSTRAINT OJB_DMAP_ENTRIES_PK PRIMARY KEY
(ID)
[torque-insert-sql] java.sql.SQLException: ORA-00942: table or view does
not exist
[torque-insert-sql] Executing file:
C:\db-ojb-1.0.rc3\target\src\sql\ojbtest-data.sql
[torque-insert-sql] 340 of 428 SQL statements executed successfully
It looks like there is a reference to this problem in the archives but I
cannot get to the archives for some reason (see my previous thread). Any
help greatly appreciated, I am evaluating ObjectRelationalBridge as a
solution for our Object-Relational translation tier on a new J2EE project
I am working on.
thx
Peter
