If you look at the html docs with the distribution I bet the table is no longer required. Same thing happened to me and although I haven't tried inserts and updates yet with a sequence manager, I don't think its required anymore.
-ak. On Wed, 30 Oct 2002, Ethel Emmons wrote: > I am using oracle and have properly set my oracle > profile. > I ran ant prepare-testdb and I got: > > [torque-insert-sql] Our new url -> > jdbc:oracle:thin:@cmsdbdev2.central.sun.com:1521:UE5 > > [torque-insert-sql] Executing file: > /home/eemmons/OJB/jakarta-ojb-0.9.7/target/src/sql/ojbtest-schema.sql > > [torque-insert-sql] Executing file: > /home/eemmons/OJB/jakarta-ojb-0.9.7/target/src/sql/ojbcore-schema.sql > > [torque-insert-sql] Failed to execute: DROP TABLE > OJB_DMAP_ENTRIES CASCADE CONSTRAINTS > [torque-insert-sql] java.sql.SQLException: > ORA-00942: table or view does not exist > [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: > /home/eemmons/OJB/jakarta-ojb-0.9.7/target/src/sql/ojbtest-data.sql > > [torque-insert-sql] 288 of 291 SQL statements > executed successfully > > So I changed the LONG RAW to BLOB and inserted > them manually. Worked. > > But how come I don't have OJB_SEQ table? I saw in > > the docs that this is required table. > > Ethel > > > > -- To unsubscribe, e-mail: <mailto:ojb-user-unsubscribe@;jakarta.apache.org> For additional commands, e-mail: <mailto:ojb-user-help@;jakarta.apache.org>
