[dba-dev] 64-bit version of the PostgreSQL SDBC driver ? Pretty please ?
Dear list, I have used the PostgreSQL SDBC driver for a while ...on x86 machines. I currently use a new laptop with an Intel Core2 Duo. Consequently, I installed Ubuntu Hardy amd64. This distribution has a openoffice.org-sdbc-postgresql package, which is 0.7.5, and no update yet to 0.7.6. The links posted on http://dba.openoffice.org/drivers/postgresql/index.html point to zip files containing 32-bit shared libraries (and 32 bit Windows libraries, BTW), uninstallable on a 64-bit distribution. (Yes, I've checked that the Ubuntu package install 64-bit code...). Rebuilding this package seems to entail rebuilding the whole openoffice.org (i. e. about 50 packages needing about 70 new tools, and a multi-gigabyte affair, last time I tried). A bit stiff for laptop... According to what I read on the driver age, rebuilding just the zip file seem to entail whole OOo 1.x build environment. Yayy !... Would it be possible to have updated amd64 versions on the Web page and/or accessible by the Tools/Extensions/Update tool on the OOo interface. It works *well* on x86 installations, and amd64 should be no different (64-bit platforms are still a minority, thanks to the incompetence of Microsoft, but are probably the future. No reason to tolerate them being treated as second-class citizens...). Sincerely, Emmanuel Charpentier - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dba-dev] 64-bit version of the PostgreSQL SDBC driver ? Pretty please ?
Emmanuel Charpentier a écrit : Hi, I have used the PostgreSQL SDBC driver for a while ...on x86 machines. I currently use a new laptop with an Intel Core2 Duo. Consequently, I installed Ubuntu Hardy amd64. This distribution has a openoffice.org-sdbc-postgresql package, which is 0.7.5, and no update yet to 0.7.6. I asked a similar question about a version for the Mac Intel platform, when he announced the availability of the new version, but as yet have had no reply from the original developer. That said, he might be on vacation. :-) Alex - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dba-dev] 64-bit version of the PostgreSQL SDBC driver ? Pretty please ?
Hi *, I have used the PostgreSQL SDBC driver for a while ...on x86 machines. I currently use a new laptop with an Intel Core2 Duo. Consequently, I installed Ubuntu Hardy amd64. This distribution has a openoffice.org-sdbc-postgresql package, which is 0.7.5, and no update yet to 0.7.6. I asked a similar question about a version for the Mac Intel platform, when he announced the availability of the new version, but as yet have had no reply from the original developer. That said, he might be on vacation. :-) While we are at it ... Is anybody willing to invest some time into making this driver an integral part of regular OOo builds? We have a CWS where we started it, there were some open issues (details slip my memory ATM, but nothing which cannot be resolved), however neither Jörg nor the Base core team found the time/priorities to finish it. If anybody volunteered, we would provide all necessary help, as usual, and finally all those questions to obtain the driver for a specific platform would be meaningless, since it would be included in every regular OOo installation. Volunteers? Ciao Frank -- - Frank Schönheit, Software Engineer [EMAIL PROTECTED] - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dba-dev] How to store formated text in OO base
Peter Eberlein schrieb: Hi, Marc Santhoff schrieb: Am Freitag, den 22.08.2008, 13:44 +0200 schrieb Fernand Vanrie: Can hard coded or styled formated text out off a writer doc been stored in OO base and then been used to be placed in a new writerdoc. - witch data type ? - how to enter ? - how to reproduce in a form ? just tried to put the XTransferable in a formatted TextField without success. The field doesn't support clipboard or transferable actions with formatted text. Worth an RFE? Sub Main xCurrentController = ThisComponent.CurrentController xCursor = ThisComponent.getText.createTextCursor() xCursor.gotoEnd(true) xViewCursor = xCurrentController.getViewCursor // make the selection xViewCursor.gotoRange(xCursor,false) xTransferable = xCurrentController.getTransferable xTextField = Thiscomponent.DrawPage.Forms(0).getByName(TextBox) xView = xCurrentcontroller.getControl(xTextField) xView.setFocus // pasting xCurrentController.insertTransferable(xTransferable) End Sub - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dba-dev] How to store formated text in OO base
Marc and Peter, Thanks for your responses, Normally for copying images and formated text portions from OO- docs or non-OO documents I simply uses the uno:copy with the dispatcher. This approach works fine I will now investigate the XTransferable stuff for a suposed more cleaner code :-). But I still has some questions: - how do i Store Cliboard or XTransferable content in to the database ? - how do i call it back from the base into the clibboard or in to a XTransferable object ? When having the database content in the cliboard or a in a XTransferable object, then the missing off a proper Form Field can been resolved with showing the database content in a frame or Cell. and using a writerdoc as a form. Thanks already for your help Fernand Peter Eberlein wrote: Peter Eberlein schrieb: Hi, Marc Santhoff schrieb: Am Freitag, den 22.08.2008, 13:44 +0200 schrieb Fernand Vanrie: Can hard coded or styled formated text out off a writer doc been stored in OO base and then been used to be placed in a new writerdoc. - witch data type ? - how to enter ? - how to reproduce in a form ? just tried to put the XTransferable in a formatted TextField without success. The field doesn't support clipboard or transferable actions with formatted text. Worth an RFE? Sub Main xCurrentController = ThisComponent.CurrentController xCursor = ThisComponent.getText.createTextCursor() xCursor.gotoEnd(true) xViewCursor = xCurrentController.getViewCursor // make the selection xViewCursor.gotoRange(xCursor,false) xTransferable = xCurrentController.getTransferable xTextField = Thiscomponent.DrawPage.Forms(0).getByName(TextBox) xView = xCurrentcontroller.getControl(xTextField) xView.setFocus // pasting xCurrentController.insertTransferable(xTransferable) End Sub - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dba-dev] How to store formated text in OO base
Hi Peter, The field doesn't support clipboard or transferable actions with formatted text. Worth an RFE? Sure. (Though I admit the thing I would want to fix before for this control is the inability to store its content in a database field ...) Ciao Frank -- - Frank Schönheit, Software Engineer [EMAIL PROTECTED] - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dba-dev] How to store formated text in OO base
OK I found a complex :-) solution using temp RTF files, but should works select the formated text portion and put it in a new empty OO_source.odf. save OO_source.odf to RTF_temp.rtf usng the RTF-Export Filter Read with simpleFileAcces the content of RTF_source.rtf and put it in a simple Varchar database field. Put the content of f the VarChar field into a simple text file with rtf extension insert the text.rtf into the OO- doc using the RTF- ImportFilter any ideas for shortening this process ? Thanks anyway Fernand - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dba-dev] How to store formated text in OO base
Hi Fernand, Fernand Vanrie schrieb: OK I found a complex :-) solution using temp RTF files, but should works select the formated text portion and put it in a new empty OO_source.odf. save OO_source.odf to RTF_temp.rtf usng the RTF-Export Filter Read with simpleFileAcces the content of RTF_source.rtf and put it in a simple Varchar database field. Put the content of f the VarChar field into a simple text file with rtf extension insert the text.rtf into the OO- doc using the RTF- ImportFilter any ideas for shortening this process ? don't know if this is shorter, but as I said you can store your OO_source.odf into a stream and then read/write a blob field of your database. e.g. http://www.oooforum.org/forum/viewtopic.phtml?t=29434 Regards Peter - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dba-dev] Image control aspect ratio
Frank Schönheit - Sun Microsystems Germany wrote: Hi Fernand, A related question: Can you give me some hints to produce a minimal code (maybe no code at all :-) )to put images out of a database into a writerdoc who is the base document to run a mailmerge using the beamer(F4) In general, the database column is able to provide its content as stream (getBinaryStream, being an XInputStream). Of course you could write this to a file (though I do not know the API for this). Whether it's possible to directly put the binary content into a text doc - not sure, perhaps the css.graphic API has something for it. I suggest asking this in detail in [EMAIL PROTECTED] If your main problem is how to get the column which supplies the binary stream, then I might be able to help - if you tell me somewhat more about your setup. Frank, thanks for the reply but in the mean time we decided to store the URL's in the datbase and not the dinary data. But storing formated text into a database field is a related problem, and Marc Santhof replied as follows: Use doc.StoreToUrl() using a stream as target and connect that stream object to the db field (on a prepared statement get/setBinaryStream() IIRC). I'm sure *Frank* can help with the details of connecting a stream to a database column ... Can you help me Frank :-) Greetz Fernand Ciao Frank - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dba-dev] 64-bit version of the PostgreSQL SDBC driver ? Pretty please ?
Hi, the driver should be buildable in OOo-2 build environment. You just need to build the office code up to offuh and cppuhelper, afterwards the driver should build as explained at http://dba.openoffice.org/drivers/postgresql/index.html#source I may sooner or later have a look to integrate into the Tools/Extensions/Update mechanism, this is doesn't work for any platform up to now. Bye, Joerg Emmanuel Charpentier wrote: Dear list, I have used the PostgreSQL SDBC driver for a while ...on x86 machines. I currently use a new laptop with an Intel Core2 Duo. Consequently, I installed Ubuntu Hardy amd64. This distribution has a openoffice.org-sdbc-postgresql package, which is 0.7.5, and no update yet to 0.7.6. The links posted on http://dba.openoffice.org/drivers/postgresql/index.html point to zip files containing 32-bit shared libraries (and 32 bit Windows libraries, BTW), uninstallable on a 64-bit distribution. (Yes, I've checked that the Ubuntu package install 64-bit code...). Rebuilding this package seems to entail rebuilding the whole openoffice.org (i. e. about 50 packages needing about 70 new tools, and a multi-gigabyte affair, last time I tried). A bit stiff for laptop... According to what I read on the driver age, rebuilding just the zip file seem to entail whole OOo 1.x build environment. Yayy !... Would it be possible to have updated amd64 versions on the Web page and/or accessible by the Tools/Extensions/Update tool on the OOo interface. It works *well* on x86 installations, and amd64 should be no different (64-bit platforms are still a minority, thanks to the incompetence of Microsoft, but are probably the future. No reason to tolerate them being treated as second-class citizens...). Sincerely, Emmanuel Charpentier - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]