Re: Committed: new database driver for PostgreSQL, SDBCX API for Java
Am 22.08.2017 um 00:02 schrieb Marcus: > Am 21.08.2017 um 14:36 schrieb Matthias Seidel: >> That sounds good! > > thank you very much for bringing something new into OpenOffice. The > database part needs some improvement, so a new database driver is > fitting good into that. :-) > > I hope that the build problems can be solved quick, so that testing > and further improvements can be done soon. Builds for Windows and Linux64 should be available tomorrow... ;-) Matthias > > Marcus > > > >> Am 20.08.2017 um 21:34 schrieb Damjan Jovanovic: >>> Hi >>> >>> In revision 1805579 I committed a large patch to AOO, that implements a >>> whole new database connector, for the PostgreSQL database. >>> >>> [...] > > - > To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org > For additional commands, e-mail: dev-h...@openoffice.apache.org > smime.p7s Description: S/MIME Cryptographic Signature
Re: Committed: new database driver for PostgreSQL, SDBCX API for Java
Am 21.08.2017 um 14:36 schrieb Matthias Seidel: That sounds good! thank you very much for bringing something new into OpenOffice. The database part needs some improvement, so a new database driver is fitting good into that. :-) I hope that the build problems can be solved quick, so that testing and further improvements can be done soon. Marcus Am 20.08.2017 um 21:34 schrieb Damjan Jovanovic: Hi In revision 1805579 I committed a large patch to AOO, that implements a whole new database connector, for the PostgreSQL database. [...] - To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org For additional commands, e-mail: dev-h...@openoffice.apache.org
Re: Expat 2.2.4
No security fixes in 2.2.4, so I also think we don't need to update 4.1.4. But we should include Don's latest patch for 2.2.3. I can confirm that it builds and is working. Matthias Am 21.08.2017 um 19:22 schrieb Jim Jagielski: > I see that v 2.2.4 of Expat was just released. There are > no security-related issues related to the release nor > any rationale for us to update 4.1.4 to use 2.2.4 instead > of 2.2.3, from what I can see. > > - > To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org > For additional commands, e-mail: dev-h...@openoffice.apache.org > > smime.p7s Description: S/MIME Cryptographic Signature
Re: [ANNOUNCE] Availability of AOO-4.1.4 RC2
Hi all I'm testing now in production environment. Util now no problems dedected, but I did only very basic stuff until now. Regards Raphael Am .08.2017, 17:19 Uhr, schrieb Jim Jagielski : Available for immediate testing are the source tarball and community builds of Apache OpenOffice 4.1.4-RC2. As noted, these are Release Candidates and are not official, GA releases, although based on testing, the could become so. So PLEASE test these out! You can find these gems at: https://dist.apache.org/repos/dist/dev/openoffice/4.1.4-RC2/ Cheers! -- Jim Jagielski On behalf of the Apache OpenOffice Project - To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org For additional commands, e-mail: dev-h...@openoffice.apache.org -- My introduction https://youtu.be/Ln4vly5sxYU - To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org For additional commands, e-mail: dev-h...@openoffice.apache.org
Expat 2.2.4
I see that v 2.2.4 of Expat was just released. There are no security-related issues related to the release nor any rationale for us to update 4.1.4 to use 2.2.4 instead of 2.2.3, from what I can see. - To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org For additional commands, e-mail: dev-h...@openoffice.apache.org
Re: Committed: new database driver for PostgreSQL, SDBCX API for Java
Yes. Well done on finding it. You can make the dependency unconditional, just like I've done with sdbc_postgres itself. On Monday, August 21, 2017, Matthias Seidel wrote: > Hi Damjan, > > I think the "problem" is in "external_deps.lst": > > --- > if (SOLAR_JAVA==TRUE && ENABLE_MEDIAWIKI==YES) > MD5 = 4c8c505cc3cba4c467c479e3e0f09ba4 > name = commons-lang3-3.3-src.tar.gz > URL1 = http://archive.apache.org/dist/commons/lang/source/$(name) > URL2 = $(OOO_EXTRAS)$(MD5)-$(name) > --- > > The Windows build is running at the moment. Looks good so far! > > If it is successful Rev. 1805579 can be found here: > https://www.openoffice.org/download/devbuilds.html > > Matthias > > > Am 21.08.2017 um 17:09 schrieb Damjan Jovanovic: > > My module uses Apache Commons Lang. Maybe I didn't patch configure.ac > > properly, or maybe you have to run autoconf on that buildbot before > > ./configure? I can't check for the next few days. > > > > On Monday, August 21, 2017, Matthias Seidel > > > wrote: > > > >> Hi Damian, > >> > >> Maybe it is because we build without Wiki publisher. (What is it good > for? > >> I have never seen a working Wiki publisher in the past years...) > >> > >> I have now enabled it (--enable-wiki-publisher), let us wait for a new > >> build... > >> > >> Regards, Matthias > >> > >> Am 21.08.2017 um 14:36 schrieb Matthias Seidel: > >> > >> Hi Damian, > >> > >> That sounds good! > >> > >> Unfortunately your commit seems to break the build on our buildbot(Win10 > >> 64bit/Java 8): > >> https://ci.apache.org/projects/openoffice/buildlogs/ > >> win/log/wntmsci12.pro.build.html > >> > >> ---1 module(s): > >> apache-commons > >> need(s) to be rebuilt > >> > >> Reason(s): > >> > >> ERROR: error 65280 occurred while making /cygdrive/e/slave14/aoo-win7/ > build/main/apache-commons/java/lang > >> > >> When you have fixed the errors in that module you can resume the build > by running: > >> > >> build --from apache-commons > >> > >> --- > >> dmake: Error: -- `../../wntmsci12.pro/misc/ > 4c8c505cc3cba4c467c479e3e0f09ba4-commons-lang3-3.3-src.unpack' not found, > and can't be made > >> --- > >> > >> Regards, Matthias > >> > >> > >> Am 20.08.2017 um 21:34 schrieb Damjan Jovanovic: > >> > >> Hi > >> > >> In revision 1805579 I committed a large patch to AOO, that implements a > >> whole new database connector, for the PostgreSQL database. > >> > >> It's the real deal, a new UNO component, 57 files, 9607 lines of code, > >> about 4 months in the pipeline. It's 100% in Java, and while developing > it > >> I've also written a lot of SDBCX helper classes, loosely based on the > C++ > >> ones we already have, which will make writing future Java-based database > >> drivers much easier :). > >> > >> Ok so it's still in its early alpha stages, maybe 50% finished, and will > >> need considerable further development, so definitely not recommended for > >> production use yet, but it already supports some things that are broken > in > >> LibreOffice's PostgreSQL driver ;). > >> > >> I would have preferred to wait until it was more complete before > >> committing, but I thought now is a good time, as there is talk of > project > >> inactivity, help from others would be welcome, and "release early, > release > >> often" is the open-source way. > >> > >> It's already integrated into the build, but if you want to contribute to > >> development, it could not be easier: the Ant project opens in Eclipse > (open > >> main/connectivity/java/sdbc_postgresql/build.xml using "Java Project > from > >> Existing Ant Buildfile"), it builds in 2 seconds, and can be easily > >> debugged (in AOO, Tools -> Options, Java, Parameters, add: > >> "-agentlib:jdwp=transport=dt_socket,server=y,suspend=n,address=8000" > >> and attach the remote debugger from Eclipse). > >> > >> To use it, you need the PostgreSQL JDBC JAR file in your classpath (we > >> should probably ship it to users instead of requiring them to download > and > >> configure it in their AOO Tools -> Options, Java, Class Path). In the > >> database wizard, choose "Connect to an existing database" and select > >> "PostgreSQL". At present you have to enter database URLs in the broken > form > >> of "://127.0.0.1/catalog". Database queries work well with a variety of > >> data types, but some DDL features are missing/broken, eg. you can't > rename > >> tables, indexes can't be deleted, views/users/groups need implementing, > >> "Refresh tables" gives you a blank screen. The code also needs to be > >> audited and cleaned up a lot (locking, UNO lifecycle, null strings > (which > >> are banned in UNO)), and the relevant GUI dialogs and wizards need > adding > >> (under main/dbaccess). > >> > >> Note that you need Java >= 7. > >> > >> Anyway, development continues. We have a few more database drivers that > >> need to be developed, such as the Thunderbird address book driver and > the > >> LDAP driver which we lost when Mozilla was removed from the build. > >> > >> Regard
Re: [ANNOUNCE] Availability of AOO-4.1.4 RC2
Niltze [Hello], Peter- On Mon, Aug 21, 2017 at 7:08 AM, Peter kovacs wrote: > Jose, > > Why do you say non-freedom respecting 'Debian Desktop' LibreOffice dependency? If during Debian installation an user selects GNOME -based 'Debian desktop environment', (please see pic in long link below) < https://metztli.it/blog/media/blogs/ixiptli/quick-uploads/p121/nanahuahuatl-2016-03-18_22-31-19.jpg > it will download LibreOffice -- as the meta-package has artificial dependence on LibreOffice. Moreover, after the debian installation completes successfully, if the user wants to purge LibreOffice, action will also remove critical GNOME component(s) that will eventually cause software incompatibility issues with the 'Debian desktop environment'; in other words, purging LibreOffice breaks desktop GUI and GDM3. It can be easily verfified at: < https://packages.debian.org/stretch/gnome-core > If you look at the source: < http://http.debian.net/debian/pool/main/m/meta-gnome3/meta-gnome3_3.22+3.tar.xz > after expanding it, grep control and control.in: grep -i libreoffice meta-gnome3-3.22+3/debian/control* meta-gnome3-3.22+3/debian/control: libreoffice-evolution, meta-gnome3-3.22+3/debian/control: libreoffice-gnome, meta-gnome3-3.22+3/debian/control: libreoffice-writer, meta-gnome3-3.22+3/debian/control: libreoffice-calc, meta-gnome3-3.22+3/debian/control: libreoffice-impress, meta-gnome3-3.22+3/debian/control.in: libreoffice-evolution, meta-gnome3-3.22+3/debian/control.in: libreoffice-gnome, meta-gnome3-3.22+3/debian/control.in: libreoffice-writer, meta-gnome3-3.22+3/debian/control.in: libreoffice-calc, meta-gnome3-3.22+3/debian/control.in: libreoffice-impress, dependency is totally *artificial* since the 'Debian desktop environment' can be perfectly built without forcing LibreOffice on the user. As a matter of fact, it could ask the user whether s/he wants Apache OpenOffice OR no office suite at all -- if the Debian devs so desired. Of course it is possible to rebuild the above package after stripping references to LibreOffice and it will succeed. After the user merely installs minimally two(2) generated DEB replacements: gnome_3.22+3.1_amd64.deb gnome-core_3.22+3.1_amd64.deb (my built replacements above have a .1 above debian official LibreOffice equivalents) < https://sourceforge.net/projects/metztli-reiser4/files/No-LibreOffice-dependency_GNOME/ > s/he can purge LibreOffice *without* breaking her 'Debian desktop environment' GUI nor GDM3. Notwithstanding, it is no trivial task to rebuild package without references to LibreOffice. I produced the above components when Debian Stretch was released and had to satisfy build procedure by installing dependencies for 'Debian desktop environment': accerciser adwaita-icon-theme aisleriot alacarte anacron anjuta anjuta-extras at-spi2-core avahi-daemon baobab bijiben brasero caribou caribou-antler cdbs cheese cups-pk-helper dconf-gsettings-backend dconf-tools debhelper desktop-base devhelp empathy eog evince evolution evolution-data-server evolution-plugins file-roller five-or-more fonts-cantarell four-in-a-row gdm3 gedit gedit-plugins gimp gitg gkbd-capplet glade glib-networking gnome-api-docs gnome-backgrounds gnome-bluetooth gnome-boxes gnome-calculator gnome-chess gnome-clocks gnome-color-manager gnome-contacts gnome-control-center gnome-core gnome-devel-docs gnome-dictionary gnome-disk-utility gnome-documents gnome-font-viewer gnome-games gnome-getting-started-docs gnome-keyring gnome-klotski gnome-logs gnome-mahjongg gnome-maps gnome-menus gnome-mines gnome-music gnome-nettool gnome-nibbles gnome-online-accounts gnome-online-miners gnome-orca gnome-packagekit gnome-photos gnome-pkg-tools gnome-robots gnome-screenshot gnome-session gnome-settings-daemon gnome-shell gnome-shell-extensions gnome-shell-extension-weather gnome-sound-recorder gnome-sudoku gnome-sushi gnome-system-log gnome-system-monitor gnome-terminal gnome-tetravex gnome-themes-standard gnome-tweak-tool gnome-user-guide gnome-user-share goobox gsettings-desktop-schemas gstreamer1.0-doc gstreamer1.0-libav gstreamer1.0-plugins-base gstreamer1.0-plugins-good gstreamer1.0-plugins-ugly gstreamer1.0-pulseaudio gtk2-engines gtk-doc-tools gucharmap gvfs-backends gvfs-bin gvfs-fuse hamster-applet hitori iagno iceweasel inkscape libatk1.0-dbg libatk1.0-dev libatk1.0-doc libatk-adaptor libcairo2-doc libcanberra-doc libcanberra-pulse libcaribou-gtk3-module libcaribou-gtk-module libclutter-1.0-dbg libclutter-1.0-dev libclutter-1.0-doc libclutter-gtk-1.0-dbg libclutter-gtk-1.0-dev libclutter-gtk-1.0-doc libcogl20-dbg libcogl-dev libcogl-doc libcogl-pango20-dbg libgail-3-0-dbg libgail-3-doc libgail-dbg libgail-doc libgdk-pixbuf2.0-dev libgdk-pixbuf2.0-doc libglib2.0-0-dbg libglib2.0-dev libglib2.0-doc libgstreamer1.0-0-dbg libgstreamer1.0-dev libgtk2.0-0-dbg libgtk2.0-dev libgtk2.0-doc libgtk2-perl libgtk-3-0-dbg libgtk-3-common
Re: Committed: new database driver for PostgreSQL, SDBCX API for Java
Hi Damjan, I think the "problem" is in "external_deps.lst": --- if (SOLAR_JAVA==TRUE && ENABLE_MEDIAWIKI==YES) MD5 = 4c8c505cc3cba4c467c479e3e0f09ba4 name = commons-lang3-3.3-src.tar.gz URL1 = http://archive.apache.org/dist/commons/lang/source/$(name) URL2 = $(OOO_EXTRAS)$(MD5)-$(name) --- The Windows build is running at the moment. Looks good so far! If it is successful Rev. 1805579 can be found here: https://www.openoffice.org/download/devbuilds.html Matthias Am 21.08.2017 um 17:09 schrieb Damjan Jovanovic: > My module uses Apache Commons Lang. Maybe I didn't patch configure.ac > properly, or maybe you have to run autoconf on that buildbot before > ./configure? I can't check for the next few days. > > On Monday, August 21, 2017, Matthias Seidel > wrote: > >> Hi Damian, >> >> Maybe it is because we build without Wiki publisher. (What is it good for? >> I have never seen a working Wiki publisher in the past years...) >> >> I have now enabled it (--enable-wiki-publisher), let us wait for a new >> build... >> >> Regards, Matthias >> >> Am 21.08.2017 um 14:36 schrieb Matthias Seidel: >> >> Hi Damian, >> >> That sounds good! >> >> Unfortunately your commit seems to break the build on our buildbot(Win10 >> 64bit/Java 8): >> https://ci.apache.org/projects/openoffice/buildlogs/ >> win/log/wntmsci12.pro.build.html >> >> ---1 module(s): >> apache-commons >> need(s) to be rebuilt >> >> Reason(s): >> >> ERROR: error 65280 occurred while making >> /cygdrive/e/slave14/aoo-win7/build/main/apache-commons/java/lang >> >> When you have fixed the errors in that module you can resume the build by >> running: >> >> build --from apache-commons >> >> --- >> dmake: Error: -- >> `../../wntmsci12.pro/misc/4c8c505cc3cba4c467c479e3e0f09ba4-commons-lang3-3.3-src.unpack' >> not found, and can't be made >> --- >> >> Regards, Matthias >> >> >> Am 20.08.2017 um 21:34 schrieb Damjan Jovanovic: >> >> Hi >> >> In revision 1805579 I committed a large patch to AOO, that implements a >> whole new database connector, for the PostgreSQL database. >> >> It's the real deal, a new UNO component, 57 files, 9607 lines of code, >> about 4 months in the pipeline. It's 100% in Java, and while developing it >> I've also written a lot of SDBCX helper classes, loosely based on the C++ >> ones we already have, which will make writing future Java-based database >> drivers much easier :). >> >> Ok so it's still in its early alpha stages, maybe 50% finished, and will >> need considerable further development, so definitely not recommended for >> production use yet, but it already supports some things that are broken in >> LibreOffice's PostgreSQL driver ;). >> >> I would have preferred to wait until it was more complete before >> committing, but I thought now is a good time, as there is talk of project >> inactivity, help from others would be welcome, and "release early, release >> often" is the open-source way. >> >> It's already integrated into the build, but if you want to contribute to >> development, it could not be easier: the Ant project opens in Eclipse (open >> main/connectivity/java/sdbc_postgresql/build.xml using "Java Project from >> Existing Ant Buildfile"), it builds in 2 seconds, and can be easily >> debugged (in AOO, Tools -> Options, Java, Parameters, add: >> "-agentlib:jdwp=transport=dt_socket,server=y,suspend=n,address=8000" >> and attach the remote debugger from Eclipse). >> >> To use it, you need the PostgreSQL JDBC JAR file in your classpath (we >> should probably ship it to users instead of requiring them to download and >> configure it in their AOO Tools -> Options, Java, Class Path). In the >> database wizard, choose "Connect to an existing database" and select >> "PostgreSQL". At present you have to enter database URLs in the broken form >> of "://127.0.0.1/catalog". Database queries work well with a variety of >> data types, but some DDL features are missing/broken, eg. you can't rename >> tables, indexes can't be deleted, views/users/groups need implementing, >> "Refresh tables" gives you a blank screen. The code also needs to be >> audited and cleaned up a lot (locking, UNO lifecycle, null strings (which >> are banned in UNO)), and the relevant GUI dialogs and wizards need adding >> (under main/dbaccess). >> >> Note that you need Java >= 7. >> >> Anyway, development continues. We have a few more database drivers that >> need to be developed, such as the Thunderbird address book driver and the >> LDAP driver which we lost when Mozilla was removed from the build. >> >> Regards >> Damjan >> >> >> >> >> smime.p7s Description: S/MIME Cryptographic Signature
Re: Committed: new database driver for PostgreSQL, SDBCX API for Java
My module uses Apache Commons Lang. Maybe I didn't patch configure.ac properly, or maybe you have to run autoconf on that buildbot before ./configure? I can't check for the next few days. On Monday, August 21, 2017, Matthias Seidel wrote: > Hi Damian, > > Maybe it is because we build without Wiki publisher. (What is it good for? > I have never seen a working Wiki publisher in the past years...) > > I have now enabled it (--enable-wiki-publisher), let us wait for a new > build... > > Regards, Matthias > > Am 21.08.2017 um 14:36 schrieb Matthias Seidel: > > Hi Damian, > > That sounds good! > > Unfortunately your commit seems to break the build on our buildbot(Win10 > 64bit/Java 8): > https://ci.apache.org/projects/openoffice/buildlogs/ > win/log/wntmsci12.pro.build.html > > ---1 module(s): > apache-commons > need(s) to be rebuilt > > Reason(s): > > ERROR: error 65280 occurred while making > /cygdrive/e/slave14/aoo-win7/build/main/apache-commons/java/lang > > When you have fixed the errors in that module you can resume the build by > running: > > build --from apache-commons > > --- > dmake: Error: -- > `../../wntmsci12.pro/misc/4c8c505cc3cba4c467c479e3e0f09ba4-commons-lang3-3.3-src.unpack' > not found, and can't be made > --- > > Regards, Matthias > > > Am 20.08.2017 um 21:34 schrieb Damjan Jovanovic: > > Hi > > In revision 1805579 I committed a large patch to AOO, that implements a > whole new database connector, for the PostgreSQL database. > > It's the real deal, a new UNO component, 57 files, 9607 lines of code, > about 4 months in the pipeline. It's 100% in Java, and while developing it > I've also written a lot of SDBCX helper classes, loosely based on the C++ > ones we already have, which will make writing future Java-based database > drivers much easier :). > > Ok so it's still in its early alpha stages, maybe 50% finished, and will > need considerable further development, so definitely not recommended for > production use yet, but it already supports some things that are broken in > LibreOffice's PostgreSQL driver ;). > > I would have preferred to wait until it was more complete before > committing, but I thought now is a good time, as there is talk of project > inactivity, help from others would be welcome, and "release early, release > often" is the open-source way. > > It's already integrated into the build, but if you want to contribute to > development, it could not be easier: the Ant project opens in Eclipse (open > main/connectivity/java/sdbc_postgresql/build.xml using "Java Project from > Existing Ant Buildfile"), it builds in 2 seconds, and can be easily > debugged (in AOO, Tools -> Options, Java, Parameters, add: > "-agentlib:jdwp=transport=dt_socket,server=y,suspend=n,address=8000" > and attach the remote debugger from Eclipse). > > To use it, you need the PostgreSQL JDBC JAR file in your classpath (we > should probably ship it to users instead of requiring them to download and > configure it in their AOO Tools -> Options, Java, Class Path). In the > database wizard, choose "Connect to an existing database" and select > "PostgreSQL". At present you have to enter database URLs in the broken form > of "://127.0.0.1/catalog". Database queries work well with a variety of > data types, but some DDL features are missing/broken, eg. you can't rename > tables, indexes can't be deleted, views/users/groups need implementing, > "Refresh tables" gives you a blank screen. The code also needs to be > audited and cleaned up a lot (locking, UNO lifecycle, null strings (which > are banned in UNO)), and the relevant GUI dialogs and wizards need adding > (under main/dbaccess). > > Note that you need Java >= 7. > > Anyway, development continues. We have a few more database drivers that > need to be developed, such as the Thunderbird address book driver and the > LDAP driver which we lost when Mozilla was removed from the build. > > Regards > Damjan > > > > >
Re: [ANNOUNCE] Availability of AOO-4.1.4 RC2
Jose, Why do you say non-freedom respecting 'Debian Desktop' LibreOffice dependency? All the best Peter Am 21. August 2017 14:51:23 MESZ schrieb Jose R R : >Thank you. > >On Mon, Aug 14, 2017 at 8:19 AM, Jim Jagielski wrote: >> Available for immediate testing are the source tarball and >> community builds of Apache OpenOffice 4.1.4-RC2. >> >> As noted, these are Release Candidates and are not official, >> GA releases, although based on testing, the could become so. >> So PLEASE test these out! >> >> You can find these gems at: >> >> https://dist.apache.org/repos/dist/dev/openoffice/4.1.4-RC2/ >> >> Cheers! >> -- >> Jim Jagielski >> On behalf of the Apache OpenOffice Project > >Built from source: >< http://svn.apache.org/repos/asf/openoffice/branches/AOO414 > > >On Debian Stretch for AMD64 (after purging non-freedom respecting >'Debian Desktop' LibreOffice dependency) >< http://www.enlightenment.org/ss/e-599ad194853a53.25100016.jpg > > > >Best Professional Regards - To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org For additional commands, e-mail: dev-h...@openoffice.apache.org
Re: [ANNOUNCE] Availability of AOO-4.1.4 RC2
Thank you. On Mon, Aug 14, 2017 at 8:19 AM, Jim Jagielski wrote: > Available for immediate testing are the source tarball and > community builds of Apache OpenOffice 4.1.4-RC2. > > As noted, these are Release Candidates and are not official, > GA releases, although based on testing, the could become so. > So PLEASE test these out! > > You can find these gems at: > > https://dist.apache.org/repos/dist/dev/openoffice/4.1.4-RC2/ > > Cheers! > -- > Jim Jagielski > On behalf of the Apache OpenOffice Project Built from source: < http://svn.apache.org/repos/asf/openoffice/branches/AOO414 > On Debian Stretch for AMD64 (after purging non-freedom respecting 'Debian Desktop' LibreOffice dependency) < http://www.enlightenment.org/ss/e-599ad194853a53.25100016.jpg > Best Professional Regards -- Jose R R http://metztli.it - Download Metztli Reiser4: Debian Stretch with Linux 4.12 - for AMD64 https://sf.net/projects/metztli-reiser4/ - Try at no charge http://b2evolution.net for http://OpenShift.com PaaS - from our GitHub http://Nepohualtzintzin.com repository. Cloud the easy way! - To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org For additional commands, e-mail: dev-h...@openoffice.apache.org
Re: Committed: new database driver for PostgreSQL, SDBCX API for Java
Hi Damian, Maybe it is because we build without Wiki publisher. (What is it good for? I have never seen a working Wiki publisher in the past years...) I have now enabled it (--enable-wiki-publisher), let us wait for a new build... Regards, Matthias Am 21.08.2017 um 14:36 schrieb Matthias Seidel: > > Hi Damian, > > That sounds good! > > Unfortunately your commit seems to break the build on our > buildbot(Win10 64bit/Java 8): > https://ci.apache.org/projects/openoffice/buildlogs/win/log/wntmsci12.pro.build.html > > --- > 1 module(s): apache-commons need(s) to be rebuilt Reason(s): ERROR: > error 65280 occurred while making > /cygdrive/e/slave14/aoo-win7/build/main/apache-commons/java/lang When > you have fixed the errors in that module you can resume the build by > running: build --from apache-commons > > --- > dmake: Error: -- > `../../wntmsci12.pro/misc/4c8c505cc3cba4c467c479e3e0f09ba4-commons-lang3-3.3-src.unpack' > not found, and can't be made > --- > Regards, Matthias > > > Am 20.08.2017 um 21:34 schrieb Damjan Jovanovic: >> Hi >> >> In revision 1805579 I committed a large patch to AOO, that implements a >> whole new database connector, for the PostgreSQL database. >> >> It's the real deal, a new UNO component, 57 files, 9607 lines of code, >> about 4 months in the pipeline. It's 100% in Java, and while developing it >> I've also written a lot of SDBCX helper classes, loosely based on the C++ >> ones we already have, which will make writing future Java-based database >> drivers much easier :). >> >> Ok so it's still in its early alpha stages, maybe 50% finished, and will >> need considerable further development, so definitely not recommended for >> production use yet, but it already supports some things that are broken in >> LibreOffice's PostgreSQL driver ;). >> >> I would have preferred to wait until it was more complete before >> committing, but I thought now is a good time, as there is talk of project >> inactivity, help from others would be welcome, and "release early, release >> often" is the open-source way. >> >> It's already integrated into the build, but if you want to contribute to >> development, it could not be easier: the Ant project opens in Eclipse (open >> main/connectivity/java/sdbc_postgresql/build.xml using "Java Project from >> Existing Ant Buildfile"), it builds in 2 seconds, and can be easily >> debugged (in AOO, Tools -> Options, Java, Parameters, add: >> "-agentlib:jdwp=transport=dt_socket,server=y,suspend=n,address=8000" >> and attach the remote debugger from Eclipse). >> >> To use it, you need the PostgreSQL JDBC JAR file in your classpath (we >> should probably ship it to users instead of requiring them to download and >> configure it in their AOO Tools -> Options, Java, Class Path). In the >> database wizard, choose "Connect to an existing database" and select >> "PostgreSQL". At present you have to enter database URLs in the broken form >> of "://127.0.0.1/catalog". Database queries work well with a variety of >> data types, but some DDL features are missing/broken, eg. you can't rename >> tables, indexes can't be deleted, views/users/groups need implementing, >> "Refresh tables" gives you a blank screen. The code also needs to be >> audited and cleaned up a lot (locking, UNO lifecycle, null strings (which >> are banned in UNO)), and the relevant GUI dialogs and wizards need adding >> (under main/dbaccess). >> >> Note that you need Java >= 7. >> >> Anyway, development continues. We have a few more database drivers that >> need to be developed, such as the Thunderbird address book driver and the >> LDAP driver which we lost when Mozilla was removed from the build. >> >> Regards >> Damjan >> > smime.p7s Description: S/MIME Cryptographic Signature
Re: Committed: new database driver for PostgreSQL, SDBCX API for Java
Hi Damian, That sounds good! Unfortunately your commit seems to break the build on our buildbot(Win10 64bit/Java 8): https://ci.apache.org/projects/openoffice/buildlogs/win/log/wntmsci12.pro.build.html --- 1 module(s): apache-commons need(s) to be rebuilt Reason(s): ERROR: error 65280 occurred while making /cygdrive/e/slave14/aoo-win7/build/main/apache-commons/java/lang When you have fixed the errors in that module you can resume the build by running: build --from apache-commons --- dmake: Error: -- `../../wntmsci12.pro/misc/4c8c505cc3cba4c467c479e3e0f09ba4-commons-lang3-3.3-src.unpack' not found, and can't be made --- Regards, Matthias Am 20.08.2017 um 21:34 schrieb Damjan Jovanovic: > Hi > > In revision 1805579 I committed a large patch to AOO, that implements a > whole new database connector, for the PostgreSQL database. > > It's the real deal, a new UNO component, 57 files, 9607 lines of code, > about 4 months in the pipeline. It's 100% in Java, and while developing it > I've also written a lot of SDBCX helper classes, loosely based on the C++ > ones we already have, which will make writing future Java-based database > drivers much easier :). > > Ok so it's still in its early alpha stages, maybe 50% finished, and will > need considerable further development, so definitely not recommended for > production use yet, but it already supports some things that are broken in > LibreOffice's PostgreSQL driver ;). > > I would have preferred to wait until it was more complete before > committing, but I thought now is a good time, as there is talk of project > inactivity, help from others would be welcome, and "release early, release > often" is the open-source way. > > It's already integrated into the build, but if you want to contribute to > development, it could not be easier: the Ant project opens in Eclipse (open > main/connectivity/java/sdbc_postgresql/build.xml using "Java Project from > Existing Ant Buildfile"), it builds in 2 seconds, and can be easily > debugged (in AOO, Tools -> Options, Java, Parameters, add: > "-agentlib:jdwp=transport=dt_socket,server=y,suspend=n,address=8000" > and attach the remote debugger from Eclipse). > > To use it, you need the PostgreSQL JDBC JAR file in your classpath (we > should probably ship it to users instead of requiring them to download and > configure it in their AOO Tools -> Options, Java, Class Path). In the > database wizard, choose "Connect to an existing database" and select > "PostgreSQL". At present you have to enter database URLs in the broken form > of "://127.0.0.1/catalog". Database queries work well with a variety of > data types, but some DDL features are missing/broken, eg. you can't rename > tables, indexes can't be deleted, views/users/groups need implementing, > "Refresh tables" gives you a blank screen. The code also needs to be > audited and cleaned up a lot (locking, UNO lifecycle, null strings (which > are banned in UNO)), and the relevant GUI dialogs and wizards need adding > (under main/dbaccess). > > Note that you need Java >= 7. > > Anyway, development continues. We have a few more database drivers that > need to be developed, such as the Thunderbird address book driver and the > LDAP driver which we lost when Mozilla was removed from the build. > > Regards > Damjan > smime.p7s Description: S/MIME Cryptographic Signature
Re: Committed: new database driver for PostgreSQL, SDBCX API for Java
>In revision 1805579 I committed a large patch to AOO, that implements a >whole new database connector, for the PostgreSQL database. Thanks Damjan for this new feature. I see that you have commited it in future 4.2.0. Did you have some links for this build to testing? - To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org For additional commands, e-mail: dev-h...@openoffice.apache.org