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>
