Apache OpenOffice (AOO) Bugzilla – Issue 11057
Unrecoverable crash CREATING POSTGRES tables/ready only tables
Last modified: 2006-05-31 14:29:06 UTC
Hi, I am using OpenOffice as a database client to connect to a Postgres database using unixODBC. Version details are: OpenOffice 1.0.1 Linux 2.4.2.2 Postgres 7.2.3 (running with -i option for TCP/IP connections) unixODBC 2.2.3 Problem1: Creating a table using Table Design always result in "An unrecoverable error occurred ...." and soffice exits. When I restart Openoffice the table has been created and can be used. Problem2: Unless I create the table using Table Design I cannot update the table. If I use SQL or another database client (datadino) to create the table then I can use SQL or the application to update the table. I cannot use OpeneOffice. I thought this might be due to the ODBC driver so I tried JDBC. Using JDBC I cannot write to any table at all (read only connections only). Have you any suggestions for resolving this. My OpenOffice connections are configured as follows: For ODBC type: ODBC URL: sdbc:odbc:MyOdbc.ini obdc.ini: ------------------------------------------ [MyOdbc.ini] Description = MyOdbc.ini Driver = PostgreSQL Trace = Yes TraceFile = /home/atalanta1/leeder/odbc.log Database = <MyDatabase> Servername = <Ip Server Ip> UserName = <Myusername> Password = Port = 5432 Protocol = 6.4 ReadOnly = No RowVersioning = No ShowSystemTables = No ShowOidColumn = No FakeOidIndex = No ConnSettings = ----------------------------------- For JDBC: (postgresql.jar added to classpath) Driver Class: org.postgresql.Driver URL: sdbc:postgresql://<ip>:<myport>/<MyDataBase> I tried to register with the user group earlier but have had problems with email the last couple of days (ISP problems!) so have not received a confirmation. I hope this query can still be dealt with. I've been using OpenOffice for a few weeks now and have been very impressed at its configurability & scope. Our company is now using it instead of MS word, excel etc. Thanks for any help/advice you can provide on my problems. Regards, Glen ----------------------------------------------------- Glen Leeder <leeder@atalanta-consulting.co.uk> <gjleeder@hotmail.com> Tel: +44 1753 874436 Fax: +44 1753 784365 http://www.atalanta-consulting.co.uk -----------------------------------------------------
re-assign to QA owner
*** Issue 11059 has been marked as a duplicate of this issue. ***
Hi, I can't reproduce this with the newest psqlODBC driver from http://odbc.postgresql.org and the newest OOo 1.0.2. Can you still reproduce this with the newest versions. Bye Marc
Hi Marc, I tried out the new psqlODBC driver with OpenOffice1.0.1 and 1.0.2. and the problem is fixed. Thanks for your time on the problem. Regards, Glen
glen, that's great news! Could you mark this issue then as WORKSFORME, please?
Problem is fixed with latest psqlODBC driver 7.2.5.
thanks glen! closing WORKSFORME
change subcomponent to 'none'