Hi Guillaume, Current martbuilder does not support generating a dataset that from two different datasources. You can use martbuilder to work on multiple schemas from different databases (mysql, postgresql, and oracle), but when you build a mart, you need to choose the datasets from the same DB type.
Regards, Yong On 27/07/09 4:09 PM, "Guillaume Collange" <[email protected]> wrote: > Hi Anthony, > > No, I mean generate a dataset that link two schema, one from a mysql DB, > another by an Oracle db. It's to cross data between this schema. After I try > to generate SQL, but it's generate the error from the previous @. Do you think > that is possible? > > Best regards, > Guillaume. > > 2009/7/27 Anthony Cros <[email protected]> >> Hi Guillaume, >> >> I suppose you mean generate a dataset from a mysql schema and output it into >> an oracle one? It that's the case then unfortunately this is not possible. >> Both your source and target schemas must be of the same instance of the same >> RDBS. I do not think we will support this even in the new system, apologies >> for the inconvenience. >> >> >> Regards, >> >> Anthony >> >> >> Guillaume Collange wrote: >>> Hi Anthony, >>> >>> I have a problem with the mart builder. I want to connect two schema source >>> editor between a mysql and oracle DB. Is it impossible? >>> >>> This is the log trace after tried to generate the sql: >>> >>> */org.biomart.builder.exceptions.ConstructorException: Dataset uses schemas >>> from multiple sources that cannot be linked to each other using SQL. >>> at >>> org.biomart.builder.controller.SaveDDLMartConstructor.getConstructorRunnable>>> ( >>> SaveDDLMartConstructor.java:180) >>> at >>> org.biomart.builder.view.gui.dialogs.SaveDDLDialog.createDDL(SaveDDLDialog.j>>> a >>> va:470) >>> at >>> org.biomart.builder.view.gui.dialogs.SaveDDLDialog.access$900(SaveDDLDialog.>>> j >>> ava:75) >>> at >>> org.biomart.builder.view.gui.dialogs.SaveDDLDialog$6.actionPerformed(SaveDDL>>> D >>> ialog.java:402) >>> at javax.swing.AbstractButton.fireActionPerformed(Unknown Source) >>> at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source) >>> at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source) >>> at javax.swing.DefaultButtonModel.setPressed(Unknown Source) >>> at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown >>> Source) >>> at java.awt.Component.processMouseEvent(Unknown Source) >>> at javax.swing.JComponent.processMouseEvent(Unknown Source) >>> at java.awt.Component.processEvent(Unknown Source) >>> at java.awt.Container.processEvent(Unknown Source) >>> at java.awt.Component.dispatchEventImpl(Unknown Source) >>> at java.awt.Container.dispatchEventImpl(Unknown Source) >>> at java.awt.Component.dispatchEvent(Unknown Source) >>> at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source) >>> at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source) >>> at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source) >>> at java.awt.Container.dispatchEventImpl(Unknown Source) >>> at java.awt.Window.dispatchEventImpl(Unknown Source) >>> at java.awt.Component.dispatchEvent(Unknown Source) >>> at java.awt.EventQueue.dispatchEvent(Unknown Source) >>> at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source) >>> at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source) >>> at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source) >>> at java.awt.Dialog$1.run(Unknown Source) >>> at java.awt.Dialog$3.run(Unknown Source) >>> at java.security.AccessController.doPrivileged(Native Method) >>> at java.awt.Dialog.show(Unknown Source) >>> at java.awt.Component.show(Unknown Source) >>> at java.awt.Component.setVisible(Unknown Source) >>> at java.awt.Window.setVisible(Unknown Source) >>> at java.awt.Dialog.setVisible(Unknown Source) >>> at >>> org.biomart.builder.view.gui.MartTabSet.requestSaveDDLDialog(MartTabSet.java>>> : >>> 587) >>> at >>> org.biomart.builder.view.gui.MartTabSet.requestCreateDDL(MartTabSet.java:549>>> ) >>> at >>> org.biomart.builder.view.gui.MartBuilder$MartBuilderMenuBar.actionPerformed(>>> M >>> artBuilder.java:918) >>> at javax.swing.AbstractButton.fireActionPerformed(Unknown Source) >>> at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source) >>> at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source) >>> at javax.swing.DefaultButtonModel.setPressed(Unknown Source) >>> at javax.swing.AbstractButton.doClick(Unknown Source) >>> at javax.swing.plaf.basic.BasicMenuItemUI.doClick(Unknown Source) >>> at javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(Unknown >>> Source) >>> at java.awt.Component.processMouseEvent(Unknown Source) >>> at javax.swing.JComponent.processMouseEvent(Unknown Source) >>> at java.awt.Component.processEvent(Unknown Source) >>> at java.awt.Container.processEvent(Unknown Source) >>> at java.awt.Component.dispatchEventImpl(Unknown Source) >>> at java.awt.Container.dispatchEventImpl(Unknown Source) >>> at java.awt.Component.dispatchEvent(Unknown Source) >>> at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source) >>> at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source) >>> at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source) >>> at java.awt.Container.dispatchEventImpl(Unknown Source) >>> at java.awt.Window.dispatchEventImpl(Unknown Source) >>> at java.awt.Component.dispatchEvent(Unknown Source) >>> at java.awt.EventQueue.dispatchEvent(Unknown Source) >>> at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source) >>> at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source) >>> at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source) >>> at java.awt.EventDispatchThread.pumpEvents(Unknown Source) >>> at java.awt.EventDispatchThread.pumpEvents(Unknown Source) >>> at java.awt.EventDispatchThread.run(Unknown Source)/* >>> >>> >>> Best regards, >>> GC. >>> >>> 2009/7/22 Anthony Cros <[email protected] >>> <mailto:[email protected]>> >>> >>> >>> Hi Guillaume, >>> >>> We recently fixed a problem regarding the use of Oracle in >>> MartBuilder, you may want to upgrade your version of BioMart >>> first. If this doesn't solve the problem I will let my colleague >>> Yong (CC'd here) take care of the problem since he's more >>> knowledgeable on MartBuilder. Please let us know how this goes for >>> you. >>> Best regards, >>> >>> Anthony >>> >>> >>> Guillaume Collange wrote: >>> >>> Hi Anthony, >>> >>> I have a problem to connect a Oracle DB with the martbuilder, >>> I'm for all my configuration, DB, Schema, login, password... >>> is it a driver problem? >>> >>> Best regards, >>> GC >>> >>> >>> >>> -- >>> *Anthony Cros >>> *Database/Application Programmer >>> >>> *Ontario Institute for Cancer Research >>> *MaRS Centre, South Tower >>> 101 College Street, Suite 600 >>> Toronto, Ontario, Canada M5G 0A3 >>> Tel: 647-260-7974 >>> Toll-free: 1-866-678-6427 >>> www.oicr.on.ca <http://www.oicr.on.ca> <http://www.oicr.on.ca> >>> >>> >>> This message and any attachments may contain confidential and/or >>> privileged information for the sole use of the intended recipient. >>> Any review or distribution by anyone other than the person for >>> whom it was originally intended is strictly prohibited. If you >>> have received this message in error, please contact the sender and >>> delete all copies. Opinions, conclusions or other information >>> contained in this message may not be that of the organization. >>> >>> >>> >>> >>> -- >>> Guillaume Collange >>> >>> ------------------------------------------------------------------------ >>> >> >> >> -- >> >> *Anthony Cros >> *Database/Application Programmer >> >> *Ontario Institute for Cancer Research >> *MaRS Centre, South Tower >> 101 College Street, Suite 600 >> Toronto, Ontario, Canada M5G 0A3 >> Tel: 647-260-7974 >> Toll-free: 1-866-678-6427 >> www.oicr.on.ca <http://www.oicr.on.ca> >> >> This message and any attachments may contain confidential and/or privileged >> information for the sole use of the intended recipient. Any review or >> distribution by anyone other than the person for whom it was originally >> intended is strictly prohibited. If you have received this message in error, >> please contact the sender and delete all copies. Opinions, conclusions or >> other information contained in this message may not be that of the >> organization. >> > > Yong Liang Database/Application Programmer Ontario Institute for Cancer Research MaRS Centre, South Tower 101 College Street, Suite 800 Toronto, Ontario, Canada M5G 0A3 Tel: 647-260-7951 Toll-free: 1-866-678-6427 www.oicr.on.ca This message and any attachments may contain confidential and/or privileged information for the sole use of the intended recipient. Any review or distribution by anyone other than the person for whom it was originally intended is strictly prohibited. If you have received this message in error, please contact the sender and delete all copies. Opinions, conclusions or other information contained in this message may not be that of the organization.
