Hello,
I am using the JDBC-MySQL-Connector under LO 4.2.5 (and 4.3.0-RC2) and have
a rather "weird" experience:
There is a table within my database by the name of "inventar" (German for
"inventory"). It is defined like this
CREATE TABLE inventar
(nummer INTEGER NOT NULL,
bezeichnung VARCHAR (255) not null default 'Hängemappe',/* ä =
a-Umlaut */
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),
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
Output of describe command using MySQL-Client 5.5):
+---------------+---------------+------+-----+-------------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------------+---------------+------+-----+-------------+-------+
| nummer | int(11) | NO | PRI | NULL | |
| bezeichnung | varchar(255) | NO | | Hängemappe | |
| stueckZahl | int(11) | NO | | 1 | |
| anschDatum | date | NO | | 1999-09-01 | |
| fvbNr | int(11) | NO | MUL | 5969 | |
| typBesch | char(1) | NO | MUL | k | |
| anschKosten | decimal(11,2) | YES | | 0.00 | |
| repKosten | decimal(11,2) | YES | | 0.00 | |
| abschreibung | decimal(11,2) | YES | | 0.00 | |
| datEliminiert | date | NO | | 2099-09-01 | |
| vorhanden | smallint(6) | NO | | 1 | |
| invDat | date | NO | | 1999-09-01 | |
| bemerkung | varchar(255) | NO | | | |
+---------------+---------------+------+-----+-------------+-------+
Using the MySQL-commandline client, all SQL-operations (select, insert,...)
function correctly. However, when trying to access this tables (as well as
views where the table is included) through LO using JDBC, I get a blank
answer. Using the native connector for the connection under LO works just
fine. None of the MySQL logs show anything.
I wonder what could be the case...
Regards
Heinz
--
To unsubscribe e-mail to: [email protected]
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
