Re: [xmlblaster] about 0.9 JDBC

[Marcel Ruff <mr at marcelruff.info>]

zhang zhi wei wrote:
> I am evaluate the 0.9 , the DB is oracle 9i
> 
> It report the following error, can u give me some clue about the error?

It looks like that you loose the TCP/IP connection
to Oracle, try

 telnet <oracleHost> 1521

to test the connection.

Marcel
> 
> 
> 2004-4-5 20:49:53 ERROR JdbcManagerCommonTable] exception when closing 
> statemen
> t: java.sql.SQLException: Io Exception: Connection reset by peer: socket 
> write error
> java.sql.SQLException: Io Exception: Connection reset by peer: socket 
> write error
>        at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
>        at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
>        at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:333)
>        at 
> oracle.jdbc.driver.OracleStatement.close(OracleStatement.java:648)
>        at 
> oracle.jdbc.driver.OraclePreparedStatement.privateClose(OraclePrepare
> dStatement.java:485)
>        at 
> oracle.jdbc.driver.OraclePreparedStatement.close(OraclePreparedStatem
> ent.java:393)
>        at org.xmlBlaster.util.queue.jdbc.JdbcManagerCommonTable.addSingleEn
> try(JdbcManagerCommonTable.java:908)
>        at org.xmlBlaster.util.queue.jdbc.JdbcManagerCommonTable.addEntry(Jd
> bcManagerCommonTable.java:967)
>        at org.xmlBlaster.util.queue.jdbc.JdbcQueueCommonTablePlugin.put(Jdb
> cQueueCommonTablePlugin.java:353)
>        at org.xmlBlaster.util.queue.jdbc.JdbcQueueCommonTablePlugin.put(Jdb
> cQueueCommonTablePlugin.java:1232)
>        at org.xmlBlaster.engine.msgstore.cache.PersistenceCachePlugin.put(P
> ersistenceCachePlugin.java:293)
>        at org.xmlBlaster.engine.TopicHandler.publish(TopicHandler.java:606)
> 
>        at org.xmlBlaster.engine.RequestBroker.publish(RequestBroker.java:16
> 40)
>        at org.xmlBlaster.engine.RequestBroker.publish(RequestBroker.java:14
> 65)
>        at org.xmlBlaster.engine.RequestBroker.publish(RequestBroker.java:14
> 59)
>        at org.xmlBlaster.engine.InforMessagingImpl.publish(InforMessagingIm
> pl.java:186)
>        at org.xmlBlaster.protocol.corba.ServerImpl.publish(ServerImpl.java:
> 111)
>        at org.xmlBlaster.protocol.corba.serverIdl.ServerPOATie.publish(Serv
> erPOATie.java:54)
>        at org.xmlBlaster.protocol.corba.serverIdl.ServerPOA._invoke(ServerP
> OA.java:51)
>        at org.jacorb.poa.RequestProcessor.invokeOperation(Unknown Source)
>        at org.jacorb.poa.RequestProcessor.process(Unknown Source)
>        at org.jacorb.poa.RequestProcessor.run(Unknown Source)
> [2004-4-5 20:49:53 WARN  
> JdbcManagerCommonTable-IM_-inforMessaging_192_168_80_62
> _3412-msgUnitStore_inforMessaging_192_168_80_62_3412dj_nsrxx-addEntry()] 
> Could n
> ot insert entry 'org.xmlBlaster.engine.MsgUnitWrapper'-'dj_nsrxx/2004-04-05
> 20:49:52.074000001-1081169392074000001': java.sql.SQLException: Io 
> Exception: Connect
> ion reset
> [2004-4-5 20:49:53 WARN  JdbcManagerCommonTable] ping to DB failed. DB 
> may be do
> wn. Reason java.sql.SQLException: Io Exception: Connection reset by 
> peer: socket writ
> e error
> 
> _________________________________________________________________
> 与联机的朋友进行交流，请使用 MSN Messenger:  http://messenger.msn.com/cn 
> 


-- 
http://www.xmlBlaster.org