Rosalind Cutts | 1 Nov 2011 12:42
Picon
Favicon

[BioMart Users] New does not always reset biomart

HI

I wonder if anyone can help with the following biomart 0.7 issue.

For our BCCTB and PED Biomart 0.7 databases, pressing on the New button does not reset the filters and attributes.

Clicking on the new button after running a query will work as expected after a first query is entered but after any subsequent queries the filters are still preselected with the results from the previous query.

Do you know of any way we can prevent this so that New always starts fresh.

Thanks again for your help

Ros Cutts

Barts Cancer Institute

 

 

 

 

This email may contain information that is privileged, confidential or otherwise protected from disclosure.
It
must not be used by, or its contents copied or disclosed to, persons other than the addressee.
If you have received
this email in error please notify the sender immediately and delete the email.
This message has been scanned for viruses.


_______________________________________________
Users mailing list
Users <at> biomart.org
https://lists.biomart.org/mailman/listinfo/users
Bob MacCallum | 1 Nov 2011 12:55
Picon

Re: [BioMart Users] New does not always reset biomart

We (VectorBase) also started seeing this in the last month or so.
Seems to be a problem in FF7.0.1 and Safari5.1.1
but behaves as expected in Chrome15.0..... for me.

A workaround seems to be to replace the session ID in the URL with
junk (e.g. askjdaksjhd).

I'm afraid we haven't looked into it any further.

On Tue, Nov 1, 2011 at 11:42 AM, Rosalind Cutts <r.j.cutts <at> qmul.ac.uk> wrote:
> HI
>
> I wonder if anyone can help with the following biomart 0.7 issue.
>
> For our BCCTB and PED Biomart 0.7 databases, pressing on the New button does
> not reset the filters and attributes.
>
> Clicking on the new button after running a query will work as expected after
> a first query is entered but after any subsequent queries the filters are
> still preselected with the results from the previous query.
>
> Do you know of any way we can prevent this so that New always starts fresh.
>
> Thanks again for your help
>
> Ros Cutts
>
> Barts Cancer Institute
>
>
>
>
>
>
>
>
>
> This email may contain information that is privileged, confidential or
> otherwise protected from disclosure.
> It must not be used by, or its contents copied or disclosed to, persons
> other than the addressee.
> If you have received this email in error please notify the sender
> immediately and delete the email.
> This message has been scanned for viruses.
>
> _______________________________________________
> Users mailing list
> Users <at> biomart.org
> https://lists.biomart.org/mailman/listinfo/users
>
>
_______________________________________________
Users mailing list
Users <at> biomart.org
https://lists.biomart.org/mailman/listinfo/users

Arek Kasprzyk | 1 Nov 2011 15:39
Picon

Re: [BioMart Users] PharmDB BioMart Service is now available!

Hi Ji-Hyun,
would you be able to send your registry file to Junjun Zhang (cc'ed on this email) who kindly agreed to include PharmDB in 0.8 BMC?

a

On Fri, Oct 28, 2011 at 9:32 AM, Arek Kasprzyk <arek.kasprzyk <at> gmail.com> wrote:
Dear Ji-Hyun,
This is a very impressive work! My congratulations!
 We will be delighted to advertise it on BioMart central Portal and add Korea to BMC. We will follow up with another email once your source is integrated

thanks once again and welcome to the BioMart community! :)
a


On Thu, Oct 27, 2011 at 12:37 AM, 지현 이 <jhlee <at> i-pharm.org> wrote:
Dear Areak kasprzyk & BioMart team,

Recently, we constructed an integrated database, PharmDB.
And it's now servicing in BioMart format.
We preparing our research paper about the database and related research.

As it is just made, we will so glad if we can advertise our database on BioMart Central Portal.

Our BioMart web address is
 http://biomart.i-pharm.org/

Thank you very much :)

=========================================================================
Ji-Hyun Lee, Researcher
i-Pharm (Information Center for Bio-pharmacological Network)
IBBI (Integrated Bioscience and Biotechnology Institute)
Advanced Institute of Convergence Technology, Seoul National University
(443-270) 864-1, Iui-dong, Yeongtong-gu, Suwon-si, Gyeonggi-do Korea
Phone : +82-31-888-9213 (office), Mobile phone: +82-10-8654-4654
E-mail: jhlee <at> i-pharm.org
=========================================================================


_______________________________________________
Users mailing list
Users <at> biomart.org
https://lists.biomart.org/mailman/listinfo/users
Arek Kasprzyk | 1 Nov 2011 16:18
Picon

