openoffice-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Matthias Seidel <matthias.sei...@hamburg.de>
Subject Re: Committed: new database driver for PostgreSQL, SDBCX API for Java
Date Tue, 22 Aug 2017 21:04:17 GMT
Am 21.08.2017 um 19:14 schrieb Damjan Jovanovic:
> Yes. Well done on finding it. You can make the dependency unconditional,
> just like I've done with sdbc_postgres itself.

As a workaround the Windows buildbot builds now with
"--enable-wiki-publisher"

But the Linux64 bot breaks even with that switch. Could you please have
a look at:
https://ci.apache.org/projects/openoffice/buildlogs/linux64/main/connectivity/unxlngx6.pro/misc/logs/java.sdbc_postgresql.txt

> On Monday, August 21, 2017, Matthias Seidel <matthias.seidel@hamburg.de>
> 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 <matthias.seidel@hamburg.de
>> <javascript:;>>
>>> 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
>>>>
>>>>
>>>>
>>>>
>>>>
>>
>>



Mime
View raw message