public Object[] getChildren(Object parentElement) {
        if (parentElement instanceof CDOObject) {
                ((CDOObject)parentElement).cdoPrefetch(10000);
                return ((EObject)parentElement).eContents().toArray();
        }
        return null;
}

List<EObject> res = session.openView().createQuery("sql", "SELECT cdo_id FROM cdo_objects").getResult(EObject.class);
System.out.println("from sql size: "+res.size());
System.out.println("object 35 is proxy: "+((EObject)res.get(35)).eIsProxy());

java.util.List<EObject> res = session.openView().createQuery("sql", "SELECT cdo_id FROM cdo_objects").getResult(EObject.class);
System.out.println("from sql size: "+res.size());
System.out.println("object 35 is proxy: "+(((CDOObject)res.get(35)).cdoState() == CDOState.PROXY));

package example;

import java.util.ArrayList;

import org.eclipse.emf.cdo.common.revision.CDORevision;
import org.eclipse.emf.cdo.eresource.CDOResource;
import org.eclipse.emf.cdo.net4j.CDONet4jUtil;
import org.eclipse.emf.cdo.net4j.CDOSession;
import org.eclipse.emf.cdo.net4j.CDOSessionConfiguration;
import org.eclipse.emf.cdo.session.CDOCollectionLoadingPolicy;
import org.eclipse.emf.cdo.transaction.CDOTransaction;
import org.eclipse.emf.cdo.util.CDOUtil;
import org.eclipse.emf.ecore.EObject;
import org.eclipse.jface.action.Action;
import org.eclipse.jface.action.IToolBarManager;
import org.eclipse.net4j.Net4jUtil;
import org.eclipse.net4j.connector.IConnector;
import org.eclipse.net4j.tcp.TCPUtil;
import org.eclipse.net4j.util.container.ContainerUtil;
import org.eclipse.net4j.util.container.IManagedContainer;
import org.eclipse.swt.events.MouseEvent;
import org.eclipse.swt.events.MouseListener;
import org.eclipse.swt.events.SelectionEvent;
import org.eclipse.swt.events.SelectionListener;
import org.eclipse.swt.widgets.Composite;
import org.eclipse.swt.widgets.List;
import org.eclipse.ui.IEditorInput;
import org.eclipse.ui.ISharedImages;
import org.eclipse.ui.PartInitException;
import org.eclipse.ui.PlatformUI;
import org.eclipse.ui.ide.IDE;
import org.eclipse.ui.part.ViewPart;


/**
 * View for managing the database and its resources.
 */
public class DBManager extends ViewPart {
    private List resourcesNameList;
    private ArrayList<CDOResource> resources;
    private Action openDbAction;
    private Action closeDbAction;
    
    private CDOSession session = null;
    private CDOTransaction transaction = null;
    
    private final static String host = "localhost:2036";
    private final static String repoName = "repo1";

    
    /**
     * Create the manager
     */
    public DBManager() {
        super();
        // no resources when starting
        resources = new ArrayList<CDOResource>();
    }

    @Override
    public void createPartControl(Composite parent) {
        // no resources when starting
        resourcesNameList = new List(parent, 0);

        createActions();
        createToolbar();
    }

    @Override
    public void setFocus() {
        resourcesNameList.setFocus();
    }

    /**
     * Create actions to open or close the access to the database
     */
    public void createActions() {
        openDbAction = new Action("Access Database...") {
            public void run() { 
                openDatabase();
            }
        };
        openDbAction.setImageDescriptor(PlatformUI.getWorkbench().getSharedImages().getImageDescriptor(ISharedImages.IMG_OBJ_ADD));
        openDbAction.setEnabled(true);

        closeDbAction = new Action("Close access to Database") {
            public void run() {
                closeDatabase();
            }
        };
        closeDbAction.setImageDescriptor(PlatformUI.getWorkbench().getSharedImages().getImageDescriptor(ISharedImages.IMG_TOOL_DELETE));
        closeDbAction.setEnabled(false);

        // Add selection listener.
        resourcesNameList.addSelectionListener(new SelectionListener() {
            @Override
            public void widgetSelected(SelectionEvent e) {
                updateActionEnablement();
            }

            @Override
            public void widgetDefaultSelected(SelectionEvent e) {
                updateActionEnablement();
            }
        });
        
        // add double click listener to open editors
        resourcesNameList.addMouseListener(new MouseListener() {
            @Override
            public void mouseDoubleClick(MouseEvent e) {
                if (resourcesNameList.getSelectionCount() > 0) {
                    // get the selected CDOResource
                    CDOResource resToOpen = resources.get(resourcesNameList.getSelectionIndex());
                    
                    try {
                        // open an editor for this resource
                        IEditorInput editorInput = new DBEditorInput(resToOpen, resToOpen.getPath());
                        IDE.openEditor(
                                PlatformUI.getWorkbench().getActiveWorkbenchWindow().getActivePage(),
                                editorInput,
                                "db.ui.dbEditor");
                    } catch (PartInitException e1) {
                        // TODO Auto-generated catch block
                        e1.printStackTrace();
                    }
                }
            }

            @Override
            public void mouseDown(MouseEvent e) { }

            @Override
            public void mouseUp(MouseEvent e) { }
        });
    }

