Re: [JDBC] JDBC setObject

2001-04-18 Thread Bruce Momjian
[ Charset ISO-8859-1 unsupported, converting... ] > Hi all, > > I have reported a problem with the PreparedStatement.setObject method on the > general list, and using the bug database. > > I haven't received any replies yet. I am prepared to fix the problem myself, > how do I go about this? Not

[JDBC] JDBC Driver under load

2001-04-18 Thread Mike Cannon-Brookes
Has anyone used the JDBC driver under heavy load? We're having a problem on one of our production machines that on some occasions under heavy load Postgres JDBC connections seem to be dying / locking up. Here's an example trace: An I/O error occured while reading from backend - Exception: java.n

Re: [JDBC] JDBC Driver under load

2001-04-18 Thread Tom Lane
What shows up in the postmaster's log when this happens? (If you're not keeping a postmaster log, now would be a good time to start.) regards, tom lane ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? ht

[JDBC] InputStream as parameter not supported

2001-04-18 Thread Steven Smith
I am using PostgreSQL 7.0, with the jdbc7.0-1.2.jar file. I am trying to send a Large Object to the database but get an error saying 'InputStream as parameter not supported' The offending statement is 'stmt.setBinaryStream(1, geomStream, geomStream.available());' where geomStream is an instanceof

[JDBC] RE: JDBC Driver under load

2001-04-18 Thread Mike Cannon-Brookes
It looks to me like there's many queries running that have frozen or are just taking a long time. Is it possible to see who is connected to postgres, and what query they're running? Or alternatively, somehow log the queries time taken? (I have the query statements being logged, looking for the tim