Re: ojb_hl_seq table doesn't exist

2003-02-20 Thread Ferran Parra 
Thanks all, Thomas, casterx, Mark and luis, now have a tables in my mysql
and run, thanks.

- Original Message -
From: "luis barreiro" <[EMAIL PROTECTED]>
To: "OJB Users List" <[EMAIL PROTECTED]>
Sent: Thursday, February 20, 2003 8:36 AM
Subject: RE: ojb_hl_seq table doesn't exist


>
>
>
> Have you create the tables for the Hi/Low Sequence Algorithm ?¿?¿ They are
> necessary in order to
> work with OJB. Check the next URL :
http://db.apache.org/ojb/platforms.html
>
> (Un saludo ;)
>
>
>
> -Mensaje original-
> De: Ferran Parra [mailto:[EMAIL PROTECTED]]
> Enviado el: miércoles 19 de febrero de 2003 19:42
> Para: OJB Users List
> Asunto: ojb_hl_seq table doesn't exist
>
>
> Hi i have this error:
> General error: Table 'ibercamera.ojb_hl_seq' doesn't exist
> dbname = ibercamera
> what are happend with ojb?? thanks
> Ferran Parra
>
> Departament de Noves Tecnologies
> MUBIMEDIA S.L.
> --
> [EMAIL PROTECTED]
> Mallorca, 275, 1r 2a
> 08008 BARCELONA
> T. (+34) 93 215 21 91
> F. (+34) 93 215 41 21
>
>
>
> -
> 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]

RE: ojb_hl_seq table doesn't exist

2003-02-20 Thread luis barreiro 



Have you create the tables for the Hi/Low Sequence Algorithm ?¿?¿ They are
necessary in order to
work with OJB. Check the next URL : http://db.apache.org/ojb/platforms.html

(Un saludo ;)



-Mensaje original-
De: Ferran Parra [mailto:[EMAIL PROTECTED]]
Enviado el: miércoles 19 de febrero de 2003 19:42
Para: OJB Users List
Asunto: ojb_hl_seq table doesn't exist


Hi i have this error:
General error: Table 'ibercamera.ojb_hl_seq' doesn't exist
dbname = ibercamera
what are happend with ojb?? thanks
Ferran Parra

Departament de Noves Tecnologies
MUBIMEDIA S.L.
--
[EMAIL PROTECTED]
Mallorca, 275, 1r 2a
08008 BARCELONA
T. (+34) 93 215 21 91
F. (+34) 93 215 41 21



-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

RE: ojb_hl_seq table doesn't exist

2003-02-19 Thread Mark H 
Just in case it's any use to beginners like myself here's some SQL to create
the tables needed with a mySQL database (OJB_HL_SEQ is the only table needed
for Persistant Broker, single VM)

CREATE TABLE ojb_hl_seq (
  TABLENAME varchar(175) NOT NULL default '',
  FIELDNAME varchar(70) NOT NULL default '',
  MAX_KEY int(11) default NULL,
  GRAB_SIZE int(11) default NULL,
  PRIMARY KEY  (TABLENAME,FIELDNAME)
) TYPE=MyISAM;

CREATE TABLE ojb_dlist (
  ID int(11) NOT NULL default '0',
  SIZE_ int(11) default NULL,
  PRIMARY KEY  (ID)
) TYPE=MyISAM;

CREATE TABLE ojb_dlist_entries (
  ID int(11) NOT NULL default '0',
  DLIST_ID int(11) NOT NULL default '0',
  POSITION_ int(11) default NULL,
  OID_ longblob,
  PRIMARY KEY  (ID)
) TYPE=MyISAM;

CREATE TABLE ojb_dmap (
  ID int(11) NOT NULL default '0',
  SIZE_ int(11) default NULL,
  PRIMARY KEY  (ID)
) TYPE=MyISAM;

CREATE TABLE ojb_dmap_entries (
  ID int(11) NOT NULL default '0',
  DMAP_ID int(11) NOT NULL default '0',
  KEY_OID longblob,
  VALUE_OID longblob,
  PRIMARY KEY  (ID)
) TYPE=MyISAM;

CREATE TABLE ojb_dset (
  ID int(11) NOT NULL default '0',
  SIZE_ int(11) default NULL,
  PRIMARY KEY  (ID)
) TYPE=MyISAM;

CREATE TABLE ojb_dset_entries (
  ID int(11) NOT NULL default '0',
  DLIST_ID int(11) NOT NULL default '0',
  POSITION_ int(11) default NULL,
  OID_ longblob,
  PRIMARY KEY  (ID)
) TYPE=MyISAM;

CREATE TABLE ojb_lockentry (
  OID_ varchar(250) NOT NULL default '',
  TX_ID varchar(50) NOT NULL default '',
  TIMESTAMP_ timestamp(14) NOT NULL,
  ISOLATIONLEVEL int(11) default NULL,
  LOCKTYPE int(11) default NULL,
  PRIMARY KEY  (OID_,TX_ID)
) TYPE=MyISAM;

CREATE TABLE ojb_nrm (
  NAME varchar(250) NOT NULL default '',
  OID_ longblob,
  PRIMARY KEY  (NAME)
) TYPE=MyISAM;

-----Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 19 February 2003 08:07PM
To: OJB Users List
Subject: Re: ojb_hl_seq table doesn't exist


See here for an explanation of the OJB internal tables:
http://db.apache.org/ojb/platforms.html

cheers,
Thomas

Ferran Parra wrote:
> Hi i have this error:
> General error: Table 'ibercamera.ojb_hl_seq' doesn't exist
> dbname = ibercamera
> what are happend with ojb?? thanks
> Ferran Parra
>
> Departament de Noves Tecnologies
> MUBIMEDIA S.L.
> --
> [EMAIL PROTECTED]
> Mallorca, 275, 1r 2a
> 08008 BARCELONA
> T. (+34) 93 215 21 91
> F. (+34) 93 215 41 21
>
>



-
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]

Re: ojb_hl_seq table doesn't exist

2003-02-19 Thread Thomas Mahler 
See here for an explanation of the OJB internal tables:
http://db.apache.org/ojb/platforms.html

cheers,
Thomas

Ferran Parra wrote:

Hi i have this error:
General error: Table 'ibercamera.ojb_hl_seq' doesn't exist 
dbname = ibercamera
what are happend with ojb?? thanks
Ferran Parra

Departament de Noves Tecnologies
MUBIMEDIA S.L.
--
[EMAIL PROTECTED]
Mallorca, 275, 1r 2a
08008 BARCELONA
T. (+34) 93 215 21 91
F. (+34) 93 215 41 21





-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]