{"id":39,"date":"2006-07-12T13:16:46","date_gmt":"2006-07-12T11:16:46","guid":{"rendered":"http:\/\/www.hackenberger.at\/wordpress\/?page_id=39"},"modified":"2006-07-12T13:39:10","modified_gmt":"2006-07-12T11:39:10","slug":"how-to-establish-a-connection-with-mysql-under-staroffice-61-beta","status":"publish","type":"page","link":"https:\/\/www.hackenberger.at\/blog\/linux-guides\/gentoo-guides\/how-to-establish-a-connection-with-mysql-under-staroffice-61-beta\/","title":{"rendered":"Mysql database in StarOffice"},"content":{"rendered":"<p><strong>Instructions how to establish a connection with mysql under StarOffice 6.1 beta<br \/>\n<\/strong><\/p>\n<p>First of all make sure, that you can connect to your mysql database from the shell. Use the mysql command.<br \/>\nInstall the mysql jdbc connector (emerge jdbc-mysql should do it)<br \/>\nSet up your java environment with \/opt\/staroffice6.1\/program\/jvmsetup<br \/>\nedit the \/opt\/staroffice6.1\/user\/config\/javarc file and add the path to the jdbc driver (usually \t\t\t\t\/usr\/share\/jdbc-mysql\/lib\/mysql-connector-java-3.0.8-stable-bin.jar to the SystemClasspath variable)<br \/>\nFire up your swriter (or any other staroffice product) and click on Tools->DataSources<br \/>\nCreate a new datasource and select MySQL as Database type<br \/>\nGo to the MySQL tab and select &#8220;Use Connector\/j3<br \/>\nEdit the &#8220;Data source URL&#8221; field to your needs, enter a user and \t\t\t\tselect &#8220;Password required&#8221; (make sure the user can access the \t\t\t\ttable you selected in the &#8220;Data source URL&#8221; field and click on tab &#8220;Tables&#8221;<\/p>\n<p>Enter your password and you&#8217;r done<\/p>\n<p>Have fun!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Instructions how to establish a connection with mysql under StarOffice 6.1 beta First of all make sure, that you can connect to your mysql database from the shell. Use the mysql command. Install the mysql jdbc connector (emerge jdbc-mysql should do it) Set up your java environment with \/opt\/staroffice6.1\/program\/jvmsetup edit the \/opt\/staroffice6.1\/user\/config\/javarc file and add &hellip; <a href=\"https:\/\/www.hackenberger.at\/blog\/linux-guides\/gentoo-guides\/how-to-establish-a-connection-with-mysql-under-staroffice-61-beta\/\" class=\"more-link\">Continue reading <span class=\"screen-reader-text\">Mysql database in StarOffice<\/span> <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"parent":35,"menu_order":0,"comment_status":"open","ping_status":"open","template":"","meta":[],"_links":{"self":[{"href":"https:\/\/www.hackenberger.at\/blog\/wp-json\/wp\/v2\/pages\/39"}],"collection":[{"href":"https:\/\/www.hackenberger.at\/blog\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.hackenberger.at\/blog\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.hackenberger.at\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.hackenberger.at\/blog\/wp-json\/wp\/v2\/comments?post=39"}],"version-history":[{"count":0,"href":"https:\/\/www.hackenberger.at\/blog\/wp-json\/wp\/v2\/pages\/39\/revisions"}],"up":[{"embeddable":true,"href":"https:\/\/www.hackenberger.at\/blog\/wp-json\/wp\/v2\/pages\/35"}],"wp:attachment":[{"href":"https:\/\/www.hackenberger.at\/blog\/wp-json\/wp\/v2\/media?parent=39"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}