[libreoffice-users] JDBC-connector to MySQL database

Hello,

I have been using a JDBC-connection to a remote MySQL-Database for 
years. It has
been working like a charm in general. There is one rather annoying 
problem, however:

I have a table with the name "inventar" (German for "inventory"). I can 
access this
table using a command-line client (mysql ... from Linux) as well as 
using the "native"
MySQL connector. However, when using JDBC 
<http://www.coderanch.com/forums/f-3/JDBC>, the table content is NOT 
displayed at all.
All the other (some 80 in number) are accessible through JDBC without 
problems. There
are 1316 tuples ("records") in the table. I don't see any error messages 
in any of the
logs I wonder what's the problem...

Below is the table definition:

DROP TABLE IF EXISTS inventar;
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 '1999-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
;

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