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 one on one interview talking about the forums, how you learn,
and tools used.  *As a thank you for your interview you will be sent a
$25.00 gift card. * Email lholt< at >utk.edu for more information.





You may do either or both of the above.  Please be assured that your answers
will be confidential.  No individual’s answers will ever be identified in
any report. Should you have any questions about the project or our interest
in using the results, we encourage you to contact Lila Holt, at
lholt< at >utk.edu) or Vandana Singh at vandana< at >utk.edu.




Contact information you provide for the drawing is completely separate from
your survey answers and there will be no way to identify participants in the
actual survey responses. Nor will contact information be used for any other
purpose. The odds of being selected will depend on the number of respondents
to this survey.

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

Re: How to refresh DataSourceBrowser in a FrameControl

Frank Schönheit — 2011-06-13T19:30:29

Hi Fernand,


Hmm, this might be caused by some special implementation, seems to be
some inconsistency here, indeed.


Well - parameters are the means by which sub forms are implemented, so I
am pretty sure they work in general. Not sure which concrete commands
cause the problem in your scenario :-\


Fine :)

Ciao
Frank

Re: How to refresh DataSourceBrowser in a FrameControl

Fernand Vanrie — 2011-06-10T15:15:58

  Frank ,

I am afraid that the "parameter" stuff is not working at all

oForm.setint(1,1000) should gives a value of "1000" to parameter 1

but this does nothing, the oform.parameters stay empty ? and SQL is 
complaining about missing parameter value's

But passing a new command an reloading works like a charm... so we uses 
this workaround sucesfuly

Thanks

Fernand

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

Frank Schönheit — 2011-06-10T13:22:02

Hi Alex,


Thank you - and ... well, yes. Not really a satisfying situation, for
nobody :-\

Ciao
Frank

Re: How to refresh DataSourceBrowser in a FrameControl

Frank Schönheit — 2011-06-10T13:21:13

Hi Fernand,


Argh.

There's no support for passing parameter values - the LoaderArguments
you specify are passed, by the FrameControl, to the component loaded
into it - which leads in DSB's case to
http://api.openoffice.org/docs/common/ref/com/sun/star/sdb/DataSourceBrowser.html#XInitialization
=> No support for such a thing.

In theory, the DSB - more precise: the form loaded into it - allows
delegating parameter requests to an external instance, via the
css.form.XDatabaseParameterBroadcaster interface. It allows registering
listeners which are asked when a parameter is to be filled.

However, you have no chance of passing such a listener to the
FrameControl in a way that it reaches the form in time.

So - for the very initial load, the parameter-based request won't work,
sorry.

Ciao
Frank

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

Alexander Thurgood — 2011-06-09T08:39:31

Le 09/06/11 09:34, Frank Schönheit a écrit :

Hi Frank,



I'm just glad you're still alive and kicking :-)) (and the same for the
other guys if they're still around) The whole sudden-death-supernova
radio silence was a bit freaky and more than a little sad :-)


Alex

Re: How to refresh DataSourceBrowser in a FrameControl

Fernand Vanrie — 2011-06-09T10:01:23

Frank ,

Me again:
when loading a paramerized statement i have aSQL error "Values not set 
for all parameters"
so i load
   aLoaderArguments(1).Name = "CommandType"
     aLoaderArguments(1).Value = 2 'com.sun.star.sdb.CommandType.TABLE
     aLoaderArguments(2).Name = "Command"
    aLoaderArguments(2).Value = "SELECT distinct *   FROM  
pmgdbase.adv_reden_tbvips  WHERE pmgdbase.adv_reden_tbvips.REDENID = ? "

how do i can "load" mi "?" parametervalue
i supose something like
aLoaderArguments(6).Name = "CommandParameter 1" ???
aLoaderArguments(6).value = sID

Grzt

Fernand

Re: How to refresh DataSourceBrowser in a FrameControl

Fernand Vanrie — 2011-06-09T09:11:14

  Frank ,

Stupid Me, I totaly overlooked the "command" i was still focused on the 
"activecommand"

Learned (again :-) ) about "parametrized statement "
Thanks a million

Fernand

Re: How to refresh DataSourceBrowser in a FrameControl

Frank Schönheit — 2011-06-09T08:49:15

Hi Fernand,


Ah - I missed, in your original mail, that you actually want to change
the command underlying the DSB.

The simplest way might be to just set the "Command" property of the
database form (the model you just retrieved) before reloading.

A slightly more complex, but cheaper (in terms of runtime resources)
solution would be to base the DSB on a parametrized statement ("...
WHERE REDENID = ?"), and then use the XParameters.setInt (or whatever
type the REDENID column has) method:
  oForm = oController.com_sun_star_awt_XTabController_getModel()
  oForm.setInt( 1, sid )
  oForm.reload()


