Re: silgraphite dependency?

[Fred Ollinger]

I think I merged all your changes.

This is the first time I did this w/ github so please let me know if I need
to do something more.

Fred


On Tue, Apr 9, 2013 at 11:04 PM, Andrea Pescetti wrote:

> Fred Ollinger wrote:
>
>> I'm building this now.
>> I think that perhaps this was dropped.
>> My goal is to first build aooo 3.3 rpm (last srpm) then to build 4.0
>> latest.
>> Anyone want this if it works?
>>
>
> Sure, and even if it doesn't work! Thank you for your efforts and we can
> surely work on this together.
>
> By the way, I posted a couple of patches last week for
> https://github.com/**fredollinger/aooo-fedora-**rawhide<https://github.com/fredollinger/aooo-fedora-rawhide>,
> please let us know if you prefer to get feedback via pull requests or any
> other means.
>
> Regards,
>   Andrea.
>
> --**--**-
> To unsubscribe, e-mail: 
> dev-unsubscribe@openoffice.**apache.org
> For additional commands, e-mail: dev-h...@openoffice.apache.org
>
>

Re: silgraphite dependency?

[Fred Ollinger]

I'll apply the patches pronto, if I need to. Plus, I'll try to figure out
how to give you commit access.

Fred


On Tue, Apr 9, 2013 at 11:04 PM, Andrea Pescetti wrote:

> Fred Ollinger wrote:
>
>> I'm building this now.
>> I think that perhaps this was dropped.
>> My goal is to first build aooo 3.3 rpm (last srpm) then to build 4.0
>> latest.
>> Anyone want this if it works?
>>
>
> Sure, and even if it doesn't work! Thank you for your efforts and we can
> surely work on this together.
>
> By the way, I posted a couple of patches last week for
> https://github.com/**fredollinger/aooo-fedora-**rawhide<https://github.com/fredollinger/aooo-fedora-rawhide>,
> please let us know if you prefer to get feedback via pull requests or any
> other means.
>
> Regards,
>   Andrea.
>
> --**--**-
> To unsubscribe, e-mail: 
> dev-unsubscribe@openoffice.**apache.org
> For additional commands, e-mail: dev-h...@openoffice.apache.org
>
>

silgraphite dependency?

[Fred Ollinger]

I'm building this now.

I think that perhaps this was dropped.

My goal is to first build aooo 3.3 rpm (last srpm) then to build 4.0 latest.

Anyone want this if it works?

Fred

silgraphite dependency

[Fred Ollinger]

On Tue, Apr 9, 2013 at 10:14 AM, Rob Weir  wrote:

> On Tue, Apr 9, 2013 at 1:10 PM, janI  wrote:
>
> > On Apr 9, 2013 7:05 PM, "Rob Weir"  wrote:
> > >
> > > On Tue, Apr 9, 2013 at 1:00 PM, janI  wrote:
> > >
> > > > On Apr 9, 2013 6:47 PM, "Rob Weir"  wrote:
> > > > >
> > > > > We talked previously about putting out an update notification for
> OOo
> > > > 3.3.0
> > > > > users, to make sure they are aware of AOO 3.4.1, and that if their
> > > > language
> > > > > is not yet translated, let them know how they can help.
> > > > >
> > > > > My proposed landing page is here:
> > > > > http://www.openoffice.org/projects/untranslated.html
> > > > >
> > > > > Since we don't have a lot of time remaining for translation, I
> > focused on
> > > > > the languages that are more than 90% complete.
> > > > >
> > > > > Let me know if there are any needed changes to that page.
> > > > I like the page, but would it be possible to have link or something
> to
> > a
> > > > full list of languages, and maybe sort the list.
> > > >
> > > >
> > > I link to Pootle in the last paragraph, and the user can then sort it
> > > however they want.  Note that points to the 3.4 project in Pootle.  I
> > don't
> > > see anything for 4.0.
> > >
> > >
> > > > you miss danish and german at least, remember we have new texts for
> 4.0
> > so
> > > > no language is 100%.
> > > >
> > >
> > >
> > > Yes, but that will be a different communication via the L10n list, for
> > > languages where we already have translators.  My main focus here is to
> > > reach out via new means to those who, we have not been successful
> > reaching
> > > in other ways.  We'll need to try a few things, mailing list, blog
> post,
> > > etc.
> >
> > hmmm as far as I know there are no danish translators, our long delay
> with
> > 3.4.1 costed motivation.
> >
> >
> Regardless, this page is for languages not supported in AOO 3.4.1.  Thus
> the opening paragraph mentioning that they are running an older version of
> OpenOffice.org.We'll reach out to translators for Danish and other
> languages already supported via other means.  It will be far easier to
> motivate existing translators familiar with the process than to onboard
> someone who has never done this kind of thing before. So it does not make
> sense to recruit for Danish via a universal appeal, at least not initially.
>
> -Rob
>
>
>
> > rgds
> > jan i.
> > >
> > > Regards,
> > >
> > > -Rob
> > >
> > >
> > >
> > > > rgds
> > > > jan i
> > > > >
> > > > > Otherwise, I'd work with Oliver to get a link to this page sent to
> > > > clients
> > > > > via an update notification, for OOo 3.3.0 users  who are using one
> of
> > the
> > > > > highlighted languages.
> > > > >
> > > > > Regards,
> > > > >
> > > > > -Rob
> > > >
> >
>

Re: SRPM Request

[Fred Ollinger]

I did not.

>From rereading your email, you seem ahead of me.

Didn't want to give the wrong impression.

I'll try your epm stuff when I get a chance on fedora rawhide.

Fred

On Thu, Mar 28, 2013 at 10:14 AM, Ariel Constenla-Haile
 wrote:
> Hi Fred,
>
> On Thu, Mar 28, 2013 at 08:58:07AM -0700, Fred Ollinger wrote:
>> I built an epm package and can send it to you if you like or whatever.
>> I have a spec as well.
>
> Did you create a single spec to build the rpms for the whole office?
> This would be nice, to see how you managed the obsoletes, and split the
> packages. Unfortunately, with the exception of the desktop-integration
> packages, we cannot use rpm/dpkg directly; the code defines the list of
> files to be included in a home-made, cross-platform way, on
> trunk/main/scp2; then you have the files that bind the definitions in
> scp2 with a rpm/deb package, in main/setup_native/source/packinfo/, the
> format is described here
> http://opengrok.adfinis-sygroup.org/source/xref/aoo-trunk/main/setup_native/source/packinfo/packinfo_office.txt#22
>
> The package information is the same for RPMs and DEBs. At the end, the
> build environment puts all these peaces together, generates a package
> configuration file and calls EPM.
>
> As you see, the process is cumbersome and not very easy to
> understand/manage.
>
>
> Regards
> --
> Ariel Constenla-Haile
> La Plata, Argentina