    /**
     * Access to the Database and read the different resources available
     */
    private void openDatabase() {
        //open session and transaction
        session = openSession(host, repoName);
        CDOCollectionLoadingPolicy policy = CDOUtil.createCollectionLoadingPolicy(0, 10000);
        session.options().setCollectionLoadingPolicy(policy);
        session.options().getProtocol().setTimeout(IConnector.NO_CHANNEL_TIMEOUT);
        transaction = session.openTransaction();
        
        // search all stored resources
        transaction.getRootResource().cdoView().options().setRevisionPrefetchingPolicy(CDOUtil.createRevisionPrefetchingPolicy(CDORevision.DEPTH_INFINITE));
        for (EObject eobj : transaction.getRootResource().getContents()) {
            if (eobj instanceof CDOResource) {
                CDOResource resource = (CDOResource)eobj;
                
                // add resource to lists
                resourcesNameList.add(resource.getName().toString());
                resources.add(resource);
            }
        }
        
        updateActionEnablement();
    }

    /**
     * Close the access to the current Database.
     */
    private void closeDatabase() {
        if (transaction != null) {
            transaction.close();
            transaction = null;
        }
        if (session != null) {
            session.close();
            session = null;
        }
        resourcesNameList.removeAll();
        resources.clear();
        
        updateActionEnablement();
    }

    /**
     * Update the close and open actions state.
     */
    private void updateActionEnablement() {
        if (session == null) {
            closeDbAction.setEnabled(false);
            openDbAction.setEnabled(true);
        } else {
            closeDbAction.setEnabled(true);
            openDbAction.setEnabled(false);
        }
    }

    /**
     * Create toolbar.
     */
    private void createToolbar() {
        IToolBarManager mgr = getViewSite().getActionBars().getToolBarManager();
        mgr.add(openDbAction);
        mgr.add(closeDbAction);
    }
    
    /**
     * Open a new session on the given repository
     * @param host host where the repository is stored
     * @param repository name of the repository to open
     * @return opened session
     */
    private CDOSession openSession(String host, String repository) {
        IManagedContainer container = ContainerUtil.createContainer();
        container.activate();
        Net4jUtil.prepareContainer(container);
        TCPUtil.prepareContainer(container);
        IConnector connector = TCPUtil.getConnector(container, host);
        
        // configure session
        CDOSessionConfiguration configuration = CDONet4jUtil.createSessionConfiguration();
        configuration.setConnector(connector);
        configuration.setRepositoryName(repository);
        
        // Open CDO session
        return configuration.openSession();
    }
}

package example;

import org.eclipse.core.runtime.Path;
import org.eclipse.core.runtime.PlatformObject;
import org.eclipse.emf.cdo.eresource.CDOResource;
import org.eclipse.emf.cdo.ui.CDOItemProvider;
import org.eclipse.jface.resource.ImageDescriptor;
import org.eclipse.net4j.util.ObjectUtil;
import org.eclipse.ui.IEditorInput;
import org.eclipse.ui.IPersistableElement;


/**
 * This editor input is used by the DbEditor to know which is the linked CDOResource.
 */
public class DBEditorInput extends PlatformObject implements IEditorInput {
    private CDOResource resource;

    private String resourcePath;
    
    
    public DBEditorInput(CDOResource resource, String resourcePath) {
        this.resource = resource;
        this.resourcePath = resourcePath;
    }

    public String getResourcePath() {
        return resourcePath;
    }

    public boolean exists() {
        return true;
    }
    
    public CDOResource getResource() {
        return resource;
    }

    public ImageDescriptor getImageDescriptor() {
        return CDOItemProvider.getViewImageDescriptor(resource.cdoView());
    }

    public String getName() {
        if (resourcePath != null) {
            return new Path(resourcePath).lastSegment();
        }

        return resource.cdoView().getSession().getRepositoryInfo().getName();
    }

    public IPersistableElement getPersistable() {
        return null;
    }

    public String getToolTipText() {
        return "myFile";
    }

    @Override
    public int hashCode() {
        return ObjectUtil.hashCode(resource.cdoView()) ^ ObjectUtil.hashCode(resourcePath);
    }

    @Override
    public boolean equals(Object obj) {
        if (obj == this)
        {
            return true;
        }

        if (obj instanceof DBEditorInput)
        {
            DBEditorInput that = (DBEditorInput)obj;
            return ObjectUtil.equals(resource, that.getResource());
        }

        return false;
    }
}

package example;

import org.eclipse.core.runtime.IProgressMonitor;
import org.eclipse.jface.viewers.TreeViewer;
import org.eclipse.swt.widgets.Composite;
import org.eclipse.ui.IEditorInput;
import org.eclipse.ui.IEditorSite;
import org.eclipse.ui.PartInitException;
import org.eclipse.ui.part.EditorPart;


