Hi Johan,

I have been having a shot with the SQL server:
MySQL 5.0.21-max
And have not had OpenOffice.org crash once on me. I have created a table, and populated that table with some data. In fact it appears to be more stable the MySQL's own MySQL query browser, which likes crashing on me.

I used the JDBC driver after selecting MySQL in the create database wizard.

I haven't tried postgresql yet.

Shaun

On 20 Feb 2007, at 10:34, Johan Henselmans wrote:

I still have problems connecting to a JDBC database eg, postgresql.

Steps to reproduce:

First:
-install a datases, eg postgresql from www.entropy.ch, or from macports.
-createuser, eg: test
-create database, eg test
-create table, eg test.
start openoffice on command line
1-Create a new database Document, use JDBC as connection method.
2-fill in connections variables: eg:

Datasource URL: jdbc:postgresql://localhost/test
UsernameL: test
JDBC driver: org.postgresql.Driver

3-Test driver (should give OK)
4- Test connection (shoudl give OK)

The tables from the database should fill the view.

After that, try opening a table. Soffice crashes consistently, with error:

terminate called after throwing an instance of 'jvmaccess::VirtualMachine::Attac
hGuard::CreationException'
./soffice: line 236: 2700 Abort trap "$sd_prog/ $sd_binary" "$@"

Observations::

It seems that the java machine is not attached to soffice: every time I look under Extra->Options->Java, a test program is started to find a JVM. This has started somewhere in the 2.1 series. OS versions used during testing: 10.4.7, 10.4.8, 10.4.9 betas


This is really a show stopper, like Alex Thurgood also has remarked. If people cannot use JDBC to connect to databases soffice is useless in environments that use databases. Which is about everywhere.

BTW: like Maho, I still do not receive macporting mail on my .mac account. Please reply direct if you have an answer


-johan






---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



                
___________________________________________________________ The all-new Yahoo! Mail goes wherever you go - free your email address from your Internet provider. http://uk.docs.yahoo.com/nowyoucan.html

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to