Re: [xmlblaster] i got a problem in oracle jdbc,pls help me

[Michele Laghi <laghi at swissinfo.org>]

Hello,
I tried
java javaclients.HelloWorldPublish -contentSize 1700000

and I got the same error as you.
I then restarted xmlBlaster with the following:

java org.xmlBlaster.Main -wipeOutJdbcDB true

and repeated the test several times. It worked with no problem. Could
you please check if you get the same behaviour ? Maybe old stuff around ?

Cheers

Michele



pikaiyuan wrote:
> Hello
> 
> 	It occurs in xmlblaster 0.901 server side with oracle9i database with following 
> command: java javaclients.HelloWorldPublish -contentSize=1700000
> 
> The error messages are:
> 
> 2004-6-9 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.XmlBlasterImpl.publish(XmlBlasterIm
> 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-6-9 20:49:53 WARN JdbcManagerCommonTable-IM_-xmlBlaster_192_168_80_62
> _3412-msgUnitStore_xmlBlaster_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-6-9 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
> 
> 
> NOTICES: if i type the commands "java javaclients.HelloWorldPublish -contentSize=100",
> the program works fine. Maybe the size of content is too large?
> 
> any suggestion?
> 
> 
> thanks any way　　　　　　　　
>  				
> 
> 			   pikaiyuan
> 			   2004-06-11	　　　
> 
> 
> 


-- 
Michele Laghi
mailto:laghi at swissinfo.org
tel. +46 8 7492952 / mob. +46 70 4103964
http://eclettic.tripod.com
http://www.xmlBlaster.org