blob columns in synchronization

[priyanka]

Hi,

1. Can we use tables with blob columns while doing bidirectinal
synchronization over internet between 2 mysql servers.
I got such an error on using:

Unable to execute the subscription using schedule due to 'DataBase
Access Error due to 'Result consisted of more than one row''
com.daffodilsw.replicator.server.schedule.b.d(Unknown
Source)com.daffodilsw.replicator.server.schedule.b.execute(Unknown
Source)org.quartz.core.JobRunShell.run(JobRunShell.java:
203)org.quartz.simpl.SimpleThreadPool
$WorkerThread.run(SimpleThreadPool.java:520)
Daffodil Replicator3.3.0_beta 2008-09-17 17:44:37.9

Is it because of blob values.

2. Also, if we execute a query with wrong syntax at database end, i
observes the sync stops and it does not even continue fiurther.does it
happen this way only that sync would stop. If so how can we resume.
I got following error in log file for such scenario:

Unable to execute the subscription using schedule due to 'DataBase
Access Error due to '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 ' FACILITY_ID= 4' at line 1''
com.daffodilsw.replicator.server.schedule.b.d(Unknown
Source)com.daffodilsw.replicator.server.schedule.b.execute(Unknown
Source)org.quartz.core.JobRunShell.run(JobRunShell.java:
203)org.quartz.simpl.SimpleThreadPool
$WorkerThread.run(SimpleThreadPool.java:520)
Daffodil Replicator3.3.0_beta 2008-09-17 17:38:17.08

3. What is the reason for following an error:
Unable to add the schedule at subscription due to 'Based on configured
schedule, the given trigger will never fire.'
com.daffodilsw.replicator.server.schedule.JobSchedular.scheduleSubscription(Unknown
Source)com.daffodilsw.replicator.ui.d.c.c.c(Unknown
Source)com.daffodilsw.replicator.ui.d.c.d$1.actionPerformed(Unknown
Source)javax.swing.AbstractButton.fireActionPerformed(Unknown
Source)javax.swing.AbstractButton$Handler.actionPerformed(Unknown
Source)javax.swing.DefaultButtonModel.fireActionPerformed(Unknown
Source)javax.swing.DefaultButtonModel.setPressed(Unknown
Source)javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown
Source)java.awt.AWTEventMulticaster.mouseReleased(Unknown
Source)java.awt.Component.processMouseEvent(Unknown
Source)javax.swing.JComponent.processMouseEvent(Unknown
Source)java.awt.Component.processEvent(Unknown
Source)java.awt.Container.processEvent(Unknown
Source)java.awt.Component.dispatchEventImpl(Unknown
Source)java.awt.Container.dispatchEventImpl(Unknown
Source)java.awt.Component.dispatchEvent(Unknown
Source)java.awt.LightweightDispatcher.retargetMouseEvent(Unknown
Source)java.awt.LightweightDispatcher.processMouseEvent(Unknown
Source)java.awt.LightweightDispatcher.dispatchEvent(Unknown
Source)java.awt.Container.dispatchEventImpl(Unknown
Source)java.awt.Window.dispatchEventImpl(Unknown
Source)java.awt.Component.dispatchEvent(Unknown
Source)java.awt.EventQueue.dispatchEvent(Unknown
Source)java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown
Source)java.awt.EventDispatchThread.pumpEventsForFilter(Unknown
Source)java.awt.EventDispatchThread.pumpEventsForFilter(Unknown
Source)java.awt.Dialog$1.run(Unknown Source)java.awt.Dialog
$3.run(Unknown
Source)java.security.AccessController.doPrivileged(Native
Method)java.awt.Dialog.show(Unknown
Source)java.awt.Component.show(Unknown
Source)java.awt.Component.setVisible(Unknown
Source)java.awt.Window.setVisible(Unknown
Source)java.awt.Dialog.setVisible(Unknown
Source)com.daffodilsw.replicator.ui.d.d.b(Unknown
Source)com.daffodilsw.replicator.ui.d.i$_f.actionPerformed(Unknown
Source)javax.swing.AbstractButton.fireActionPerformed(Unknown
Source)javax.swing.AbstractButton$Handler.actionPerformed(Unknown
Source)javax.swing.DefaultButtonModel.fireActionPerformed(Unknown
Source)javax.swing.DefaultButtonModel.setPressed(Unknown
Source)javax.swing.AbstractButton.doClick(Unknown
Source)javax.swing.plaf.basic.BasicMenuItemUI.doClick(Unknown
Source)javax.swing.plaf.basic.BasicMenuItemUI
$Handler.mouseReleased(Unknown
Source)java.awt.Component.processMouseEvent(Unknown
Source)javax.swing.JComponent.processMouseEvent(Unknown
Source)java.awt.Component.processEvent(Unknown
Source)java.awt.Container.processEvent(Unknown
Source)java.awt.Component.dispatchEventImpl(Unknown
Source)java.awt.Container.dispatchEventImpl(Unknown
Source)java.awt.Component.dispatchEvent(Unknown
Source)java.awt.LightweightDispatcher.retargetMouseEvent(Unknown
Source)java.awt.LightweightDispatcher.processMouseEvent(Unknown
Source)java.awt.LightweightDispatcher.dispatchEvent(Unknown
Source)java.awt.Container.dispatchEventImpl(Unknown
Source)java.awt.Window.dispatchEventImpl(Unknown
Source)java.awt.Component.dispatchEvent(Unknown
Source)java.awt.EventQueue.dispatchEvent(Unknown
Source)java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown
Source)java.awt.EventDispatchThread.pumpEventsForFilter(Unknown
Source)java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown
Source)java.awt.EventDispatchThread.pumpEvents(Unknown
Source)java.awt.EventDispatchThread.pumpEvents(Unknown
Source)java.awt.EventDispatchThread.run(Unknown Source)

4. Does creating a JDBC datasource with 45 tables take a lot of time,
what is the approx time for this?

Regards
Priyanka Arora