gmane.comp.openoffice.dba.devel

new Apache OpenOffice.org mail list to replace this list

2011-11-02T16:23:59

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

use DriverManager and Native MySQLconnector

Fernand Vanrie — 2011-08-24T15:09:09

Can i use the DriverManager + the Native MySQLconnector to make a 
connection ?

thanks for any hint or link to some documentation

Fernand

How to display table contents?

Rohit Kulkarni — 2011-06-17T04:47:37

Hello,

I am working on writing an ldap driver for openoffice. I followed the steps
for skeleton driver and was able to establish a connection and everything.

I also changed some code inside getTables method of DatabaseMetaData.cxx
file so that when the database is opened for editing it shows a default
table exists in it.

However this table is empty, I want to show some data based on the user's
connection string when s/he double clicks and opens the table. Could someone
point me to where code for this is ? I want to put in code to read ldap
directory there so that I can show data from ldap as part of a table.

I tried setting breakpoint to executeQuery in SStatement.cxx but it does not
go there when you doubleclick open the table in a database.

any help is appreciated !

thanks,

Rohit

SDBC driver / Display data to user

Rohit Kulkarni — 2011-06-16T04:19:34

Hello,

I worked on writing an SDBC driver for LDAP for a bit. I was able to make
the skeleton SDBC driver work for me. After I go through couple of steps
of establishing a connection with the correct connection string there is
this new Window that shows up which is supposed to show list of available
tables and queries etc.

Now I don't have any tables there as this is just a sample driver. What I
want to do is extract some sample data from my LDAP directory and display it
in a table to the user. But I can figure out how can I do that.

Could someone give me any pointer about how can you show the data read from
the underlying database, to the user in a table?

thanks in advance.

-Rohit

staus of bugfixes toward OOo 3.4 and dev300: cws fs34b and fs34c, fs35a, hsqldb19

Reizinger Zoltán — 2011-06-08T08:02:26

Hi Frank,

I know correctly that the latest integrated into m106 database connected 
cws was dba34d.
The fs34b in finished status, and fs34 fixed two issue and still open, 
the hsqldb19 approved by QA still wait for DEV300 integration.

In EIS i found that is nmerged to cws 
dba34d:.http://eis.services.openoffice.org/EIS2/cws.ShowCWS?Id=10124&logon=true&OpenOnly=false&TasksInline=false&Section=All 
<http://eis.services.openoffice.org/EIS2/cws.ShowCWS?Id=10124&logon=true&OpenOnly=false&TasksInline=false&Section=All>
But I fuond in OOO340m0/DEV300m106 that for example,  bug 117454 old 
report, and bug 117472 is still in.
That means fs34b not merged correctly.

This is correct?
Ragards,
Zoltan

How to refresh DataSourceBrowser in a FrameControl

Fernand Vanrie — 2011-06-07T10:14:52

I try to use the "com.sun.star.frame.FrameControl" in a dialog acting as 
a "subforms'.

So i have 2 Framecontrol's  loaded with a dataSource browser based on a 
SQL-statement

When selecting a row in the first FrameControl the data in the second 
must been refreshed (passing a new SQL-statementto the second Framecontrol).

I found no way to do that because the activeCommand off the Resultset is 
"readonly".

now i use  this workaround:
' delete the FrameControl we want to refresh
  odlg.getcontrol("Grid2").dispose
' make  a new FrameControl
    oFrameControl2 = createUnoService("com.sun.star.frame.FrameControl")
    aLoaderArguments2(0).Name = "DataSourceName"
     aLoaderArguments2(0).Value = "mysql_native_PMG_reports"
     aLoaderArguments2(1).Name = "CommandType"
     aLoaderArguments2(1).Value = 2 'com.sun.star.sdb.CommandType.TABLE
     aLoaderArguments2(2).Name = "Command"
     aLoaderArguments2(2).Value = "SELECT distinct *   FROM  
pmgdbase.adv_reden_tbvips  WHERE pmgdbase.adv_reden_tbvips.REDENID =

libreoffice-sdbc-postgresql: cannot edit tables

Ferry Toth — 2011-06-05T15:09:32

Currently the SDBC driver 0.7.6b is broken with OO > 3.3.

- you can not add/modify records
- you can not set database options through <edit><database>..

This is true for OO 3.3, LO 3.3 i32/am64, windows and linux.

http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=620100
http://openoffice.org/bugzilla/show_bug.cgi?id=113494
https://bugs.freedesktop.org/show_bug.cgi?id=35784
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/782292

This is pretty bad, since the jdbc driver is about 10x slower. Because
of that Base is currently almost unusable with Progresql databases.

I believe this issue should be a showstopper for the 3.4 release.

Ferry

OOo Base 3.4 new features

Reizinger Zoltán — 2011-04-17T11:12:34

Hi all,
Now the OOo Base 3.4 beta is out, I crated Base 3.4 new features wiki 
page, as in earlier version, from base features mails:
http://eis.services.openoffice.org/EIS2/cws.ShowCWS?Id=8774&logon=true&OpenOnly=false&TasksInline=false&Section=All
Regards,
Zoltan

Shared Library registration with regcomp

Rohit Kulkarni — 2011-04-04T01:04:58

Hello,

I am trying to register the library (.so) file for the example skeleton sdbc
driver using "regcomp" tool into the services.rdb file. When I try to
register the shared library in "connection/unxlngi6.pro/lib" directory it
fails giving "CannotRegisterImplementationException" exception.

However during the build process this library is copied into 'solver//330/
unxlngi6.pro" directory and when I try to register this file it succeeds !

Could anyone tell me what changes happen to the library files during build
process when they are copied into the solver directory?

