Hi Carlsson Thank you for your response My problem is OJB opens so many statements at a time. Do you use statement pooling? If no, do you plan to? This would possibly be a big performance gain (?).
Thanks -----Original Message----- From: Roland Carlsson [mailto:[EMAIL PROTECTED] Sent: vendredi 5 septembre 2003 20:23 To: OJB Users List Subject: Re: OutOfMemoryError When no use proxy !!! Hi R�da! If you need to have all your database in memory you have to look at memorysettings for the jvm when you start tomcat and perhaps buy a lot of memory. No tricks there as fare as I know of. My view on the problem is that the database is probably the best place to keep data on. Tools like ojb can simplify programming and in some cases reduce load on the database though a cache. I don't think that OJB shall be used as an "in-memory-database". There are probably more sutible tools for that task. I'd be interested in why you feel like caching the whole database is a good idea? Regards Roland Carlsson ----- Original Message ----- From: "R�da Benzair" <[EMAIL PROTECTED]> To: "'OJB Users List'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Friday, September 05, 2003 7:14 PM Subject: OutOfMemoryError When no use proxy !!! Hi My problem is I use ojb for large Data bases(Oracle) with many assotiation M:N and 1:M if I do not use "Proxy=true" but I have a out off memory (tomcat is stopped !!) or this error I does not want use proxy because I Would be use all data in Cache. I seek a solution with this problem thank you in advance for the answer Thanks . at org.apache.ojb.broker.core.PersistenceBrokerImpl.getDBObject(Persistence BrokerImpl.java:1628) at org.apache.ojb.broker.core.PersistenceBrokerImpl.getExtentDBObject(Persi stenceBrokerImpl.java:1672) at org.apache.ojb.broker.core.PersistenceBrokerImpl.getDBObject(Persistence BrokerImpl.java:1591) at org.apache.ojb.broker.core.PersistenceBrokerImpl.getObjectByIdentity(Per sistenceBrokerImpl.java:1731) at org.apache.ojb.broker.core.PersistenceBrokerImpl.getReferencedObject(Per sistenceBrokerImpl.java:1321) at org.apache.ojb.broker.core.PersistenceBrokerImpl.retrieveReference(Persi stenceBrokerImpl.java:1070) at org.apache.ojb.broker.core.PersistenceBrokerImpl.retrieveReferences(Pers istenceBrokerImpl.java:1050) at org.apache.ojb.broker.accesslayer.RsIterator.getObjectFromResultSet(RsIt erator.java:455) at org.apache.ojb.broker.accesslayer.RsIterator.next(RsIterator.java:254) at org.apache.ojb.broker.accesslayer.ChainingIterator.next(ChainingIterator .java:357) at org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Pe rsistenceBrokerImpl.java:1374) at org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Pe rsistenceBrokerImpl.java:1515) at org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Pe rsistenceBrokerImpl.java:1551) at org.apache.ojb.broker.core.PersistenceBrokerImpl.retrieveCollection(Pers istenceBrokerImpl.java:1098) at org.apache.ojb.broker.core.PersistenceBrokerImpl.retrieveCollections(Per sistenceBrokerImpl.java:1208) at org.apache.ojb.broker.core.PersistenceBrokerImpl.getDBObject(Persistence BrokerImpl.java:1628) at org.apache.ojb.broker.core.PersistenceBrokerImpl.getExtentDBObject(Persi stenceBrokerImpl.java:1672) at org.apache.ojb.broker.core.PersistenceBrokerImpl.getDBObject(Persistence BrokerImpl.java:1591) at org.apache.ojb.broker.core.PersistenceBrokerImpl.getObjectByIdentity(Per sistenceBrokerImpl.java:1731) at org.apache.ojb.broker.core.PersistenceBrokerImpl.getReferencedObject(Per sistenceBrokerImpl.java:1321) at org.apache.ojb.broker.core.PersistenceBrokerImpl.retrieveReference(Persi stenceBrokerImpl.java:1070) at org.apache.ojb.broker.core.PersistenceBrokerImpl.retrieveReferences(Pers istenceBrokerImpl.java:1050) at org.apache.ojb.broker.accesslayer.RsIterator.getObjectFromResultSet(RsIt erator.java:455) at org.apache.ojb.broker.accesslayer.RsIterator.next(RsIterator.java:254) at org.apache.ojb.broker.accesslayer.ChainingIterator.next(ChainingIterator .java:357) at org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Pe rsistenceBrokerImpl.java:1374) at org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Pe rsistenceBrokerImpl.java:1515) at org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Pe rsistenceBrokerImpl.java:1551) at org.apache.ojb.broker.core.PersistenceBrokerImpl.retrieveCollection(Pers istenceBrokerImpl.java:1098) at org.apache.ojb.broker.core.PersistenceBrokerImpl.retrieveCollections(Per sistenceBrokerImpl.java:1208) at org.apache.ojb.broker.core.PersistenceBrokerImpl.getDBObject(Persistence BrokerImpl.java:1628) at org.apache.ojb.broker.core.PersistenceBrokerImpl.getExtentDBObject(Persi stenceBrokerImpl.java:1672) at org.apache.ojb.broker.core.PersistenceBrokerImpl.getDBObject(Persistence BrokerImpl.java:1591) at org.apache.ojb.broker.core.PersistenceBrokerImpl.getObjectByIdentity(Per sistenceBrokerImpl.java:1731) at org.apache.ojb.broker.core.PersistenceBrokerImpl.getReferencedObject(Per sistenceBrokerImpl.java:1321) at org.apache.ojb.broker.core.PersistenceBrokerImpl.retrieveReference(Persi stenceBrokerImpl.java:1070) at org.apache.ojb.broker.core.PersistenceBrokerImpl.retrieveReferences(Pers istenceBrokerImpl.java:1050) at org.apache.ojb.broker.accesslayer.RsIterator.getObjectFromResultSet(RsIt erator.java:455) at org.apache.ojb.broker.accesslayer.RsIterator.next(RsIterator.java:254) at org.apache.ojb.broker.accesslayer.ChainingIterator.next(ChainingIterator .java:357) at org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Pe rsistenceBrokerImpl.java:1374) at org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Pe rsistenceBrokerImpl.java:1515) at org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Pe rsistenceBrokerImpl.java:1551) at org.apache.ojb.broker.core.PersistenceBrokerImpl.retrieveCollection(Pers istenceBrokerImpl.java:1098) at org.apache.ojb.broker.core.PersistenceBrokerImpl.retrieveCollections(Per sistenceBrokerImpl.java:1208) at org.apache.ojb.broker.core.PersistenceBrokerImpl.getDBObject(Persistence BrokerImpl.java:1628) at org.apache.ojb.broker.core.PersistenceBrokerImpl.getExtentDBObject(Persi stenceBrokerImpl.java:1672) at org.apache.ojb.broker.core.PersistenceBrokerImpl.getDBObject(Persistence BrokerImpl.java:1591) at org.apache.ojb.broker.core.PersistenceBrokerImpl.getObjectByIdentity(Per sistenceBrokerImpl.java:1731) at org.apache.ojb.broker.core.PersistenceBrokerImpl.getReferencedObject(Per sistenceBrokerImpl.java:1321) at org.apache.ojb.broker.core.PersistenceBrokerImpl.retrieveReference(Persi stenceBrokerImpl.java:1070) at org.apache.ojb.broker.core.PersistenceBrokerImpl.retrieveReferences(Pers istenceBrokerImpl.java:1050) at org.apache.ojb.broker.accesslayer.RsIterator.getObjectFromResultSet(RsIt erator.java:455) at org.apache.ojb.broker.accesslayer.RsIterator.next(RsIterator.java:254) at org.apache.ojb.broker.accesslayer.ChainingIterator.next(ChainingIterator .java:357) at org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Pe rsistenceBrokerImpl.java:1374) at org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Pe rsistenceBrokerImpl.java:1515) at org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Pe rsistenceBrokerImpl.java:1551) at org.apache.ojb.broker.core.PersistenceBrokerImpl.retrieveCollection(Pers istenceBrokerImpl.java:1098) at org.apache.ojb.broker.core.PersistenceBrokerImpl.retrieveCollections(Per sistenceBrokerImpl.java:1208) at org.apache.ojb.broker.core.PersistenceBrokerImpl.getDBObject(Persistence BrokerImpl.java:1628) at org.apache.ojb.broker.core.PersistenceBrokerImpl.getExtentDBObject(Persi stenceBrokerImpl.java:1672) at org.apache.ojb.broker.core.PersistenceBrokerImpl.getDBObject(Persistence BrokerImpl.java:1591) at org.apache.ojb.broker.core.PersistenceBrokerImpl.getObjectByIdentity(Per sistenceBrokerImpl.java:1731) at org.apache.ojb.broker.core.PersistenceBrokerImpl.getReferencedObject(Per sistenceBrokerImpl.java:1321) at org.apache.ojb.broker.core.PersistenceBrokerImpl.retrieveReference(Persi stenceBrokerImpl.java:1070) at org.apache.ojb.broker.core.PersistenceBrokerImpl.retrieveReferences(Pers istenceBrokerImpl.java:1050) at org.apache.ojb.broker.accesslayer.RsIterator.getObjectFromResultSet(RsIt erator.java:455) at org.apache.ojb.broker.accesslayer.RsIterator.next(RsIterator.java:254) at org.apache.ojb.broker.accesslayer.ChainingIterator.next(ChainingIterator .java:357) at org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Pe rsistenceBrokerImpl.java:1374) at org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Pe rsistenceBrokerImpl.java:1515) at org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Pe rsistenceBrokerImpl.java:1551) at org.apache.ojb.broker.core.PersistenceBrokerImpl.retrieveCollection(Pers istenceBrokerImpl.java:1098) at org.apache.ojb.broker.core.PersistenceBrokerImpl.retrieveCollections(Per sistenceBrokerImpl.java:1208) at org.apache.ojb.broker.core.PersistenceBrokerImpl.getDBObject(Persistence BrokerImpl.java:1628) at org.apache.ojb.broker.core.PersistenceBrokerImpl.getExtentDBObject(Persi stenceBrokerImpl.java:1672) at org.apache.ojb.broker.core.PersistenceBrokerImpl.getDBObject(Persistence BrokerImpl.java:1591) at org.apache.ojb.broker.core.PersistenceBrokerImpl.getObjectByIdentity(Per sistenceBrokerImpl.java:1731) at org.apache.ojb.broker.core.PersistenceBrokerImpl.getReferencedObject(Per sistenceBrokerImpl.java:1321) at org.apache.ojb.broker.core.PersistenceBrokerImpl.retrieveReference(Persi stenceBrokerImpl.java:1070) at org.apache.ojb.broker.core.PersistenceBrokerImpl.retrieveReferences(Pers istenceBrokerImpl.java:1050) at org.apache.ojb.broker.accesslayer.RsIterator.getObjectFromResultSet(RsIt erator.java:455) at org.apache.ojb.broker.accesslayer.RsIterator.next(RsIterator.java:254) at org.apache.ojb.broker.accesslayer.ChainingIterator.next(ChainingIterator .java:357) at org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Pe rsistenceBrokerImpl.java:1374) at org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Pe rsistenceBrokerImpl.java:1515) at org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Pe rsistenceBrokerImpl.java:1551) at org.apache.ojb.broker.core.PersistenceBrokerImpl.retrieveCollection(Pers istenceBrokerImpl.java:1098) at org.apache.ojb.broker.core.PersistenceBrokerImpl.retrieveCollections(Per sistenceBrokerImpl.java:1208) at org.apache.ojb.broker.core.PersistenceBrokerImpl.getDBObject(Persistence BrokerImpl.java:1628) at org.apache.ojb.broker.core.PersistenceBrokerImpl.getExtentDBObject(Persi stenceBrokerImpl.java:1672) at org.apache.ojb.broker.core.PersistenceBrokerImpl.getDBObject(Persistence BrokerImpl.java:1591) at org.apache.ojb.broker.core.PersistenceBrokerImpl.getObjectByIdentity(Per sistenceBrokerImpl.java:1731) at org.apache.ojb.broker.core.PersistenceBrokerImpl.getReferencedObject(Per sistenceBrokerImpl.java:1321) at org.apache.ojb.broker.core.PersistenceBrokerImpl.retrieveReference(Persi stenceBrokerImpl.java:1070) at org.apache.ojb.broker.core.PersistenceBrokerImpl.retrieveReferences(Pers istenceBrokerImpl.java:1050) at org.apache.ojb.broker.accesslayer.RsIterator.getObjectFromResultSet(RsIt erator.java:455) at org.apache.ojb.broker.accesslayer.RsIterator.next(RsIterator.java:254) at org.apache.ojb.broker.accesslayer.ChainingIterator.next(ChainingIterator .java:357) at org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Pe rsistenceBrokerImpl.java:1374) at org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Pe rsistenceBrokerImpl.java:1515) at org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Pe rsistenceBrokerImpl.java:1551) at org.apache.ojb.broker.core.PersistenceBrokerImpl.retrieveCollection(Pers istenceBrokerImpl.java:1098) at org.apache.ojb.broker.core.PersistenceBrokerImpl.retrieveCollections(Per sistenceBrokerImpl.java:1208) at org.apache.ojb.broker.core.PersistenceBrokerImpl.getDBObject(Persistence BrokerImpl.java:1628) at org.apache.ojb.broker.core.PersistenceBrokerImpl.getExtentDBObject(Persi stenceBrokerImpl.java:1672) at org.apache.ojb.broker.core.PersistenceBrokerImpl.getDBObject(Persistence BrokerImpl.java:1591) at org.apache.ojb.broker.core.PersistenceBrokerImpl.getObjectByIdentity(Per sistenceBrokerImpl.java:1731) at org.apache.ojb.broker.core.PersistenceBrokerImpl.getReferencedObject(Per sistenceBrokerImpl.java:1321) at org.apache.ojb.broker.core.PersistenceBrokerImpl.retrieveReference(Persi stenceBrokerImpl.java:1070) at org.apache.ojb.broker.core.PersistenceBrokerImpl.retrieveReferences(Pers istenceBrokerImpl.java:1050) at org.apache.ojb.broker.accesslayer.RsIterator.getObjectFromResultSet(RsIt erator.java:455) at org.apache.ojb.broker.accesslayer.RsIterator.next(RsIterator.java:254) at org.apache.ojb.broker.accesslayer.ChainingIterator.next(ChainingIterator .java:357) at org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Pe rsistenceBrokerImpl.java:1374) at org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Pe rsistenceBrokerImpl.java:1515) at org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Pe rsistenceBrokerImpl.java:1551) at org.apache.ojb.broker.core.PersistenceBrokerImpl.retrieveCollection(Pers istenceBrokerImpl.java:1098) at org.apache.ojb.broker.core.PersistenceBrokerImpl.retrieveCollections(Per sistenceBrokerImpl.java:1208) at org.apache.ojb.broker.accesslayer.RsIterator.getObjectFromResultSet(RsIt erator.java:456) at org.apache.ojb.broker.accesslayer.RsIterator.next(RsIterator.java:254) v --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
