Please assign the task to the one who introduced the configure switch !

sorry, i spoke on IRC with _rene_ to issue it like this, may be i missunderstood
something.

caolan and _rene_ (names of IRC channel) work on some --with-system-* switches
but I do not know who exactly did which switch.

-> cmc

ok, i copied my system's db.jar file and got this error:

java
-Djava.library.path=/var/tmp/portage/openoffice-cvs-20040829/work/OpenOffice/solver/680/unxlngi4.pro/lib
-cp
.:../../unxlngi4.pro/class:/opt/blackdown-jdk-1.4.2_rc1/jre/lib/rt.jar:.:/var/tmp/portage/openoffice-cvs-20040829/work/OpenOffice/solver/680/unxlngi4.pro/bin/jaxp.jar:/var/tmp/portage/openoffice-cvs-20040829/work/OpenOffice/solver/680/unxlngi4.pro/bin/parser.jar:/var/tmp/portage/openoffice-cvs-20040829/work/OpenOffice/solver/680/unxlngi4.pro/bin/xt.jar:/var/tmp/portage/openoffice-cvs-20040829/work/OpenOffice/solver/680/unxlngi4.pro/bin/unoil.jar:/var/tmp/portage/openoffice-cvs-20040829/work/OpenOffice/solver/680/unxlngi4.pro/bin/ridl.jar:/var/tmp/portage/openoffice-cvs-20040829/work/OpenOffice/solver/680/unxlngi4.pro/bin/jurt.jar:/var/tmp/portage/openoffice-cvs-20040829/work/OpenOffice/solver/680/unxlngi4.pro/bin/jut.jar:/var/tmp/portage/openoffice-cvs-20040829/work/OpenOffice/solver/680/unxlngi4.pro/bin/xmlsearch.jar:/var/tmp/portage/openoffice-cvs-20040829/work/OpenOffice/solver/680/unxlngi4.pro/bin/db.jar:/var/tmp/portage/openoffice-cvs-20040829/work/OpenOffice/solver/680/unxlngi4.pro/bin/xmlsearch.jar:/var/tmp/portage/openoffice-cvs-20040829/work/OpenOffice/solver/680/unxlngi4.pro/bin/xmlhelp.jar
com.sun.star.help.HelpLinker @/var/tmp/portage/openoffice-cvs-20040829/temp/mkWZy86c
Exception in thread "main" java.lang.UnsatisfiedLinkError: no db_java-3.2 in
java.library.path
        at java.lang.ClassLoader.loadLibrary(ClassLoader.java:1491)
        at java.lang.Runtime.loadLibrary0(Runtime.java:788)
        at java.lang.System.loadLibrary(System.java:834)
        at com.sleepycat.db.Db.load_db(Db.java:554)
        at com.sleepycat.db.Db.<clinit>(Db.java:574)
        at com.sun.star.help.HelpLinker.link(HelpLinker.java:327)
        at com.sun.star.help.HelpLinker.main(HelpLinker.java:207)
dmake:  Error code 1, while making '../../unxlngi4.pro/bin/schart_en-US.zip'
dmake:  '../../unxlngi4.pro/bin/schart_en-US.zip' removed.
'---* tg_merge.mk *---'

ERROR: Error 65280 occurred while making
/var/tmp/portage/openoffice-cvs-20040829/work/OpenOffice/helpcontent2/util/schart

we were discussing this at the conference recently, and are trying to get
agreement with Hamburg devel that using db4 as the default OpenOffice db would
be possible. If so then the various problems that rene outlines there would go away.

We'll revisit this when
http://www.openoffice.org/servlets/ReadMsg?list=dev&msgNo=12152 gets resolved.
If they move up to db4 then stuff gets a lot easier. 

*** Issue 34903 has been marked as a duplicate of this issue. ***

Apparently they're going to move to db4 alright. So we'll wait until they do and
then swoop down and make whatever configure db4 options we need and all will be
well.

linux sparc will not build on 680 with db3 but builds wih db4 OK. So I build 680
with db4 from SRX645_m52. i am not sure what to do, should i provide patches for
db4 or just wait? why is 680 still with db3 when 645 has db4?

i guess the Devs are very busy with all kind of stuff for OOo 2.0.
you may post DB4 patches for OOo 1.9 to test. at least for me ;)

Thanks!

