Issue 75741

Summary: Open Office Crashes connecting to postgresql via JDBC
Product: Base Reporter: johanhenselmans2 <johan.henselmans>
Component: codeAssignee: dbaneedsconfirm <needsconfirm>
Status: CLOSED DUPLICATE QA Contact: issues@dba <issues>
Severity: Trivial    
Priority: P3 CC: issues
Version: OOo 2.2 RC4   
Target Milestone: ---   
Hardware: Mac   
OS: All   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---

Description johanhenselmans2 2007-03-26 12:26:25 UTC
Create a local or remote connection to a postgresql database via JDBC.
Save the Database document.
Open the database document, fill in the username/password for the database. 
Try to open a table. Open Office silently crashes. 
While running in xterm, this is the message one gets:

ppp20:/Applications/OpenOffice.org 2.2.app/Contents/MacOS/program johan$ ./soffice.bin 
terminate called after throwing an instance of 
'jvmaccess::VirtualMachine::AttachGuard::CreationException'
Abort trap


jdbc: postgresql-jdbc-8.2-504

java: java version "1.5.0_07"
Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0_07-164)
Java HotSpot(TM) Client VM (build 1.5.0_07-87, mixed mode, sharing)

System:

ppp20:~ johan$ uname -a
Darwin ppp20.nest.nl 8.9.1 Darwin Kernel Version 8.9.1: Thu Feb 22
20:55:00 PST 2007; root:xnu-792.18.15~1/RELEASE_I386 i386 i386


ppp20:~ johan$ psql82 --help
This is psql 8.2.3, the PostgreSQL interactive terminal.

psql is built from www.macports.org.

Connection in which I noticed the problem is remote. If I try local, same problem.

I have tried already to look at the crash log. There isn't any, nor a
message in /var/log/system.log. I looked in all the usual places.
Started with ./soffice and ./soffice.bin. I had even turned on the
java console logging on to see if I could get some messages over
there.
Comment 1 guy_rouillier 2007-04-03 22:20:02 UTC
I am having the same problem described here.  Running the new OpenOffice version
2.2, using the PostgreSQL driver postgresql-8.2-504.jdbc3.jar.  I can open the
datasource, and when I click Tables it shows me a list of tables.  But when I
try to open a particular table, Base appears to hang for about 15 seconds, then
crashes.

I also set up a different datasource using the sdbc driver, and that one works
fine, so the database is working.  My platform is Windows XP Home, and the
database is installed locally.

I see the following in the PostgreSQL log:

2007-04-03 16:49:45 LOG:  could not receive data from client: No connection
could be made because the target machine actively refused it.

2007-04-03 16:49:45 LOG:  unexpected EOF on client connection
Comment 2 Frank Schönheit 2007-04-04 08:16:28 UTC
sounds like a duplicate of issue 75872, which technically is a duplicate of
issue 74732.

*** This issue has been marked as a duplicate of 75872 ***
Comment 3 Frank Schönheit 2007-04-04 08:17:40 UTC
closing duplicate