Date: prev next · Thread: first prev next last
2015 Archives by date, by thread · List index


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

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

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.