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

                clearTabs();


                //ResultScrollpane.getViewport().remove(
                //    ResultScrollpane.getViewport().getComponent(0));
                // create a new conec
                Database db = _jdo.getDatabase();
                db.begin();


                 /**
                    * add query to the history,
                    * maybe it's important lo loglso querys that won't work
                    * for this reason it's logged before creation
                    */
                _qhistory.addQuery(_oqlquery.getText());




                oql = db.getOQLQuery(_oqlquery.getText());




                // and execute it
                Date starttime = new Date();
                r = oql.execute(Database.READONLY);
                Date endtime = new Date();
                // write the status bar
                _statusBar.setText("Query successful, Time: "
                        + (endtime.getTime() - starttime.getTime()) + " ms");


                // get SQL statement via backdoor
                _sqlPane.setText(((OQLQueryImpl) oql).getSQL());




                while (r.hasMore()) {
                    o = r.next();
                    if (firstObject) {
                        properties = getProperties(o);
                        fillTableHeader(properties, _model);
                        firstObject = false;
                    }
                    _model.addRow(fillRow(properties, o));


                }
                db.commit();


                _resultTable.setModel(_model);
                _resultTable.repaint();
                _tabbedPane.setSelectedComponent(_resultScrollpane);

View Full Code Here

    protected void tearDown() throws Exception {
        super.tearDown();
    }
    
    public void testQueryEntity() throws Exception {
        Database db = _jdo.getDatabase();
        db.begin();
        
        OQLQuery query = db.getOQLQuery("SELECT entity FROM "
                + Entity.class.getName() + " entity WHERE id = $1");
        query.bind(new Integer(1));
        QueryResults results = query.execute();
        
        Entity entity = (Entity) results.next();


        assertNotNull(entity);
        assertEquals(new Integer(1), entity.getId());
        
        db.commit();
        db.close();
    }

View Full Code Here

        testOQLQueryWithParameter();
//        testOQLQueryWithoutParameter();
    }


    public void testLoadLaptop() 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());
        
        database.close();
    }

View Full Code Here

        
        database.close();
    }


    public void testCreateAndLoadLaptop() throws Exception {
        Database database = _category.getDatabase();
        
        database.begin();
        ProductDetail detail = new ProductDetail();
        detail.setId(10);
        detail.setCategory("category 10");
        detail.setLocation("location 10");
        database.create(detail);
        database.commit();
        
        
        database.begin();
        Laptop laptop = new Laptop();
        laptop.setId(10);
        laptop.setName("laptop 10");
        laptop.setCpu("centrino");
        laptop.setResolution("1600");
        laptop.setWeight(2750);
        laptop.setDetail((ProductDetail) database.load(
                ProductDetail.class, new Integer(10)));
        database.create(laptop);


        Owner owner = new Owner ();
        owner.setId(new Integer (10));
        owner.setName("owner 10");
        owner.setProduct(laptop);
        database.commit();
        
        database.begin();
        laptop = (Laptop) database.load (Laptop.class, new Integer(10));
        database.commit();
        
        assertNotNull (laptop);
        assertEquals("ctf.jdo.tc9x.Laptop", laptop.getClass().getName());
        assertEquals(10, laptop.getId());
        assertEquals("laptop 10", laptop.getName());
        
        database.begin();
        database.remove(database.load(Laptop.class, new Integer(10)));
        database.remove(database.load(ProductDetail.class, new Integer(10)));
        database.commit();
        
        database.begin();
        try {
            laptop = (Laptop) database.load(Laptop.class, new Integer(10));
            fail("Laptop with id 10 still exists.");
        } catch (ObjectNotFoundException e) {
           assertEquals("The object of type ctf.jdo.tc9x.Laptop with identity <10(10)> " 
                   + "was not found in persistent storage", e.getMessage());
        }
        database.commit();
        
        database.close();
    }

View Full Code Here

    }
    
    public void testReadWriteEmpty() throws Exception {
        long start = System.currentTimeMillis();
        
        Database db =  _jdo.getDatabase();
        db.getCacheManager().expireCache();
        db.begin();
        
        long begin = System.currentTimeMillis();
        
        OQLQuery query = db.getOQLQuery(
                "SELECT o FROM " + Service.class.getName() + " o order by o.id");
        QueryResults results = query.execute();
        
        long result = System.currentTimeMillis();
        
        int count = 0;
        while (results.hasMore()) {
            results.next();
            count++;
        }
        
        long iterate = System.currentTimeMillis();
        
        db.commit();
        
        long commit = System.currentTimeMillis();
        
        db.close();


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

View Full Code Here

    }
    
    public void testReadWriteCached() throws Exception {
        long start = System.currentTimeMillis();
        
        Database db =  _jdo.getDatabase();
        db.begin();
        
        long begin = System.currentTimeMillis();
        
        OQLQuery query = db.getOQLQuery(
                "SELECT o FROM " + Service.class.getName() + " o order by o.id");
        QueryResults results = query.execute();
        
        long result = System.currentTimeMillis();
        
        int count = 0;
        while (results.hasMore()) {
            results.next();
            count++;
        }
        
        long iterate = System.currentTimeMillis();
        
        db.commit();
        
        long commit = System.currentTimeMillis();
        
        db.close();


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

View Full Code Here

        
        database.close();
    }


    public void testLoadLaptopMulti() throws Exception {
        Database database = _category.getDatabase();
        
        database.begin();
        LaptopMulti laptop = (LaptopMulti) database.load(LaptopMulti.class,
                new Identity(new Integer (1), new Integer(1)));
        database.commit();
        
        assertNotNull(laptop);
        assertEquals("ctf.jdo.tc9x.LaptopMulti", laptop.getClass().getName());
        assertEquals("laptop 1", laptop.getName());
        assertEquals(1, laptop.getId1());
        assertEquals(1, laptop.getId2());
        
        database.close();
    }

View Full Code Here

    }
    
    public void testReadOnlyEmpty() throws Exception {
        long start = System.currentTimeMillis();
        
        Database db =  _jdo.getDatabase();
        db.getCacheManager().expireCache();
        db.begin();
        
        long begin = System.currentTimeMillis();
        
        OQLQuery query = db.getOQLQuery(
                "SELECT o FROM " + Service.class.getName() + " o order by o.id");
        QueryResults results = query.execute(Database.READONLY);
        
        long result = System.currentTimeMillis();
        
        int count = 0;
        while (results.hasMore()) {
            results.next();
            count++;
        }
        
        long iterate = System.currentTimeMillis();
        
        db.commit();
        
        long commit = System.currentTimeMillis();
        
        db.close();


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

View Full Code Here

        
        database.close();
    }


    public void testLoadServer() throws Exception {
        Database database = _category.getDatabase();
        
        database.begin();
        Server server = (Server) database.load(Server.class, new Integer(3));
        database.commit();
        
        assertNotNull(server);
        assertEquals("ctf.jdo.tc9x.Server", server.getClass().getName());
        assertEquals(3, server.getId());
        assertEquals("server 3", server.getName());
        
        database.close();
    }

View Full Code Here

        
        database.close();
    }


    public void testLoadServerMulti() throws Exception {
        Database database = _category.getDatabase();
        
        database.begin();
        ServerMulti server = (ServerMulti) database.load(ServerMulti.class,
                new Identity(new Integer(3), new Integer(3)));
        database.commit();
        
        assertNotNull(server);
        assertEquals("ctf.jdo.tc9x.ServerMulti", server.getClass().getName());
        assertEquals(3, server.getId1());
        assertEquals(3, server.getId2());
        assertEquals("server 3", server.getName());
        
        database.close();
    }

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.