sorry but i dont know y the msg is cut off.
here is the problem again:

the following is my mapping:

/***********************************************/
 <class name="og_Broker" access="read-only" identity="brokerCde" >
  <description>just a testing mapping for trying out castor</description>
  <cache-type type="count-limited" capacity="30"/>
  <map-to table="OGT_BKR" />
  <field name="brokerCde" type="string" required="true">
   <sql name="BKR_CDE" type="varchar" />
  </field>
 </class>
/***********************************************/

and the following is my code:

/***********************************************/
    public static og_Broker get(String brokerNbr) throws Exception{

  Database  db;
  Query   oql;
  QueryResults results;
  og_Broker aBroker = null;

  db = myJDO.instance().getDatabase();

  db.begin();
  oql = db.getOQLQuery( "SELECT p FROM og_Broker p WHERE brokerCde=$1" );
  oql.bind(brokerNbr);

  results = oql.execute();

  if ( results.hasMore() ) {
   aBroker = (og_Broker) results.next();
  } else {
   throw new Exception("user not found");
  } // end if

  db.commit();
  results.close();
  oql.close();
  db.close();
  return aBroker;
 } // end get
/***********************************************/
and here is my very simply test on caching:

/***********************************************/
public class myCastorTest{

 public static void main(String args[]){

  try{
   System.out.println(og_Broker.get(args[1]).toString());
   for (int i = 0; i < 100; i++){
    og_Broker aBkr = og_Broker.get(args[1]);
   }
  }catch(Exception e){
   e.printStackTrace();
  }
 }

} // end myCastorTest

/***********************************************/

and it seems castor goes to the DB every time for the same copy which should be
able to get from cache?


regards,

dave


_______________________
CONFIDENTIALITY NOTICE:

This message, together with any attachment, is intended only for the use of the 
individual or entity to whom it is addressed and contains information that is 
privileged and confidential.  If you are not the intended recipient, please be 
informed that any dissemination, distribution or reproduction of this message 
(including any attachment) is strictly prohibited.  If you have received this message 
in error, please notify us immediately by return e-mail and delete the original 
message.  Thank you.

----------------------------------------------------------- 
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
        unsubscribe castor-dev

Reply via email to