-
To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org
For additional commands, e-mail: dev-h...@openoffice.apache.org

Re: SRPM Request

[Fred Ollinger]

I built an epm package and can send it to you if you like or whatever.
I have a spec as well. Just email me in private.

Fred

On Thu, Mar 28, 2013 at 8:24 AM, Ariel Constenla-Haile
 wrote:
> On Thu, Mar 28, 2013 at 03:36:19PM +0100, Jürgen Schmidt wrote:
>> On 3/28/13 2:09 PM, Ariel Constenla-Haile wrote:
>> > Hi Kay,
>> >
>> > On Mon, Dec 10, 2012 at 09:27:30AM -0800, Kay Schenk wrote:
>> >>> No. The spec are generated at build time and removed once each
>> >>> package each built, so there is no way to get the spec from the
>> >>> build (besides, those spec are generated at runtime and are
>> >>> dependent on configure switches).
>> >>
>> >> On this matter -- identification of spec files for Linux
>> >> packages. I have looked in vain for about 2 weeks on this as
>> >> well. I found the specs for the desktop integrations but this is
>> >> after the fact -- not the actual specs for most of the install.
>> >
>> > Hacking EPM allowed me to keep them after the package is built:
>> > http://people.apache.org/~arielch/specs.tar.gz (this is only for
>> > RPMs, didn't look at the DEB stuff yet).
>> >
>> > The spec files are rather simple, nothing you won't get by querying
>> > rpm passing it a rpm package.
>> >
>> > Linux installation is broken:
>> > https://issues.apache.org/ooo/show_bug.cgi?id=121968 so any help
>> > would be appreciated.
>>
>> a good question but my knowledge about linux package manager is limited.
>>
>> We have a new major version and a new name. I hope we can agree that
>> we want both, especially the new name (the version is straight forward).
>
> What I've learned from the previous versions is that we need the version
> out of the package name, otherwise openoffice4.0 is a different package
> than openoffice4.1, and so on, see 
> http://markmail.org/message/t76ag6tco4kpkopd
>
>
>> The question is indeed how we can solve this. Is there a way to
>> provide a package or some dependencies that removes older or other
>> packages. Something that we can provide additionally?
>>
>> Or a special openoffice.org cleanup package.
>
> Most all of these is possible. EPM has support for Provides, Requires,
> Obsoletes, Conflicts (see rpm.c in the epm source package).
>
> The build environment has partial support for this via "linuxreplaces",
> as explained in the mail above
> (main/solenv/bin/modules/installer/packagelist.pm has to be patched).
>
> The desktop-integration packages are more easy, because there is no epm
> in the middle, just spec files.
>
>
>> Who has more knowledge about rpm/debs and can provide more info?
>
> I'm familiar with RPM, but about Debian packaging don't know much
> (almost nothing).
>
> The other problem is that all Linux users here, AFAIK, are using rpm-based
> distributions (Ricardo, Andrea, Kay, me). This can be solved by
> a virtual machine for testing.
>
> Real work and testing on this has to wait for your integration of the
> 1-layer installation; so, the sooner you commit it on trunk, the better.
> Do you have an estimated date?
>
>
> Regards
> --
> Ariel Constenla-Haile
> La Plata, Argentina

-
To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org
For additional commands, e-mail: dev-h...@openoffice.apache.org

Re: questions about Base---do we need an embedded DB?

[Fred Ollinger]

What was the original problem that we are trying to solve?

>From what I can gather we have no idea how many people use Base.
There's speculation that it's small, but unless it's measured, what
does this mean? Also, there are some people who think that Base works
for them and that it's critical for them to have.

Perhaps things are good as is regarding the db?

Fred

On Wed, Mar 27, 2013 at 1:57 PM, Kay Schenk  wrote:
> On Wed, Mar 27, 2013 at 11:01 AM, Donald Whytock  wrote:
>
>> Just tossing this out...It seems Apache Derby is the one SQL-based
>> DBMS in the Foundation.  It's actively maintained, and, while it's
>> written in Java, it still works in a client/server model and is
>> therefore probably launchable.
>>
>> Since it's in the family and all, perhaps it can be bundled with OOo,
>> if Base can be structured to use it?
>>
>> Don
>>
>
> Well Derby does seem to be "embed-able ". See:
>
> http://db.apache.org/derby/papers/DerbyTut/embedded_intro.html
>
> This has been suggested before, as early as 2006. See:
>
> http://markmail.org/message/kp5n2d5yzhprgpjm
>
> Still, is any embedded DB  a good thing? Pros and cons...
>
>
>> -
>> To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org
>> For additional commands, e-mail: dev-h...@openoffice.apache.org
>>
>>
>
>
> --
> 
> MzK
>
> "Achieving happiness requires the right combination of Zen and Zin."

-
To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org
For additional commands, e-mail: dev-h...@openoffice.apache.org

Re: questions about Base---do we need an embedded DB?

[Fred Ollinger]

Perhaps a survey question could be regarding this. How many people use
it? What features do they use? What features do they want. To MS
Access users, it could be, feature(s) would get you to switch to AOOO
for all DB needs?

Fred

On Mon, Mar 25, 2013 at 4:39 PM, Ariel Constenla-Haile
 wrote:
