Apache OpenOffice (AOO) Bugzilla – Issue 2529
Form Letter crash when data not preloaded
Last modified: 2013-08-07 15:45:41 UTC
When I try to retrieve data from a JDBC Data Source into a Form Letter, and the data was not yet displayed (e.g. I dont wan't the form letter to start with record 1 but rather with record 20) in the table at the right side of the form letter dialog, printing crashes. The problem can be worked around by first scrolling down the table to the point where I want to start printing the letters.
Seems to be a timing problem in the beamer window or the form. Marc, can you reproduce the problem?
Hi, I can't reproduced this problem, so I have some questions. Which JDBC driver do you use? How many records are in teh table? Bye Mary
Sorry, my name is Marc not Mary.
Hi, I could provide a compact testcase including DDL for a JDBC driver if someone could send me a formletter or a ling where to find them(and of course if I can reproduce this). Currently I don't know how to write such a formletter template. Would someone be so kind to send me one to bht@actrix.gen.nz ? Thanks, Bernard
Bernard, Form letter in this context simply means a writer document which contains database fields (it's a - reasonable - guess of what Moritz meant). For creating such a form letter, simply open a table in the data source browser, and drag'n'drop a column into a new text document. Ciao Frank
Frank, I can't believe how easy it is. Thanks a lot!
Would like to duplicate this but cannot connect to my JDBC datasource. The server is running and I connect to it with other programs ok. Error is: The connection to the data source "name here" could not be established. SQL Status S1000 Description "No Java installed" The path of the jar file with the driver is under Option|Security as a single entry (locks up if I want to add another one). I re-installed Java in OpenOffice multiple times. Found a java.ini file: [Install] InstallationPath=. CPLD=0 AdditionalClasspath=<OFFICE_CLASSDIR>\classes.jar;<OFFICE_CLASSDIR>\sandbox.jar;<OFFICE_CLASSDIR>\ridl.jar;<OFFICE_CLASSDIR>\unoil.jar;<OFFICE_CLASSDIR>\jurt.jar;<OFFICE_CLASSDIR>\juh.jar;<OFFICE_CLASSDIR>\swingall.jar;<OFFICE_CLASSDIR>\java_uno.jar;<OFFICE_CLASSDIR>\xt.jar;<OFFICE_CLASSDIR>\jaxp.jar; VerifiedVersion=1.3.1 RequiredVersion=1.3.0 ExcludeVersion=1.1.6 1.1.7b 1.1.7B 1.1.8 1.2.1 [Java] Home=C:\Program Files\Java\j2re1.4.0 VMType=jre Version=1.4.0 RuntimeLib=C:\Program Files\Java\j2re1.4.0\bin\hotspot\jvm.dll SystemClasspath=C:\Program Files\Java\j2re1.4.0\lib\rt.jar;C:\Program Files\Java\j2re1.4.0\lib\i18n.jar;C:\Program Files\Java\j2re1.4.0\lib;C:\prog\STOFF\program\classes\classes.jar;C:\prog\STOFF\program\classes\sandbox.jar;C:\prog\STOFF\program\classes\ridl.jar;C:\prog\STOFF\program\classes\unoil.jar;C:\prog\STOFF\program\classes\jurt.jar;C:\prog\STOFF\program\classes\juh.jar;C:\prog\STOFF\program\classes\swingall.jar;C:\prog\STOFF\program\classes\java_uno.jar;C:\prog\STOFF\program\classes\xt.jar;C:\prog\STOFF\program\classes\jaxp.jar; Java=1 JavaScript=1 Applets=1 That all looks quite good but what could be missing? Is there an easy test to verify Java before I get into the driver issue? Any ideas? Many thanks.
Sorry, but where is path to your jdbc-driver class?
Thanks for the feedback. I entered the class name "com.mckoi.JDBCDriver" in Data Souce Administration JDBC tab. Results appear in DataAccess.XML: <DataSourceDescription state="replaced" cfg:name="GE2"> <Bookmarks cfg:element-type="Bookmark"/> <DataSourceSettings cfg:element-type="DataSourceSetting"> <DataSourceSetting cfg:name="CharSet"> <Value cfg:type="string"/> </DataSourceSetting> <DataSourceSetting cfg:name="JavaDriverClass"> <Value cfg:type="string">com.mckoi.JDBCDriver</Value> </DataSourceSetting> </DataSourceSettings> <IsPasswordRequired cfg:type="boolean">true</IsPasswordRequired> <LayoutInformation cfg:type="binary" cfg:nullable="false" cfg:encoding="hex"/> <LoginTimeout cfg:type="int">0</LoginTimeout> <NumberFormatSettings cfg:type="binary" xsi:null="true"/> <Queries cfg:element-type="Query"/> <SuppressVersionColumns cfg:type="boolean">true</SuppressVersionColumns> <TableFilter cfg:type="string" cfg:derivedBy="list">%</TableFilter> <TableTypeFilter cfg:type="string" cfg:derivedBy="list"/> <Tables cfg:element-type="Table"/> <URL cfg:type="string">jdbc:mckoi://localhost:port number here/</URL> <User cfg:type="string">user name here</User> </DataSourceDescription> And the additional classpath shows in the file user\config\registry\instance\org\openoffice\Office\Java.xml as follows: <Java state="modified" cfg:package="org.openoffice.Office" xmlns="http://openoffice.org/2000/registry/components/Java" xmlns:cfg="http://openoffice.org/2000/registry/instance" xmlns:xsi="http://www.w3.org/1999/XMLSchema-instance"> <VirtualMachine> <NetAccess cfg:type="int">0</NetAccess> <UserClassPath cfg:type="string">C:\prog\mckoi\mkjdbc.jar;C:\prog\jdk14\jre\lib\rt.jar</UserClassPath> </VirtualMachine> </Java>
OK I have JDBC running. The problem was JRE 1.4 was accepted as runtime in OOo but only 1.3 is supported and works. Will come back to this bug after I am a little more familiar with JDBC datasources. Thanks a lot for your help.
Hi, is this bug still there in the new version. Bye Marc
Hi, I'll check thet status with the new version of OpenOffice after my holidays. Actually, you didn't even need a JDBC Datasource. A CSV TextFile as Datasource was alright to make the bug show up. Greeting Moritz
I've been working with the Firebird database and their JDBC driver in OpenOffice to develop form letters. Unfortunately I get the same crash as previously noted. I'm using OOo v643 on Win2K SP3 (Java 1.4.1) connecting to a Firebird (v1.02) database on a Linux server. On the latest crash I received the following error: The instruction at "0x0040634e" referenced at "0x00000030" The memory could not be read. Hope this helps and if you need more info please ask. Thanks
Some additional notes: 1. Upgraded to 643C and problem still occurs 2. OO Writer doesn't crash if you select one record from the database 3. The information from the database (using a single record) does not update the fields in the document.
change subcomponent to 'none'
mh->msc: can we close this issue ?
yes I think so -> close
close