My problem is that the my sdbc driver library is supposed to implement
com.sun.star.sdbc.Driver service but when I register it from solver it is
implementing some strange services like
"com.sun.star.comp.svl.PathService" and
"com.sun.star.uno.util.numbers.SvNumberFormatterServiceObject" hence I am
wondering if something is changing the library during the build process.

thank you,
Rohit
--
-----------------------------------------------------

Opening forms in m105

Peter Eberlein — 2011-04-01T12:42:20

Hi,

my forms are not readable anymore (really ugly).
That seems due the fact that forms are now opened in printlayout instead 
of weblayout, but: shouldn't forms created in weblayout continue to open 
in weblayout?
Otherwise all those forms have to be edited oncemore, and people who 
don't know about this fact may think 3.4 is buggy.
For new forms this is ok.
What's the reason (issue) for this change?

Regards

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

Report builder for DEV300m105

Reizinger Zoltán — 2011-03-31T11:19:16

Hi Ocke,
Please create report builder for DEV300m105.
Zoltan
--
-----------------------------------------------------------------
To unsubscribe send email to dev-unsubscribe< at >dba.openoffice.org
For additional commands send email to sympa< at >dba.openoffice.org
with Subject: help

Base webpage errors

Reizinger Zoltán — 2011-03-27T18:09:51

On this page, the mailing list link is point to non existing page:
http://qa.openoffice.org/ooQAReloaded/DatabaseTeamsite/ooQA-TeamDatabaseLinks.html

This page outdated:
http://qa.openoffice.org/ooQAReloaded/DatabaseTeamsite/Docs/ooQA-TeamDatabaseConnectionTest.html

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

dba qa webpage

Reizinger Zoltán — 2011-03-27T17:55:16

Hi all,
On 
http://qa.openoffice.org/ooQAReloaded/DatabaseTeamsite/ooQA-TeamDatabase.html 
webpage, Chris is a dba qa project lead.
Please correct it.
Zoltan
--
-----------------------------------------------------------------
To unsubscribe send email to dev-unsubscribe< at >dba.openoffice.org
For additional commands send email to sympa< at >dba.openoffice.org
with Subject: help

Flat text Database Opening Changes in DataSource Browser

Fernand Vanrie — 2011-03-25T14:11:16

Sinds 3.3 the opening of a Flat Text Database (showing the tables) in 
the DataSource Browser has changed.
Before, when  showing the Tables (all the ".txt" files in a directory) 
was fast.and no files where locked by OO. Now , OO seems to load in 
Memory all the tables (.txt files) and locks all the files in the 
directory what makes a multi-user aproch imposible . With many files in 
the directory, it takes "ages" to view the tables also.
Is this wanted behavior or should i file a issue ?

Greetz
Fernand

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

Form wizard changed views?

Reizinger Zoltán — 2011-03-25T09:11:23

Hi all,
I checked bug http://openoffice.org/bugzilla/show_bug.cgi?id=98239 it is 
a form wizard control placing problems in DEV300m104.
When I created new forms now the wizard works correctly with option In 
Blocks Labels Above.

Two other options,  "Columnar Labels on Top", and  "Columnar Labels 
Left" inserts some controls into the form, in way that the controls 
placed wrongly, not fully within the form, hang out, the field starts in 
page, but ends out of the page.

When investigated further I found changes in form final format, until 
now the form wizard created forms in web layout, now the form created in 
print layout, and consequently the the above two settings  creates form 
in weblayout and places correctly within their limits, but the form 
saved in print layout, and some controls hangs out.

In the earlier versions until 3.3 I could switch between print/web 
layout in data input mode, now this is impossible and form stays in 
print mode, which is not wrong.
users prints forms as reports very ofte

Reports in m102 don't work

Peter Eberlein — 2011-03-18T11:40:53

Hi,

seems the "classical" Report doesn't work in m102 anymore. Known issue?

Regards

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

OOo QA Base Team: team lead change

Christoph Lukasiak — 2011-03-15T12:34:40

moin qa folks,

as i more and more change into the ux area it makes less sense to 
further lead an qa team, therefore marc neumann will overtake this role 
from me, from now on. please support him as you supported me and many 
thx for our work together and all the best for all of you, especially my 
team: mechtilde, alex, kiril, simon and zoltan.


bye chris
(http://wiki.services.openoffice.org/wiki/User:Clu)

Help Required In Writing a New SDBC Driver For LDAP

Rohit Kulkarni — 2011-03-09T15:37:42

Currently I am writing an SDBC driver for LDAP directories. I am following
the guidelines given at
http://wiki.services.openoffice.org/wiki/Documentation/DevGuide/Database/SDBC_Driver
This includes writing Driver, connection, statement and resultset services.

I want to compile the skeleton driver code and have an entry in the list of
available drivers. This driver will be a pseudo driver and will not have any
functionality. This will help in developing the actual driver.

I am not able to find skeleton driver related source files. I could locate a
folder named skeleton in  "/OOO320_m19/connectivity/workben/skeleton" but
could not find actual source files.

Could anyone please give me any pointers regarding

1. Where can I find the source files for the skeleton driver?
2. How to build a skeleton driver?
3. How to make an entry in available drivers list?

Thanks for your time. I really appreciate the help.

Regards,
Rohit
--
-----------------------------------------------------------------
To unsubscribe send

Next record in form navigation bar

Peter Eberlein — 2011-03-02T07:49:23

Hi,
if I step to the last record, shouldn't the button "Next Record" then 
not be disabled?
There's a button "New Record" for this purpose.
Often it happens, that the "Next Record" button is accidentally pushed 
after the last record in a filtered recordset.

Regards

Peter
--