correct, it's not longer used! > -----Urspr�ngliche Nachricht----- > Von: adam kramer [mailto:adam@;monkey.org] > Gesendet: Donnerstag, 31. Oktober 2002 15:04 > An: OJB Users List > Betreff: Re: Missing OJB_SEQ > > > > 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>
-- To unsubscribe, e-mail: <mailto:ojb-user-unsubscribe@;jakarta.apache.org> For additional commands, e-mail: <mailto:ojb-user-help@;jakarta.apache.org>
