{"id":152,"date":"2018-01-21T21:28:31","date_gmt":"2018-01-21T21:28:31","guid":{"rendered":"http:\/\/labiol.xyz\/?p=152"},"modified":"2018-01-21T21:28:31","modified_gmt":"2018-01-21T21:28:31","slug":"polaczenie-libreoffice-z-postgresql-za-pomoca-jdbc","status":"publish","type":"post","link":"https:\/\/www.labiol.xyz\/index.php\/2018\/01\/21\/polaczenie-libreoffice-z-postgresql-za-pomoca-jdbc\/","title":{"rendered":"Po\u0142\u0105czenie LibreOffice z PostgreSQL za pomoc\u0105 JDBC."},"content":{"rendered":"<ol>\n<li>Konfiguracja postgresql: pg_hba.conf: host all all 192.168.1.0\/24(albo inna sie\u0107) md5, postgresql.conf: listen_address = &#8216;*&#8217;<\/li>\n<li>Konfiguracja u\u017cytkownika i bd: sudo -i, su &#8211; postgres, createdb nazwa, createuser nazwa, psql, alter user nazwa encrypted password &#8216;haslo&#8217;<\/li>\n<li>Nale\u017cy pobra\u0107 sterownik ze strony:\u00a0<a href=\"http:\/\/jdbc.postgresql.org\/download.html\">http:\/\/jdbc.postgresql.org\/download.html<\/a><\/li>\n<li>Zapisa\u0107 sterownik, najlepiej w \u015bcie\u017cce og\u00f3lnodost\u0119pnej typu: C:\\Program Files (x86)\\LibreOffice 3.4\\program\\jdbcdrivers (wymagane odpowiendie uprawnienia)<\/li>\n<li>Doda\u0107 \u015bcie\u017ck\u0119 do zapisanego sterownika w programie LibreOffice: narz\u0119dzia -&gt; opcje -&gt; java -&gt; \u015bcie\u017cka do klas -&gt; dodaj archiwum<\/li>\n<li>W LibreOffice Base wybra\u0107 po\u0142\u0105czenie typu JDBC, dalej Datasource Url: postgresql:\/\/host:port\/nazwa_bazy, jdbc driver class: org.postgresql.Driver (z uwzgl\u0119dnieniem du\u017cego D)<\/li>\n<\/ol>\n<p>UWAGI:<\/p>\n<p>Dok\u0142adny opis:<\/p>\n<p><a href=\"http:\/\/www.postgresonline.com\/journal\/archives\/8-Using-OpenOffice-Base-2.3.1-with-PostgreSQL.html\">http:\/\/www.postgresonline.com\/journal\/archives\/8-Using-OpenOffice-Base-2.3.1-with-PostgreSQL.html<\/a><\/p>\n<p>Sterownik dzia\u0142a bezproblemowo na systemach 32 i 64 bit.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Konfiguracja postgresql: pg_hba.conf: host all all 192.168.1.0\/24(albo inna sie\u0107) md5, postgresql.conf: listen_address = &#8216;*&#8217; Konfiguracja u\u017cytkownika i bd: sudo -i, su &#8211; postgres, createdb nazwa, createuser nazwa, psql, alter user nazwa encrypted password &#8216;haslo&#8217; Nale\u017cy pobra\u0107 sterownik ze strony:\u00a0http:\/\/jdbc.postgresql.org\/download.html Zapisa\u0107 sterownik, najlepiej w \u015bcie\u017cce og\u00f3lnodost\u0119pnej typu: C:\\Program Files (x86)\\LibreOffice 3.4\\program\\jdbcdrivers &hellip; <\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4,3],"tags":[],"class_list":["post-152","post","type-post","status-publish","format-standard","hentry","category-freebsd","category-linux"],"_links":{"self":[{"href":"https:\/\/www.labiol.xyz\/index.php\/wp-json\/wp\/v2\/posts\/152","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.labiol.xyz\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.labiol.xyz\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.labiol.xyz\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.labiol.xyz\/index.php\/wp-json\/wp\/v2\/comments?post=152"}],"version-history":[{"count":1,"href":"https:\/\/www.labiol.xyz\/index.php\/wp-json\/wp\/v2\/posts\/152\/revisions"}],"predecessor-version":[{"id":153,"href":"https:\/\/www.labiol.xyz\/index.php\/wp-json\/wp\/v2\/posts\/152\/revisions\/153"}],"wp:attachment":[{"href":"https:\/\/www.labiol.xyz\/index.php\/wp-json\/wp\/v2\/media?parent=152"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.labiol.xyz\/index.php\/wp-json\/wp\/v2\/categories?post=152"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.labiol.xyz\/index.php\/wp-json\/wp\/v2\/tags?post=152"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}