> Hi Kay,
>
> On Mon, Mar 25, 2013 at 03:58:06PM -0700, Kay Schenk wrote:
>> Well no doubt this may start a rather heated discussion.
>
> One of my favorites quotes about Base is from Andreas Säger (villeroy on
> the forums):
>
> "The difference between MS Access and Base amounts to several millions of
> Dollars and more than one decade of development time.
>
> Once you got used to MS Access, it is rather unlikely that you will ever
> be able to work with any other set of database utilities.
>
> I wish the AOO team had the balls to remove all the experimental trash
> while keeping bare important database connectivity for the pros. Since
> 2006 the whole concept of Base with the embedded HSQLDB and wizards is
> proven to be completely wrong, wrong, wrong."
>
> http://markmail.org/message/izhtpii5li57lnjn
>
>> I don't really know who the author is, but, I too, had been giving this a
>> great deal of thought. Does a user know what any of this really means, for
>> example. And, including an embedded DB like HSQL puts added responsibility
>> for that embedded DB on this project.  What if Base were  strictly  a
>> front-end?
>>
>> So, does anyone have any further insights into how many users, if any,
>> directly use Base to create and use their own individual DBs as opposed to
>> using the "front-end" capabilities?
>
> This is hard too guess. The majority of AOO users are Windows users, so
> you can asume that the "average user" that tries Base with a MS Office
> background, is looking for something like MS Access. I guess this was
> what drove Sun to create the ODB file with embedded db inside. With such
> an expectation, no wonder this average user gets frustrated with Base.
>
>
> For the whole topic, though it might be interesting to discuss it, IMHO
> it is completely pointless: look at the history in
>
> trunk/main/connectivity
> trunk/main/dbaccess
> trunk/main/reportdesign
> trunk/main/reportbuilder
>
> if there is no one to maintain the code, it will end up being dead code,
> so it's not a matter of "having the balls" (at least not *just* this);
> it's a matter of knowing the code, or willing to learn it and work on it
> (be it for removing Base embedded completely, or for fixing Base bugs,
> or developing Base features).
>
> Many mails can be written discussing dropping embedded HSQLDB engine,
> but at the end who will do this?
>
> Given that the not-so-difficult bug for building with Java 7 (it has
> even the explanation from the HSQLDB developer on the bug, telling how
> to fix it) didn't find someone to take care of him, removing HSQLDB
> seems something unrealistic. Just let it die.
>
>
> Regards
> --
> Ariel Constenla-Haile
> La Plata, Argentina

-
To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org
For additional commands, e-mail: dev-h...@openoffice.apache.org

Re: building rpms for fedora rawhide

[Fred Ollinger]

May I please an account?

I'm building on fedora now. I'd like to point the first page to the second.

Also, I do now have some minor updates.

Sincerely,

Fred

On Thu, Mar 21, 2013 at 5:09 AM, Andrea Pescetti  wrote:
> On 20/03/2013 Kay Schenk wrote:
>>
>>
>> http://wiki.openoffice.org/wiki/Documentation/Building_Guide_AOO/Building_on_Linux
>> or maybe you could update some of the Fedora information when you get a
>> moment?
>
>
> Actually, we have a dedicated page too:
> http://wiki.openoffice.org/wiki/Fedora_Build_Instructions
>
> It's just one of many redundancies in the wiki, probably... but the latter
> is more specific and more up-to-date in general.
>
> Regards,
>   Andrea.
>
>
> -
> To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org
> For additional commands, e-mail: dev-h...@openoffice.apache.org
>

-
To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org
For additional commands, e-mail: dev-h...@openoffice.apache.org

Re: building rpms for fedora rawhide

[Fred Ollinger]

Ug, I wish I did this earlier.

I don't have anything to add at this time. But I'll update this next
time I find a new wrinkle in fedora rawhide that we need.

At this point, I'm working on aooo build deps for fedora.

Fred

On Wed, Mar 20, 2013 at 10:02 AM, Kay Schenk  wrote:
> On Tue, Mar 19, 2013 at 10:03 AM, Fred Ollinger  wrote:
>
>> I don't know where this is at, but I heard that people wanted this.
>>
>> So far, I have a spec file for dmake. I need to fix a few errors and
>> warnings, but it does make an rpm which works.
>>
>> I'm keeping my work here:
>>
>> https://github.com/fredollinger/aooo-fedora-rawhide
>>
>> Next move is an rpm for esp.
>>
>> Then I'll move on to aooo.
>>
>> If this is pointless, please don't let me know. I want to learn to
>> build rpms, etc.
>>
>> If there's something else that I can do which is just as easy, but
>> more pressing, please let me know.
>>
>> sincerely,
>>
>> Fred
>>
>> -
>> To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org
>> For additional commands, e-mail: dev-h...@openoffice.apache.org
>>
>>
> This is great to know really!
>
> Would you mind if this information was added to our current Linux Building
> information:
>
> http://wiki.openoffice.org/wiki/Documentation/Building_Guide_AOO/Building_on_Linux
>
> or maybe you could update some of the Fedora information when you get a
> moment?
>
>
>
> --
> 
> MzK
>
> "Achieving happiness requires the right combination of Zen and Zin."

-
To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org
For additional commands, e-mail: dev-h...@openoffice.apache.org

building rpms for fedora rawhide

[Fred Ollinger]

I don't know where this is at, but I heard that people wanted this.

So far, I have a spec file for dmake. I need to fix a few errors and
warnings, but it does make an rpm which works.

I'm keeping my work here:

https://github.com/fredollinger/aooo-fedora-rawhide

Next move is an rpm for esp.

Then I'll move on to aooo.

If this is pointless, please don't let me know. I want to learn to
build rpms, etc.

If there's something else that I can do which is just as easy, but
more pressing, please let me know.

sincerely,

Fred

-
To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org
For additional commands, e-mail: dev-h...@openoffice.apache.org

Re: [tdf-discuss] macro compatibility between LO and AOO?

[Fred Ollinger]

I know that there were reasons for the fork and I respect that. I was
wondering if libreoffice and aooo can't agree to some basic level api
for 3rd party developers?

Probably not, but I think it's worth asking.

Fred

On Tue, Mar 5, 2013 at 8:28 AM, Keith Curtis  wrote:
> On Mon, Mar 4, 2013 at 1:46 AM, Fernand Vanrie  wrote:
>> On 4/03/2013 8:27, M. Fioretti wrote:
>>>
>>> On Mon, Mar 04, 2013 08:16:25 AM +0100, Fernand Vanrie wrote:
>>>
 99% percent , changes comes and will come from incompatiliteis in de API.
 for now this is OK, small changes from version to version, but
 nothing who not can been repaired or handled with the code( basic)
 itself
