Re: strange error - Mailing list pgsql-jdbc

Hi-

I'm going to copy your response to the JDBC list, so others can view the
config info. They might have some better ideas.

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
> -----------------
>