|
| Hi,
I'm working on an application using PostgreSQL 8.0.3 via Hibernate
2.1.6 in a JBoss 4.0.1 Appserver, with both appserver and
postgres db running on the same machine with Windows XP SP2.
I get the following errors in JBoss' log, does anyone know the problem
and a solution? And yes, I already googled a lot for this problem.
I use the postgresql-8.0-311.jdbc3.jar jdbc driver.
Thanks a lot!
--snip from the stacktrace--
20:38:40,335 WARN & #91;JBossManagedConn
ectionPool] Unable to fill pool
org.jboss.resource. JBossResourceExcepti
on: Could not create connection;
- nested throwable: (org.postgresql.util.PSQLExc
eption: Der Verbindungsversuch schlug fehl.)
at
org.jboss.resource.adapter.jdbc.local. LocalManagedConnecti
onFactory. createManagedConnect
ion(LocalManagedConn
e
ctionFactory.java:161)
at
org.jboss.resource.connectionmanager. InternalManagedConne
ctionPool. createConnectionEven
tListener(InternalMa
na
gedConnectionPool.java:508)
at
org.jboss.resource.connectionmanager. InternalManagedConne
ctionPool. fillToMin(InternalMa
nagedConnectionPool.ja
va:455)
at
org.jboss.resource.connectionmanager.PoolFiller.run(PoolFiller.java:70)
at java.lang.Thread.run(Thread.java:534)
Caused by: org.postgresql.util.PSQLException: Der Verbindungsversuch
schlug fehl.
at
org.postgresql.core.v3. ConnectionFactoryImp
l. openConnectionImpl(C
onnectionFactoryImpl
.java:136)
at
org.postgresql.core.ConnectionFactory. openConnection(Conne
ctionFactory.java:65)
at
org.postgresql.jdbc2. AbstractJdbc2Connect
ion.<init> (AbstractJdbc2Connec
tion.java:117)
at
org.postgresql.jdbc3. AbstractJdbc3Connect
ion.<init> (AbstractJdbc3Connec
tion.java:30)
at
org.postgresql.jdbc3.Jdbc3Connection.<init>(Jdbc3Connection.java:24)
at org.postgresql.Driver.connect(Driver.java:235)
at
org.jboss.resource.adapter.jdbc.local. LocalManagedConnecti
onFactory. createManagedConnect
ion(LocalManagedConn
e
ctionFactory.java:151)
... 4 more
Caused by: java.net.SocketException: Connection reset
at java.net.SocketInputStream. read(SocketInputStre
am.java:168)
at
java.io.BufferedInputStream. fill(BufferedInputSt
ream.java:183)
at
java.io.BufferedInputStream. read(BufferedInputSt
ream.java:201)
at org.postgresql.core.PGStream. ReceiveChar(PGStream
.java:241)
at
org.postgresql.core.v3. ConnectionFactoryImp
l. doAuthentication(Con
nectionFactoryImpl.java:253)
at
org.postgresql.core.v3. ConnectionFactoryImp
l. openConnectionImpl(C
onnectionFactoryImpl
.java:94)
... 10 more
20:38:56,909 WARN & #91;JDBCExceptionRep
orter] SQL Error: 0, SQLState:
08006
20:38:56,909 ERROR & #91;JDBCExceptionRep
orter] Eingabe/Ausgabe-Fehler {0}
beim Senden an das Backend.
20:38:56,940 WARN & #91;JDBCExceptionRep
orter] SQL Error: 0, SQLState:
08006
20:38:56,940 ERROR & #91;JDBCExceptionRep
orter] Eingabe/Ausgabe-Fehler {0}
beim Senden an das Backend.
20:38:56,940 ERROR & #91;JDBCExceptionRep
orter] Could not execute query
org.postgresql.util.PSQLException: Eingabe/Ausgabe-Fehler {0} beim
Senden an das Backend.
at
org.postgresql.core.v3.QueryExecutorImpl. execute(QueryExecuto
rImpl.java:201)
at
org.postgresql.jdbc2. AbstractJdbc2Stateme
nt. execute(AbstractJdbc
2Statement.java:389)
at
org.postgresql.jdbc2. AbstractJdbc2Stateme
nt. executeWithFlags(Abs
tractJdbc2Statement.java:330)
at
org.postgresql.jdbc2. AbstractJdbc2Stateme
nt. executeQuery(Abstrac
tJdbc2Statement.java:240)
at
org.jboss.resource.adapter.jdbc. WrappedPreparedState
ment. executeQuery(Wrapped
PreparedStatement.java:296)
at
net.sf.hibernate.impl.BatcherImpl. getResultSet(Batcher
Impl.java:87)
at net.sf.hibernate.loader.Loader.getResultSet(Loader.java:875)
at net.sf.hibernate.loader.Loader.doQuery(Loader.java:269)
at
net.sf.hibernate.loader.Loader. doQueryAndInitialize
NonLazyCollections(L
oader.java:133)
at net.sf.hibernate.loader.Loader.doList(Loader.java:1033)
at net.sf.hibernate.loader.Loader.list(Loader.java:1024)
at
net.sf.hibernate.hql.QueryTranslator. list(QueryTranslator
.java:854)
at
net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1544)
at net.sf.hibernate.impl.QueryImpl.list(QueryImpl.java:39)
[...]
Caused by: java.net.SocketException: Connection reset by peer: socket
write error
at java.net.SocketOutputStream.socketWrite0(Native Method)
at
java.net.SocketOutputStream. socketWrite(SocketOu
tputStream.java:92)
at
java.net.SocketOutputStream. write(SocketOutputSt
ream.java:136)
at
java.io. BufferedOutputStream
. flushBuffer(Buffered
OutputStream.java:66)
at
java.io. BufferedOutputStream
. flush(BufferedOutput
Stream.java:124)
at org.postgresql.core.PGStream.flush(PGStream.java:494)
at
org.postgresql.core.v3.QueryExecutorImpl. sendSync(QueryExecut
orImpl.java:631)
at
org.postgresql.core.v3.QueryExecutorImpl. execute(QueryExecuto
rImpl.java:174)
... 56 more
20:38:57,643 ERROR [HibernateQuery] Could not execute query
net.sf.hibernate.JDBCException: Could not execute query
at
net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1547)
at net.sf.hibernate.impl.QueryImpl.list(QueryImpl.java:39)
[...]
Caused by: org.postgresql.util.PSQLException: Eingabe/Ausgabe-Fehler
{0} beim Senden an das Backend.
at
org.postgresql.core.v3.QueryExecutorImpl. execute(QueryExecuto
rImpl.java:201)
at
org.postgresql.jdbc2. AbstractJdbc2Stateme
nt. execute(AbstractJdbc
2Statement.java:389)
at
org.postgresql.jdbc2. AbstractJdbc2Stateme
nt. executeWithFlags(Abs
tractJdbc2Statement.java:330)
at
org.postgresql.jdbc2. AbstractJdbc2Stateme
nt. executeQuery(Abstrac
tJdbc2Statement.java:240)
at
org.jboss.resource.adapter.jdbc. WrappedPreparedState
ment. executeQuery(Wrapped
PreparedStatement.java:296)
at
net.sf.hibernate.impl.BatcherImpl. getResultSet(Batcher
Impl.java:87)
at net.sf.hibernate.loader.Loader.getResultSet(Loader.java:875)
at net.sf.hibernate.loader.Loader.doQuery(Loader.java:269)
at
net.sf.hibernate.loader.Loader. doQueryAndInitialize
NonLazyCollections(L
oader.java:133)
at net.sf.hibernate.loader.Loader.doList(Loader.java:1033)
at net.sf.hibernate.loader.Loader.list(Loader.java:1024)
at
net.sf.hibernate.hql.QueryTranslator. list(QueryTranslator
.java:854)
at
net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1544)
... 44 more
Caused by: java.net.SocketException: Connection reset by peer: socket
write error
at java.net.SocketOutputStream.socketWrite0(Native Method)
at
java.net.SocketOutputStream. socketWrite(SocketOu
tputStream.java:92)
at
java.net.SocketOutputStream. write(SocketOutputSt
ream.java:136)
at
java.io. BufferedOutputStream
. flushBuffer(Buffered
OutputStream.java:66)
at
java.io. BufferedOutputStream
. flush(BufferedOutput
Stream.java:124)
at org.postgresql.core.PGStream.flush(PGStream.java:494)
at
org.postgresql.core.v3.QueryExecutorImpl. sendSync(QueryExecut
orImpl.java:631)
at
org.postgresql.core.v3.QueryExecutorImpl. execute(QueryExecuto
rImpl.java:174)
... 56 more
20:38:57,643 WARN & #91;JDBCExceptionRep
orter] SQL Error: 0, SQLState:
08006
--snip from the stacktrace--
|
|