Re: [dba-dev] Where to find all open DB connections and closes them
Hi Fernand, When opening a DatasourceBrowser with the dispatcher using loadComponentFromURL(.component:DB/DataSourceBrowser, _beamer, 0, aProps) I have a connection opened with the database server. How can i find this opened connection and close it with the API ? I tried and found a activeConnection on the derivided rowset orowset.activeconnection.dispose or orowset.activeConnection.close does nothing the connection stays open on the server site, only closing OO closes this connection Since you say in your other mail that disabling connection pooling doesn't change the behavior, I can't think of any legitimate reason for keeping the connection open - so, it sounds like a bug. And yet more, there's no chance to iterate over opened connections, and forcefully close them (as this would ... irritate a lot of other components). Sorry to say. Interesting question would be whether this also happens with MySQL over JDBC, for instance. (One reason why this is interesting is because the JDBC driver has built-in logging capabilities, see http://wiki.services.openoffice.org/wiki/Logging_JDBC_Activity.) Ciao Frank -- ORACLE Frank Schönheit | Software Engineer | frank.schoenh...@sun.com - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] Typo in a string
Hi Sophie, In the file openoffice_org/dbaccess/source/ext/macromigration.po there is a typo in the source string [No database document found in the initializatin arguments.] I think it should be [initialization]. Do I open an issue? If we want to have it fixed for 3.3, then yes, please (Normally we could fix this by passing, but since the 3.3 branch off date passed ...) Thanks Ciao Frank -- - Frank Schönheit, Software Engineer frank.schoenh...@sun.com - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Impress http://graphics.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] ORB args ComponentData
Hi Fernand, How and in witch format can i provide the ComponentData Argument when using LoadFromURL i try to set the filter to new value Looking into the code, it seems to me that the only parameter in the component data which is respected so far is the ActiveConnection. So, I don't think you can override the report's filter this way. Ciao Frank -- - Frank Schönheit, Software Engineer frank.schoenh...@sun.com - - Sun Microsystems http://www.sun.com/staroffice - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] UnoComponent: invoking from form control
Hi Peter, in Uno dialogs you can bind an event to a dialog control: either a macro or a method of a uno component. In form controls I'm missing the latter. Any hints? (hoping Frank is reading here yet) I can't remember ... that's so long ago ... :-P No, this doesn't work for form controls, they basically accept the script URL you attach to an event to the scripting framework. The feature of calling methods of an UNO component has, sadly, been implemented bypassing the scripting framework, so this doesn't work for form controls. However, it should be easy to embed a macro in the document which does nothing but instantiating a service and calling a method, shouldn't it? Ciao Frank -- - Frank Schönheit, Software Engineer frank.schoenh...@sun.com - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Impress http://graphics.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Sitz der Gesellschaft: - - Sun Microsystems GmbH, Sonnenallee 1, D-85551 Kirchheim-Heimstetten - - Amtsgericht München: HRB 161028 - - Geschäftsführer: Jürgen Kunz- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] ODBC from AS/400, results dependent on server version
Hi Terrence, I wonder if this behaviour is right. And if it is wrong, does anybody care, given the age of V5R2? V6R1 of the o/s has been in production for a couple of years, and V7R1 is anticipated shortly. In short, is this a candidate for a bug report? Normally I'd say every bug is worth a bug report ... In this concrete case, given the ... difficulty for the core development team to get their fingers on a AS/400 DB, the age of the DB system in question, and the suspicion that this is a problem of the ODBC driver (the OBJECT suggests that it returns some kind of binary data type for the columns in question), I'd say that in reality, the issue would just add to the pile ... :-\ Ciao Frank -- - Frank Schönheit, Software Engineer frank.schoenh...@sun.com - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Impress http://graphics.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] issue 94543, some progress and request for help
Hi Terrence, Ocke would be better to answer (most of) your questions, since a) I'm no active Base developer anymore :) and b) the ODBC driver is his domain. But since he's on vacation currently, let me jump in. (*) I am not satisfied with my analysis of the impact of the change. For me to make any progress on this, I think I shall have to start over with {OpenGrok, considering the confusion I got into in my first attempt at analysis. Perhaps someone here just knows that the change looks right or wrong? Of course, having found the bug at two places, I have to fear that there is a third place which I have not found. Chances are good there's no third place. First, grok says fraction is used nowhere else, and second, connectivity/source/drivers/odbc(base) are the only two folders which are that close to the ODBC API that they use this time. (*) Contributing Patches http://wiki.services.openoffice.org/wiki/Contributing_Patches assumes a working copy from cvs. I lack that, so submitted a diff of from the files that I have. Is this of any use? Well, as long as a patch -p... -i patch_file succeedes, any patch file is of use :) Your current patch file doesn't allow for this, since the file names therein are *.cxx_some_suffix, which means manual work (typing the proper file names) when applying the patch. Possible, but annoying. If you do not have a VCS, on top of which you do your patches, try copying the source module which you intend to patch aside (say, cp -a connectivity connectivity.org) and diff -ru the original to your patched version. Another problem with your patch is that it is not complete: There is no DateTimeToTimestamp which takes a TIMESTAMP_STRUCT and delivers a DateTime, only the other way 'round. So, what you probably want to do is to introduce a TimestampToDateTime method in the OTools class, which does the proper calculation. (*) Along the way, a couple of things in the cod have raised my eyebrows a little bit. Are they candidates for fixes? - The last case the switch structure ending at connectivity/source/drivers/odbcbase/OTools.cxx line 394 lacks a break statement. Worth fixing. Just pushed that fix to CWS dba33f. - Line 248 of the same file assigns a literal constant to _nColumnSize. I think it would be better to use SQL_TIMESTAMP_LEN defined at unixODBC/inc/sql.h line 55. Looks less than optimal. The same probably holds for the other two cases above the one in question, right? However, I'd like to hear Ocke's opinion on this before tampering with it. Where did the multiplcation by 1000 come from? And is there some context in which it is the right thing to do? Which leads to further questions ... Such specifications of ODBC that I have found on the net agree that ODBC expresses fraction as a number of nanoseconds. But these specifications all apply to ODBC 3 or 3.5 or 3.51. Did older version of ODBC do it differently? Does some particular (incorrect) ODBC driver do it differently? Does anybody care? Is there a standard set of backends against which to test ODBC functionality? Is there even a standard set of test of ODBC functionality? For the standard set of tests - I would delegate this to our QA folks. In general, I assume there might be backends where the 1000 makes sense, otherwise the issue would probably have popped up much earlier. So, to be on the safest possible side, one would have to introduce a setting to the driver which controls how the DateTime-TIMESTAMP_STRUCT conversion is done (we have lots of such settings, to care for different backend behaviors. Not nice at all, but necessary, often enough). I *think* this might be overkill, assuming that date/time fields continue to work after the patch, with some set of backends (the usual MS suspects come to my mind, plus MySQL, and the like). However, I again would like to hear Ocke's opinion on that. Thanks Ciao Frank -- - Frank Schönheit, Software Engineer frank.schoenh...@sun.com - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Impress http://graphics.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
[dba-dev] resigning as Base project lead (and as Base team member)
Hello fellow Base users and developers, of the ~2000 mails I sent to d...@dba and us...@dba (wow! 20% of the mails were from me? My mail client must be lying to me ...), this is one of the more difficult ones. Effective immediately, I'll be resigning from the position of Base's project lead. Along with that, I will probably significantly reduce my contribution to those lists, and definitely to overall Base. Background: Some time ago, I've been asked whether I could imagine working, on a per-project basis, in another part of Sun's [1] OpenOffice.org team. To be precise, the talk was about Impress. Well, after some consideration, I said I could. But - I don't like the idea of doing things only half. If I were to go to the Impress team, I would want to be an Impress developer, not half an Impress and half a Base developer. Consequently, I decided to accept this offering, but only as full-time assignment. Hey, this was *the* chance to get rid of the responsibility for all the crimes I committed in Base! :) So, here I am: still with Sun/Oracle, still with OpenOffice.org, but not with Base anymore. Well, of course I'll continue to be available for consultation (though my bad memory is proverbial, at least for my wife, I'll probably remember a few things I did to the code). And the next show stopper fix in some code area of mine will probably also be done by /me. But I'll stop contributing significant changes to Base. I certainly see this change with mixed feelings. I started in the Base team more than 10 years ago, in my first job ever, immediately after university, still some time before StarDivision was bought by Sun, and StarOffice was open sourced as OpenOffice.org. Times were interesting and challenging, we did some things pretty well, and some things went ... not as good as I would have hoped. Still, Base is an important part of my (professional, at least) life. On the other hand, other challenges lie ahead. Impress is pretty new to me, there'll be a lot to learn. And who knows - perhaps I'll return to Base when the Impress team recognizes my inherent inability to understand the basics of their work - YMCA color models, or however those are called, and such ... I'm going to send another mail regarding my suggestion for a project lead successor (it won't surprise you too much). Also, I still owe some of you an Apfelstrudel - I hope we can still do that at some point in time :) See you around, the OpenOffice.org community isn't *that* big that I'll be completely out of your way ... Ciao Frank [1] I am probably obliged to tell that Sun Microsystems by now is a wholly owned subsidiary of Oracle Corporation -- - Frank Schönheit, Software Engineer frank.schoenh...@sun.com - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
[dba-dev] Base project lead suggestion
Hi, if you're reading your mails in the order they were written by their authors, you know by know that I resigned from the Base Project Lead role. Which means we need to find somebody else ... It won't come as a big surprise to you that I suggest Ocke Jansen (usually merely known as Ocke, sometimes as oj - the only person I know whose IZ nick name is accepted by our SQL parser) as my successor in this role. Ocke surely knows his ways around in the Base project, he joined the Base team even 3 months earlier than I did, nearly 11 years ago. To me, he is the canonical choice. So, I suppose we're expected to vote here - let's get the party started, then. +1 from /me :) Ciao Frank -- - Frank Schönheit, Software Engineer frank.schoenh...@sun.com - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] dev 33m72 and nativ driver for mysql
I'm pretty certain that the integration does not, at least at this point, mean the extension is going into the main distribution package. So you still need to install separately. Correct. Ciao Frank -- - Frank Schönheit, Software Engineer frank.schoenh...@sun.com - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] How to load a SRB report from his com.sun.star.comp.report.OReportDefinition
Hi Fernand, oReport.open 'the wonder: it Runs the report with the wanted Filter Conditions !!! From here on the wonder continious it works just by running the third part OK wonders do happen :-) but please can someone explain this behaviour See our thread over there in d...@api. As I explained there, I think this is a side effect of the macro handling, as it does not happen when the document does not contain macros (and thus you're not asked for macro execution). Also, I outlined there how the API *should* be used to reach your goal - in particular, one should be able to pass the filter to a loadComponentFromURL call at the reports object. Ciao Frank -- - Frank Schönheit, Software Engineer frank.schoenh...@sun.com - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] Please welcome the newest member of the Base QA Team - Zoltan Reizinger
It is my pleasure to have as my first opportunity in this capacity the chance to announce the teams newest member, Zoltan Reizinger. Welcome Zoltan (whatever this official welcome will change, or not change :) ) - not only the Sun Report Builder would, without your invaluable work, look much worse than it actually does :) Ciao Frank -- - Frank Schönheit, Software Engineer frank.schoenh...@sun.com - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] Problem: OpenOffice Base and PostgreSQL stored procedures
Hi Marc, Can the internal SQL parser be changed to accept statements like SELECT * FROM function(:parameter) ? Probably, yes (but Ocke has a saying in this, he has deeper insights in the parser implementation). Feel free to submit an issue. Ciao Frank -- - Frank Schönheit, Software Engineer frank.schoenh...@sun.com - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] Problem: OpenOffice Base and PostgreSQL stored procedures
Hi Marc, I can, however, set the query editor to native SQL mode, then the SQL code is passed as is to the database backend and no error is output. But with native SQL mode, I loose the possibility to have OpenOffice ask the user for parameters. I can only use calls without parameters. But most stored procedurs actually require paramates. Indeed, native queries do not allow for parameters. This is caused by the fact that for recognizing the parameters, Base would need to parse the statement, which contradicts the do-not-parse restricting imposed by the native flag. Some of the underlying APIs (JDBC, for instance) support retrieving parameter information from the database/driver, but that's not used in Base currently. Issue 66559 would probably fix this, at least for all JDBC based connections (the issue talks about HSQL only, but that wouldn't matter much). Another option - which I am not sure an issue exists for - would be to let the creator of the native query define which parameters to ask the user for - would be the responsibility of the creator then to ensure consistency. There is a second (and maybe unrelated) problem: OpenOffice Base seems for each query to send a generated query to the database server to check if that table in the query exists. It does something like SELECT COUNT(*) FROM tablename WHERE 0 = 1 This will of course never return any data, but it will raise an error if tablename does not exist, so I assume this is done to check for the presence of a table. But again, this does not work when a query instead of table specifies a stored procedure in a SELECT. For historic reasons, the WHERE 0 = 1 thing is done for retrieving column information, with a fallback to ask the meta data of the prepared statement. I suppose the latter didn't work properly formerly, for a certain set of database/drivers, so WHERE 0 = 1 had been invented (well, that's not really an invention of Base), since the meta data of a result set (which is forced to be empty) were more reliable than the meta data of the prepared statement. If you're saying this happens even for native queries, then please submit an issue for it - it should be done for non-native queries only, IMO. Ciao Frank -- - Frank Schönheit, Software Engineer frank.schoenh...@sun.com - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] How to find the Schema name from a dataform using the MySQL native connector?
Hi Drew, Specifically the updateSchema name. The property at the dataform returns a null string. The SQLQueryCompoers doesn't seem to have a way. The column objects returned by the composer should have a SchemaName. Remember that the schema basically belongs to the table name, and the qualified table name is an attribute of the column, not of the select statement as the whole. Ciao Frank -- - Frank Schönheit, Software Engineer frank.schoenh...@sun.com - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] SetBlob.... ( was Re: setBlog not implemented for preparedStatement in HSQLdb SDBC driver)
Hi Ocke, I thought that I fixed that one in a DEV320 but that doesn't seem to be. So please submit an issue for it. Thanks. Wasn't that in one of the dba33? CWS', i.e. for 3.3 only? Ciao Frank -- - Frank Schönheit, Software Engineer frank.schoenh...@sun.com - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] Question 1: Finding the actual column name for an aliased field?
Hi Drew, I have a query: SELECT COL1 AS ALIAS FROM TABLE Now I am handed a dataform in a routine and I need to find the column names in the table, not the alias. depending on which column object you have ... there might be a property RealName, though I do not know, out of my head, at which col objects it is available. So, try ControlModel.BoundField.RealName. Ciao Frank -- - Frank Schönheit, Software Engineer frank.schoenh...@sun.com - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] ResultsetColumn.Typename inconsistent between drivers?
Hi Drew, for cntr = 1 to oDataForm.Columns.count CurrentColumn = oDataForm.Columns(cntr -1 ) if UCASE( CurrentColumn.Typename) = UCASE(longvarbinary) then because under HSQLdb it is LONGVARBINARY under MySQL Native it is longvarbinary. Shouldn't this be consistent? Issue? This name is completely driver-controlled, so each and every database can do what it wants here, OOo just routes through, without interfering. The only thing you can interpret is the css.sdbc.DataType. Ciao Frank -- - Frank Schönheit, Software Engineer frank.schoenh...@sun.com - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] forms cannot handle Oracles mode of generated values
Hi Peter, just for the record ... just tested with m7 and jdbc; Oracle handles the autogenerated values as following: ... After pushing Save the message comes: Exhausted resultset, but the record was inserted. But not enough: If the focus wants to left the form, a new record is inserted with the error message above again and again. submitted by you as issue 107812, confirmed and grabbed by /me, targeted for 3.x ATM. Ciao Frank -- - Frank Schönheit, Software Engineer frank.schoenh...@sun.com - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] turning Create New Base file off
Hi Drew, Checking 3.2 RC1 and this issue http://www.openoffice.org/issues/show_bug.cgi?id=96862 OK I edited the file /opt/openoffice.org/basis3.2/share/registry/schema/org/openoffice/office/DataAccess.xcs Uhm, not sure editing the schema is a good idea, I don't know which restrictions apply there (the least you might need to do is removing registry/cache in your user data folder). Try something like the following in Basic Dim oProvider as Object oProvider = createUnoService( _ com.sun.star.configuration.ConfigurationProvider ) Dim args(0) as new com.sun.star.beans.PropertyValue args(0).Name = nodepath args(0).Value = _ /org.openoffice.office.Office.DataAccess/Policies/Features/Base Dim oNode as Object oNode = oProvider.createInstanceWithArguments( _ com.sun.star.configuration.ConfigurationUpdateAccess, _ args() ) oNode.CreateLocalDatabase = FALSE oNode.commitChanges (warning: that's out of my head, not tried that actual piece of code, but it works along the above lines) Ciao Frank -- - Frank Schönheit, Software Engineer frank.schoenh...@sun.com - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] Border of controls visible after filtering
I fixed this in one of our 3.3-CWS, IIRC, though I am not sure whether it was dba33a, dba33b, or dba33d ... Thanks for reporting, nonetheless. it was 106368 in CWS dba33b ... Ciao Frank -- - Frank Schönheit, Software Engineer frank.schoenh...@sun.com - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] Base throwing error using HSQLDB Database Driver
Hello Sebastian, I am trying to set up a HSQL database and connect OpenOffice Base to it. Whenever I try connection OpenOffice tells me: Unable to establish connection. Fehler-Code: 1000 The driver class ' org.hsqldb.jdbcDriver ' could not be loaded. (I translated this) You need to add hsqldb.jar (found somewhere in your installation folder, in program/classes, or another version of your choice) to OOo's JVM classpath (Tools/Options/Java, Extras/Optionen/Java). While this file is shipped with OOo, it is only automatically employed when you use the internal HSQLDB, for external pure-JDBC connections to an HSQLDB, you need to make it known to OOo. Ciao Frank -- - Frank Schönheit, Software Engineer frank.schoenh...@sun.com - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] Border of controls visible after filtering
Hi Peter, another regression for you (though I wouldn't call that a stopper ;) ): http://www.openoffice.org/issues/show_bug.cgi?id=107524 I fixed this in one of our 3.3-CWS, IIRC, though I am not sure whether it was dba33a, dba33b, or dba33d ... Thanks for reporting, nonetheless. Ciao Frank -- - Frank Schönheit, Software Engineer frank.schoenh...@sun.com - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] Regression in m7: Stepping to filtered records not possible in special cases
Hi Peter, I'd like to pay your attention to http://www.openoffice.org/issues/show_bug.cgi?id=107485. This has worked at least in OpenOffice 2.2 and should considered as a stopper? Yes. Care to visit relea...@ooo? Thanks Ciao Frank -- - Frank Schönheit, Software Engineer frank.schoenh...@sun.com - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] report: argument Hidden for loadComponentFromURL()
Hi Peter, seems, the property Hidden=false is not supported for report-documents. ... Any hints no, sorry. Any workarounds I could think of (for instance passing a hidden Frame to the loader to plug the to-be-loaded component into) are not implemented for this particular loader. (of course I'll file an issue)? That'd be great, if course. Ciao Frank -- - Frank Schönheit, Software Engineer frank.schoenh...@sun.com - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] enhance the Query definition code to recognize CALL
Hi Drew, The request is to enhance the query parser components to recognize a command such as CALL somefunction( params ) - allowing escape processing for function parameters -- I don't know what the implications are regarding column names They need to be provided by the DB then, there's not much chance base could obtain them beforehand (as it does when parsing normal SELECT statements). -- Also don't know the cost of supporting this only for the data sources that can utilize it, adding another item/option overhead I suppose --- Question - do the different data sources (SDB, MySQL native, etc) supply code/configuration options to the query component runtime, or is that (the query component code) singular and within it accounts for the different data sources? The parser, and the query designer are pretty generic, they take into account a limited set of meta data provided by the database/driver itself, for instance the list of supported functions, the stuff listed in XDatabaseMetaData, and such. However, there's an awful lot of features which is not covered by meta data, and thus needs either an explicit option, or guesswork, or finally is supported in the parser/designer even if the underlying DB can't handle it. Also, call CUSTOMProcedure( p1...pn ) CUSTOMProcedure returnS a read only result set containing ONE row, columns named p0 to p(n-1) and call CUSTOMFunction( p1...pn ) CUSTOMFunction returns a read only result set with zero or more rows, columns named IN returned result set. Not sure it is feasible to distinguish those. I think recognizing CALL something( parameter_list ) would be sufficient. For the column information, one would have to rely on the DB/driver, anyway, and the number of rows is not of interest to the parser/query designer at all. Ciao Frank -- - Frank Schönheit, Software Engineer frank.schoenh...@sun.com - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] Recovery process
Hi Peter, seems the recovery process for base has some shortcomings yet. Neither a created report nor the basic code is restored after crashing and starting the recovery (WinXP and m6). A known issue? http://www.openoffice.org/issues/show_bug.cgi?id=65597 Accidentally, I spent the last ... let me see ... two and a half weeks nearly exclusively to lay some very basic foundations to fix this. (Not in Base. In the framework of the other applications, which needs some heavy re-factoring, so the auto-recovery mechanism can be generalized, so Base can gain control over how emergency-save and crash-recovery are actually done.) Ciao Frank -- - Frank Schönheit, Software Engineer frank.schoenh...@sun.com - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] problem repaint formcontrols ..
Hi Cor, While working in m6, writer document with form controls. When editing some text, the form control becomes invisible. Which can be corrected by zooming / scrolling. Was the same in M5, maybe earlier? Known problem? Not that I know. Cannot reproduce out of the box, interesting questions include: design mode or alive mode or both? Control is anchored where? Does the typed text overlap with the control position? Does your page have a non-default background? Does it affect transparent or non-transparent controls only, or both? Do you use a OS/Desktop with desktop theming, or one without (such as WinXP classic)? Ciao Frank -- - Frank Schönheit, Software Engineer frank.schoenh...@sun.com - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] method setBinaryStream not working with Oracle BLOB using jdbc
Hi Peter, fine, so I consider this a bug in OpenOffice. Quite reasonable. Ocke just reworks the [B|C]LOB handling, it seems this code was never confronted with reality before. How to workaround? Sorry, don't have to offer anything here. BLOB is highly ... under-implemented currently :-\ If you're interested in, we could upload a CWS snapshot when Ocke finished his fixes, so you can test them in your real life scenario, and give us early feedback. Ciao Frank -- - Frank Schönheit, Software Engineer frank.schoenh...@sun.com - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] Opening a GridControl in a UNO Dialog
Hi Noel, This sounds a little familiar to something we discussed on this list in the past ( it wasn't exactly the same thing, but if you remember we talked about using form control models ( especially data aware ones ) with the toolkit controls in dialogs ) as such I darkly remember, now that you mention it ... Btw I use currently use the form control models with the toolkit controls ( and it seems to work well ) in ooo-build, the (self imposed) limitation is that this is only available 'transiently' when importing MSO 'Userform' controls. Not sure if any of the work I have done is that useful in this case but I'd happily attach it/upload [*] etc. somewhere should you want it or think it's useful. Sure, im always interested in seeing what you're doing to ¨my¨ form controls :) In anycase I am interested in upstreaming this code anyway but I was thinking about doing that in the context of a future vba support CWS. Any concrete time line for this? However, as I said at the moment it really isn't suitable to be used with Openoffice directly ( lack of ui/persistence support for one ) and I haven't had the time to concentrate on that part of it :-/ It sounds though that any work in this area would be relevant to ( and affect ) a 'proper' solution for what I would like to do, so I am very interested I think having a solution without UI and persistence is a great first step, I'd be willing to get this into MWS in such a shape (and add some test cases to ensure it doesn't break, and then officially declare it as feature). So, when you upstream this, I'd be more than happy to have a look at it. Ciao Frank -- - Frank Schönheit, Software Engineer frank.schoenh...@sun.com - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] Opening a GridControl in a UNO Dialog
Hi Fernand, For months i am looking for the best solutions to manipulating data in Dialogs instead of forms. Just this morning, sitting in the subway and having no newspaper to read :), I wondered whether it would make sense to implement the runtime code for all the database controls in dialogs. Adding a full-blown dedicated UI for creating database dialogs would be an additional effort, but perhaps it would be valueable having only the runtime, i.e. the ability to programmatically create and execute such dialogs. As a first step, at least. So i was missing a GridControl. Last week i Readed on Gulfoss that a new AWT UNO Dialog GridControl is coming, I discused with the makers why there is no dataloader available. They told me that this GridControl is a developer tool and we have to build our proper Loading stuff. I can do that but it wil be terible slow using loops over the resultset. Not olnly that, it won't scale. IIRC, the API for the new table control requires you to have all data in memory, something you usually won't do with a complete result set. Instead, there you usually only hold the data which is displayed (plus some cached data), and re-fetch everything else as needed. Ciao Frank -- - Frank Schönheit, Software Engineer frank.schoenh...@sun.com - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: AW: AW: [dba-dev] internationalization of exception messages in a database driver extension
Hi Michael, I'm a bit confused. Actually our driver extension is written in Java, Ah - actually I don't know much (put carefully) about implementing UNO components in Java, so I hope that Ariel's idea solves your problem (I suppose it does, given Ariel's expertise :) ). So, assuming it does, some general remarks only: XSingleServiceFactory can be considered the legacy version of XSingleComponentFactory (and the same holds for the XMulti- versions). So, in general you should use the Component-version, and only fall back to the Service-thing if you interface with code which still needs it. In my understanding (and it's well possible that other major differences slip my attention), the most important advantage of the Component-API is that you have the XComponentContext, which can provide, well, context for your component, which reliefs implementations from accessing all kind of global shared data (which is a paint in the neck). Ciao Frank -- - Frank Schönheit, Software Engineer frank.schoenh...@sun.com - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] internationalization of exception messages in a database driver extension
Hi Michael, I'm looking for a possiblity to provide the user with custom exception messages in a database driver extension, according to the locale of his installation/system. The prefered solution from my side would be to provide the messages strtings in some sort of plain text ressource file(s) and fetch them from there in the driver. I know that css.resource.OfficeResourceBundle is working fine (we use it in our drivers, too), but its drawback is that it's based on .res files, compiled from .src files when building OOo. Since I assume that your driver is not built in an OOo build env, but with the ODK, this is probably no option. I also know that the dialog localization feature is based on text files, but I'm somewhat lost on the details. AFAIK, the css.resource services can be used to access such files, but that's an educated guess only. I suggest you play a little with the StringResourceWithLocation service. The documentation of those services/interfaces seems to be ... above average :), so http://api.openoffice.org/docs/common/ref/com/sun/star/resource/StringResourceWithLocation.html might indeed help you. Ciao Frank -- - Frank Schönheit, Software Engineer frank.schoenh...@sun.com - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] connect to ldap fails with authentication
Hi Peter, in m58 and in former installations I cannot connect to a ldap datasource if a password is required. Without password the connect succeeds. Maybe it has something to do with the name of the user: CN=install,OU=Admins,OU=xxx DC=de I tried the user/pw authentication with Thunderbird Addressbook and LDAPExplorerTool2 without any problems. So the problem is on oo side? Probably yes :-\ You submitted an issue for this, but neither from the issue nor from this mail here I get whether it ever worked for you ...? That is, we upgraded the underlying code which provides LDAP access in m53 (IIRC), and if this is the version where it stopped working for you, than that's a regression in that code (SeaMonkey 1.1x, as opposed to stone-aged Mozilla 1.7.x), or in the way how we use it. Perhaps this issue is a good chance to get rid of the LDAP-via-Mozilla implementation, and write a dedicated LDAP driver, which directly uses OpenLDAP or some such ... (desired for years, not implemented for the same time) Ciao Frank -- - Frank Schönheit, Software Engineer frank.schoenh...@sun.com - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] Resultset FetchDirections
Hello Fernand, The DEV guide told us to set the approriate FetchDirection in the Statement object. OK: but where can I find more information about this Fetch settings ? In theory: http://api.openoffice.org/docs/common/ref/com/sun/star/sdbc/FetchDirection.html In practice: All of OOo's own driver implementaions completely ignore this setting, it's only applied if you bridge to an external driver (JDBC/ODBC/ADO). So, the respective chapter in the DevGuide (where did you read that) seems to be inspired by the theory, not the practice. Or is the FetchDirection automaticly set by the ResultsetType in the Statement object No. Ciao Frank -- - Frank Schönheit, Software Engineer frank.schoenh...@sun.com - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] connect to ldap fails with authentication
Hi Peter, So I tell you, that it doesn't work in an old version (2.2) neither. okay, this reliefs me from the suspicion that it is a regression from the SeaMonkey migration, at least. Thanks Ciao Frank -- - Frank Schönheit, Software Engineer frank.schoenh...@sun.com - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] Sun Connector for mySQL Column Default and Description not passed(correction)
Hi Fernand, Defaultvalues are passed for Native and ODBC Comment are NOT passed for both drivers There's no code for passing this down, what you see as column description in the table designer UI is purely client-side. The whole table designer would need some overhauling here, fixing this problem, as well as a better default handling, as well as possibly offering more backend-specific properties ... Ciao Frank -- - Frank Schönheit, Software Engineer frank.schoenh...@sun.com - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] MySQL Native Driver source
Hi Ariel, any idea where the MySQL Native Driver source code can be found? switch a local SVN working copy of the OOo source tree to .../cws/mysqlnative, and issue a build --all in module mysqlc. Ciao Frank -- - Frank Schönheit, Software Engineer frank.schoenh...@sun.com - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org