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

["pikaiyuan" <pikaiyuan at 163.com>]

Michele Laghi,hello！

	I tried xmlblaster 0.903 release, and I got the same problem.

I think this problem maybe due to jdbc drivers and machine ram
(my os is windows2000;ram is 256m; jdbc driver is oracle9i jdbc driver).

any suggestion?

======= 2004-06-11 21:40:36 has been wrote：=======

>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
>
>

= = = = = = = = = = = = = = = = = = = =
			

　　　　　
 
				 
pikaiyuan
pikaiyuan at 163.com
2004-06-12