gmane.comp.openoffice.dba.user

Re: Slow database access with jre 1.6u30

Girvin R. Herr — 2012-02-21T18:36:01

Zoltan,
Thanks very much for the information.  I will try it.  I usually opt for 
latest stable versions, but I guess this time it didn't work.  "He who 
lives on the cutting edge of technology gets sliced to bits." -  Adam 
Osborn.
It looks like the "dba-users" list is merging with the regular users 
list.  Do you know if that is true?
The reason I am still using this list is that I have changed my OO.o 
list subscriptions several times in the last few years as OO.o was 
transferred from one entity to another.  I am a bit tired of that, so 
now I am waiting for the incubator lists to stabilize into the final 
lists, so I only need to re-subscribe once.  Hopefully, that will be soon.
Thanks again.
Girvin


Reizinger Zoltán wrote:

Re: Slow database access with jre 1.6u30

Reizinger Zoltán — 2012-02-21T06:24:57

Hello,
This is a known bug in java under linux, use u22 which is a latest 
working version.
This mailing list will be closed soon, please use 
ooo-users< at >incubator.apache.org list for asking such question or use OOo 
community forum: http://user.services.openoffice.org/
Regards,
Zoltan

2012.02.20. 22:50 keltezéssel, Girvin R. Herr írta:

Slow database access with jre 1.6u30

Girvin R. Herr — 2012-02-20T21:50:14

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

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

Lila Holt — 2011-10-09T00:12:24

Hello!

We are asking you for some help from the Open Source communities.

As researchers at the University of Tennessee we are interested in
discovering more about learning and interactions of members of the open
source forums.   This research is conducted through the University of
Tennessee and is in no way associated with any forum organization.  To
further our research we would like input from forum members.  The responses
are very important to us so we can better understand what tools help forum
members learn and have a productive experience in participation.

There are two ways you can help:

1.       Take a survey about the tools you use in the forum.

We are requesting approximately 15 minutes of your time to participate in
our survey.
Survey link:  http://survey.utk.edu/mrIWeb/mrIWeb.dll?I.Project=FORUMLEARN



*As a thank you, upon exiting the survey you will be given an opportunity to
submit information to be entered in a drawing for a tablet computer ($500.00
Gift Card).    *



2.      Have a on

Invitation to connect on LinkedIn

Hirano Kazunari — 2011-09-28T11:15:21

I'd like to add you to my professional network on LinkedIn.

- Hirano

Hirano Kazunari
I18n/L10n Community Contributor at OpenSolaris
Japan

Confirm that you know Hirano Kazunari:
https://www.linkedin.com/e/-4dpk1-gt47xzvx-39/isd/4381524065/FWVHV0Rk/?hs=false&tok=3-GkgoWJX3-QU1

--
You are receiving Invitation to Connect emails. Click to unsubscribe:
http://www.linkedin.com/e/-4dpk1-gt47xzvx-39/vPNwsByeo2M14aHtbE-XBeEGTsiK_mrVBuumed/goo/users%40dba%2Eopenoffice%2Eorg/20061/I1517859406_1/?hs=false&tok=38HInB3EH3-QU1

(c) 2011 LinkedIn Corporation. 2029 Stierlin Ct, Mountain View, CA 94043, USA.

Re: Memo-Fields (Longtext)

Alexander Thurgood — 2011-06-23T09:38:43

Le 22/06/11 09:19, Andreas Renold a écrit :

Hi Andreas,


There was an old bug report that related how MEMO fields were limited to
some arbitrary number of characters less than what mysql was offering by
default, due to a hardcoded limit set in the form design code. I also
seem to remember that this got fixed at some stage, but perhaps it has
come back again ?


Alex

Memo-Fields (Longtext)

Andreas Renold — 2011-06-22T07:19:52

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

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

Alexander Thurgood — 2011-05-10T07:52:35

Le 10/05/11 09:46, Reizinger Zoltán a écrit :

Hi Zoltan,



Thanks, will head over there to try it out, but I have posted a similar
question on the extensions mailing list too, because the RD is not the
only extension I use :-)) Most of them seem inaccessible, I would hate
to think that the timeout has been deliberately set so ridiculously low
that it intentionally discourages users from attempting to download
anything. I would like to think that this is purely a DNS redirection /
resolution problem after the move to the new server infrastructure...


Alex

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

Reizinger Zoltán — 2011-05-10T07:46:56

Hi Alex,
It is sporadically works for me.
When I connected first, works, next three I get error, then works again.

