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

[Michele Laghi <laghi at swissinfo.org>]

Hi,

pikaiyuan wrote:
> 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).
> 
mm, in that case you should get an OutOfMemory exception I guess. Are
you running oracle on the same machine ? Are you seeing any logs/errors
on the oracle itself ?

Do you get the same error with
java javaclients.HelloWorldPublish -contentSize 1700000
?

On our testsuite we test messages up to 2.1 MB and we don't have
problems with it. Could you also check if that test is passing with your
configuration ? That's the I_QueueTest.java.

Regards
Michele



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