Skip site navigation (1) Skip section navigation (2)

Re: JDBC error in 7.0.3

From: Peter T Mount <peter(at)retep(dot)org(dot)uk>
To: Travis Bauer <trbauer(at)indiana(dot)edu>
Cc: pgsql-general(at)postgresql(dot)org, pgsql-jdbc(at)postgresql(dot)org
Subject: Re: JDBC error in 7.0.3
Date: 2001-04-17 13:57:12
Message-ID: 987515832.3adc4bb84bafc@webmail.retep.org.uk (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-jdbc
Quoting Travis Bauer <trbauer(at)indiana(dot)edu>:

> During the run of a java program connected to 7.0.3, the following
> errors occurred:
> 
> insert into current_resources values (459, 0, 
> 'http://a1829.g.akamaitech.net/6/1829/792/000/search.britannica.com/
> images/storethumbs/T_CMB_HG_FDALRTP.jpg', '', '', 'not foundnot found 
> the requested object does not exist on this server the link you followed
> 
> is either outdated inaccurate or the server has been instructed not to
> let 
> you have it please inform the site administrator of the referring page
> r', 
> 'Not Found')
> ERROR: Unterminated quotes string
> 
> Error updating: insert into current_usages values (115, 459, 'trbauer',
> 
> CURRENT_TIMESTAMP, 0) -- java.sql.SQLException: 
> FATAL 1:  Socket command type r unknown
> 
> Any subsequent attent to access the database yields:
> 
> An I/O error has occured while flushing the output -
> java.io.IOException: 
> Broken pipe
> 
> The problem is that the first insert statement is correct.  Other
> statements
> had proceeded it.  Could one of them have been the problem?  

No, the SQL looks ok. The broken pipe exceptions seem to indicate that the 
backend is dying for some reason.

If you use psql, does the connection die if you enter the same queries?

Peter

-- 
Peter Mount peter(at)retep(dot)org(dot)uk
PostgreSQL JDBC Driver: http://www.retep.org.uk/postgres/
RetepPDF PDF library for Java: http://www.retep.org.uk/pdf/

In response to

Responses

pgsql-jdbc by date

Next:From: Peter T MountDate: 2001-04-17 13:59:16
Subject: Re: Oracle to PostgreSQL
Previous:From: Peter B. WestDate: 2001-04-17 01:16:19
Subject: Re: Errors Trying To Use JDBC

pgsql-general by date

Next:From: Peter T MountDate: 2001-04-17 13:59:16
Subject: Re: Oracle to PostgreSQL
Previous:From: newsreaderDate: 2001-04-17 13:35:55
Subject: Re: Select

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group