>>>
>>> I knew that. The sense of my question is, is there is a list of things
>>> to avoid beforehand, rather than wait that they break and fix the
>>> code?
>>
>> thats more a question for the developers list .
>> libreoff...@lists.freedesktop.org  and fore the aOO counterpart
>> ooo-...@incubator.apache.org
>>
>>>
>>> Thanks,
>>> Marco
>
> The reason why nobody responded is no one knows, and it will generally
> get worse over time as the codebases diverge. It is sort of like the
> Java: "write once, test everywhere" situation.
>
> One of the unintended consequences of the fork is the various ways it
> makes things more difficult for third-parties. Users will generally
> pick one product, but extension developers have a more complicated set
> of choices because they may want to support multiple brands. Here is
> an article I recently wrote about the power of brands that may be
> helpful: http://keithcu.com/wordpress/?p=3163
>
> The good news is that in the free software world, code flows with less
> friction. Any typical (non-enterprise) who really wants an extension
> will likely be able to install a specific version of the product if it
> is required. It is just a download.
>
> Good luck!
>
> Regards,
>
> -Keith
>
> -
> To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org
> For additional commands, e-mail: dev-h...@openoffice.apache.org
>

-
To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org
For additional commands, e-mail: dev-h...@openoffice.apache.org

Re: oracle java7 build bug

[Fred Ollinger]

Below is the list to the patch I spoke of which seems better than the
one I sent b/c this one fixes the ant build file as well.

When I applied it, it only patched: patches/jdbc-4.1.patch which is cool.

But now I can not apply this patch as it is rejected.

Any ideas on how the patches directory should be processed? I assumed
it was automatic, but it's not.

I'd like to test this patch to move forward w/ building on java7, but
to _target_ java 1.5 as Ariel said.

Sincerely,

Fred

On Fri, Feb 15, 2013 at 11:09 AM, Pedro Giffuni  wrote:
> Hello Fred;
>
> This doesn't seem related to the jdk7 issue, I think someone else
> reported the same glib issue in Ubuntu.
>
> FWIW, in FreeBSD we have AOO building with jdk7 too.
> http://www.freebsd.org/cgi/cvsweb.cgi/ports/editors/openoffice-3-devel/files/
>
>
> We even carry a patch for issue 121098
>
> Cheers,
>
> Pedro.
>
>
> - Messaggio originale -
>> Da: Fred Ollinger 
>> A: dev@openoffice.apache.org
>> Cc:
>> Inviato: Venerdì 15 Febbraio 2013 13:49
>> Oggetto: oracle java7 build bug
>>
>>T his is using the patch that I had created last week which gets us
>> past the hsqldb java7 compile errors:
>>
>> Entering /mnt/lfs/sources/ubuntu/local_dev300/vcl/prj
>>
>> cd .. && make -s -r -j1
>> make: *** No rule to make target
>> `/usr/include/glib-2.0/glib/gcache.h', needed by
>> `/mnt/lfs/sources/ubuntu/local_dev300/solver/300/unxlngi6.pro/workdir/CxxObject/vcl/unx/gtk/a11y/atkaction.o'.
>> Stop.
>> dmake:  Error code 2, while making 'all'
>>
>> 1 module(s):
>> vcl
>> need(s) to be rebuilt
>>
>> Reason(s):
>>
>> ERROR: error 65280 occurred while making
>> /mnt/lfs/sources/ubuntu/local_dev300/vcl/prj
>>
>> Attention: if you fix the errors in above module(s) you may prolongue
>> your the build issuing command:
>>
>> build --all:vcl
>>
>> I'm on ubuntu 11.04.
>>
>> Fred
>>

Re: java 7 patch

[Fred Ollinger]

I think that Pedro pointed out that this is redundant as there all
ready is a patch that fixes this and more issues.

I was going to eventually grab Pedro's linked patch and test it on a
fresh install.

