[libreoffice-users] Re: JDBC driver for Mac OS
Le 12/05/13 05:39, rounak jain a écrit : Hi Rounak, worked. thank you very much. Bear in mind that performance of LO using the JDBC connector degrades rapidly (it was never stellar) once you reach a few thousand records, or if you are using multiple joins and complex queries. Also, the JDBC connector doesn't natively support NULL timestamps, potentially causing crashes in LO on OSX, and it has various problems with binary object support (e.g. video, audio, etc) other than images. This is actually partly a limitation of LO, that does not fully implement CLOB/BLOB binary streaming. 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] Re: JDBC driver for Mac OS
so what must i use? On Mon, May 13, 2013 at 4:44 PM, Alexander Thurgood alex.thurg...@gmail.com wrote: Le 12/05/13 05:39, rounak jain a écrit : Hi Rounak, worked. thank you very much. Bear in mind that performance of LO using the JDBC connector degrades rapidly (it was never stellar) once you reach a few thousand records, or if you are using multiple joins and complex queries. Also, the JDBC connector doesn't natively support NULL timestamps, potentially causing crashes in LO on OSX, and it has various problems with binary object support (e.g. video, audio, etc) other than images. This is actually partly a limitation of LO, that does not fully implement CLOB/BLOB binary streaming. 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 -- 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] Re: JDBC driver for Mac OS
Found j connector instead. http://dev.mysql.com/downloads/connector/j/ How to install it in Mac OS? Quite a few articles advice against setting the Class variable like http://stackoverflow.com/questions/2509138/classpath-on-mac-and-how-does-mac-look-for-mysql-connector-java-bin-jar and the rest of the things I have read are just too heavy to grasp. Please guide me. On Sat, May 11, 2013 at 7:29 PM, rounak jain rounak.m...@gmail.com wrote: According to the article here, I need to install libmysql-java to connect BASE with MySQL using JDBC. http://www.techrepublic.com/blog/doityourself-it-guy/diy-connect-libreoffice-base-to-a-mysql-database/1386 I found instructions for installing it on linux via apt-get. Any ideas for Mac OS? -- 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 driver for Mac OS
The method of installing the j connector should be similar to installing it on any Operating System. from the MySQL website download the zip file to your desktop: mysql-connector-java-5.1.25.zip. Double click it to unzip it producing the mysql-connector-java-5.1.25 folder. Drag it to the Document folder. Open LibreOffice. Command + comma key combination opens a dialog. Look down the list the has LibreOffice at the top for Advanced. Click it. (This is the Java page of the dialog. Click the Class Path button to open the Class Path dialog. Now click the Add Archive button to browse to the location of mysql-connector-java-5.1.25-bin.jar. (It is in Document/mysql-connector-java-5.1.25/.) Highlight the file and click Open. The path to the file is now entered in the Class Path dialog. Click OK. Click OK in the Java page of the dialog. Now close LibreOffice. The connector has been installed in LibreOffice. --Dan Found j connector instead. http://dev.mysql.com/downloads/connector/j/ How to install it in Mac OS? Quite a few articles advice against setting the Class variable like http://stackoverflow.com/questions/2509138/classpath-on-mac-and-how-does-mac-look-for-mysql-connecytor-java-bin-jar and the rest of the things I have read are just too heavy to grasp. Please guide me. On Sat, May 11, 2013 at 7:29 PM, rounak jain rounak.m...@gmail.com wrote: According to the article here, I need to install libmysql-java to connect BASE with MySQL using JDBC. http://www.techrepublic.com/blog/doityourself-it-guy/diy-connect-libreoffice-base-to-a-mysql-database/1386 I found instructions for installing it on linux via apt-get. Any ideas for Mac OS? -- 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 driver for Mac OS
worked. thank you very much. On Sun, May 12, 2013 at 1:43 AM, Dan Lewis elderdanle...@gmail.com wrote: The method of installing the j connector should be similar to installing it on any Operating System. from the MySQL website download the zip file to your desktop: mysql-connector-java-5.1.25.**zip. Double click it to unzip it producing the mysql-connector-java-5.1.25 folder. Drag it to the Document folder. Open LibreOffice. Command + comma key combination opens a dialog. Look down the list the has LibreOffice at the top for Advanced. Click it. (This is the Java page of the dialog. Click the Class Path button to open the Class Path dialog. Now click the Add Archive button to browse to the location of mysql-connector-java-5.1.25-**bin.jar. (It is in Document/mysql-connector-**java-5.1.25/.) Highlight the file and click Open. The path to the file is now entered in the Class Path dialog. Click OK. Click OK in the Java page of the dialog. Now close LibreOffice. The connector has been installed in LibreOffice. --Dan Found j connector instead. http://dev.mysql.com/**downloads/connector/j/http://dev.mysql.com/downloads/connector/j/How to install it in Mac OS? Quite a few articles advice against setting the Class variable like http://stackoverflow.com/** questions/2509138/classpath-**on-mac-and-how-does-mac-look-** for-mysql-connecytor-java-bin-**jarhttp://stackoverflow.com/questions/2509138/classpath-on-mac-and-how-does-mac-look-for-mysql-connecytor-java-bin-jarand the rest of the things I have read are just too heavy to grasp. Please guide me. On Sat, May 11, 2013 at 7:29 PM, rounak jain rounak.m...@gmail.com wrote: According to the article here, I need to install libmysql-java to connect BASE with MySQL using JDBC. http://www.techrepublic.com/**blog/doityourself-it-guy/diy-** connect-libreoffice-base-to-a-**mysql-database/1386http://www.techrepublic.com/blog/doityourself-it-guy/diy-connect-libreoffice-base-to-a-mysql-database/1386 I found instructions for installing it on linux via apt-get. Any ideas for Mac OS? -- To unsubscribe e-mail to: users+unsubscribe@global.**libreoffice.orgusers%2bunsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/**get-help/mailing-lists/how-to-** unsubscribe/http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.**documentfoundation.org/** Netiquette http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.**libreoffice.org/global/users/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