/**
 * This editor is a simple example to load and display in a tree the content of a CDOResource.
 */
public class DBEditor extends EditorPart {
    TreeViewer tree;
    

    public DBEditor() {}

    @Override
    public void doSave(IProgressMonitor monitor) {}

    @Override
    public void doSaveAs() {}

    @Override
    public void init(IEditorSite site, IEditorInput input) throws PartInitException {
        if (input instanceof DBEditorInput) {
            setSite(site);
            setInputWithNotify(input);
            setPartName(input.getName());
        } else {
            
        }
    }

    @Override
    public boolean isDirty() {
        return false;
    }

    @Override
    public boolean isSaveAsAllowed() {
        return false;
    }

    @Override
    public void createPartControl(Composite parent) {
        tree = new TreeViewer(parent);
        
        // The tree will display the content of the CDOResource linked to the editor
        tree.setContentProvider(new DBTreeContentProvider());
        tree.setLabelProvider(new DBLabelProvider());
        tree.setInput(((DBEditorInput)getEditorInput()).getResource());
    }

    @Override
    public void setFocus() {}
}

package example;

import org.eclipse.emf.cdo.CDOObject;
import org.eclipse.emf.ecore.EObject;
import org.eclipse.jface.viewers.ITreeContentProvider;
import org.eclipse.jface.viewers.TreeViewer;
import org.eclipse.jface.viewers.Viewer;


/**
 * This treeContentProvider load dynamically objects from the CDOResource for the DBEditor tree.
 */
public class DBTreeContentProvider implements ITreeContentProvider {
    TreeViewer viewer = null;
    EObject rootObject = null;
    
    
    @Override
    public void dispose() {}

    @Override
    public void inputChanged(Viewer viewer, Object oldInput, Object newInput) {
        this.viewer = (TreeViewer)viewer;
        rootObject = (EObject)newInput;
    }
    
    @Override
    public Object[] getElements(Object inputElement) {
        return getChildren(inputElement);
    }

    @Override
    public Object[] getChildren(Object parentElement) {
        if (parentElement instanceof CDOObject) {
            // start timing
            System.out.print("getChildren("+parentElement+") = ");
            long t1 = System.currentTimeMillis();
            
            // load objects (or get from cache)
            Object[] res = ((EObject)parentElement).eContents().toArray();
            
            // stop timing and display
            System.out.println(System.currentTimeMillis() - t1);
            
            return res;
        }

        return null;
    }

    @Override
    public Object getParent(Object element) {
        if (element instanceof EObject) {
            return ((EObject)element).eContainer();
        }

        return null;
    }

    @Override
    public boolean hasChildren(Object element) {
        if (element instanceof CDOObject) {
            return !((EObject)element).eContents().isEmpty();
        }

        return false;
    }
}

package example;

import org.eclipse.emf.cdo.CDOObject;
import org.eclipse.emf.ecore.EObject;
import org.eclipse.jface.viewers.ILabelProvider;
import org.eclipse.jface.viewers.ILabelProviderListener;
import org.eclipse.swt.graphics.Image;


/**
 * Label provider to provide labels in the tree displaying the CDOResource.
 * Labels just display the type of the object and its version.
 */
public class DBLabelProvider implements ILabelProvider {

    @Override
    public void addListener(ILabelProviderListener listener) {}

    @Override
    public void dispose() {}

    @Override
    public boolean isLabelProperty(Object element, String property) {
        return false;
    }

    @Override
    public void removeListener(ILabelProviderListener listener) {}

    @Override
    public Image getImage(Object element) {
        return null;
    }

    @Override
    public String getText(Object element) {
        return ((EObject)element).eClass().getName()
            +" (v"+((CDOObject)element).cdoRevision().getVersion()+")";
    }

}

<?xml version="1.0" encoding="UTF-8"?>
<cdoServer>
    
    <!--acceptor type="http"/ -->
    
    <acceptor type="tcp" listenAddr="0.0.0.0" port="2036">
        <!-- negotiator type="challenge" description="/temp/users.db"/ -->
    </acceptor>
    
    <repository name="repo1">
        <property name="overrideUUID" value="1ff5d226-b1f0-40fb-aba2-0c31b38c764f"/>
        <property name="supportingAudits" value="true"/>
        <property name="verifyingRevisions" value="false"/>
        <property name="currentLRUCapacity" value="10000"/>
        <property name="revisedLRUCapacity" value="100"/>
        
        <store type="db">
            <mappingStrategy type="horizontal">
                <property name="qualifiedNames" value="true"/>
                <property name="toManyReferences" value="ONE_TABLE_PER_REFERENCE"/>
                <property name="toOneReferences" value="LIKE_ATTRIBUTES"/>
            </mappingStrategy>
            
                   <dbAdapter name="h2"/>
            <dataSource class="org.h2.jdbcx.JdbcDataSource"
                uRL="jdbc:h2:_database/cdodb1"/>
        </store>
    </repository>
    
</cdoServer>