tag:blogger.com,1999:blog-15319370.post3310341577045715976..comments2024-03-05T11:16:00.846+01:00Comments on Roland Bouman's blog: MySQL meets OpenOffice.orgrpboumanhttp://www.blogger.com/profile/13365137747952711328noreply@blogger.comBlogger68125tag:blogger.com,1999:blog-15319370.post-64900662044315214732014-07-15T03:00:51.219+02:002014-07-15T03:00:51.219+02:00Thank you for posting this article about OpenOffic...Thank you for posting this article about OpenOffice. It is very informative. Cheers!Clarissa Lucashttp://www.process-box.com/noreply@blogger.comtag:blogger.com,1999:blog-15319370.post-12537310213763476442014-01-23T01:04:29.692+01:002014-01-23T01:04:29.692+01:00A very great article on OpenOffice. Users of such ...A very great article on OpenOffice. Users of such are surely grateful. Thanks for sharing. Ramon Andrewshttp://www.cloudstaff.com/noreply@blogger.comtag:blogger.com,1999:blog-15319370.post-82279106128127930332013-02-25T13:02:33.486+01:002013-02-25T13:02:33.486+01:00Hi
I've connected Base to mySQL, I can read th...Hi<br />I've connected Base to mySQL, I can read the data from the DB with a query. But I cannot seem to be able to add a Record to the BB via a Form in Base, Is there sum thing I'm missing or is there a primition that I need to add.<br /><br /> Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-15319370.post-69973024561815453892010-08-04T00:06:28.659+02:002010-08-04T00:06:28.659+02:00I really liked this info. I am not a typical DBA s...I really liked this info. I am not a typical DBA so looking for a suitable way to deal with migrating information between spreadsheets and MySQL through Calc and forms as a looping mddle man proved to be the perfect solution, so far. The info has only been in my noggin for a few minutes now ;)Timothy W. Cranehttp://sat-act-preparation.blogspot.comnoreply@blogger.comtag:blogger.com,1999:blog-15319370.post-84545059269989739832009-09-06T12:57:12.769+02:002009-09-06T12:57:12.769+02:00Hi Roland,
first of all: Thanks for your great ar...Hi Roland,<br /><br />first of all: Thanks for your great article, Works like a charm! :)<br /><br />Do you happen to know any good resources that help me understand if and how it is possible to load MySQL-Tables directly from Calc Spreadsheets? After trying for some time I feel like being too dumb for this ...<br /><br />Thanks in advance!<br /><br />AlexAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-15319370.post-37739602773802632322009-07-29T20:34:29.584+02:002009-07-29T20:34:29.584+02:00Hi Stephanie,
thanks! Glad it was useful for you...Hi Stephanie, <br /><br />thanks! Glad it was useful for you. <br /><br />I never tried the mysql oo native driver - just never got round to it. I do know some of the developers involved, and I know that they're dying for your bug reports and feedback! <br /><br />If you can find the time, please file bugs, it'll be greatly appreciated. <br /><br />kind regards, and thanks in advance,<br /><br />Rolandrpboumanhttps://www.blogger.com/profile/13365137747952711328noreply@blogger.comtag:blogger.com,1999:blog-15319370.post-32764728288103617652009-07-29T20:10:46.665+02:002009-07-29T20:10:46.665+02:00Just want to say that I did find this helpful.
Had...Just want to say that I did find this helpful.<br />Had to use jdbc because the MySQL native driver for OpenOffice has been a disaster - it connects ok but then OpenOffice crashes on Windows. Maybe you need to go back to Sun and help them out!stephaniehttp://www.retiredhorses.orgnoreply@blogger.comtag:blogger.com,1999:blog-15319370.post-65945398548823470232009-07-29T19:31:56.817+02:002009-07-29T19:31:56.817+02:00Hi Sam,
sorry - no - never tried it myself. Did ...Hi Sam, <br /><br />sorry - no - never tried it myself. Did donwnload it today. I figured, as I was suggesting it to you I'd better try it myself too.rpboumanhttps://www.blogger.com/profile/13365137747952711328noreply@blogger.comtag:blogger.com,1999:blog-15319370.post-23764055391074091672009-07-29T19:01:45.889+02:002009-07-29T19:01:45.889+02:00I do have primary keys defined, but I should try a...I do have primary keys defined, but I should try a sample DB like Sakila. <br /><br />Roland, do you have experience with WaveMaker? It looks good. I'd probably be able to do a good bit of the build-out in it myself, but for our timeline and custom needs, I'd need help from an experienced developer. I can't figure out how to find developers with WaveMaker experience. I've posted in their dev forums, tried to contact WaveMaker, and twittered about trying to find WaveMaker experienced developers. I'll give all that more time, but if you know of a good way to find someone to talk with me about WaveMaker, that'd be great to know.Sam Hummelhttps://www.blogger.com/profile/14009873778989801142noreply@blogger.comtag:blogger.com,1999:blog-15319370.post-19233822188423033202009-07-29T11:16:22.842+02:002009-07-29T11:16:22.842+02:00Hi!
"Is there a way to have an OOBase form o...Hi!<br /><br />"Is there a way to have an OOBase form or report that pulls from more than one database on a MySQL server?" <br /><br />I imagine it's possible though manual programming, but that is probably not the way you want to go.rpboumanhttps://www.blogger.com/profile/13365137747952711328noreply@blogger.comtag:blogger.com,1999:blog-15319370.post-57395888883575287442009-07-29T11:15:21.040+02:002009-07-29T11:15:21.040+02:00Hi Sam!
"However, I don't appear to be ...Hi Sam! <br /><br />"However, I don't appear to be able to create any Forms..." <br /><br />I'm on open office 3.1.0, and it seems to work fine on the sakila sample database. Do you have primary keys defined? Just a hunch that that might matter.rpboumanhttps://www.blogger.com/profile/13365137747952711328noreply@blogger.comtag:blogger.com,1999:blog-15319370.post-33672032253414670292009-07-29T07:24:50.477+02:002009-07-29T07:24:50.477+02:00It's really too bad that OOBase will only let ...It's really too bad that OOBase will only let you connect to one database on a MySQL server at a time. I have an application database that I want to make a front-end for but I was also hoping that it would be able to pull in some data from another database on our server. Anybody know if anything has changed since this article was written? Is there a way to have an OOBase form or report that pulls from more than one database on a MySQL server?Sam Hummelhttps://www.blogger.com/profile/14009873778989801142noreply@blogger.comtag:blogger.com,1999:blog-15319370.post-29676068841846024832009-07-29T07:22:54.888+02:002009-07-29T07:22:54.888+02:00Hey Roland,
Another great post! Thank you so muc...Hey Roland,<br /><br />Another great post! Thank you so much for the time you put into preparing this. OpenOffice Base sounds like it might make a better front-end for MySQL than MS Access (would you agree?). <br /><br />I had no problem connecting up OOBase to my MySQL server (well, really a single database on the MySQL server) thanks to your clear instructions. However, I don't appear to be able to create any Forms or Reports in OOBase for the tables that load through the JDBC connector. All the Form building and Report building buttons and options are grayed-out. Did you ever get a chance to write that post on creating Forms in OOBase for JDBC connected MySQL databases? I searched your blog for it but may have missed it. Any help would be much appreciated. Thanks again.<br /><br />-SamSam Hummelhttps://www.blogger.com/profile/14009873778989801142noreply@blogger.comtag:blogger.com,1999:blog-15319370.post-52657568645016172402009-02-04T01:20:00.000+01:002009-02-04T01:20:00.000+01:00Hi Geoff!thanks for the kind words, glad it wsa of...Hi Geoff!<BR/><BR/>thanks for the kind words, glad it wsa of use to you.<BR/><BR/>Re the timout: tough one. Somehow you must keep your connection alibve by issuing some statement. I can't boast any real experience building OOo applications so I daren't promise it is feasible to implement this.<BR/><BR/>Perhaps you can set up mysql proxy on the localhost, and have some wicked lua script automatically refresh the connection periodically. Let me know if that worked...<BR/><BR/>regards, Rolandrpboumanhttps://www.blogger.com/profile/13365137747952711328noreply@blogger.comtag:blogger.com,1999:blog-15319370.post-24003313871968620012009-02-03T22:26:00.000+01:002009-02-03T22:26:00.000+01:00First off, this is a great article. I wish that I...First off, this is a great article. I wish that I would have found it before struggling through tons of web sites which didn't describe it as clearly as you did. However, I have a problem that I haven't been able to solve.<BR/><BR/>Using OOo I'm connecting to a db on shared server for which I have no control. I can connect to the db using ODBC or JDBC. After 120 seconds of inactivity, the link drops, I get the following using JDBC:<BR/><BR/>SQL Status: 08003<BR/><BR/>No operations allowed after connection closed.Connection was implicitly closed due to underlying exception/error:<BR/><BR/><BR/>** BEGIN NESTED EXCEPTION ** <BR/><BR/>com.mysql.jdbc.exceptions.jdbc4.CommunicationsException<BR/>MESSAGE: Communications link failure<BR/><BR/>or using ODBC I get <BR/><BR/>[MySQL][ODBC 3.51 Driver][mysqld-4.1.18-standard]MySQL server has gone away<BR/><BR/>It appears that the issue is that the MySQL server has wait_timeout = 120, which causes the connection to be dropped after 120 of inactivity.<BR/><BR/>I have yet to find a solution to this. Do you have any suggestions?<BR/><BR/>-- GeoffAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-15319370.post-81875514175865312182009-02-03T22:24:00.000+01:002009-02-03T22:24:00.000+01:00First off, this is a great article. I wish that I...First off, this is a great article. I wish that I would have found it before struggling through tons of web sites which didn't describe it as clearly as you did. However, I have a problem that I haven't been able to solve.<BR/><BR/>Using OOo I'm connecting to a db on shared server for which I have no control. I can connect to the db using ODBC or JDBC. After 120 seconds of inactivity, the link drops, I get the following using JDBC:<BR/><BR/>SQL Status: 08003<BR/><BR/>No operations allowed after connection closed.Connection was implicitly closed due to underlying exception/error:<BR/><BR/><BR/>** BEGIN NESTED EXCEPTION ** <BR/><BR/>com.mysql.jdbc.exceptions.jdbc4.CommunicationsException<BR/>MESSAGE: Communications link failure<BR/><BR/>or using ODBC I get <BR/><BR/>[MySQL][ODBC 3.51 Driver][mysqld-4.1.18-standard]MySQL server has gone away<BR/><BR/>It appears that the issue is that the MySQL server has wait_timeout = 120, which causes the connection to be dropped after 120 of inactivity.<BR/><BR/>I have yet to find a solution to this. Do you have any suggestions?<BR/><BR/>-- GeoffAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-15319370.post-59307969350747698482009-01-28T20:33:00.000+01:002009-01-28T20:33:00.000+01:00Awesome... this functionality took only a few mome...Awesome... this functionality took only a few moments to setup, but it will give me the ability to generate custom reports from the desktop without having to create html tables to extract data from MySQL.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-15319370.post-45323738465502315972008-12-01T11:20:00.000+01:002008-12-01T11:20:00.000+01:00Hi robertomuggli,err...I think you are right...I ...Hi robertomuggli,<BR/><BR/>err...I think you are right...I must've misread it in one of those sleepy hours past 1 in the morning.<BR/><BR/>Anyway - yes you can use this to connect to a remote host. In fact, my hosting provider (Servage) allows me to create databases and access them directly from outside the webenvironment.rpboumanhttps://www.blogger.com/profile/13365137747952711328noreply@blogger.comtag:blogger.com,1999:blog-15319370.post-35069135286347284212008-12-01T09:33:00.000+01:002008-12-01T09:33:00.000+01:00Hey Roland,I suppose Anonymous @ 1054PM was asking...Hey Roland,<BR/>I suppose Anonymous @ 1054PM was asking wether your approach would allow him to connect from Base to his remote database.<BR/><BR/>Nothing to do with him writing a tutorial based on yours.<BR/><BR/>That said, it would be really cool to be able to use a remote MySQL database as a data source in Calc, but I guess I'm asking too much :-)Unknownhttps://www.blogger.com/profile/08172138647469020965noreply@blogger.comtag:blogger.com,1999:blog-15319370.post-60603674708878625062008-11-19T00:43:00.000+01:002008-11-19T00:43:00.000+01:00Hi anonymous,If you start your tutorial with prope...Hi anonymous,<BR/><BR/>If you start your tutorial with proper attribution then its ok.<BR/><BR/>The best way to do that is by clearly stating the fact that you are reproducing material. Be sure to include my full name and the link to this blogpost.<BR/><BR/>kind regards.rpboumanhttps://www.blogger.com/profile/13365137747952711328noreply@blogger.comtag:blogger.com,1999:blog-15319370.post-12430450984574235642008-11-18T22:54:00.000+01:002008-11-18T22:54:00.000+01:00Could I use this tutorial for connect OOo Base to ...Could I use this tutorial for connect OOo Base to a data base MySQL in my website (remote hosting)?<BR/>If not which is the best way to do that?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-15319370.post-18233066678424245442008-09-09T01:14:00.000+02:002008-09-09T01:14:00.000+02:00Great Article. I'm experiencing the same problem l...Great Article. I'm experiencing the same problem like Adam. I follow the described steps carefully and get the error message,that the JDBC driver can't be loaded. Why? I have no white spaces or anything in the path?<BR/><BR/>Thanks very, very much.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-15319370.post-29796067264071204562008-07-18T12:06:00.000+02:002008-07-18T12:06:00.000+02:00I create it under MS Excel because the end-user th...I create it under MS Excel because the end-user that using the reports may do advanced data operations they need using the features of MS Excel.<BR/><BR/>On other word, I "borrow" Excel's features, so I don't have to create them myself.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-15319370.post-43887819297494028572008-06-28T10:32:00.000+02:002008-06-28T10:32:00.000+02:00Hi William Anthony,can you tell me a bit more abou...Hi William Anthony,<BR/><BR/>can you tell me a bit more about your report generator? <BR/><BR/>Is it essential to build it in a desktop office environment, or is that merely a development platform you find convenient?rpboumanhttps://www.blogger.com/profile/13365137747952711328noreply@blogger.comtag:blogger.com,1999:blog-15319370.post-62829911027919421092008-06-28T07:21:00.000+02:002008-06-28T07:21:00.000+02:00Your article might be a solution to everyone that ...Your article might be a solution to everyone that want to migrate to non-MS application like me.<BR/><BR/>Currently, I'm using MS Excel with MySQL ODBC Connector and VBA to create automated report generator.<BR/><BR/>Too bad, VBA support in OO still in development.Anonymousnoreply@blogger.com