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.java:470) >> at >> org.biomart.builder.view.gui.dialogs.SaveDDLDialog.access$900(SaveDDLDialog.java:75) >> at >> org.biomart.builder.view.gui.dialogs.SaveDDLDialog$6.actionPerformed(SaveDDLDialog.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(MartBuilder.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> >> >> 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 > > 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
