Hello,
To create the core tables in my db, I just ran ${OJB INSTALL
DIRECTORY}\target\src\sql\ojbcore-schema.sql (the slant of your slashes may vary)
against a new database after running the prepare-testdb target. There may be a better
way, I dunno.
As for 2), you can always roll your own, I suppose. From what I understand from
browsing the posts over the last couple of days, OJB's sequence manager should work by
calling nextval() or whatever from the sequences you specify, not by creating its own
sequence. You could always hack a quick test and see.
-----Original Message-----
From: Duffy Gillman [mailto:[EMAIL PROTECTED]
Sent: Friday, April 04, 2003 5:22 PM
To: OJB Users List
Subject: core OJB tables; auto-increment
Hi,
I am trying to use OJB as part of a web-service. The database may be
accessed by other software. I need to find answers to the following
questions:
1) How do I create the core OJB tables in my database? In the
documentation I am only finding the "prepare-testdb" ant target. This
builds a bunch of extra tables that I do not want. Surely I can drop the
extra tables... but I would like to know how to just build the core ones
into my project (OJB_HL_SEQ, OJB_LOCKENTRY, OJB_NRM, OJB_DLIST, etc...).
2) Is using the OJB sequence manager the only way to get OJB to work with
sequences? Several PK fields in my database are autoincrement. Will the
OJB create its OWN sequences for these (i.e. if another application relies
on the sequence maintained by the RDBMS itself, will it clash with the
sequence OJB is maintaining?)?
Thanks in advance,
Duffy
--
=====================================
Duffy Gillman
POLIS Systems Programmer
Learning Technology Center
PO Box 210073, CCIT Bldg., Rm. 337
1077 N. Highland Ave.
Tucson, AZ 85721-0073
520.626.0117 (voice)
520.626.8220 (fax)
=====================================
---------------------------------------------------------------------
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]