At any rate, I suggest that you apply one of the java fixes (mine or
the other one, I don't care which) soon if we are really going to drop
java6 like others had told me.

Sincerely,

Fred

On Tue, Feb 19, 2013 at 5:20 AM, Rob Weir  wrote:
> On Mon, Feb 11, 2013 at 12:41 PM, Rob Weir  wrote:
>> On Thu, Feb 7, 2013 at 2:32 PM, Fred Ollinger  wrote:
>>> To whom it may concern,
>>>
>>> Below is a patch to fix some java7 compilation bugs. Also, this is attached.
>>>
>>
>> Thanks for the patch, Fred!
>>
>> I've created a Bugzilla issue for this, so we don't lose track of it.
>>  I also added you to the cc list for the report, so you will be
>> notified when its status changes.
>>
>> https://issues.apache.org/ooo/show_bug.cgi?id=121754
>>
>
> Is someone able to review this patch?  It is good encouragement to
> review and integrate patches quickly.   If you can do it soon, but not
> right now, you could just assign the BZ to yourself:
>
> https://issues.apache.org/ooo/show_bug.cgi?id=121754
>
> Thanks!
>
> -Rob
>
>
>>
>> Regards,
>>
>> -Rob
>>
>>
>>> Index: hsqldb/jdbcDriver.java
>>> ===
>>> --- hsqldb.orig/jdbcDriver.java 2013-02-07 09:17:01.0 -0800
>>> +++ hsqldb/jdbcDriver.java  2013-02-07 09:17:32.0 -0800
>>> @@ -31,6 +31,11 @@
>>>
>>>  package org.hsqldb;
>>>
>>> +//#ifdef JAVA7
>>> +import java.sql.SQLFeatureNotSupportedException;
>>> +import java.util.logging.Logger;
>>> +//#enddif JAVA7
>>> +
>>>  import java.sql.Connection;
>>>  import java.sql.Driver;
>>>  import java.sql.DriverManager;
>>> @@ -121,6 +126,12 @@
>>>   */
>>>  public class jdbcDriver implements Driver {
>>>
>>> +//#ifdef JAVA7
>>> +public Logger getParentLogger() throws SQLFeatureNotSupportedException 
>>> {
>>> +  throw new SQLFeatureNotSupportedException();
>>> +}
>>> +//#endif JAVA7
>>> +
>>>  /**
>>>   *  Attempts to make a database connection to the given URL. The driver
>>>   *  returns "null" if it realizes it is the wrong kind of driver to
>>> @@ -321,4 +332,8 @@
>>>  DriverManager.registerDriver(new jdbcDriver());
>>>  } catch (Exception e) {}
>>>  }
>>> +
>>> +public boolean isCloseOnCompletion() { return false; }
>>> +
>>>  }
>>> +
>>> Index: hsqldb/jdbc/jdbcCallableStatement.java
>>> ===
>>> --- hsqldb.orig/jdbc/jdbcCallableStatement.java 2013-02-07
>>> 09:55:57.0 -0800
>>> +++ hsqldb/jdbc/jdbcCallableStatement.java  2013-02-07 
>>> 09:57:17.0 -0800
>>> @@ -302,6 +302,14 @@
>>>  public class jdbcCallableStatement extends jdbcPreparedStatement
>>>  implements CallableStatement {
>>>
>>> +//#if JAVA7
>>> +public  T getObject(String s, Class T) throws SQLException
>>> { throw new SQLException(); }
>>> +public  T getObject(int i, Class T) throws SQLException {
>>> throw new SQLException(); }
>>> +public boolean isCloseOnCompletion() {
>>> + throw new UnsupportedOperationException("Not supported yet.");
>>> +}
>>> +//#endif JAVA7
>>> +
>>>  /** parameter name => parameter index */
>>>  private IntValueHashMap parameterNameMap;
>>>
>>> @@ -3373,11 +3381,6 @@
>>>  {
>>>  throw new UnsupportedOperationException("Not supported yet.");
>>>  }
>>> -//#endif JAVA6
>>> -
>>> -//#if JAVA7
>>> -[javac] 
>>> /mnt/lfs/sources/ubuntu/old/local_dev300/hsqldb/unxlngi6.pro/misc/build/hsqldb/src/org/hsqldb/jdbc/jdbcCallableStatement.java
>>> :302: error: jdbcCallableStatement is not abstract and does not
>>> override abstract method getObject(String,Class) in
>>> CallableStatement
>>> -
>>> -//#endif JAVA7
>>>
>>> +//#endif JAVA6
>>>  }
>>> Index: hsqldb/jdbc/jdbcConnection.java
>>> 

oracle java7 build bug

[Fred Ollinger]

This is using the patch that I had created last week which gets us
past the hsqldb java7 compile errors:

Entering /mnt/lfs/sources/ubuntu/local_dev300/vcl/prj

cd .. && make -s -r -j1
make: *** No rule to make target
`/usr/include/glib-2.0/glib/gcache.h', needed by
`/mnt/lfs/sources/ubuntu/local_dev300/solver/300/unxlngi6.pro/workdir/CxxObject/vcl/unx/gtk/a11y/atkaction.o'.
 Stop.
dmake:  Error code 2, while making 'all'

1 module(s):
vcl
need(s) to be rebuilt

Reason(s):

ERROR: error 65280 occurred while making
/mnt/lfs/sources/ubuntu/local_dev300/vcl/prj

Attention: if you fix the errors in above module(s) you may prolongue
your the build issuing command:

build --all:vcl

I'm on ubuntu 11.04.

Fred

Re: Updating Java libraries

[Fred Ollinger]

Relying on jars, IMHO, is not bad, but it depends on your goals.

The point of compiling from source is that it's a first step to
actually being a developer which is why I do it. Compiling problems
aren't problems for us new developers they are puzzles to solve to
help people out.

If there are changes needed to the jars, we need to recompile. For a
build where I don't modify the jar, I'd prefer to just fetch it b/c
it's way faster. Also, where does compiling from source end. That is,
we all rely on someone else's compiling some of our software (unless
our name is Theo, I guess). :)

Fred

On Tue, Feb 12, 2013 at 7:28 PM, Ariel Constenla-Haile
 wrote:
> Hi Michael,
>
> On Tue, Feb 12, 2013 at 09:59:02PM -0500, Michael Lam wrote:
>> On 02/12/2013 12:01 AM, Ariel Constenla-Haile wrote:
>> >On Mon, Feb 11, 2013 at 11:37:35PM -0500, Michael Lam wrote:
>> >>I have updated the external_deps.lst with the updated hsqldb
>> >>information. If someone can give me some pointer into how to just
>> >>retrieve the jar instead of the source
>> >You don't retrieve precompiled stuff. The logic is:
>> >
>> >a) don't include the dependency at all
>> >
>> >b) include the dependency
>> >
>> >b.1) build it from source
>> >
>> >b.2) use the precompiled version in the system (this switch is only for
>> >external packagers, the builds are release with no system [configurable]
>> >dependencies).
>> >
>> >
>> >Regards
>> I am still a little confused. Obviously it is possible to build from
>> source but as a lot of email on the list have shown it could cause
>> issues with the build that is not directly related to the AOO code.
>> Why not just retrieve the jar so the build is inclusive?
>
> I don't know what motivated these rules, but I guess it was something in
> the lines of having control about what is being compiled and how it is
> being compiled (the use of the compiler, the Java base line, etc.).
>
> 35 million of downloads are worth not relaying on a jar built by someone
> else and, instead, build it from sources.
>
>
>> I am used to retrieving compiled jars on the projects I worked on, in
>> Java there is maven and ivy to retrieve specific version of the jar
>> that the project is tested on along with the dependencies.
>
> But it is still trusting in a binary built by someone else. Every
> project is free to trust or build from sources. Historically, OpenOffice
> builds from external sources and includes these binaries in its
> releases, it has no external dependencies (other than the system
> libraries). The configure switches that allow building with system
> libraries/jars are only supported on *nix, and even there they are not
> relaying on a jar built by someone else: Linux distributions, for
> example, build all their jars; why do they build all by themselves
> instead of fetching compiled jars? I've no idea, but I guess they follow
> the same criteria mentioned above (as a Linux user you can use Maven in
> your projects, but it won't modify the system's jars).
>
>
> Regards
> --
> Ariel Constenla-Haile
> La Plata, Argentina

Re: Calc behavior: result of 0 ^ 0

[Fred Ollinger]

I love it. I'd prefer a warning rather than silently giving me 1 even
if I had that in the past.

Another idea is to return 1, but have a popup which says: "We are
returning 1 to 0^0 due to backwards compatability, but we this might
change in the fure. Click here to never show this warning again and
continue to return 1. Also, you can use strict (or whatever) to flag
these warnings as errors."