For OOo 3.4 beta use: 
ftp://qa-upload.services.openoffice.org/SRB/report-builder-dev-1.2.2.m105.oxt
Zoltan

2011.05.10. 9:30 keltezéssel, Alexander Thurgood írta:

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

Alexander Thurgood — 2011-05-10T07:30:29

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

Re: Base Embedded Link Lost

Gene Kohlenberg — 2011-05-06T00:49:38

If that is the case, I would think that I would not be able to retrieve 
the data and script files with no errors from the unzipped file.  When I 
get the failure, the only thing that happens is that it now thinks that 
there is an external JDBC database, rather than the internal one.

I now copy the file and save it under a different name after I make 
changes so that I don't have to re-enter data.

Maybe I will do some editing on my wife's computer to see if there is 
something wrong with mine.

Re: Base Embedded Link Lost

Marc Santhoff — 2011-05-05T17:34:04

Am Mittwoch, den 04.05.2011, 19:01 -0400 schrieb Gene Kohlenberg:

That must have been a very old forum posting. Th last time I have heard
or read about such kind of problem dates back to OO.o Version 2.x.


Since you're relatively alone with this type of failure:
Have you ruled out other sources of failure? Slowly dying hardware like
power supply or disk drive can easily destroy random files.

HTH anyhow,
Marc

Re: Base Embedded Link Lost

Gene Kohlenberg — 2011-05-04T23:01:10

 From the forum archive I found that I had to create a new database 
file, unzip the damaged file, and copy the data files to the new 
unzipped file.  I then dragged the queries and forms from the last 
backup into the new file, and renamed it as an odb file.

It seems that the embedded system is not all that robust.  I had done 
nothing different than I had for several years when this problem happened.

Re: Base Embedded Link Lost

Alexander Thurgood — 2011-05-04T08:41:53

Le 03/05/11 21:10, Gene Kohlenberg a écrit :

Hi Gene,
This sounds like you are using either a different version of hsqldb.jar
(1.8.10, 1.9, 2.0 ?) on your system (i.e. you have multiple copies of
hsqldb.jar), or you have previously used the hsqldb.jar in "server" mode
and not "file" mode.

From what I can remember, you'll have to unzip your ODB file and dig
into the various text editable files to see where things have gone
wrong. Try searching on the openoffice.org forum, you'll probably find
the answer there if no one else answers here.


Alex

Re: Base Embedded Link Lost

Fernand Vanrie — 2011-05-04T09:24:01

On 03/05/2011 21:10, Gene ,

Sounds like you overwrited the databaseDoc with a "new" JDBC connected 
databaseDoc ?
Sure you have a backup of your databaseDoc :-)

hope it helps

Fernand

Base Embedded Link Lost

Gene Kohlenberg — 2011-05-03T19:10:51

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?

Re: Requests in OOo 3.3 give incorrect values

Frank Schönheit — 2011-03-28T11:02:00

Hi Robert,


confirmed ...

Zoltan thankfully already transferred it to BugZilla
(http://openoffice.org/bugzilla/show_bug.cgi?id=117093), where it is now
flagged with "regression" (always a good idea due to
http://wiki.services.openoffice.org/wiki/OOoRelease34#Release_relevant_issues),
and targeted to 3.x (with the idea to investigate whether a fix is
possible for 3.4).

Thanks & Ciao
Frank

Re: bug

Fernand Vanrie — 2011-03-28T08:10:50

guenkotsu,

There is a button to "hide" some tables, check this settings

Greetz

Fernand

--
-----------------------------------------------------------------
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

bug

guenkotsu — 2011-03-28T00:25:02

I'm using Windows XP + ODBC + MySQL.
Base doesn't display any table or databases.
It let to create new tables and use SQL statement like 'use database1'. 
Drag and drop do fine too.
But it doesnt display previos tables already created.

Thanks

Elcio
--
-----------------------------------------------------------------
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

Re: OO Base and kerberos auth to postgresql

Reizinger Zoltán — 2011-03-25T10:48:49

Hi Kamil,
2011.03.25. 10:27 keltezéssel, Kamil Jońca írta:
There is a known bug with OOo 3.3 and sdbc driver, it makes the tables 
read only:
http://openoffice.org/bugzilla/show_bug.cgi?id=117280
May be it is a side effect of this bug, but I'm not sure.
The JDBC connection works correctly, but it is slower than sdbc.
Regards,
Zoltan

--
-----------------------------------------------------------------
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

Kamil Jońca — 2011-03-25T09:27:08

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