Re: strange error - Mailing list pgsql-jdbc

hi all...in addition to all those errors i could get some more
information...

this is the dump that i get when i run the simplest of jdbc
inserts/selects

helping mails plz...
-------------------------------------------------------------------------------------------
[sriram@nmlinux2 sriram]$ java jdbc
020301.16:00:08.437  [3033] read_pg_options: verbose=2,query=2,syslog=0
020301.16:00:08.440  [3033] started: host=127.0.0.1 user=sriram database=mydb
020301.16:00:08.440  [3033] InitPostgres
020301.16:00:08.818  [3033] reset_client_encoding()..
020301.16:00:08.820  [3033] reset_client_encoding() done.
020301.16:00:08.831  [3033] StartTransactionCommand
020301.16:00:08.831  [3033] query: set datestyle to 'ISO'; select version(), case when pg_encoding_to_char(1)
= 'SQL_ASCII' then 'UNKNOWN' else getdatabaseencoding() end;
020301.16:00:08.974  [3033] ProcessUtility: set datestyle to 'ISO'; select version(), case when
pg_encoding_to_char(1) = 'SQL_ASCII' then 'UNKNOWN' else getdatabaseencoding() end;
020301.16:00:08.996  [3033] ProcessQuery
020301.16:00:09.008  [3033] CommitTransactionCommand
020301.16:00:09.212  [3033] StartTransactionCommand
020301.16:00:09.212  [3033] query: SELECT * FROM TABLE1
020301.16:00:09.301  [3033] ProcessQuery
020301.16:00:09.307  [3033] CommitTransactionCommand
Internal error: caught an unexpected exception.
Please check your CLASSPATH and your installation.
java/lang/NoSuchMethodError: java/sql/Statement.getResultSetConcurrency()I
at org.postgresql.jdbc2.Connection.getResultSet(Connection.java:216)
at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:121)
at org.postgresql.Connection.ExecSQL(Connection.java:398)
at org.postgresql.jdbc2.Statement.execute(Statement.java:130)
at org.postgresql.jdbc2.Statement.executeQuery(Statement.java:54)
at jdbc.main(jdbc.java:18)
pq_recvbuf: unexpected EOF on client connection
020301.16:00:09.475  [3033] proc_exit(0)
020301.16:00:09.475  [3033] shmem_exit(0)
020301.16:00:09.475  [3033] exit(0)
Aborted
-------------------------------------------------------------------------------------------
On Tue, 26 Feb 2002, Nick Fankhauser wrote:

!Date: Tue, 26 Feb 2002 07:39:52 -0500
!From: Nick Fankhauser <nickf@ontko.com>
!To: Psql-Jdbc <pgsql-jdbc@postgresql.org>, # sriram # <sriram@imsc.ernet.in>
!Subject: Re: [JDBC] strange error
!
!I'll copy this to the JDBC list again. (I'd suggest posting all of these to
!the list- While I'm happy to try to help, I'm not the most informed person
!on the list, so you really need everyone's eyeballs checking these problems
!out.)
!
!Here are a few more ideas:
!
!
!> well....i missed the database...it should read
!> jdbc:postgres://localhost:5432/mydb," "," ".....
!OK, so that's not the problem.
!
!
!> i mentioned apache and tomcat...to make matters more simple if someone
!> really feels that my jdbc classpath should also be present on the tomcat
!> lib directory....i tried that also...(sounds silly though)
!
!Are you running this through a servlet, or just in a standalone application?
!I'd suggest trying to debug this with a simple standalone application first
!& get tomcat involved once the database issue is resolved.
!
!
!> i ran netstat --tcp -a -n | grep 5432 and i found just 5432 listening to
!> my requests and there are no other clashes...
!
!I think others have experienced disconnects after an initial response due to
!some packet filtering, so I'm still curious about whether you have any
!network security software running.
!
!
!> i also tried running postmaster on a different port...but no avail...
!> some one mentioned that i am trying to access a jdbc2 statement......
!> how far can i go in that direction...
!
!
!> PS..amazingly mysql also throws the same error ??
!
!I think this is an important clue. I think it points again to another piece
!of software interfering.
!
!-NickF
!
!
!
!
!
!
!
!>
!>
!> On Fri, 22 Feb 2002, Nick Fankhauser wrote:
!>
!> !Hi-
!> !
!> !I'm going to copy your response to the JDBC list, so others can view the
!> !config info.
!> !
!> !The snippet of code that you include doesn't appear to specify a database
!> !name in the URL- is it really this way, or is that just from
!> pasting it into
!> !the mail message? If this is an exact copy, maybe we've found
!> your problem.
!> !
!> !Nothing in your environment looks like a problem to me. You
!> mention tomcat &
!> !apache, but so far these aren't involved, correct? It looks like
!> you're just
!> !trying to get a plain vanilla connection to the database going.
!> !
!> !You mentioned in an earlier post that you got the message "pg_recvbuf :
!> !client closed connection" in one of the logs. Is it possible
!> that you have
!> !some sort of network security software running that might interfere with
!> !tcp/ip socket communication? Even though you're on the same machine, the
!> !communication looks like any other network traffic.
!> !
!> !Those are my three best guesses. The first one seems obvious, but doesn't
!> !seem to match the error message, that's why I thought it might just have
!> !gotten copied into the mail wrong.
!> !
!> !-NickF
!> !
!> !
!> !
!> !> -----Original Message-----
!> !> From: # sriram # [mailto:sriram@imsc.ernet.in]
!> !> Sent: Friday, February 22, 2002 8:15 AM
!> !> To: Nick Fankhauser
!> !> Subject: RE: [JDBC] strange error
!> !>
!> !>
!> !> ok here we go...
!> !>
!> !> i downloaded the tar archive from sun ....
!> !> and then the postgresql.jar from one of the postgres links...
!> !> i run mdk8 with apache and tomcat servers...
!> !> i use postgresql 7.1 (i believe)
!> !> my classpath is perfect....
!> !> my installation sits in /usr/local
!> !>
!> !> really puzzling ??
!> !>
!> !> may be i will attach the code also...
!> !>
!> !> import java.sql.Connection;
!> !> import java.sql.DriverManager;
!> !> import java.sql.ResultSet;
!> !> import java.sql.Statement;
!> !>
!> !> public class jdbc
!> !> {
!> !>     public static void main(String args[]) throws
!> !> SQLException,ClassNotFoundException
!> !>     {
!> !>     Class.forName("org.postgresql.Driver");
!> !>     Connection
!> !> con=DriverManager.getConnection("jdbc:postgresql://localhost:5432"
!> !> ,"sriram","******");
!> !>     Statement s=con.prepareStatement();
!> !>     s.execute("insert into...................");
!> !>     }
!> !> }
!> !>
!> !> and the host of errors..which i have already included
!> !>
!> !>
!> !>
!> !> On Fri, 22 Feb 2002, Nick Fankhauser wrote:
!> !>
!> !> !Although it sounds like you have matched up the correct versions
!> !> of the jvm
!> !> !& jdbc driver, the error message still seems to point to a
!> problem in you
!> !> !environment rather than your code. Please give us some more
!> !> details on your
!> !> !platform, such as the source of the jvm
!> (Sun/IBM/blackdown/Jikes, etc...)
!> !> !and versions & sources of anything else you can think of that might be
!> !> !relevant.
!> !> !
!> !> !-NickF
!> !> !
!> !> !
!> !> !> i am using j2sdk1.3.1 and downloaded postgresql.jar from the
!> !> !> specified site which said drivers for jdk1.2+
!> !> !
!> !> !> !> Internal error: caught an unexpected exception.
!> !> !> !> Please check your CLASSPATH and your installation.
!> !> !> !> java/lang/NoSuchMethodError:
!> !> !> !java/sql/Statement.getResultSetConcurrency()I
!> !> !> !
!> !> !
!> !> !
!> !>
!> !> -----------------
!> !> rm -rf /bin/laden
!> !> -----------------
!> !>
!> !
!> !
!> !---------------------------(end of broadcast)---------------------------
!> !TIP 6: Have you searched our list archives?
!> !
!> !http://archives.postgresql.org
!> !
!>
!> -----------------
!> rm -rf /bin/laden
!> -----------------
!>
!
!
!---------------------------(end of broadcast)---------------------------
!TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
!

----------
mAtScIeNcE
----------