Fred

On Mon, Feb 11, 2013 at 3:04 PM, Dennis E. Hamilton  wrote:
> My apologies.  I replied to the wrong message, so the context was lost.  I 
> was responding to a statement that "0^0 = 1" is not wrong mathematically.  I 
> wanted to point out that is misleading, because it is also not right 
> mathematically.  POWER(x,y) implements an arithmetic function, and I agree 
> that is not a mathematical usage.
>
> I rose to object based on this statement:
>
> "But returning 1 for 0^0 is not wrong.  It is not wrong mathematically.
>  It is not wrong per the ODF 1.2 standard."
>
> (I think there are strings attached to the ODF 1.2 case and those strings 
> need to be tied, as has already been discussed.)
>
> To make amends for the diversion, I also want to offer my +1 for the 
> following which I did not see the first time:
>
> "An interesting option would be to enable a "strict" or "audit" mode of
> calculation where all error-prone expressions are reported to the
> user.  This mode would be slower than a normal calculation, but would
> allow us to point out things like:
>
> "1) Use of implementation-defined formulas that might impact
> interoperability (0^0 is one example, but there are several others)
>
> "2) Dependency on automatic string to number conversion operations that
> might be interpreted differently in different locales.
>
> "3) Operations that involve exact comparisons of results to constant
> floating numbers, something that is very risky due to round-off errors
> and precision limitations.
>
> "4) String operations that silently returned reasonable values despite
> parameters that exceeded the bounds of the string."
>
> -Original Message-
> From: Rob Weir [mailto:robw...@apache.org]
> Sent: Monday, February 11, 2013 14:30
> To: dev@openoffice.apache.org; dennis.hamil...@acm.org
> Subject: Re: Calc behavior: result of 0 ^ 0
>
> On Mon, Feb 11, 2013 at 5:24 PM, Dennis E. Hamilton
>  wrote:
>> This is not a vote.  There is a statement about what is acceptable 
>> mathematically that I cannot leave unchallenged.  However, that is different 
>> than what might or might not be acceptable computationally for a give case 
>> and I continue to refrain from reiterating any argument about that.
>>
>>  - Dennis
>>
>> MATHEMATICAL RIGHT/WRONG-NESS
>>
>> I'm sorry, I will not accept that 0^0 = 1 as a definition is "not wrong 
>> mathematically."  It is not right mathematically either.  That it is 
>> convenient to assume 0^0 = 1 in certain contexts of mathematical 
>> *application* is different than making it part of the laws of number theory.
>>
> [ ... ]
>>
>
> If OpenOffice were a theorem proving system and we put in 0^0 ==1 as
> an axiom, then you might have a point there.   But it isn't.  The only
> entity making logical conclusions and extrapolating to other
> mathematical problems from the behavior of POWER() is the user.  So
> your concern is not really valid in this context.
>
> -Rob
>
> [ ... ]
>

Re: Updating Java libraries

[Fred Ollinger]

OK, I won't build with java6 anymore then.

Fred

On Mon, Feb 11, 2013 at 12:30 PM, Fernando Cassia  wrote:
> On Mon, Feb 11, 2013 at 3:13 PM, Fred Ollinger  wrote:
>
>> Haha, I don't know. I could be wrong.
>
>
> OpenJDK 7 is the current version, OpenJDK 8 is coming along nicely.
>
> OpenJDK 6 is the past. Yes, there' s been some RedHat volunteers saying
> they' ll keep releasing OpenJDK 6 updates and security fixes, but from a
> developers'  perspective it' s as unattractive as some .Net developer still
> using the Net 1.0 APIs... or a Java developer still using JDK 1.4 for that
> matter.
>
> Ubuntu: OpenJDK 7
> http://packages.ubuntu.com/oneiric/openjdk-7-jdk
>
> Fedora 18: OpenJDK 7
> http://pkgs.org/download/java-1.7.0-openjdk
>
> SUSE: OpenJDK 7
> http://software.opensuse.org/package/java-1_7_0-openjdk
>
> Debian: OpenJDK 7
> http://packages.debian.org/sid/openjdk-7-jre
>
> ArchLinux: OpenJDK 7
> https://www.archlinux.org/packages/extra/x86_64/jre7-openjdk/
>
> So, again: "we should also respect that many distros are probably going to
> ship java 6 for a while." = SciFi ?
>
> FC
>
>
>
> --
> During times of Universal Deceit, telling the truth becomes a revolutionary
> act
> Durante épocas de Engaño Universal, decir la verdad se convierte en un Acto
> Revolucionario
> - George Orwell

Re: Updating Java libraries

[Fred Ollinger]

Haha, I don't know. I could be wrong.

I'm not trying to start a debate, but I'm just trying help to get
things working on as many current distros as possible.

Best Wishes,

Fred

On Mon, Feb 11, 2013 at 12:08 PM, Fernando Cassia  wrote:
> On Mon, Feb 11, 2013 at 2:16 PM, Fred Ollinger  wrote:
>
>> but we should also
>> respect that many distros are probably going to ship java 6 for a
>> while.
>>
>
> for example?
>
> FC

Re: Updating Java libraries

[Fred Ollinger]

I'll help with testing java 6 and java 7 from Oracle.

I vote for keeping up with latest and greatest, but we should also
respect that many distros are probably going to ship java 6 for a
while.

Thus, we should probably work with both then officially deprecated
java6 when it's time.

Fred

On Mon, Feb 11, 2013 at 11:06 AM, Michael Lam  wrote:
> On 02/11/2013 01:16 PM, Kay Schenk wrote:
>>
>> On Mon, Feb 11, 2013 at 9:24 AM, Herbert Duerr  wrote:
>>
>>> Hi Michael,
>>>
>>>
>>> On 11.02.2013 17:21, Michael Lam wrote:
>>>
 I have successfully test hsqldb-2.2.9 against the following 4 issues and
 it is functioning correctly:

 https://issues.apache.org/ooo/**show_bug.cgi?id=96823

 https://issues.apache.org/ooo/**show_bug.cgi?id=103528

 https://issues.apache.org/ooo/**show_bug.cgi?id=104901

 https://issues.apache.org/ooo/**show_bug.cgi?id=97032

