Slow database access with jre 1.6u30

Hello,
Ever since I upgraded my Java Runtime Environment (JRE) from 1.6u11 to 
1.6u30, my database access is terribly slow.  My 280-record database 
data entry form now takes minutes to initialize, where with u11, it took 
seconds.  MySql logon also is noticeably slower.  I have already 
re-configured OO base to the new jre.  My database name is:   
"inventories?zeroDateTimeBehavior=convertToNull".  (I understand this 
was required to prevent errors with Null dates and times.)  The driver I 
am using is "com.mysql.jdbc.Driver".  With the exception of selecting 
the new jre, none of the configuration has changed from 6u11 and the new 
configuration "tests" okay.

Anyone else have this problem and know the solution?

Other data:
jre-1.6.0_u30
mysql-connector-java-5.1.12
mysql  5.0.67
OO.o  3.3.0 (OOO330m20 build 9567)
Slackware Linux 12.2 (K2.6.17)
KDE  3.5.10

TIA
Girvin Herr

--

-- 
-----------------------------------------------------------------
To unsubscribe send email to users-unsubscribe <at> dba.openoffice.org
For additional commands send email to sympa <at> dba.openoffice.org
with Subject: help

OSS Research Help Needed Please - drawing for tablet computer ($500.00 gift card) for participation.

Invitation to connect on LinkedIn

Memo-Fields (Longtext)

I have a problem with Memo-Fields (Longtext) using the MySQL-Connector 
for Openoffice (3.3.0).
No problem to write until a certain number of caracters either writing 
directly in the table view or in a form, where the lengh is set zero 
(0). But then, it stops me an I can't write more caracters. When I 
reload table or form, it is possible to write a fiew more caracters 
until it stops me again. No problem to record this in the DB. So I could 
each time lengthen the field reloading the form or the tableview.
If I load the table design there is not possible to change the lengh of 
the Memo-Field  indicated with -1 or 0.

May be, it's a Openoffice 3.3 - bug, but I did not notice the problem 
using HSQLDB.

Andreas
--

-- 
-----------------------------------------------------------------
To unsubscribe send email to users-unsubscribe <at> dba.openoffice.org
For additional commands send email to sympa <at> dba.openoffice.org
with Subject: help

Extensions site down, or systematically timing out ? Report Designer download

Hi all,

Can anyone tell me why when I try to download the Report Designer for
OOo from here :

http://extensions.services.openoffice.org/fr/project/reportdesign

the server keeps timing out ? You have to be really persistent to get
anywhere with any of the extensions these days, some of them just appear
to have disappeared completely ? Any new user coming to the extensions
site will probably just give up.

Alex

--

-- 
-----------------------------------------------------------------
To unsubscribe send email to users-unsubscribe <at> dba.openoffice.org
For additional commands send email to sympa <at> dba.openoffice.org
with Subject: help

Base Embedded Link Lost

When I opened my database, no tables, queries or forms were displayed. 
Rather than saying "Embedded" at the bottom of the window, it now says 
JDBC, and my data cannot be accessed.  I can't find any place to 
reestablish the link with the embedded database.

I am using Windows XP Media Center Edition, SP3 on a Dell Inspiron E1505 
computer with OpenOffice.org 3.3.0, OOO330m20 (Build:9567).

How can I re-establish a link to my database?

--

-- 
-----------------------------------------------------------------
To unsubscribe send email to users-unsubscribe <at> dba.openoffice.org
For additional commands send email to sympa <at> dba.openoffice.org
with Subject: help

OO Base and kerberos auth to postgresql

I have an .odb file with some forms. This file connects to (via sdbc) to
postgresql database. Authentication is done via gssapi. Under linux
everything works ok, but under windows I've got 

--8<---------------cut here---------------start------------->8---
Couldn't establish database connection to 'sdbc:postgresql:dbname=test
host=my.host' (authentication method 7 not supported
)
--8<---------------cut here---------------end--------------->8---

Linux Verision 3.2.1
Windows version 3.3.0 
Is this Oo issue? Java? Windows?
KJ

--

-- 
http://blogdebart.pl/2010/03/17/dalsze-przygody-swinki-w-new-jersey/
"Sęk w tym, że człowiek rozumny jest statystycznie głupi" - Stanisław Lem.

--
-----------------------------------------------------------------
To unsubscribe send email to users-unsubscribe <at> dba.openoffice.org
For additional commands send email to sympa <at> dba.openoffice.org
with Subject: help

email hyperlinks in a form

Received an interesting request from a user that stores contact 
information in a Base document. When stored in a Write or Calc document, 
OOo recognizes things such as an email address and converts it to a 
link. You can then click on the link to automatically open say your 
email software.

Now, if I store an email address as a field in Base, is there anyway 
that I can cause this to be treated as a link in a form (or similar).

In a pinch, I will write a macro that is called as an event handler for 
a button activation that will read the email field for the current 
record and invoke the default email software.  I would prefer to not 
write a macro, however.

--

-- 
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
Info:  http://www.pitonyak.org/oo.php

--
-----------------------------------------------------------------
To unsubscribe send email to users-unsubscribe <at> dba.openoffice.org
For additional commands send email to sympa <at> dba.openoffice.org
with Subject: help

Java set up

Hi,
It's about Ubuntu 10.4 with sun-java-1.6_24 (was _22) and 
openjdk-1.6_20, some Java based databases (H2 and mostly embedded 
HSQLDB) connected to Base 3.3.
Additional Java parameters in the OOo options: Xms256m, Xmx512m

The one and only Java version that used to work normally was 
sun-java-1.6_22 which I installed because the openjdk was slow.
Now my system upgraded to from sun-java-1.6_22 to _24 which causes 
apparently the same performance as the openjdk. Queries take many 
minutes where they used to take 15 seconds and editing subforms is a 
pain because you have to wait for some seconds after each record change. 
Is there any way to fix the problem by means of settings and parameters?
Off topic: If not, where do I get the older sun-java-1.6._22? Is ist 
true that Oracle packages do not support any apt install? I see rpm 
only. The rpm packages are not convertible to dpkg.
Thanks in advance,
Andreas Säger

--
-----------------------------------------------------------------
To unsubscribe send email to users-unsubscribe <at> dba.openoffice.org
For additional commands send email to sympa <at> dba.openoffice.org
with Subject: help

builtin func to extract date from datetime field

Hello everybody!

last evening I was trying to solve a tiny problem in base but didn't
succeed !! Could it be that there is no built-in function to extract the
date part of a datetime field??

I have to set up a query in OO-base like this one. In "mysql dialect" it
would be

SELECT DATE(`datetime-field`) AS `workdate`, SUM(`field-2`),
SUM(`field-3`), ....  FROM `Another-Query`
WHERE ....
GROUP BY `workdate`
ORDER BY `workdate` DESC

Couldn't find a proper way. Or am I just blind ??

Norbert
--
-----------------------------------------------------------------
To unsubscribe send email to users-unsubscribe <at> dba.openoffice.org
For additional commands send email to sympa <at> dba.openoffice.org
with Subject: help