Your hints were right and it's working know. In fact, before I have created not a mysql but a jdbc connection to the database in OOo. Changing my old URL "jdbc:mysql://localhost:3306/test" to "sdbc:mysql:jdbc:localhost:3306/test" makes the form-example working.
Thank you very much for your help!! -----Ursprüngliche Nachricht----- Von: Frank Schönheit - Sun Microsystems Germany [mailto:[EMAIL PROTECTED] Gesendet: Mittwoch, 1. November 2006 10:35 An: [email protected] Betreff: Re: [dba-dev] Creating a main-form sub-form Form Hi Stefan, > I have written a program which automatically creates forms in a Writer > Document. It is basically the same as the form example provided by > OpenOffice.org SDK. It creates a Main-Form and a Sub-Form (the Sub-Form is > implemented with grid-columns). > > The underlying database is a mysql database. > > When I create a connection manually via the Base GUI to this database and > use this registered database in the form-program everything works perfectly. The problem might in fact be that your code creates a JDBC connection, whereas you UI-created data source is probably of type MySQL. The dedicated MySQL/JDBC bridge in OOo cares for some MySQL percularities, parameter handling being on of those. As Ocke said, try the "sdbc:mysql:jdbc" prefix instead of "jdbc:mysql", this will load the better suiting driver. Ciao Frank -- - Frank Schönheit, Software Engineer [EMAIL PROTECTED] - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Database http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.1.409 / Virus Database: 268.13.21/511 - Release Date: 01.11.2006 --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