>>> Thanks a lot for investigating this!
>>
>>
>> yes, great news!
>>
>>
>>>
>>>   and I have looked at


 http://hg.services.openoffice.**org/cws/hsqldb19/

 Unless I am looking at this wrong, many of the changes are not related
 to hsqldb19 and it is already in the latest revision. As for the hsqldb
 specific, the patches does not apply to 2.2.9. As far as patches,
 wouldn't it be better to report upstream and provide the patch instead
 of just patching within the build?

>>> Definitely.
>>>
>>> In a linux distribution or a project such as ours with so many external
>>> dependencies there are good reasons not to always use the latest version
>>> of
>>> each component: That could easily result in endless churn and prevent
>>> releases. So backporting fixes is an alternative that should is often
>>> preferable. I don't know the background of the issues mentioned above
>>> that
>>> were fixed for HSQLDB but maybe they were such backports of fixes?
>>
>>
>> I thought the main reason for investigating the HSQLDB upgrade/change was
>> due to issues between java 6 and 7? we have some other patches submitted
>> to
>> help with that also. I could be wrong about this though.
>>
>>
>>
>>>
>>>   There are also checks within the code

 to specifically check for version 1.8.x, not sure  wouldn't it be better
 to enforce on configure/bootstrap? The current way seem to require a lot
 more work to update dependencies and the with-system-hsqldb for
 configure provides no warning.

>>> Using configure for checking this and cleaning up checks for obsoleted
>>> versions is a good plan. Please go ahead.
>>>
>>>
>>>   I will take a look at the open issues and see if it is resolved with
>>> the

 new version.

 I am guessing my next steps would be looking into updating the build to
 pull the jar?

>>> Better use the mechanism provided by main/external_deps.lst
>>>
>>> Herbert
>>>
>>
>>
> It is partially to address the JDK issue but there have been improvements in
> HSQLDB for both performance and conformance that would be helpful which is
> why I lean more towards updating to the latest rather than patching the
> existing. I understand it would be difficult to constantly update to the
> latest release of a dependent project both in a quality and release
> standpoint. With adequate planning and testing, the code should also allow
> for an update to the latest without too many gotchas.

Re: Open Office spreadsheet

[Fred Ollinger]

I don't have time now, but David has given me some great ideas on how
he uses macros. Anyone interested should ask for details.

It's nice to see an intelligent end user making detailed suggestions.

Again, I won't work on this now due to it's size, but I would like
oocalc to have a simpler macro language modeled on older ones which
makes macros easy for the savvy, but non-programmer user.

Sincerely,

Fred

On Fri, Feb 8, 2013 at 12:29 PM, Rob Weir  wrote:
> On Thu, Feb 7, 2013 at 1:40 PM, David A Yablonsky Sr
>  wrote:
>> I am, if not a spreadsheet power user, at least a spreadsheet developer,
>> since 1982. Having experienced Visicalc, Multiplan, Lotus and Lotus clones,
>> Quattro and Excel and others, I have come to the sad conclusion that
>> spreadsheet applications have become overdeveloped due to the influence of
>> Microsoft's programming philosophies.
>>
>> Specifically, Microsoft has demanded that Basic must be used to develop
>> macros in spreadsheets. For this reason, I use Quattro, which is apparently
>> the only spreadsheet to still use Lotus-style spreadsheet macros.
>>
>
> I remember reading in "Computer Languages" magazine (now defunct)
> around 1992 or so, the results of a survey of the most-common
> programming languages use in businesses.  It was not COBOL, C or
> BASIC.  The winner was the "1-2-3 macro language".  That language
> enabled end-user programming (or scripting, or whatever you want to
> call it).  You are right that today's apps concentrate more on
> capabilities for the professional programmer.
>
> I don't think this is because we're chasing after Excel.  Personally,
> I think it is because these interfaces tend to be developed by
> professional programmers.  So they tend to meet the needs of
> professional programmers.   Of course if we had always thought like
> that we wouldn't even have spreadsheets, since the spreadsheet itself,
> even without macros, is the tool that brought power to the masses, in
> the form of spreadsheet formulas.
>
> In any case, thanks for the reminder that end-user/power-user
> capabilities short of programming are important.
>
> Regards,
>
> -Rob
>
>
>> The linear style and modular storage of Basic-based macros limit the ability
>> of those users who are NOT programmers to develop useful complex macro
>> routines not only because of the requirement to become a Basic programmer,
>> but because there are actions available in Lotus-style macros that  make
>> Basic programming of the same actions a complicated nightmare.
>>
>> In addition, I deplore the loss of database construction and query in
>> contemporary spreadsheet applications. This is another reason I use Quattro.
>> I can create a relatively small database and then query it without knowing
>> SQL or using another application to query the database. What ever happened
>> to "keep it simple"? If one wants to only manage a database, Access or other
>> database applications are great, but if one wants to integrate a small
>> database with spreadsheet functions, you're out of luck.
>>
>> Spreadsheet applications all seem to want to compete with Excel, on the
>> assumption that they can garner a share of the market that Microsoft has
>> pretty much monopolized. As for me, this is wrong-headed, because if you
>> want to grab some market-share, your product should offer something
>> different than Excel; mainly, simplicity. Don't get me wrong, I use Excel
>> for many business applications. It's just that I find that for some of the
>> processes I perform on a daily basis, Excel simply can't perform due its
>> requirement that macros must be developed in Basic and the lack of ability
>> to query a limited internal database. I have downloaded Open Office and find
>> it to be on the path to Excel's blind alley. Too bad. What are needed are
>> some new views of what is really useful to the user, instead of chasing
>> Microsoft's arrogant "my way or the highway" philosophies.
>>
>>
>>
>> D. A. Yablonsky Sr.
>>
>>   truetax2...@gmail.com
>>
>> Phone: 951-279-7026
>>
>> Cell: 951-520-5187
>>
>>
>>
>>
>>

vlc build error (may be associated with java7)

[Fred Ollinger]

=
Building module vcl
=

Entering /mnt/lfs/sources/ubuntu/local_dev300/vcl/prj

cd .. && make -s -r -j1
[ build DEP ] LNK:Library/libvclplug_gtkli.so
make: *** No rule to make target
`/usr/include/glib-2.0/glib/gcache.h', needed by
`/mnt/lfs/sources/ubuntu/local_dev300/solver/300/unxlngi6.pro/workdir/CxxObject/vcl/unx/gtk/a11y/atkaction.o'.
 Stop.
