[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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


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.


> any suggestion?
> ======= 2004-06-11 21:40:36 has been wrote:=======
>>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 ?
>>pikaiyuan wrote:
>>>	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
>>>at oracle.jdbc.driver.OraclePreparedStatement.close(OraclePreparedStatem
>>>at org.xmlBlaster.util.queue.jdbc.JdbcManagerCommonTable.addSingleEn
>>>at org.xmlBlaster.util.queue.jdbc.JdbcManagerCommonTable.addEntry(Jd
>>>at org.xmlBlaster.util.queue.jdbc.JdbcQueueCommonTablePlugin.put(Jdb
>>>at org.xmlBlaster.util.queue.jdbc.JdbcQueueCommonTablePlugin.put(Jdb
>>>at org.xmlBlaster.engine.msgstore.cache.PersistenceCachePlugin.put(P
>>>at org.xmlBlaster.engine.TopicHandler.publish(TopicHandler.java:606)
>>>at org.xmlBlaster.engine.RequestBroker.publish(RequestBroker.java:16
>>>at org.xmlBlaster.engine.RequestBroker.publish(RequestBroker.java:14
>>>at org.xmlBlaster.engine.RequestBroker.publish(RequestBroker.java:14
>>>at org.xmlBlaster.engine.XmlBlasterImpl.publish(XmlBlasterIm
>>>at org.xmlBlaster.protocol.corba.ServerImpl.publish(ServerImpl.java:
>>>at org.xmlBlaster.protocol.corba.serverIdl.ServerPOATie.publish(Serv
>>>at org.xmlBlaster.protocol.corba.serverIdl.ServerPOA._invoke(ServerP
>>>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