The LoaderArguments are used at the time the DSB is plugged into the
frame, and then discarded (at least as far as the DSB is concerned, not
sure the FrameControl implementation makes later use of it). Thus,
reload does know nothing 'bout changed LoaderArguments, so this doesn't
work.


As said above,
  oModel.Command = <new_command>
before doing the reload should help already.

Ciao
Frank

Re: How to refresh DataSourceBrowser in a FrameControl

Fernand Vanrie — 2011-06-09T07:51:46

Frank ,

Thanks, now i have my Model and can reload, but the reloading do not 
affects the activecommand ? an not the results

So how to make the new Loaderarguments ("active") or how to pass a new 
activecommand to the DatasourceBrowser
my code is now:

  odlg.getcontrol("Grid2").LoaderArguments = aLoaderArguments2 ' the new 
arguments with a new SQL statement in it

  oDatasourceBrowser = odlg.getcontrol("Grid2").frame.controller
  omodel = oDatasourceBrowser.com_sun_star_awt_XTabController_getModel()
  omodel.reload

Greetz

Fernand

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

Frank Schönheit — 2011-06-09T07:42:24

Hi Zoltán,


forgot to answer the hsqldb19 part ...

As far as I know, the original goal was to integrate hsqldb19 into 3.4,
if possible. Not sure what got of this idea, since EIS currently says
"Release = OOo 3.5", it might have changed. Ocke should know the details.

From what I know, it is still worth pursuing a 3.4 target for the CWS,
at least because it is certainly desirable for the HSQL project. On the
other hand, the radical change in the CWS (moving to HSQLDB 2) is
certainly a risk for 3.4 - and while you and Ocke did a great job in
finding and fixing zillions of bugs already, there might be more,
undiscovered so far - and if they were to go into OOO340, it might be
hard to fix them in time for the release.

Ciao
Frank

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

Frank Schönheit — 2011-06-09T07:34:59

Hi Zoltán,


No, it is the other way 'round: dba34d was merged into fs34b. Sorry, my
wording in EIS could have been better :)


Not sure at the moment what the "finished" status for fs34b is supposed
to tell us - at least it implies "not integrated, yet".

<http://eis.services.openoffice.org/EIS2/cws.ShowCWS?Id=10194&logon=true&OpenOnly=false&TasksInline=false&Section=Overview>
says that fs34b is in status "integrated", but the "Milestone
(integrated)" field is empty - this means that the milestone which the
CWS has been integrated into has not been finished, but is ongoing -
which means the CWS will be in OOO340.m1. If it were in OOO320.m0, then
the "Milestone (integrated)" field would be filled, since m0 is done
already.

So, the bottom line is: No surprise that fs34b's bugs are not fixed in
m0, expect the fixes for m1.

As far as I know, m1 has been built already, or at least it was started
(since I got questions 'bout some build breakers caused by a flawed
integration of another CWS of mine :) ). Not sure whether it is finished.

Also, I don't know the timeline for the upcoming builds, but I know that
I am not the only one who thinks we (whatever "we" means in this
context) should at least release a proper 3.4. But again, there's still
some dust in the air, which might need to settle beforehand ...

Ciao
Frank

Re: How to refresh DataSourceBrowser in a FrameControl

Frank Schönheit — 2011-06-09T07:12:28

Hi Fernand,


Ah ... the pitfalls of the Basic UNO binding!

The controller supports both the XController and XTabController
interfaces, both have a getModel() method, so "oController.getModel()"
(or "oController.Model") is ambiguous in Basic. It is not defined (to my
knowledge) to which of the methods this is resolved - seems to be
XController.getModel(), which indeed returns NULL - which is expected,
since the DataSourceBrowser does not have an associated document (which
would be the XModel returned by XController.getModel()).

Basic's syntax to access a method *with* specifying the interface it is
defined at is
  oDataSourceBrowser.com_sun_star_awt_XTabController_getModel()

Ciao
Frank

Re: OpenOffice Internship-2011

Amit Pal — 2011-06-08T17:03:13

No open office internship

Thank You
Amit Pal
Junior UnderGraduate Student,
Computer Science and Engineering,
IT-BHU, India

amix.pal(Skype)

*+49-1514-3531-847*





On Wed, Jun 8, 2011 at 5:01 PM, Jim Callahan <jim.callahan.orlando< at >gmail.com

Re: OpenOffice Internship-2011

Jim Callahan — 2011-06-08T17:01:00

Google Summer of Code?
Jim

On 6/8/11, Amit Pal <amix.pal< at >gmail.com> wrote:

Re: OpenOffice Internship-2011

Amit Pal — 2011-06-08T16:09:50

I just saw somewhere about this internship and talked a girl who was the
part of internship 2010.

Re: OpenOffice Internship-2011

Ferry Toth — 2011-06-08T15:09:17

What are the OO developers at right now? Waiting at home?

Frank Schönheit schreef op wo 08-06-2011 om 09:20 [+0200]: