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