Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql Interfaces Jdbc > JVM crash when ...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 6 Topic 1887 of 1997
Post > Topic >>

JVM crash when select count(*) on large table through JDBC

by k.ruhl@[EMAIL PROTECTED] ("Kai Ruhl") Feb 22, 2008 at 05:25 PM

Hello,

I have a curious problem, which I would like to know whether somebody
can reproduce this: From a JVM using JDBC, I issue

	select count(*) from big_table

where big table has more than 20 million entries (timestamps and
numbers). Upon PreparedStatement.executeQuery(), the VM quits, without
any message.

Java VM: 1.4.2-16 (latest one)
Pg-Jdbc: JDBC3 Postgresql Driver, Version 8.3-603
Server:  PostgreSQL 8.1.11 (on Debian etch)

The most surprising thing is the lack of any error message (I had
expected a TimeOutException, or OutOfMemoryError, or the like), as if
someone had called System.exit().

The same commando, when executed through pgAdmin III, works.

As suggested on the website (http://jdbc.postgresql.org/lists.html),
I
have searched the mailing lists, to no avail so far.

I would highly appreciate any reproduction of these results, or
suggestions for remedy.

Kind regards,

  Kai Ruhl


---------------------------(end of broadcast)---------------------------
TIP 7: You can help sup****t the PostgreSQL project by donating at

                http://www.postgresql.org/about/donate
 




 6 Posts in Topic:
JVM crash when select count(*) on large table through JDBC
k.ruhl@[EMAIL PROTECTED]   2008-02-22 17:25:15 
Re: JVM crash when select count(*) on large table through JDBC
pg@[EMAIL PROTECTED] (Da  2008-02-22 14:30:38 
Re: JVM crash when select count(*) on large table through JDBC
olarte.andres@[EMAIL PROT  2008-02-22 14:19:02 
Re: JVM crash when select count(*) on large table through
books@[EMAIL PROTECTED]   2008-02-22 15:33:44 
Re: JVM crash when select count(*) on large table through JDBC
olarte.andres@[EMAIL PROT  2008-02-22 14:39:54 
Re: JVM crash when select count(*) on large table through JDBC
pg@[EMAIL PROTECTED] (Da  2008-02-22 16:13:18 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan13V112 Thu Jul 24 1:48:06 CDT 2008.