geki: as joergB has explained for me, i am probably using some weird mixture of
system db plus the internal db4, anyway the patches which may be of interest are
at http://qa.openoffice.org/issues/show_bug.cgi?id=38008 but the value of these
is very doubtful...

Thanks! I will dig into them soon.

sparcmoz--> geki: in m66 the system-db libraries are defined in
solenv/inc/libs.mk. This is used in linking xmlhelp. for example:

.IF "$(SYSTEM_DB3)"=="YES"
BERKELEYLIB=-ldb-4
BERKELEYCPPLIB=-ldb_cxx-4
.ELSE
BERKELEYLIB=-ldb-4.3
BERKELEYCPPLIB=-ldb_cxx-4.3
.ENDIF

patches for using system db4 on linux sparc (debian) with SRC680_m68 are at
issue 38686. These are derived by trial-and-error but the help seems to work ok.

btw, Rene diff'ed OOo 1.1.3 to OOo 1.1.4 to get system db4 patchset for OOo 1.9
http://people.debian.org/~rene/openoffice.org/db-upgrade-and-system-db-680.diff

cmc, please update OOo 1.1.4 source to let office_config/configure.in find
Gentoo's system db4.2 files:

/usr/include/db$DB_VERSION (instead of db$DB_VERSION_MAJOR)
/usr/include/db4.2/db_cxx.h
/usr/lib/db-4.2.jar

Thanks all! :)

a) 1.1.x has to system-db (only ooo-build has) 
 
b) I don't like alpha patches (whose I even didn't test myself yet) be pasted 
to issues 
 
c) jars are architecture-independent. According to FHS they should be 
in /usr/share then.. Fix that ;-) I won't look for them in /usr/lib, the 
current check is to longish and ugly anyway. BTW, you know that there is 
--with-db-jar=...? 
 
d) wrt the includes I'll look 
 
(ah, and reassign to me) 
 
Regards, 
 
Rene 

s/to/no/ 

well, at least with your patch there is no --with-db-jar=... switch on
'./configure --help' or README :)

searching your patchset did not show up any db-jar thinggie either. may be i
just don't see it. ;)

forgot the cws full address of the bdb4 cws like cws_srx645_bdb4 is not there

bdb or db or db4 instead of bdb4 neither. EIS does not show it, still...

what is the status of solenv/inc/libs.mk ? is this the right way to do
wih-system-things or is it the bad way ?

sparcmoz: sorry, didn't see you already had patches :( 

> what is the status of solenv/inc/libs.mk ? is this the right way to do 
> wih-system-things or is it the bad way ? 
 
Should be OK to use. It has the advantage that necessary stuff is at one point. 
Although that is currently not consistent in whole office anyhow... 
 
Regards, 
 
Rene 

geki: 
 
~/ooo-build_ooo-build-1-3/patches/OOO_1_1> grep db-jar config-switches.diff 
+AC_ARG_WITH(db-jar, 
+[  --with-db-jar=JARFILE          Specify path to jarfile manually ], 

oh, and you of course are right, the AC_WITH_* is not included in that alpha 
patch (yet) ;) 

well, i just would love to see --with-system-db for db-4.2 in OO 2.0 :)
since when is system-db patch again in ximian? thought it was dropped?! well, it
was by some time... :/

ericb-> rene 

The following patch is the diff between 1.1.3 and 1.1.4 you send me *modified* 
with the change I proposed in
<http://qa.openoffice.org/issues/show_bug.cgi?id=37733>

I just use this to build SRC680_m71s1 on MAc OSX . If I remember correctly, I
have one or two other changes to add, because libdb_java wasn't correctly
delivered.  Next rebuild, I'll complete

 
Regards,

Created attachment 21767 [details]
diff for db4.2 in SRC680_m71s1 on MacOSX + modified with 37733

will fix it in cws systemdb

fixed in cws systemdb

Verified with Linux PPC (without Java) build, milestone m90s1, with following
action :

Tools -> Package manager...

I've choosen :
My Packages -> sqlite-sdbc-0.1.1.zip

3 entries are present, with given status :

DataAccess.xcu                  Enabled
sqlite-sdbc-impl.uno.so     Disabled
sqlite-sdbc.uno.so              Enabled

Following JoergB mind on IRC, means it works

-- 
eric bachard

give it a target...

closing...