Re: [libreoffice-users] Re: Where is Base?
Hello again, As was mentioned in a reply to one of my remarks: Yes, there are a number of things missing in the LO-Front end to databases: Just ONE little thing eg.: When selecting tuples using the standard filter, the selection criteria (max 3 in number) are too restricted. Like -- eg. if I want to select tuples, where ((fielda = x or fielda = y) and fieldb = z) I cannot specify this (no parenthesis capability!). This kind of filter is naturally possible when accessing MySQL through phpMyAdmin. But then, it is not a big issue to quickly create a view using native SQL. So, while I would like to have this capability, it doesn't really prevent me from using LO-Base. On the other hand, trying to build a REAL application system using LO-Base and (eg.) Basic Macros and Forms is not really a choice. I suppose that M$-Access isn't fit to handle this kind of requirements either. For this kind of system I am looking at frameworks such as Symfony2 at the moment. Keep up the good work! Heinrich Ian Whitfield schrieb: .Ditto!!! +1 It has cemented the decision I took last year to move to Base+MySQL - which works very well indeed!! IanW Pretoria RSA On 03/05/2015 04:08 PM, HBarr wrote: Just want to say this thread has been so helpful and enlightening, I have learned a lot about base, mysql and databases. Tom, thanks for all your input! Howard On 5 Mar 2015 21:29, Tom Davies tomc...@gmail.com wrote: Hi :) I have been told, off-list, that i am quite wrong about what i have been saying about Base. I'm not clear exactly which bits of what i have said are wrong. Almost all of what i said was things i had picked-up from experts on this mailing list or discussions elsewhere, rather than from my own direct experience or knowledge of the issues. It would be nice to know where i am wrong to help me be less wrong in the future! Also it would be good for such corrections to be in this thread if possible because it has been a really good thread with a lot of good feedback about different people's knowledge and experience. Finally if i have given people a wrong impression about Base then it would be nice to be able to fix that. Regards from Tom :) On 4 March 2015 at 16:40, Tom Davies tomc...@gmail.com wrote: Hi :) Yeh, in attempting to clarify i did add an extra confusion! Sorry! The HsqlDb version 1.8 is only a problem when using the internal version in Base. However Base doesn't give you much choice about what to use as the internal back-end. Just the heavily tweaked and broken version of 1.8. Regards from Tom :) On 4 March 2015 at 10:58, Andreas Säger ville...@t-online.de wrote: Am 04.03.2015 um 11:03 schrieb Tom Davies: Hi :) I think Noel ( Marion)'s good experience of H2 being sooo much better than Base is purely down to them moving away from the internal back-end in Base. The version of HsqlDb mentioned by Noel is the 1.8 which Andreas identified as being the version used as the internal back-end in Base. The problem is _not_ a particular version of a particular database. If HSQL 1.8 works for you, even that version works as a rock stable, fast and reliable backend to your Base document. Heinrich demanded an _interface_ to handle the big irons. He was not talking about a particular version of some particular big iron. He did not tell us what is wrong with the current interface. From the view point of database developers, there are several missing features. From the view point of someone who wants to build a serial letter from his spreadsheet, Base is the big and dark mystery to be avoided entirely and the serial letter wizard does not mention that one of its products is a Base document together with the serial letter. -- To unsubscribe e-mail to: users+unsubscr...@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 -- To unsubscribe e-mail to: users+unsubscr...@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 -- To unsubscribe e-mail to: users+unsubscr...@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
Re: [libreoffice-users] Re: Where is Base?
Hello Noel, Interesting! I will have a look at H2. The only issue for me at the moment is that my provider has not got it installed and therefore I cannot use it. Regards from Salzburg Heinz Marion Noel Lodge schrieb: Hi Heinrich, I've been reluctant to join this discussion, but you comment about the need to have ... a stable, scalable interface to REAL databases (with sometimes millions of DB-tuples) ..., has prompted me to say that I believe one such database already exists - it is called H2. See - http://www.h2database.com/html/main.html. Some will perhaps reject it out of hand, because it is Java based. However it has a vibrant user base and from comments on the user group, some are using H2 for very large databases. A year or so ago one user was complaining that H2 was slowing down after his application passed the 1 billion record mark! In reply, he received several suggestions as to how he might over come his problem. I have migrated 6 databases from HSQL 1.8, (the largest having nearly 35,000 records - which I realise, is still quite small), but I have found that H2 works well for me. There was a bit of work involved with the migration, but H2 tables can be designed in LibreOffice and the process went pretty smoothly. Perhaps the only drawback is that once tables have been designed, they can be altered only using SQL commands. But I guess most users who want an industrial strength database, would already be literate in SQL. My 2c worth, Noel -- Noel Lodge lodg...@gmail.com On 4 March 2015 at 05:56, Heinrich Stöllinger hc.stoellin...@aon.at wrote: Hello, I am an old DB-User in the real sense of the word (I am over 70!). In the 90ies I got into DB2 as a systems engineer at IBM. Then, around the turn of the millenium, I set up a database for the administration of a 50-piece wind band, using Lotus-Approach (DBase...). It was fine but I wanted to go Open Software and - when stumbling onto StarOffice/OpenOffice and Base - it was clear to me to go for that scene. Since then I have been using MySQL as external back-end and must say I am more than happy with it. My DB consists of some 80 interconnected tables/views with record numbers up to around 40.000. This is handled perfectly fine by MySQL (maybe MariaDB in the near future!). Of course - as an old DB-guy I have no qualms about using the command-line mysql client directly for doing things like defining DBs, tables, views, foreign keys etc. Therefore, if there are any limitations in the LO-front end, it is o.k. for me. I do feel strongly though, that if we ever want LO to become a REALLY important player (especially within the business world!), a stable, scalable interface to REAL databases (with sometimes millions of DB-tuples) will have to be implemented. Internal, integrated backends are o.k. for playing around but NOT for mission-critical, large-scale operations. Regards Heinz Tom Davies schrieb: Hi :) +1 One advantage of Base is that it can connect to such a wide range of other database programs. It is kinda the default way of using Base. MS Access can be twisted into using an external database but it's not as easy to set-up that way as Base. Kexi and other front-ends can be used either alongside Base or on other systems by other users to use the same external back-end as the Base users connect to. Again this playing well with others is a huge advantage that Access doesn't have by default. Sadly the marketing team, if and when they ever mention Base, focus on using the internal back-end and never even mention the advantages that Base has. This could be one reason why we see so many people using the internal back-end and comparing it negatively against Access. Unfortunately the marketing team took such strong offence to my objections to their attempts to market Base on it's weakest points instead of it's strength that they banned me from posting to their mailing list at all. Sometimes i am really not a people person! I think if we do mention specific back-ends, especially if they are owned by Oracle, then it is well worth pointing out other names. It's not about fanboyism, just about showing there are a wide range of choices - and that people might well already have a database (or even spreadsheet) that can be used without any export-import conversions. It is VERY good to know that use of internal back-end can be externalised fairly easily without having to go through all the troubles Ian Whitfield went through. On the other hand his move away from Java-based back-ends probably gave additional benefits! I definitely appreciate Andreas' posts in this thread! He has cleared-up several mysteries by explaining the problems under the bonnet. It has also been good to see experienced and knowledgeable people giving anecdotal confirmation of Andreas' points. In answer to Jay's question there was some attempt to move to using Firebird rather than HSqlDb but i think that is still an experimental feature and that we
Re: [libreoffice-users] Re: Where is Base?
Hello Tom... Maybe I misunderstand your remark below, but... My database has for years been on a WAN-accessed MySQL server. This is only an issue resolved through DNS or the hosts file . I haven't experienced any difficulties/problems either in defining the database, loading or backing up data to my local machine (either through phpMyAdmin or the native command-line client). The only issue I have at this time is that scrolling through tables/views under LO tends to be slow. I'll have to look at that... Regards Heinz Tom Davies schrieb: Hopefully Base can even connect to back-ends hosted on WANs rather than just LANs and even on remotely hosted websites and Clouds. -- To unsubscribe e-mail to: users+unsubscr...@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
Re: [libreoffice-users] Re: Where is Base?
Hello, I am an old DB-User in the real sense of the word (I am over 70!). In the 90ies I got into DB2 as a systems engineer at IBM. Then, around the turn of the millenium, I set up a database for the administration of a 50-piece wind band, using Lotus-Approach (DBase...). It was fine but I wanted to go Open Software and - when stumbling onto StarOffice/OpenOffice and Base - it was clear to me to go for that scene. Since then I have been using MySQL as external back-end and must say I am more than happy with it. My DB consists of some 80 interconnected tables/views with record numbers up to around 40.000. This is handled perfectly fine by MySQL (maybe MariaDB in the near future!). Of course - as an old DB-guy I have no qualms about using the command-line mysql client directly for doing things like defining DBs, tables, views, foreign keys etc. Therefore, if there are any limitations in the LO-front end, it is o.k. for me. I do feel strongly though, that if we ever want LO to become a REALLY important player (especially within the business world!), a stable, scalable interface to REAL databases (with sometimes millions of DB-tuples) will have to be implemented. Internal, integrated backends are o.k. for playing around but NOT for mission-critical, large-scale operations. Regards Heinz Tom Davies schrieb: Hi :) +1 One advantage of Base is that it can connect to such a wide range of other database programs. It is kinda the default way of using Base. MS Access can be twisted into using an external database but it's not as easy to set-up that way as Base. Kexi and other front-ends can be used either alongside Base or on other systems by other users to use the same external back-end as the Base users connect to. Again this playing well with others is a huge advantage that Access doesn't have by default. Sadly the marketing team, if and when they ever mention Base, focus on using the internal back-end and never even mention the advantages that Base has. This could be one reason why we see so many people using the internal back-end and comparing it negatively against Access. Unfortunately the marketing team took such strong offence to my objections to their attempts to market Base on it's weakest points instead of it's strength that they banned me from posting to their mailing list at all. Sometimes i am really not a people person! I think if we do mention specific back-ends, especially if they are owned by Oracle, then it is well worth pointing out other names. It's not about fanboyism, just about showing there are a wide range of choices - and that people might well already have a database (or even spreadsheet) that can be used without any export-import conversions. It is VERY good to know that use of internal back-end can be externalised fairly easily without having to go through all the troubles Ian Whitfield went through. On the other hand his move away from Java-based back-ends probably gave additional benefits! I definitely appreciate Andreas' posts in this thread! He has cleared-up several mysteries by explaining the problems under the bonnet. It has also been good to see experienced and knowledgeable people giving anecdotal confirmation of Andreas' points. In answer to Jay's question there was some attempt to move to using Firebird rather than HSqlDb but i think that is still an experimental feature and that we now effectively have a choice of 2 internal back-ends neither of which work entirely as hoped for yet. With Firebird it feels like it is on the way though. Regards from Tom :) On 2 March 2015 at 21:09, Andreas Säger ville...@t-online.de wrote: Am 02.03.2015 um 21:23 schrieb Tom Davies: Hi :) Apparently another great database program to use as a back-end is Postgresql. Some of the Postgresql people worked with the LibreOffice people to make a really good connector and then got that connector into LibreOffice main trunk. This is not a matter of partisanship, fanboyism nor objective evidence of the better product. The important thing is that you are able to connect to whatever you already have. The database of your online shop, your business software, your accounting software, some dBase directory, spreadsheets or csv files. The connectivity feature lets you use tabular data without troublesome export/import. If all you have is an embedded HSQLDB, you can convert this to HSQL 2 within minutes. Conversion into Postrgre/MySQL/whatever would require careful editing of SQL scripts, testing and possibly adjustment of queries, forms, reports. -- To unsubscribe e-mail to: users+unsubscr...@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 -- To unsubscribe e-mail to:
[libreoffice-users] Where is Base?
Hello, Base DOES come with the main installer - at least in my two cases: Linux-Mint and Windows-7. My version 4.3.6 gets started with libreoffice4.3 --base %U under Linux. Regards H. Stoellinger -- To unsubscribe e-mail to: users+unsubscr...@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
Re: [libreoffice-users] Re: JDBC params - the J null date problem
Also - one obviously specify MORE than just ONE parameter in the connection string, such as dbname?autoReconnect=truezeroDateTimeBehavior=convertToNull Heinrich Alex Thurgood schrieb: Le 02/02/2015 12:34, Mark Stanton a écrit : I note from a quick search that this is a well known problem. There are some solutions involving to the JDBC connector load string, which seems to not be accessible from Base. Is that a good idea? The way is to add the parameter in the field where you specify which database to connect to : nameofmydb?zeroDateTimeBehavior=convertToNull Alex -- To unsubscribe e-mail to: users+unsubscr...@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
Re: [libreoffice-users] And while I'm here, data extraction
Hello Mark, Maybe I am missing something here and if I am suggesting something that is old hat to you - I am sorry! Besides producing reports the usual way from a database (which is o.k. in SOME cases) I also keep extracting data into Calc-spreadsheets, a very simple process indeed! Just mark all records in a table (eg. by marking the left top corner in a table/view-display), copy them and insert them into a new spreadsheet. Regards Heinrich Mark Stanton schrieb There seems to be no way to output *data* from Base, is that right? For my purposes at the moment, what would be perfectly acceptable would be a csv file but I can't find a way to do that, is there something? Yes, I know I can produce a report, but you don't want to see what that looks like when you force the output into a text file, and a merged writer document will not produce raw data like this (will it?) Again, have I missed the answer? Mark -- To unsubscribe e-mail to: users+unsubscr...@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
[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+unsubscr...@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
[libreoffice-users] Conditional DB-Fields
Hello, I want the following to work in writer (LO 4.3.5.2, Linux-Mint 17): if db.table.field != - print db.table.field else print nothing. In other words - if a field in a DB-tuple isn't empty I want LO to print that field, otherwise don't print anything. I have no problem printing fixed text if a condition is fulfilled. However, I can't get it to work in case I want the DB-field itself printed. Regards H. Stoellinger -- To unsubscribe e-mail to: users+unsubscr...@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
[libreoffice-users] MySQL Native Connector for Linux 4.2 and 4.3
Hello, As I have already mentioned before... I would love to use the native connector for a number of reasons (eg. performance...). My provider has a timeout-value of 1 minute set for a MySQL-connections and is not willing to increase this value. Using the JDBC-Connector one can specify an automatic reconnect parameter. This is by no means ideal, because sometimes one does not access the database for more than one minute. However, it is kind of o.k. because LO-DB reconnects to the server-DB by just pressing o.k. -- one gets used to this (at least in MY case!). To my knowledge the native connector does NOT have the possibility to specify such a parameter. Under the given situation LO 4.3.5.2 crashes when the server goes away and one acknowledges the respective error message. Is there a chance to get an autoconnect-feature included in a future version of the connector? Regards from snowy Salzburg H. Stoellinger -- To unsubscribe e-mail to: users+unsubscr...@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
[libreoffice-users] Printing serial letters
Hello, A long time ago (REALLY long ago!) I complained that LO does not print serial letters correctly. I think I also filed a bug report with (in MY opinion!) the right test data. I just tried to print such serial letters again today. Unfortunately the problem still exists. As you can maybe see from the enclosed pdf-file, only the FIRST letter prints correctly, while ANY letters after the first one miss out lines of text (e.g. the place and date near the top on the right), drawn lines (near the bottom). Even though I use a MySQL database as supplier of DB-fields, I don't think this has anything to do with Base. It should be easy enough to put together a test for this issue, but I include the respective .odt-file in any case. Again, I don't think a DB-table is necessary for testing. Regards Heinrich -- To unsubscribe e-mail to: users+unsubscr...@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
Re: [libreoffice-users] Re: MySQL native connector for LibreOffice 4.2 and 4.3 (Linux versions)
Alex Thurgood schrieb: Le 03/10/2014 07:27, Alan B a écrit : Hi Alan, I have a database from the US gov't, npidata freely available, with about 3.5 million rows and around 350 columns. Actually the gov't provides a csv. Imported it into a MySQL db using the MySQL command line. Never been able to read the primary table using the Java connector. With the native MySQL Yeah, the whole Java connector thing within LibreOffice and large record sets is a very bad combination, even with a mysql backend ! I'm not surprised you couldn't read it with an array of data that big, even if each field only contained 1 byte :-) Glad that the native connector at least allows you to load the records :-)) Alex Hi Alex, I do have a long-time connection with ALL 3 kinds of MySQL connectors. Only the native one REALLY works o.k... There is one problem in MY case, however: My DB-Hosting facility specifies a connection time-out value of 1 minute. With the Java connector one can specify reconnect-true (or yes?) when defining the DB under LO. This means that LO at least re-connects after a termination of the connection by the server. This is NOT a good situation, but it is kind of acceptable. The native connector does NOT allow such a specification. This makes it unusable to me unfortunately. I hope that it might be possible to change this limitation of the native connector. Regards Heinrich -- To unsubscribe e-mail to: users+unsubscr...@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
Re: [libreoffice-users] Re: MySQL native connector for LibreOffice 4.2 and 4.3 (Linux versions)
Dan Lewis schrieb: On 10/03/2014 06:07 AM, Heinrich Stöllinger wrote: Alex Thurgood schrieb: Le 03/10/2014 07:27, Alan B a écrit : Hi Alan, I have a database from the US gov't, npidata freely available, with about 3.5 million rows and around 350 columns. Actually the gov't provides a csv. Imported it into a MySQL db using the MySQL command line. Never been able to read the primary table using the Java connector. With the native MySQL Yeah, the whole Java connector thing within LibreOffice and large record sets is a very bad combination, even with a mysql backend ! I'm not surprised you couldn't read it with an array of data that big, even if each field only contained 1 byte :-) Glad that the native connector at least allows you to load the records :-)) Alex Hi Alex, I do have a long-time connection with ALL 3 kinds of MySQL connectors. Only the native one REALLY works o.k... There is one problem in MY case, however: My DB-Hosting facility specifies a connection time-out value of 1 minute. With the Java connector one can specify reconnect-true (or yes?) when defining the DB under LO. This means that LO at least re-connects after a termination of the connection by the server. This is NOT a good situation, but it is kind of acceptable. The native connector does NOT allow such a specification. This makes it unusable to me unfortunately. I hope that it might be possible to change this limitation of the native connector. Regards Heinrich This may not be much of a work a round. I have a database using MySQL 5.5 server that I leave open for long periods of time. So when I come back the database, I get the message: MySQL has gone away. Since the database is the only thing that I am using LibreOffice for at the time, I close the database rather than LibreOffice. This opens the Start window which contains a list of previously used files. I double click the name of the database, and I am reconnected. It even remembers the user name and password, so the database is opened and ready to use. Have you filed a bug report about this? Dan Hello Dan, I understand what you are telling me! However, a one-minute-timeout value (which I unfortunately cannot change since I don't have sysadmin access to the server) is simply too short. It means that it interrupts normal work far too often. Certainly one cannot go away for a coffee and excpect the server to still be connected!!! No, I haven't yet filed a bug report. Solving this issue (auto-reconnect) is probably more of an enhancement than a bug. However, I think I will follow your suggestion in any case. Regards Heinrich -- To unsubscribe e-mail to: users+unsubscr...@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
[libreoffice-users] Problem with MySQL tables
Hello, After changing the structure of a MySQL-table (deleting ONE column and inserting another column) I cannot access the table anymore through LO-Base. LO-Base still keeps looking for the old column. Since everything works just fine when using the mysql-client (Linux.Mint) through the command-line, I assume that the problem might have to do with some kind of cache that persists across LO-restart and/or system boot. If this is so - can anybody tell me where such a cache might be stored under LO 4.2.5 or LO 4.3.1? On the other hand, this only happens when using the JDBC-Connector. However, I HAVE to use this connector since the wait_timeout global value specification on the server is too low for decent work in my case and I cannot increase this value. The native MySQL-connector works fine, except that it doesn't have the possibility to specify an auto-reconnect parameter in the connection, so, again I cannot use it. In MY case one solution would be to have such a parameter also in the native connector case... Thanks a lot for any ideas Heinrich -- To unsubscribe e-mail to: users+unsubscr...@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
[libreoffice-users] MySQL-JDBC-Connector
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: users+unsubscr...@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