dmake:  Error code 2, while making 'all'

I'm currently working on a patch to fix this, but I wanted mailing
list to be aware and to see if anyone is working on this.

1 module(s):
vcl
need(s) to be rebuilt

Reason(s):

ERROR: error 65280 occurred while making
/mnt/lfs/sources/ubuntu/local_dev300/vcl/prj

Attention: if you fix the errors in above module(s) you may prolongue
your the build issuing command:

build --all:vcl

java 7 patch

[Fred Ollinger]

To whom it may concern,

Below is a patch to fix some java7 compilation bugs. Also, this is attached.

Index: hsqldb/jdbcDriver.java
===
--- hsqldb.orig/jdbcDriver.java 2013-02-07 09:17:01.0 -0800
+++ hsqldb/jdbcDriver.java  2013-02-07 09:17:32.0 -0800
@@ -31,6 +31,11 @@

 package org.hsqldb;

+//#ifdef JAVA7
+import java.sql.SQLFeatureNotSupportedException;
+import java.util.logging.Logger;
+//#enddif JAVA7
+
 import java.sql.Connection;
 import java.sql.Driver;
 import java.sql.DriverManager;
@@ -121,6 +126,12 @@
  */
 public class jdbcDriver implements Driver {

+//#ifdef JAVA7
+public Logger getParentLogger() throws SQLFeatureNotSupportedException {
+  throw new SQLFeatureNotSupportedException();
+}
+//#endif JAVA7
+
 /**
  *  Attempts to make a database connection to the given URL. The driver
  *  returns "null" if it realizes it is the wrong kind of driver to
@@ -321,4 +332,8 @@
 DriverManager.registerDriver(new jdbcDriver());
 } catch (Exception e) {}
 }
+
+public boolean isCloseOnCompletion() { return false; }
+
 }
+
Index: hsqldb/jdbc/jdbcCallableStatement.java
===
--- hsqldb.orig/jdbc/jdbcCallableStatement.java 2013-02-07
09:55:57.0 -0800
+++ hsqldb/jdbc/jdbcCallableStatement.java  2013-02-07 09:57:17.0 
-0800
@@ -302,6 +302,14 @@
 public class jdbcCallableStatement extends jdbcPreparedStatement
 implements CallableStatement {

+//#if JAVA7
+public  T getObject(String s, Class T) throws SQLException
{ throw new SQLException(); }
+public  T getObject(int i, Class T) throws SQLException {
throw new SQLException(); }
+public boolean isCloseOnCompletion() {
+ throw new UnsupportedOperationException("Not supported yet.");
+}
+//#endif JAVA7
+
 /** parameter name => parameter index */
 private IntValueHashMap parameterNameMap;

@@ -3373,11 +3381,6 @@
 {
 throw new UnsupportedOperationException("Not supported yet.");
 }
-//#endif JAVA6
-
-//#if JAVA7
-[javac] 
/mnt/lfs/sources/ubuntu/old/local_dev300/hsqldb/unxlngi6.pro/misc/build/hsqldb/src/org/hsqldb/jdbc/jdbcCallableStatement.java
:302: error: jdbcCallableStatement is not abstract and does not
override abstract method getObject(String,Class) in
CallableStatement
-
-//#endif JAVA7

+//#endif JAVA6
 }
Index: hsqldb/jdbc/jdbcConnection.java
===
--- hsqldb.orig/jdbc/jdbcConnection.java2013-02-07 11:22:20.0 
-0800
+++ hsqldb/jdbc/jdbcConnection.java 2013-02-07 11:22:43.0 -0800
@@ -31,6 +31,10 @@

 package org.hsqldb.jdbc;

+//#ifdef JAVA7
+import java.util.concurrent.Executor;
+//#endif JAVA7
+
 //#ifdef JAVA2
 import java.sql.Array;
 import java.sql.Blob;
@@ -416,6 +420,21 @@
  * @see jdbcDatabaseMetaData
  */
 public class jdbcConnection implements Connection {
+//#ifdef JAVA7
+public void abort(Executor e){}
+public int getNetworkTimeout(){
+  throw new UnsupportedOperationException("Not supported yet.");
+}
+public void setNetworkTimeout(Executor e, int i ){
+  throw new UnsupportedOperationException("Not supported yet.");
+}
+public String getSchema() {
+   throw new UnsupportedOperationException("Not supported yet.");
+}
+public void setSchema(String s) {
+   throw new UnsupportedOperationException("Not supported yet.");
+}
+//#endif JAVA7

 //  Common Attributes --

Index: hsqldb/jdbc/jdbcDatabaseMetaData.java
===
--- hsqldb.orig/jdbc/jdbcDatabaseMetaData.java  2013-02-07
11:27:01.0 -0800
+++ hsqldb/jdbc/jdbcDatabaseMetaData.java   2013-02-07 11:27:03.0 
-0800
@@ -99,7 +99,7 @@
  * 
  * A method that gets information about a feature that the driver does not
  * support will throw an SQLException.
- * In the case of methods that return a ResultSet
+ * In the case of methods that eeturn a ResultSet
  * object, either a ResultSet object (which may be empty) is
  * returned or an SQLException is thrown.
  *
@@ -282,6 +282,13 @@
  */
 public class jdbcDatabaseMetaData implements DatabaseMetaData {

+//#ifdef JAVA7
+public ResultSet getPseudoColumns(String catalog, String
schemaPattern, String tableNamePattern, String columnNamePattern)
throws SQLException {throw new SQLException(); }
+
+public boolean generatedKeyAlwaysReturned(){ return false; }
+//#endif JAVA7
+
+
 /** Used by getBestRowIdentifier to avoid extra object construction */
 static final Integer INT_COLUMNS_NO_NULLS = new Integer(columnNoNulls);

@@ -5694,3 +5701,5 @@

 //#endif JAVA6
 }
+
+
Index: hsqldb/jdbc/jdbcDataSource.java
===
--- h

simple patch to get started

[Fred Ollinger]

Attached is a simple patch which should quiet some ant warnings.

Also, I'm trying to get this working with Oracle's Java 7.

local_dev300/hsqldb/unxlngi6.pro/misc/build/hsqldb/build/build.xml

Fred