AW: [Objectbridge-developers] Q: How to setup the database?

[Mahler T. <tho...@it...>]

Hi Ivan,

For The first tutorial you only need two tables in your database:

the product table for the tutorial and the the sequence-manager table =
that
keeps track of primary key values.
here the respective DDL fragments from the file =
src/test/setup/sql1.txt:

;;; Product Table for Tutorial 1
e DROP TABLE PRODUCT;
e CREATE TABLE PRODUCT (
	ID    INT NOT NULL UNIQUE PRIMARY KEY,
	NAME  CHAR(100),
	PRICE DOUBLE,
	STOCK INT
  );

; create the OJB SequenceManager table
e DROP TABLE OJB_SEQ;
e CREATE TABLE OJB_SEQ (
    CLASSNAME    CHAR(512) NOT NULL UNIQUE PRIMARY KEY,
    FIELDNAME    CHAR(256) NOT NULL UNIQUE PRIMARY KEY,
    CURRENT      INT
);

You can do 2 things to get this tables created in your db
1. Do it manually with statements appropriate for Postgresql.
2. do it automatically with the ojb build process:
  - change the first lines of sql1.txt to point to your postgresql =
database:
  d org.enhydra.instantdb.jdbc.idbDriver; // replace with postgresql =
driver
classname
  o jdbc:idb:demo.prp;				// replace with url of your
database

  - run build.sh tests (under u*x) or build tests (under win32)=20


HTH=09

Thomas

-----Urspr=FCngliche Nachricht-----
Von: Ivan Toshkov [mailto:to...@cr...]
Gesendet: Dienstag, 7. August 2001 16:46
An: obj...@li...
Betreff: [Objectbridge-developers] Q: How to setup the database?


Hi list,

I'm trying to run the tutorial1 example w/ postgresql. How should I
initially setup the database?

Thank,
Ivan Toshkov



_______________________________________________
Objectbridge-developers mailing list
Obj...@li...
http://lists.sourceforge.net/lists/listinfo/objectbridge-developers