Apache OpenOffice (AOO) Bugzilla – Issue 11059
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 -----------------------------------------------------
marking as duplicate *** This issue has been marked as a duplicate of 11057 ***
As mentioned on the qa dev list on March 5th I will close all resolved duplicate issues. Please see this posting for details. First step in IssueZilla is unfortunately to set them to verified.
As mentioned on the qa dev list on March 5th I will close all resolved duplicate issues. Please see this posting for details.
change subcomponent to 'none'