Hi R�da! Oracle have a "client"-cache (I don't know the name) that can allow you to query a "local"-database with cached data and the server for non-cached data, it handles this transparently. It will save the server from a lot of work under the right circumstances (much more selects than inserts/updates).
I am not sure if I understand your problem correctly. It seems like you are looking for something that will allow you to run your database in a cluster so that you can get more performance from it. Have you tried collection-proxies? Compared to a standard proxy it saves the database a lot since it will load all objects in the collection by one query and not one per object. Regards Roland Carlsson ----- Original Message ----- From: "R�da Benzair" <[EMAIL PROTECTED]> To: "'OJB Users List'" <[EMAIL PROTECTED]> Sent: Monday, September 08, 2003 1:20 PM Subject: RE: OutOfMemoryError When no use proxy !!! 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] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
