[libreoffice-users] displaying/editing a table through LO-Base

Hello,

To start with - I am not certain that this belongs into THIS "forum"...

I run a MySQL-database which is stored at a Linux-Debian-Squeeze-Server.
This DB consists of "dozens" of inter-related tables, views, functions, procedures,
etc., etc.
I have been accessing the DB both through the the command-line client and phpMyAdmin,
adding, updating, deleting tuples with no problems at all with ALL tables.

Except - when accessing the DB through LO-Base, using the JDBC connector from MySQL
(mysql-connector-java-5.1.30), there is just ONE table which I cannot access. it is
defined like this:
CREATE TABLE inventar
  (nummer INTEGER NOT NULL,
   bezeichnung VARCHAR (255) not null default ' ',
   stueckZahl INTEGER not null default 1,
   anschDatum DATE not null DEFAULT '1999-09-01',/* Anschaffungsdatum */
   fvbNr INTEGER not null default 0,             /* Firmennummer des Lieferanten */
   typBesch CHAR(1) not null default 'k',        /* Miete, Kauf, Leihe, Spende,... */
   anschKosten FIXED (11,2) default 0,           /* Anschaffungskosten in EUR */
   repKosten FIXED (11,2) default 0,             /* aufgelaufene Reparaturkosten in EUR */
   abschreibung FIXED (11,2) default 0,          /* aufgelaufene Abschreibung in EUR */
   datEliminiert DATE NOT NULL DEFAULT '2099-09-01',/* aus Inventar ausgeschieden am... */
   vorhanden SMALLINT NOT NULL default 1,        /* Menge laut Inventur */
   invDat DATE not null default '1999-09-01',    /* Inventur-Datum */
   bemerkung VARCHAR (255) not null default ' ',
   PRIMARY KEY (nummer),
   UNIQUE INDEX (nummer),
   INDEX (fvbNr),
   INDEX (typBesch),
   FOREIGN KEY (fvbNr) REFERENCES fvbPartner(nummer),
   FOREIGN KEY (typBesch) REFERENCES invBeschTyp(code)
  )
  CHARACTER SET latin1 COLLATE latin1_german1_ci
  ENGINE=InnoDB
;
I am sure that the problem lies with the JDBC-Connector itself or its usage under LO-Base,
since I don't experience any problems when going either through the command-line client,
phpMyAdmin or the native MySQL connector under LO-Base. There is NO entry in any of the
MySQL-logs...

Has anybody experienced a similar situation?
Regards
H.S.
--
Erstellt mit Operas revolutionärem E-Mail-Modul: http://www.opera.com/mail/

--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted