Examples of org.exolab.castor.jdo.Database

org.exolab.castor.jdo.Database
a database and start a transaction db = jdo.getDatabase(); db.begin(); // Select all the products in a given group oql = db.getOQLQuery( "SELECT p FROM Product p WHERE group=$"); oql.bind( groupId ); results = oql.execute(); while ( results.hasMore() ) { // A 25% mark down for each product and mark as sale prod = (Product) results.next(); prod.markDown( 0.25 ); prod.setOnSale( true ); } // Commit all changes, close the database db.commit(); db.close(); @author Assaf Arkin @version $Revision: 7976 $ $Date: 2006-03-16 16:04:24 -0700 (Thu, 16 Mar 2006) $ @see JDOManager#getDatabase() @see Query

    /**
     * Test method.
     * @throws Exception For any exception thrown.
     */
    public void testLoadChildWithCompoundId() throws Exception {
        Database db = _category.getDatabase();
        db.begin();
        
        ChildWithCompoundId child = (ChildWithCompoundId) 
            db.load(ChildWithCompoundId.class,
                    new Identity(new Integer(1), new Integer(1)));


        assertNotNull(child);
        assertEquals(new Integer(1), child.getId1());
        assertEquals(new Integer(1), child.getId2());
        
        db.commit();
        db.close();
    }

View Full Code Here

    /**
     * Test method.
     * @throws Exception For any exception thrown.
     */
    public void testQueryParent() throws Exception {
        Database db = _category.getDatabase();
        db.begin();
        
        OQLQuery query = db.getOQLQuery("SELECT entity FROM "
                + SelfReferentialParent.class.getName() + " entity WHERE id = $1");
        query.bind(new Integer(1));
        QueryResults results = query.execute();
        
        SelfReferentialParent entity = (SelfReferentialParent) results.next();


        assertNotNull(entity);
        assertEquals(new Integer(1), entity.getId());
        
        List children = entity.getEntities();
        assertNotNull(children);
        assertEquals(2, children.size());
        
        Iterator childrenIterator = children.iterator();
        
        SelfReferentialParent child = (SelfReferentialParent) childrenIterator.next();
        assertNotNull(child);
        assertEquals(2, child.getId().intValue());
        assertNotNull(child.getEntities());
        assertEquals(0, child.getEntities().size());


        child = (SelfReferentialParent) childrenIterator.next();
        assertNotNull(child);
        assertEquals(3, child.getId().intValue());
        assertNotNull(child.getEntities());
        assertEquals(0, child.getEntities().size());


        db.commit();
        db.close();
    }

View Full Code Here

    /**
     * Test method.
     * @throws Exception For any exception thrown.
     */
    public void testLoadParent() throws Exception {
        Database db = _category.getDatabase();
        db.begin();
        
        Object obj = db.load(SelfReferentialParent.class, new Integer(1));
        SelfReferentialParent entity = (SelfReferentialParent) obj;


        assertNotNull(entity);
        assertEquals(new Integer(1), entity.getId());
        
        List children = entity.getEntities();
        assertNotNull(children);
        assertEquals(2, children.size());
        
        Iterator childrenIterator = children.iterator();
        
        SelfReferentialParent child = (SelfReferentialParent) childrenIterator.next();
        assertNotNull(child);
        assertEquals(2, child.getId().intValue());
        assertNotNull(child.getEntities());
        assertEquals(0, child.getEntities().size());


        child = (SelfReferentialParent) childrenIterator.next();
        assertNotNull(child);
        assertEquals(3, child.getId().intValue());
        assertNotNull(child.getEntities());
        assertEquals(0, child.getEntities().size());


        db.commit();
        db.close();
    }

View Full Code Here

    /**
     * Test method.
     * @throws Exception For any exception thrown.
     */
    public void testLoadChild() throws Exception {
        Database db = _category.getDatabase();
        db.begin();
        
        Object obj = db.load(SelfReferentialChild.class, new Integer(1));
        SelfReferentialChild child = (SelfReferentialChild) obj;


        assertNotNull(child);
        assertEquals(new Integer(1), child.getId());
        
        List children = child.getEntities();
        assertNotNull(children);
        assertEquals(2, children.size());
        
        Iterator childrenIterator = children.iterator();
        
        SelfReferentialParent entity = (SelfReferentialParent) childrenIterator.next();
        assertNotNull(entity);
        assertEquals(2, entity.getId().intValue());
        assertNotNull(entity.getEntities());
        assertEquals(0, entity.getEntities().size());


        entity = (SelfReferentialParent) childrenIterator.next();
        assertNotNull(entity);
        assertEquals(3, entity.getId().intValue());
        assertNotNull(entity.getEntities());
        assertEquals(0, entity.getEntities().size());


        db.commit();
        db.close();
    }

View Full Code Here

        testDepends();
    }


    
    public void testDepends() throws Exception {
        Database db = null;
        MasterObject master = new MasterObject();
        master.setDescrip("This is the descrip.");
        db = _category.getDatabase();
        db.begin();
        db.create(master);
        db.commit();


        assertTrue(master.getId() != 0);


        //THIS Part Works!
        db.begin();
        DependentObject depends = new DependentObject();
        depends.setDescrip("Description");
        master.setDepends(depends);
        db.update(master);
        db.commit();


        assertTrue(master.getId() != 0);
        int masterId = master.getId();


        db.begin();
        master = (MasterObject) db.load(MasterObject.class, new Integer(masterId));
        assertNotNull(master.getDepends());
        master.setDepends(null);
        db.commit();


        db.begin();
        master = (MasterObject) db.load(MasterObject.class, new Integer(masterId));
        assertNull(master.getDepends());
        db.commit();


        //THIS part doesn't!
        db.begin();
        master = (MasterObject) db.load(MasterObject.class, new Integer(masterId));
        depends = new DependentObject();
        depends.setDescrip("Description");
        master.setDepends(depends);
        db.commit();


        db.begin();
        master = (MasterObject) db.load(MasterObject.class, new Integer(masterId));
        assertNotNull(master.getDepends());
        db.commit();


        db.begin();
        master = (MasterObject) db.load(MasterObject.class, new Integer(
                masterId));
        assertNotNull(master);
        db.remove(master);
        db.commit();
    }

View Full Code Here

    public void runTest() throws Exception {
        testDepends();
    }


    public void testDepends() throws Exception {
        Database db = null;
        MasterObjectNoKeyGen master = new MasterObjectNoKeyGen();
        master.setId(100);
        master.setDescrip("This is the descrip.");
        db = _category.getDatabase();
        db.begin();
        db.create(master);
        db.commit();


        assertTrue(master.getId() != 0);
        assertEquals(100, master.getId());


        //THIS Part Works!
        db.begin();
        DependentObjectNoKeyGen depends = new DependentObjectNoKeyGen();
        depends.setId(101);
        depends.setDescrip("Description");
        master.setDepends(depends);
        db.update(master);
        db.commit();


        assertTrue(master.getId() != 0);
        assertEquals(100, master.getId());
        int masterId = master.getId();


        db.begin();
        master = (MasterObjectNoKeyGen) db.load(MasterObjectNoKeyGen.class, new Integer(
                masterId));
        assertNotNull(master.getDepends());
        master.setDepends(null);
        db.commit();


        db.begin();
        master = (MasterObjectNoKeyGen) db.load(MasterObjectNoKeyGen.class, new Integer(
                masterId));
        assertNull(master.getDepends());
        db.commit();


        //THIS part doesn't!
        db.begin();
        master = (MasterObjectNoKeyGen) db.load(MasterObjectNoKeyGen.class, new Integer(
                masterId));
        depends = new DependentObjectNoKeyGen();
        depends.setId(102);
        depends.setDescrip("Description");
        master.setDepends(depends);
        db.commit();


        db.begin();
        master = (MasterObjectNoKeyGen) db.load(MasterObjectNoKeyGen.class, new Integer(
                masterId));
        assertNotNull(master.getDepends());
        db.commit();


        db.begin();
        master = (MasterObjectNoKeyGen) db.load(MasterObjectNoKeyGen.class, new Integer(
                masterId));
        assertNotNull(master);
        db.remove(master);
        db.commit();
    }

View Full Code Here

    public void runTest() throws Exception {
        testLoadAndUpdateLaptop();
    }


    public void testLoadAndUpdateLaptop() throws Exception {
        Database database = _category.getDatabase();
        
        database.begin();
        Laptop laptop = (Laptop) database.load(Laptop.class, new Integer(1));
        database.commit();
        
        assertNotNull(laptop);
        assertEquals("ctf.jdo.tc9x.Laptop", laptop.getClass().getName());
        assertEquals(1, laptop.getId());
        assertEquals("laptop 1", laptop.getName());
        
        laptop.setName("laptop 1x");


        database.begin();
        database.update(laptop);
        database.commit();
        
        database.begin();
        laptop = (Laptop) database.load(Laptop.class, new Integer(1));
        database.commit();
        
        assertNotNull(laptop);
        assertEquals("ctf.jdo.tc9x.Laptop", laptop.getClass().getName());
        assertEquals(1, laptop.getId());
        assertEquals("laptop 1x", laptop.getName());


        laptop.setName("laptop 1");


        database.begin();
        database.update(laptop);
        database.commit();
        
        database.begin();
        laptop = (Laptop) database.load(Laptop.class, new Integer(1));
        database.commit();


        assertNotNull(laptop);
        assertEquals("ctf.jdo.tc9x.Laptop", laptop.getClass().getName());
        assertEquals(1, laptop.getId());
        assertEquals("laptop 1", laptop.getName());


        database.close();
    }

View Full Code Here

    }
    
    public void testReadWriteOidCached() throws Exception {
        long start = System.currentTimeMillis();
        
        Database db = _jdo.getDatabase();
        db.begin();
        
        long begin = System.currentTimeMillis();
        
        OQLQuery query = db.getOQLQuery(
                "CALL SQL select PTF_LOCKED.ID as ID "
              + "from PTF_LOCKED order by PTF_LOCKED.ID "
              + "AS " + OID.class.getName());
        QueryResults results = query.execute(Database.READONLY);
        
        long result = System.currentTimeMillis();
        
        int count = 0;
        while (results.hasMore()) {
            OID oid = (OID) results.next();
            iterateStates((Locked) db.load(Locked.class, oid.getId()));


            count++;
        }
        
        long iterate = System.currentTimeMillis();
        
        db.commit();
        
        long commit = System.currentTimeMillis();
        
        db.close();


        long close = System.currentTimeMillis();
        
        LOG.info(format("ReadWriteOidCached",
                         DF.format(begin - start),

View Full Code Here

    }
    
    public void testReadOnlyOidEmpty() throws Exception {
        long start = System.currentTimeMillis();
        
        Database db = _jdo.getDatabase();
        db.getCacheManager().expireCache();
        db.begin();
        
        long begin = System.currentTimeMillis();
        
        OQLQuery query = db.getOQLQuery(
                "CALL SQL select PTF_LOCKED.ID as ID "
              + "from PTF_LOCKED order by PTF_LOCKED.ID "
              + "AS " + OID.class.getName());
        QueryResults results = query.execute(Database.READONLY);
        
        long result = System.currentTimeMillis();
        
        int count = 0;
        while (results.hasMore()) {
            OID oid = (OID) results.next();
            iterateStates((Locked) db.load(Locked.class, oid.getId(), Database.READONLY));


            count++;
        }
        
        long iterate = System.currentTimeMillis();
        
        db.commit();
        
        long commit = System.currentTimeMillis();
        
        db.close();


        long close = System.currentTimeMillis();
        
        LOG.info(format("ReadOnlyOidEmpty",
                         DF.format(begin - start),

View Full Code Here

    }
    
    public void testReadOnlyOidCached() throws Exception {
        long start = System.currentTimeMillis();
        
        Database db = _jdo.getDatabase();
        db.begin();
        
        long begin = System.currentTimeMillis();
        
        OQLQuery query = db.getOQLQuery(
                "CALL SQL select PTF_LOCKED.ID as ID "
              + "from PTF_LOCKED order by PTF_LOCKED.ID "
              + "AS " + OID.class.getName());
        QueryResults results = query.execute(Database.READONLY);
        
        long result = System.currentTimeMillis();
        
        int count = 0;
        while (results.hasMore()) {
            OID oid = (OID) results.next();
            iterateStates((Locked) db.load(Locked.class, oid.getId(), Database.READONLY));


            count++;
        }
        
        long iterate = System.currentTimeMillis();
        
        db.commit();
        
        long commit = System.currentTimeMillis();
        
        db.close();


        long close = System.currentTimeMillis();
        
        LOG.info(format("ReadOnlyOidCached",
                         DF.format(begin - start),

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

Related Classes of org.exolab.castor.jdo.Database

com.frovi.ss.Tree.BaseNodeSupplier

ctf.jdo.tc20x.TestSelfRelation

ctf.jdo.tc20x.TestSelfRelationExtend

ctf.jdo.tc20x.TestTimezone

ctf.jdo.tc3x.TestNamedQueries

ctf.jdo.tc7x.TestAutostore

ctf.jdo.tc7x.TestAutostoreMany

ctf.jdo.tc7x.TestExpireManyToMany

ctf.jdo.tc8x.TestEnum

ctf.jdo.tc8x.TestIdentityPerFieldMapping

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.