Re: [BioMart Users] Editing a Virtual Mart

Dear Celine,
This feature that was present in 0.7 is not supported in 0.8 rc6 yet
(Yong, our resident MBuilder expert  to correct me here if i am wrong)

a.

On Fri, Oct 28, 2011 at 2:51 AM, Celine Noirot <Celine.Noirot <at> toulouse.inra.fr> wrote:
Hi,
I'm using the 0.8 rc6 and MyISAM db, I haven't  problem when I use naming convention.
I thought I can use a relationnal db (without convention naming like in documentation p20) and edit links between table to generate a virtual mart.
Does this feature is supported in 0.8rc6 ?

Celine
Le 27/10/2011 21:49, Yong Liang a écrit :

Are you using MyISAM or Innodb? You may need to uncheck the MyISAM
checkbox if you are using Innodb.


On 11-10-27 3:44 PM, "Syed Haider"<sah84 <at> cam.ac.uk>  wrote:

Celine,

I might have misunderstood, but if you are referring to PK<->FK links,
these should be possible between a pair of columns between two tables
that have corresponding keys.

Best,
Syed

On 27/10/2011 08:29, Celine Noirot wrote:
Hi,
I'm loading a MySQL relationnal database (not a mart model) but no link
are created between tables.
Does it possible to edit link between table to generate a Virtual Mart
and not just hide/unhide existing link?
Thank you,
Céline


_______________________________________________
Users mailing list
Users <at> biomart.org
https://lists.biomart.org/mailman/listinfo/users


--

Céline Noirot
Plateforme Bioinfo Genotoul- Unité BIA - INRA Toulouse 31326 Castanet-Tolosan
Tel. 05 61 28 57 24
http://bioinfo.genotoul.fr

_______________________________________________
Users mailing list
Users <at> biomart.org
https://lists.biomart.org/mailman/listinfo/users

_______________________________________________
Users mailing list
Users <at> biomart.org
https://lists.biomart.org/mailman/listinfo/users
Yong Liang | 1 Nov 2011 16:21
Picon

Re: [BioMart Users] Editing a Virtual Mart

Yes, this feature was in 0.7, but not supported in 0.8 rc6.
From: Arek Kasprzyk <arek.kasprzyk <at> gmail.com>
Date: Tue, 1 Nov 2011 11:18:22 -0400
To: Celine Noirot <Celine.Noirot <at> toulouse.inra.fr>
Cc: Yong Liang <yong.liang <at> oicr.on.ca>, "users <at> biomart.org" <users <at> biomart.org>
Subject: Re: [BioMart Users] Editing a Virtual Mart

Dear Celine,
This feature that was present in 0.7 is not supported in 0.8 rc6 yet
(Yong, our resident MBuilder expert  to correct me here if i am wrong)

a.

On Fri, Oct 28, 2011 at 2:51 AM, Celine Noirot <Celine.Noirot <at> toulouse.inra.fr> wrote:
Hi,
I'm using the 0.8 rc6 and MyISAM db, I haven't  problem when I use naming convention.
I thought I can use a relationnal db (without convention naming like in documentation p20) and edit links between table to generate a virtual mart.
Does this feature is supported in 0.8rc6 ?

Celine
Le 27/10/2011 21:49, Yong Liang a écrit :

Are you using MyISAM or Innodb? You may need to uncheck the MyISAM
checkbox if you are using Innodb.


On 11-10-27 3:44 PM, "Syed Haider"<sah84 <at> cam.ac.uk>  wrote:

Celine,

I might have misunderstood, but if you are referring to PK<->FK links,
these should be possible between a pair of columns between two tables
that have corresponding keys.

Best,
Syed

On 27/10/2011 08:29, Celine Noirot wrote:
Hi,
I'm loading a MySQL relationnal database (not a mart model) but no link
are created between tables.
Does it possible to edit link between table to generate a Virtual Mart
and not just hide/unhide existing link?
Thank you,
Céline


_______________________________________________
Users mailing list
Users <at> biomart.org
https://lists.biomart.org/mailman/listinfo/users


--

Céline Noirot
Plateforme Bioinfo Genotoul- Unité BIA - INRA Toulouse 31326 Castanet-Tolosan
Tel. 05 61 28 57 24
http://bioinfo.genotoul.fr

_______________________________________________
Users mailing list
Users <at> biomart.org
https://lists.biomart.org/mailman/listinfo/users

_______________________________________________
Users mailing list
Users <at> biomart.org
https://lists.biomart.org/mailman/listinfo/users
Junjun Zhang | 1 Nov 2011 19:25
Picon

Re: [BioMart Users] Error using Java API

Hi Manjula,

It is expected to use a 0.8 version registry xml file, not the 0.7 one. You will need to add the COSMIC data mart in 0.8 MartConfigurator, then save the registry file, and this will be the file to be used.

Hope this helps,

Junjun

From: Manjula Dharmawardhana <manjulapra <at> gmail.com>
Date: Thu, 27 Oct 2011 02:24:03 -0400
To: "users <at> biomart.org" <users <at> biomart.org>
Subject: [BioMart Users] Error using Java API

Hi All,
Thank you very much for all the help for the previous questions. Sadly I am stuck again. 
Here is my code (Same code given at Biomart Central)

package cosmicAccess;

import org.biomart.api.factory.*;
import org.biomart.api.Portal;
import org.biomart.api.Query;

/*
 * This is a runnable Java class that executes the query.
 * Please adapt this code as needed, and DON'T forget to change the xmlPath.
 */

public class accessCosmic {
    public static void main(String[] args) throws Exception {
        String xmlPath = "C:/cosmicRegistry.xml"; // Needs to be changed

        MartRegistryFactory factory = new XmlMartRegistryFactory(xmlPath, null);
        Portal portal = new Portal(factory, null);

        Query query = new Query(portal);
        query.setProcessor("TSV");
        query.setClient("biomartclient");
        query.setLimit(-1);
        query.setHeader(true);

        Query.Dataset ds = query.addDataset("COSMIC54", "COSMIC54_config");
        ds.addFilter("sample_source", "primary");
        ds.addFilter("tumour_source", "primary");
        ds.addFilter("site_primary", "cervix");
        ds.addAttribute("id_sample");
        ds.addAttribute("tumour_source");
        ds.addAttribute("id_gene");
        ds.addAttribute("accession_number");
        ds.addAttribute("pubmed_pmid");

        // Print to System.out, but you can pass in any java.io.OutputStream
        query.getResults(System.out);

        System.exit(0);
    }
}

Here is the Registry file in C:/cosmicRegistry.xml

<?xml version="1.0" encoding="UTF-8"?>
<!-- <!DOCTYPE MartRegistry> -->
<MartRegistry>
  <MartURLLocation 
  database="cosp" 
  default="1" 
  displayName="COSMIC (SANGER UK)" 
  host="www.sanger.ac.uk
  includeDatasets="" 
  martUser="" 
  name="CosmicMart" 
  path="/genetics/CGP/cosmic/biomart/martservice" 
port="80" 
  redirect="1" 
  serverVirtualSchema="default" 
  visible="1"
  />
 </MartRegistry>

When I run this I get this error.

Exception in thread "main" java.lang.NoClassDefFoundError: net/infonode/docking/View
        at java.lang.ClassLoader.defineClass1(Native Method)
        at java.lang.ClassLoader.defineClassCond(ClassLoader.java:632)
        at java.lang.ClassLoader.defineClass(ClassLoader.java:616)
        at java.security.SecureClassLoader.defineClass(SecureClassLoader.java:141)
        at java.net.URLClassLoader.defineClass(URLClassLoader.java:283)
        at java.net.URLClassLoader.access$000(URLClassLoader.java:58)
        at java.net.URLClassLoader$1.run(URLClassLoader.java:197)
        at java.security.AccessController.doPrivileged(Native Method)
        at java.net.URLClassLoader.findClass(URLClassLoader.java:190)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:307)
        at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:301)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:248)
        at org.biomart.api.factory.XmlMartRegistryFactory.<init>(XmlMartRegistryFactory.java:23)
        at cosmicAccess.accessCosmic.main(accessCosmic.java:21)
        at owlextract.Main.main(Main.java:26)
Caused by: java.lang.ClassNotFoundException: net.infonode.docking.View
        at java.net.URLClassLoader$1.run(URLClassLoader.java:202)
        at java.security.AccessController.doPrivileged(Native Method)
        at java.net.URLClassLoader.findClass(URLClassLoader.java:190)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:307)
        at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:301)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:248)
        ... 15 more
Java Result: 1
BUILD SUCCESSFUL (total time: 2 seconds)

I am running this in windows 7 environment. I have added the biomart0.8.jre as a lib to my Netbeans project. I compiled it using Ant.
I will be grateful if anyone can point me to the error. Thank you very much for all the support and the great tool.

Regards,
Manjula


--


This communication (including any attachments) is intended for the use of the intended recipient only and may contain information that is confidential, privileged or legally protected. Any unauthorized use or dissemination of this communication is strictly prohibited. If you have received this communication in error, please immediately notify manjulapra <at> gmail.com by return e-mail message and delete all copies of the original communication. Thank you for your cooperation.


_______________________________________________
Users mailing list
Users <at> biomart.org
https://lists.biomart.org/mailman/listinfo/users
Manjula Dharmawardhana | 1 Nov 2011 19:50
Picon
Gravatar

Re: [BioMart Users] Error using Java API

Dear Junjun,
Thank you very much. But I am sorry I am a bit confused. Can you please be a bit clearer as to from where should I get the MartConfigurator and what to add.
Thank you
Regards,
Manjula

On Tue, Nov 1, 2011 at 11:55 PM, Junjun Zhang <Junjun.Zhang <at> oicr.on.ca> wrote:
Hi Manjula,

It is expected to use a 0.8 version registry xml file, not the 0.7 one. You will need to add the COSMIC data mart in 0.8 MartConfigurator, then save the registry file, and this will be the file to be used.

Hope this helps,

Junjun

From: Manjula Dharmawardhana <manjulapra <at> gmail.com>
Date: Thu, 27 Oct 2011 02:24:03 -0400
To: "users <at> biomart.org" <users <at> biomart.org>

Subject: [BioMart Users] Error using Java API

Hi All,
Thank you very much for all the help for the previous questions. Sadly I am stuck again. 
Here is my code (Same code given at Biomart Central)

package cosmicAccess;

import org.biomart.api.factory.*;
import org.biomart.api.Portal;
import org.biomart.api.Query;

/*
 * This is a runnable Java class that executes the query.
 * Please adapt this code as needed, and DON'T forget to change the xmlPath.
 */

public class accessCosmic {
    public static void main(String[] args) throws Exception {
        String xmlPath = "C:/cosmicRegistry.xml"; // Needs to be changed

        MartRegistryFactory factory = new XmlMartRegistryFactory(xmlPath, null);
        Portal portal = new Portal(factory, null);

        Query query = new Query(portal);
        query.setProcessor("TSV");
        query.setClient("biomartclient");
        query.setLimit(-1);
        query.setHeader(true);

        Query.Dataset ds = query.addDataset("COSMIC54", "COSMIC54_config");
        ds.addFilter("sample_source", "primary");
        ds.addFilter("tumour_source", "primary");
        ds.addFilter("site_primary", "cervix");
        ds.addAttribute("id_sample");
        ds.addAttribute("tumour_source");
        ds.addAttribute("id_gene");
        ds.addAttribute("accession_number");
        ds.addAttribute("pubmed_pmid");

        // Print to System.out, but you can pass in any java.io.OutputStream
        query.getResults(System.out);

        System.exit(0);
    }
}

Here is the Registry file in C:/cosmicRegistry.xml

<?xml version="1.0" encoding="UTF-8"?>
<!-- <!DOCTYPE MartRegistry> -->
<MartRegistry>
  <MartURLLocation 
  database="cosp" 
  default="1" 
  displayName="COSMIC (SANGER UK)" 
  host="www.sanger.ac.uk
  includeDatasets="" 
  martUser="" 
  name="CosmicMart" 
  path="/genetics/CGP/cosmic/biomart/martservice" 
port="80" 
  redirect="1" 
  serverVirtualSchema="default" 
  visible="1"
  />
 </MartRegistry>

When I run this I get this error.

Exception in thread "main" java.lang.NoClassDefFoundError: net/infonode/docking/View
        at java.lang.ClassLoader.defineClass1(Native Method)
        at java.lang.ClassLoader.defineClassCond(ClassLoader.java:632)
        at java.lang.ClassLoader.defineClass(ClassLoader.java:616)
        at java.security.SecureClassLoader.defineClass(SecureClassLoader.java:141)
        at java.net.URLClassLoader.defineClass(URLClassLoader.java:283)
        at java.net.URLClassLoader.access$000(URLClassLoader.java:58)
        at java.net.URLClassLoader$1.run(URLClassLoader.java:197)
        at java.security.AccessController.doPrivileged(Native Method)
        at java.net.URLClassLoader.findClass(URLClassLoader.java:190)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:307)
        at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:301)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:248)
        at org.biomart.api.factory.XmlMartRegistryFactory.<init>(XmlMartRegistryFactory.java:23)
        at cosmicAccess.accessCosmic.main(accessCosmic.java:21)
        at owlextract.Main.main(Main.java:26)
Caused by: java.lang.ClassNotFoundException: net.infonode.docking.View
        at java.net.URLClassLoader$1.run(URLClassLoader.java:202)
        at java.security.AccessController.doPrivileged(Native Method)
        at java.net.URLClassLoader.findClass(URLClassLoader.java:190)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:307)
        at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:301)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:248)
        ... 15 more
Java Result: 1
BUILD SUCCESSFUL (total time: 2 seconds)

I am running this in windows 7 environment. I have added the biomart0.8.jre as a lib to my Netbeans project. I compiled it using Ant.
I will be grateful if anyone can point me to the error. Thank you very much for all the support and the great tool.

Regards,
Manjula


--


This communication (including any attachments) is intended for the use of the intended recipient only and may contain information that is confidential, privileged or legally protected. Any unauthorized use or dissemination of this communication is strictly prohibited. If you have received this communication in error, please immediately notify manjulapra <at> gmail.com by return e-mail message and delete all copies of the original communication. Thank you for your cooperation.





--


This communication (including any attachments) is intended for the use of the intended recipient only and may contain information that is confidential, privileged or legally protected. Any unauthorized use or dissemination of this communication is strictly prohibited. If you have received this communication in error, please immediately notify manjulapra <at> gmail.com by return e-mail message and delete all copies of the original communication. Thank you for your cooperation.


_______________________________________________
Users mailing list
Users <at> biomart.org
https://lists.biomart.org/mailman/listinfo/users
Lance Frohman | 1 Nov 2011 20:48
Picon

[BioMart Users] source code for martj 0.7

I can't get this from cvs, it times out. Is this available somewhere else?

_______________________________________________
Users mailing list
Users <at> biomart.org
https://lists.biomart.org/mailman/listinfo/users
Lance Frohman | 1 Nov 2011 21:13
Picon

[BioMart Users] error in martj 0.7

I am usgin the martj 0.7 code from the user docs, using the igisMartRegistry.xml, and I get a:


org.ensembl.mart.lib.config.ConfigurationException: Caught SQL Exception during fetch of requested digest: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ensembl_mart_62.meta_conf__xml__dm mx WHERE md.dataset_id_key=mi.dataset_id_key ' at line 1

on the adaptor.getDatasetConfigByDatasetInternalName() method.

the sql statement is

SELECT interface, display_name, dataset, description, message_digest, type, visible, version,md.dataset_id_key, modified FROM ensembl_mart_62.meta_conf__interface__dm mi, ensembl_mart_62.meta_conf__dataset__main md ensembl_mart_62.meta_conf__xml__dm mx WHERE md.dataset_id_key=mi.dataset_id_key  AND md.dataset_id_key=mx.dataset_id_key AND visible = 1

but it is missing a comma between the "md" and "ensembl_mart_62."

Has anyone seen this?


_______________________________________________
Users mailing list
Users <at> biomart.org
https://lists.biomart.org/mailman/listinfo/users
Arek Kasprzyk | 1 Nov 2011 21:32
Picon

Re: [BioMart Users] error in martj 0.7

Hi Lance,
Not really a direct answer to your question but ... a different question ;)

are you using something like martj 0.7 MExplorer to query ensembl? you maybe be better of using 0.8 rc6. This is a new version of BioMart entirely java based complete with the BioMart web server.

a



On Tue, Nov 1, 2011 at 4:13 PM, Lance Frohman <lfrohman <at> gmail.com> wrote:
I am usgin the martj 0.7 code from the user docs, using the igisMartRegistry.xml, and I get a:

org.ensembl.mart.lib.config.ConfigurationException: Caught SQL Exception during fetch of requested digest: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ensembl_mart_62.meta_conf__xml__dm mx WHERE md.dataset_id_key=mi.dataset_id_key ' at line 1

on the adaptor.getDatasetConfigByDatasetInternalName() method.

the sql statement is

SELECT interface, display_name, dataset, description, message_digest, type, visible, version,md.dataset_id_key, modified FROM ensembl_mart_62.meta_conf__interface__dm mi, ensembl_mart_62.meta_conf__dataset__main md ensembl_mart_62.meta_conf__xml__dm mx WHERE md.dataset_id_key=mi.dataset_id_key  AND md.dataset_id_key=mx.dataset_id_key AND visible = 1

but it is missing a comma between the "md" and "ensembl_mart_62."

Has anyone seen this?



_______________________________________________
Users mailing list
Users <at> biomart.org
https://lists.biomart.org/mailman/listinfo/users


_______________________________________________
Users mailing list
Users <at> biomart.org
https://lists.biomart.org/mailman/listinfo/users

Gmane